Chapter 7. Transactions with ODP.NET
When programming systems with data distributed in different locations, your application must take on the responsibility of managing data integrity. In complex systems, such as those of a financial institution, applications have to frequently update data that resides in different databases. If something goes wrong somewhere in the chain, chaos can ensue if nothing is done to ensure that data integrity is maintained.
For example, if you were updating the address of a customer in three different databases, the operation can only be considered complete if all three databases were updated. If any one of these three updates failed, the updates that were successfully done on the other two databases must also be undone. ...
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