Tag Info

New answers tagged


I would like to offer a different approach than the accepted answer based on event sourcing + cqrs. Event sourcing is a different approach than nor relational design. You basically have only one table lets call it events. An event Is something that happened in the past tense. I.e AccountCreated MoneyDeposited. These events are classes that you serialize to ...


Here is my favorite approach: Each table has a corresponding history table Write stored procedures (or triggers) to make sure that all actions are logged to the history tables On insert, add a row to the history table with start = now() and end = 31.12.2999 On update, first update the most recent history record to end = now(). Then insert a new row with ...

Top 50 recent answers are included