Using Transactions
The nature of a relational database is that the database designer tries to reconcile a reduction in redundancy and waste with an increase in complexity. This reconciliation is referred to in database jargon as normalization. The trade-off of normalization is the complexity introduced and the hoops we have to jump through to reassemble disparate tables into usable chunks. For example, from a programmer's perspective, orders and order details are related, but a reasonable database design would separate these pieces of information to avoid repeating order information for every detail item in the order. Then when the user wants to see a complete order, the order and detail information must be reassembled. Additionally, when operations ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access