In some cases, I just don’t like the field-by-field logging when creating an audit trail for my database tables.  While it might be needed in some cases (and it might make sense), most of the time, I am find that a simple audit table that stores an entire record of fact data is more useful and easier to manage for reporting, etc.

So, instead of a generic audit table that captures all old and new values for many tables, I prefer creating an audit table for each of my important fact tables.  Drop me a line if you are struggling with how to implement auditing (on Oracle, SQL Server, or MySQL) and we can chat.