Data integrity is about the actual values that are stored and used in your application's data structures. Your application must exert deliberate control on every process that uses your data to ensure the continued correctness of the information.
You can ensure data integrity through the careful implementation of several key concepts, including:
- Normalizing data.
- Defining business rules.
- Providing referential integrity.
- Validating the data.
The following sections will acquaint you with some important ways you can ensure the integrity of your application's data.
In This Section
- Data Normalization
- Explains the process of refining the data definitions to eliminate repeating groups and unnecessary dependencies.
- Business Rules for Data Access
- Discusses how business rules control your application's data handling and are reusable by other applications.
- Referential Integrity
- Describes how referential integrity protects your data from corruption.
- Data Validation
- Discusses range checking, field validation, and more complex forms of data validation.
- Data Design
- Presents some concepts and processes that are typically encountered as you design your application's data.