Tuesday, August 14, 2007

Free Code: Audit Tables and Change Control



The above link provides the following:
1. DBAuditTrackingTool.zip
Description:
This tool audits your database tables without changing the table orginal table schema. Tracks what, when, and who changed a row within a table. Each table has a corrisponding history table and trigger to audit a table.

Feature List:
1. Track all who, what, and when changes have been made to any table.
2. Auto Generates the "Audit Trigger" for tables being audited.

3. Auto Generates the "Audit Table" for tables being audited.
4. Has a function called the "TableTardis" to reconstruct what the data looked like for any period of time in the past or future.

Current Requirements:
1. PK must exists.
2. Audit tables and sprocs are all in the same database as the tables being audited.

2. DBChangeControlAndTrackingTool.zip
Description:
This tool creates a staging environment for change tracking a database. Tracks what, when, and who changed a row within a table and group them within a batch.

Technique:
Uses minimum logging techique to save disk space. If 10% of 1 billion rows change over a period of a year, you will have 100 million rows of log audits. Batches are auto-managed and a batch window is for one full day starting at midnight.

Feature List:
1. Track all who, what, and when changes have been made to any table.
2. Auto Generates the "Audit Trigger" for tables being audited.
3. Auto Generates the "Audit Views" for the table to view current data or history.
4. Has a function called the "TableTardis" to reconstruct what the data looked like for any period of time in the past or future.
5. Automatically track groups of changes into a batch. Batches can be manually or auto controlled. Auto batch tracking will group all changes for a day. This is useful for change release to production database.

Current Requirements:
1. PK must exists.
2. Audit tables views and sprocs are all in the same database as the tables being audited.

3. ServiceControlCenter.zip
Desciption:
Set of free code that demonstrates how to create a Service Control Center for any application, service, or utility that need a central database to control and monitor them. This an essential to manage complex systems that contain numerous services. Pipelines found in data warehouses is one example. This is complete with data model and stored procedures.

No comments: