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 ...
Get Microsoft® SQL Server 2005 Unleashed 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.
