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, ...