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

Summary

In this chapter, we discussed how ledger databases can help us with data integrity management. In our hands-on examples, we specifically used Amazon QLDB, a fully managed ledger database available on AWS. We started by creating an AWS account and then creating an S3 bucket where our journal data from QLDB would be exported. After that, we created the QLDB ledger resource and covered the basic concepts such as getting the digest, the PartiQL editor, how to create a table, and inserting data into the table. Then, we covered how verification is done in QLDB, and why being immutable and cryptographically verifiable are crucial in preventing data integrity issues. We also covered how to work with the built-in history function and data even though they have been deleted. Lastly, we covered the best practices when using ledger databases, particularly for QLDB. Now that you are equipped with a solid understanding of these concepts, you know how the use of this type of database can...