Revolut would own the database in my example.

How would a ledger work without having some kind of lock, how would you prevent a negative balance?

When someone checks their balance, would you to retrieve every transaction from the ledger and calculate the current balance?