Designing Data Integrity

The ability to ensure you can retrieve persisted data without error is of primary importance. Without data confidence, no query answer can be guaranteed to be correct, and there is not much point in worrying about data availability or performance.

Thus far in the chapter you have seen methods to review and query your data for quality using implicit means. In this section, you will take a proactive approach to data integrity through explicit definitions.

Your first concern is to make certain that you have exactly one master copy of the data that is used throughout the enterprise. Then, to be proactive, you must explicitly define the data using entity and attribute values.

It goes without saying, but we will say it anyway: ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide 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.