July 2019
Intermediate to advanced
410 pages
10h 32m
English
The ledger-style database design will be highlighted, as it is both a pattern that has been used in many financial databases for decades and it may not be known to some developers. The ledger-style database stems from an accountant's ledger, where transactions were added to a document and the quantities and/or amounts are tallied in order to arrive at a final quantity or amount. The following table shows a ledger of the sale of apples:

There are a couple of things to point out about the example. The Purchaser information is written on separate rows instead of erasing their amounts and entering a new amount. Take the ...
Read now
Unlock full access