Integrity
Integrity is a serious and complex issue in relational database management. In general, it means the consistency of the data in the database. Inconsistencies in data arise in several ways. System failure—a hardware problem, a software bug, or a logical error in an application program—can introduce one kind of inconsistency. Relational database management systems that protect data from this type of inconsistency do so by guaranteeing that SQL commands either run to completion or are canceled. The processes by which this guarantee is enforced are often called transaction management. Transactions and SQL's method of handling them are discussed in Chapter 10.
Another kind of integrity, entity integrity, is a design issue. Entity integrity ...
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.
