Skip to Main Content
Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition
book

Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition

by Craig S. Mullins
October 2012
Intermediate to advanced content levelIntermediate to advanced
936 pages
23h 23m
English
Addison-Wesley Professional
Content preview from Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Database Administration: The Complete Guide to Practices and Procedures

Database Administration: The Complete Guide to Practices and Procedures

Craig S. Mullins

Publisher Resources

ISBN: 9780133012743Purchase book