Book Image

Managing Data Integrity for Finance

By : Jane Sarah Lat
Book Image

Managing Data Integrity for Finance

By: Jane Sarah Lat

Overview of this book

Data integrity management plays a critical role in the success and effectiveness of organizations trying to use financial and operational data to make business decisions. Unfortunately, there is a big gap between the analysis and management of finance data along with the proper implementation of complex data systems across various organizations. The first part of this book covers the important concepts for data quality and data integrity relevant to finance, data, and tech professionals. The second part then focuses on having you use several data tools and platforms to manage and resolve data integrity issues on financial data. The last part of this the book covers intermediate and advanced solutions, including managed cloud-based ledger databases, database locks, and artificial intelligence, to manage the integrity of financial data in systems and databases. After finishing this hands-on book, you will be able to solve various data integrity issues experienced by organizations globally.
Table of Contents (16 chapters)
1
Part 1: Foundational Concepts for Data Quality and Data Integrity for Finance
5
Part 2: Pragmatic Solutions to Manage Financial Data Quality and Data Integrity
10
Part 3: Modern Strategies to Manage the Data Integrity of Finance Systems

Best practices when using database locks

When working with database locks, it is important to follow best practices to ensure smooth and efficient operations. Here are some best practices to keep in mind:

  • Use locks when they are needed: Applying locks can affect performance, so only do it when it’s absolutely required. Reduce the time that locks are in place. Locks should be applied as late as possible, and then released as soon as they are no longer required.
  • Use appropriate lock granularity: Instead of locking entire tables or large sections, lock the specific rows or objects that need protection. This limits the scope of the lock and improves concurrency.
  • Understand transaction isolation levels: The acquisition and release of locks are affected by various isolation levels. Learn about the many isolation levels that are available and select the best one for your application’s concurrency and consistency requirements.
  • Avoid deadlocks: The use of explicit...