This section focuses on two important database design issues related to the integrity of databases: semantic and physical data integrity. First and foremost, enforcing database integrity means getting the correct results. This is fundamental.
The quality of data from different sources can vary immensely.
The following content is mainly applicable to the standard nodes of the primary cluster in VantageCloud Lake and may not apply to compute clusters on the primary cluster.
For information about the primary cluster and compute clusters, see Managing Compute Resources.
- Sources of Data Quality Problems
- Logical Integrity Constraints
- How Relational Databases Are Built from Logical Propositions
- Inclusion Compatibilities
- Semantic Integrity Constraint Types
- Semantic Constraint Specifications
- Semantic Constraint Enforcement
- Updatable Cursors and Semantic Database Integrity
- Semantic Integrity Constraints for Updatable Views
- Summary of Fundamental Database Principles
- Physical Database Integrity
- Disk I/O Integrity Checking
- Reading or Repairing Data from Fallback