13. Data Integrity

Ensuring the integrity of the organization’s databases is a key component of the DBA’s job. A database is of little use if the data it contains is inaccurate or if it cannot be accessed due to integrity problems. DBAs have many tools at their disposal to ensure data integrity.

DBAs have many tools at their disposal to ensure data integrity.

Types of Integrity

With respect to databases, we will discuss two aspects of integrity:

• Database structure integrity

• Semantic data integrity

Keeping track of database objects and ensuring that each object is created, formatted, and maintained properly is the goal of database structure integrity. Each DBMS uses its own internal format and structure to support the databases, tablespaces, ...

Get Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.