8
Using Database Locking Techniques for Financial Transaction Integrity
In Chapter 1, Recognizing the Importance of Data Integrity in Finance, we discussed how locking techniques such as mutual exclusion locks can help maintain the integrity of transactions and financial data. These locking techniques (as well as the database constraints discussed in Chapter 2, Avoiding Common Data Integrity Issues and Challenges in Finance Teams) help ensure that financial numbers and transaction values add up, even if simultaneous actions or operations are happening at the same time. In this chapter, we’ll build on top of what we learned in the previous chapters and dive deeper into how race conditions can affect financial transaction integrity in databases ...
Get Managing Data Integrity for Finance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
