Banking Systems

Banking Systems

The Data items contain names and addresses of customers, accounts, loans, and their balances, and the connection between customers and their accounts and loans, e.g., who has signature authority over which accounts. Queries for account balances are common, but far more common are alterations representing a single payment from, or deposit to, an account.
 
As with the airline reservation system, we expect that many tellers and customers (through ATM machines or the Web) will be querying and changing the bank's data at once. It is very important that concurrent accesses to an account not cause the effect of a transaction to be lost. Failures cannot be tolerated. For example, once the money has been ejected from an ATM machine, the bank must record the debit, even if the power immediately fails. On the other hand, it is not permissible for the bank to record the debit and then not deliver the money if the power fails. The proper way to handle this operation is far from obvious and can be regarded as one of the important achievements in DBMS design.

Tags