31 Jan 2020

  • January 31, 2020
  • Amitraj
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. 


Translate

Popular Posts