4 ms·
One would expect all DB-based live accounting systems to store balances as a series of transactions? Even if you have a view that sums over that or a regular pr
by jessaustin 8y ago
One would expect all DB-based live accounting systems to store balances as a series of transactions? Even if you have a view that sums over that or a regular process to collapse old transactions, there's really no other sensible way to do it. Concurrent updates to the same row will always cause problems.
...Having written the above, I just examined the ERD for the COTS customer system in the office I'm in now. It stores not just balances but aged balances directly in the main customer table. Good grief.