PPT-1/11/2012 1 3. Concurrency Control

for Transactions Part One CSEP 545 Transaction Processing Philip A Bernstein Copyright 2012 Philip A Bernstein 1112012 2 Outline 1 A Simple System Model 2 Serializability Theory 3 Synchronization Requirements . Sadhna Kumari. OUTLINE. ACID Properties. 2-Phase Commit Protocol. TPS. Serializability. Concurrency Control Protocols. Current Research. Future. References. ACID PROPERTIES. Atomicity: . A . transaction is . Seminar: Transaction Processing (Bachelor). SS 2009. Dennis . Stratmann. Outline. Goal and Overview. Examine Three Approaches to CC on RD:. 1. Predicate-Oriented Concurrency Control. 2. Relational Update Transactions. concurrency. . controll. Chapter. 13. “Distributed Systems: . Concepts and Design”. Coulouris. , . Dollimore. , Kindberg. Hanna. Björling, . Stina Fröjd & Liv Sundman. Transaction. A transaction is a point where there is interaction with the database. -. Bhavya. . Kilari. Dr. . Yanqing. Zhang, . CSc. 8320. PREVIEW. P. ART. I. : . I. NTRODUCTION. Transaction Processing System. [. R. Chow & T. Johnson, 1997. UNC 2012 Financial Systems Conference. UNC FIT Position Control. Position Control defined. Person-based vs. Position-based systems. UNC FIT and Position Control. How is Position Control being used on campuses?. for Distributed Learning. Xinghao Pan. Joseph E. Gonzalez. Stefanie . Jegelka. Tamara Broderick. Michael I. Jordan. Data. Model. Parameters. Machine Learning . Algorithm. Data. Model. Parameters. Distributed Machine Learning. Prof. O. Nierstrasz. Selected material © Magee and Kramer. © Oscar Nierstrasz. 2. Roadmap. Modelling Concurrency. Finite State Processes . Labelled Transition Systems. Java Threads. Thread creation. Database System Implementation CSE 507. Some slides adapted from . Navathe. et. Al. , . Silberchatz. et. Al and . Hector Garcia-Molina . Lock Based Protocols. A lock is a mechanism to control concurrent access to a data item. Database Concurrency Control. 1 Purpose of Concurrency Control. To enforce Isolation (through mutual exclusion) among conflicting transactions. . To preserve database consistency through consistency preserving execution of transactions.. in SDD-1. Philip A. Bernstein. Microsoft Research. SDD-1. A DARPA-funded research project at Computer Corporation of America (Cambridge, MA) to build a distributed database system. Started in the fall of 1976. Introduction. Concurrency control protocols. Set of rules to guarantee serializability. Two-phase locking protocols. Lock data items to prevent concurrent access. Timestamp. Unique identifier for each transaction. Sadhna Kumari. OUTLINE. ACID Properties. 2-Phase Commit Protocol. TPS. Serializability. Concurrency Control Protocols. Current Research. Future. References. ACID PROPERTIES. Atomicity: . A . transaction is . -. Bhavya. . Kilari. Dr. . Yanqing. Zhang, . CSc. 8320. PREVIEW. P. ART. I. : . I. NTRODUCTION. Transaction Processing System [. R. Chow & T. Johnson, 1997. Some slides adapted from . Navathe. et. Al. , . Silberchatz. et. Al and . Hector Garcia-Molina . Lock Based Protocols. A lock is a mechanism to control concurrent access to a data item. Data items can be locked in two modes :.