Transcription of Introduction to Database Systems Module 1, Lecture 1
{{id}} {{{paragraph}}}
Database Management Systems , R. Ramakrishnan1 Introduction to Database SystemsModule 1, Lecture 1 Instructor: Raghu Management Systems , R. Ramakrishnan2 What Is a DBMS?vA very large, integrated collection of real-world enterprise. Entities ( , students, courses) Relationships ( , Madonna is taking CS564)vA Database Management System (DBMS) is asoftware package designed to store andmanage Management Systems , R. Ramakrishnan3 Why Use a DBMS?vData independence and efficient application development integrity and data access, recovery from Management Systems , R.
– Ti writes an object: the old value and the new value. Log record must go to disk before the changed page! – Ti commits/aborts: a log record indicating this action. Log records chained together by Xact id, so it’s easy to undo a specific Xact (e.g., to resolve a deadlock). Log is often duplexed and archived on “stable” storage.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}