To folks who worked with financial organisations, I wonder how accurate the Account Balance updated examples are with respect to transaction isolation and concurrent updates? Or do banks just updates ledger and balances in a literally serialized manner with one thead avoiding any complexity altogether?
it all just lives in a bunch of csv files on a few people’s PCs and every night a 62 year old man copy pastes it together and checks everything and then uploads it to some old mainframe. he is the only one who knows how to do that job.
I remember one bank used to, and it was big news, process all deductions from accounts, then issue overdrawn penalties, then any deposits. So if you had $500 in your account, then deposited $500 in cash, then withdrew $501, you would be overdrawn and assessed a penalty. Oh and it was a very major bank (in the US).
If you're interested in this topic, you may want to read through some of the Bits about Money essays/newsletters: <a href="https://www.bitsaboutmoney.com/" rel="nofollow">https://www.bitsaboutmoney.com/</a>
It’s all an immutable ledger, where the “account balance” is just a sum of all transactions on the account…<p><i>disclaimer: I don’t work in finance at all</i>