Data Integrity
Broadly speaking, data integrity refers to the accuracy and consistency of the data in the database. Ideally, database software would provide a variety of mechanisms for checking on data integrity; unfortunately, several important kinds of integrity are unsupported by most relational systems.
In practice, many requirements for integrity are often met through special-purpose application code. The disadvantages of assigning the task of integrity control to application programs include the amount of extra work involved in writing and maintaining integrity-checking code, the potential for both duplicating work and introducing inconsistencies when more than one application uses the same database, and the ease with which constraints ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition 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.
