VISVESVARAYA TECHNOLOGICAL UNIVERSITY
JNANA SANGAMA, BELAGAVI-590014
Report on
“Concurrency Control in Databases”
Submitted in the partial fulfillment of the requirement of IV Semester in
DATABASE MANAGEMENT SYSTEM -(BCS403)
Submitted By
Jayanth G - 1DT22IS066
Keerthan Raj B - 1DT22IS072
Kavya B A - 1DT22IS071
Lava Kumar - 1DT22IS081
Under the guidance of
Mrs. Gagana B R
Asst. Professor
Dept. of ISE
DSATM,Bangalore
DEPARTMENT OF INFORMATION SCIENCE and ENGINEERING
DAYANANDA SAGAR ACADEMY OF TECHNOLOGY and MANAGEMENT
Udayapura, Kanakapura Main Road, Opp. Art of Living, Bengaluru-82
2023-2024
DAYANANDA SAGAR ACADEMY OF TECHNOLOGY AND MANAGEMENT
(Affiliated to Visvesvaraya Technological University, Belagavi and Approved by AICTE, New Delhi)
(Accrediated by NAAC with A+ Grade)
Udayapura, Kanakapura Main Road, Opp. Art of Living, Bengaluru-560082
(Accredited 3 years by NBA, New Delhi)
Department of Information Science and Engineering
CERTIFICATE
This is to certify that the case study work entitled “Concurrency Control in
Databases” is carried out by JAYANTH G (1DT22IS066), KAVYA B
A(1DT22IS071), KEERTHANRAJ B (1DT22IS072), Lava kumar (1DT22IS081)
in the partial fulfillment for the requirement of IV semester DBMS in Information
Science and Engineering of the Visvesvaraya Technological University, Belagavi,
during the year 2023-2024. It is certified that all corrections/suggestions indicated for the
internal assessment have been incorporated in the report. This report has been approved
as it satisfies the academic requirements in respect of case study work.
Signature of the Guide Signature of the HOD
[Link] B R Dr. Nandini Prasad KS
[Link],Dept of ISE Dean and HOD
DSATM,Bangalore. Dept of ISE
DSATM,Bangalore
TABLE OF CONTENTS
[Link] TITLE PAGE NO
1 Introduction 1
2 Two-phase locking techniques for Concurrency control 2
3 Concurrency control based on Timestamp ordering 3
4 Multiversion Concurrency control techniques 4
5 Validation Concurrency control techniques 5
Conclusion 6
[Concurrency Control in Databases]
Dept. of ISE,DSATM 2023-24 4
