Chapter 21. Implementing Data Integrity
IN THIS CHAPTER
The value of your data is determined by its integrity. You may have heard the phrase “garbage in, garbage out.” In the database world, “garbage in” refers to data that has been loaded into a database without validation or without data integrity. This “garbage” data can then be retrieved (“garbage out”), and erroneous decisions can result because of it.
Implementing good data integrity measures is your best defense against the “garbage in, garbage out” scenario. This involves identifying valid values for tables and columns and deciding how to enforce the integrity of those values. This chapter ...