3 ms·
Temporal databases make a lot of sense for financial data, for example. But in most cases you can just have a normal database and store the historic changes in
by alecco 3y ago
Temporal databases make a lot of sense for financial data, for example.
But in most cases you can just have a normal database and store the historic changes in auxiliary tables. So the main database is kind of a materialized view.
- GartzenDeHaes 3y agoThe traditional way to handle this is to use a GAAP style transaction/journal and a roll-up summary table. The current state can be reconstructed from the read only transaction table and you don't need any complex event processing system.
- theteapot 3y ago> The current state can be reconstructed from the read only transaction table .. Isn't that called event-sourcing?