1. Data Integrity -
Data integrity defines the accuracy and consistency of data stored in a database. it can also define integrity constraints to enforce business rules on the data when it is entered into the application or database.
2. Integrity Constraint -
An Integrity Constraint is a mechanism used by oracle to prevent invalid data entry into the table. it has enforcing the rules for the columns in a table.
Every relations has some conditions that must hold for it to be a valid relation. These conditions are called Relational Integrity Constraints.
3. Concurrency Control -
Concurrency Control is the process managing simultaneous operations against a database so that database integrity is not compromised.
There are 2 approaches to concurrency control. The pessimistic approach involves locking and the optimistic approach involves versioning.
Data integrity defines the accuracy and consistency of data stored in a database. it can also define integrity constraints to enforce business rules on the data when it is entered into the application or database.
2. Integrity Constraint -
An Integrity Constraint is a mechanism used by oracle to prevent invalid data entry into the table. it has enforcing the rules for the columns in a table.
Every relations has some conditions that must hold for it to be a valid relation. These conditions are called Relational Integrity Constraints.
3. Concurrency Control -
Concurrency Control is the process managing simultaneous operations against a database so that database integrity is not compromised.
There are 2 approaches to concurrency control. The pessimistic approach involves locking and the optimistic approach involves versioning.