PPT-Concurrency Control on Relational Databases

Seminar Transaction Processing Bachelor SS 2009 Dennis Stratmann Outline Goal and Overview Examine Three Approaches to CC on RD 1 PredicateOriented Concurrency Control 2 Relational Update Transactions. Also formal definitions of insertion anomaly and deletion anomaly are presented It is shown that a schema is in DKNF if and only if it has no insertion or deletion anomalies Unlike previously defined normal forms DKNF is not defined in terms of trad Slide . 1. Relation (Table). name. birth. gpa. grad. Anderson. 1987-10-22. 3.9. 2009. Jones. 1990-4-16. 2.4. 2012. Hernandez. 1989-8-12. 3.1. 2011. Chen. 1990-2-4. 3.2. 2011. VARCHAR(30). DATE. FLOAT. 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. Chapter . 4. 4. -1. Learning Objectives. Explain the importance and advantages of databases, as well as the difference between database and file-based legacy systems.. Explain the difference between logical and physical views of a database.. 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. An . entity. is anything about which the organization wishes to store data. At your college or university, one entity would be the student.. STUDENTS. Student ID. Last Name. First Name. Phone Number. Sadhna Kumari. OUTLINE. ACID Properties. 2-Phase Commit Protocol. TPS. Serializability. Concurrency Control Protocols. Current Research. Future. References. ACID PROPERTIES. Atomicity: . A . transaction is . Cse 344 May 7 th – Exam Review Examination Stations Exam Wednesday 9:30-10:20 One sheet of notes, front and back Practice solutions out after class Good luck! Exam Length Production v. Verification Non-Relational Databases Jeff Allen Overview Background Benefits Pitfalls Available Platforms Summary Overview Background Benefits Pitfalls Available Platforms Summary “A database is a collection of data.” Lecture 11 * Fall 2019 * Kesden. Socrative. https://api.socrative.com/rc/Nfu6Lp. Today’s Goals. A brief introduction to relational databases. A brief introduction to the SQL language used by relational databases. -. Bhavya. . Kilari. Dr. . Yanqing. Zhang, . CSc. 8320. PREVIEW. P. ART. I. : . I. NTRODUCTION. Transaction Processing System [. R. Chow & T. Johnson, 1997. Stefano Grazioli. Critical thinking. ‘Big ERD’ graded. Questions about the next assignment. Identifying / non-identifying relationships. Regular class on Nov 22. 2. Literacy. Big data. Data lake.