How are account balances updated in a real bank?
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).
Look into Flexcube docs to more fully answer your questions. It's a reasonably well established core banking product, or series of products.
It’s all an immutable ledger, where the “account balance” is just a sum of all transactions on the account…
disclaimer: I don’t work in finance at all
In the past it was mostly the second, but now its the first.