This content has been marked as final.
Show 2 replies
-
1. Re: why so many version tables per db schema?
asookazian Mar 24, 2009 6:18 PM (in response to asookazian)I can't determine if Fowler is suggesting to use one "master" audit log or one audit log per entity...
http://martinfowler.com/ap2/auditLog.html -
2. Re: why so many version tables per db schema?
adamw Mar 25, 2009 11:42 AM (in response to asookazian)Hello,
well, you could of course have one table. The table would have to contain: entity name (class), entity id, field name, field value, metadata (like the revision number). This is much less clear for the reader to see what exactly changed.
So in fact, it depends on what are your requirements. If you only want to audit, without an easy way to read historical data, the "flat" way may be better. But if you want to execute queries, access historical data etc - then the table-per-entity way is probably better.
Adam