INTRODUCTION TO CONCURRENCY CONTROL
Concurrency control is the procedure in DBMS for managing simultaneous operations without conflicting with each another. Concurrent access is quite easy if all users are just reading data. There is no way they can interfere with one another. Though for any practical database, would have a mix of reading and WRITE operations and hence the concurrency is a challenge.
Concurrency control is used to address such conflicts which mostly occur with a multi-user system. It helps you to make sure that database transactions are performed concurrently without violating the data integrity of respective databases.
Therefore, concurrency control is a most important element for the proper functioning of a system where two or multiple database transactions that require access to the same data, are executed simultaneously.
Check out this video lecture, for more info on concurrency control
More topics from DBMS to read:
EasyExamNotes.com covered following topics in these notes.
- Introduction to Database
- Introduction to DBMS
- Advantages and disadvantages of DBMS
- DML, DDL and DCL
- Domains
- Introduction to data models
- Entities and Attributes
- Relationship among entities
- Tuples
- Attributes
- Relation
- Keys
- Twelve rules of CODD
- Schemas
- Integrity Constraints
- Normalization
- Functional dependency
- Transaction processing concepts
- Schedule
- Serializability
- OODBMS vs RDBMS
- RDBMS
- SQL join
- SQL functions: SUM(), AVG(), MAX(), MIN(), COUNT().
- Block, Extent, Segment
- Oracle Background processes
- Trigger
- Oracle cursor
- Introduction to Concurrency Control
A list of Video lectures
EasyExamNotes.com covered following topics in these notes.
- Introduction to Database
- Introduction to DBMS
- Advantages and disadvantages of DBMS
- DML, DDL and DCL
- Domains
- Introduction to data models
- Entities and Attributes
- Relationship among entities
- Tuples
- Attributes
- Relation
- Keys
- Twelve rules of CODD
- Schemas
- Integrity Constraints
- Normalization
- Functional dependency
- Transaction processing concepts
- Schedule
- Serializability
- OODBMS vs RDBMS
- RDBMS
- SQL join
- SQL functions: SUM(), AVG(), MAX(), MIN(), COUNT().
- Block, Extent, Segment
- Oracle Background processes
- Trigger
- Oracle cursor
- Introduction to Concurrency Control
A list of Video lectures
References:
- Korth, Silbertz,Sudarshan, “Fundamental of Database System”, McGraw Hill
- Atul Kahate , “ Introduction to Database Management System”, Pearson Educations
- Korth, Silbertz,Sudarshan, “Fundamental of Database System”, McGraw Hill
- Atul Kahate , “ Introduction to Database Management System”, Pearson Educations