O'Reilly logo

Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition by Craig S. Mullins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required