Principles of Database Management Systems includes Course Overview (Physical data storage, Indexing & Hashing, Query Processing,.); Simplified DBMS structure, Why study DBMS implementation techniques? | Principles of Database Management Systems Based on lecture notes by Hector Garcia-Molina 1 Course Overview Physical data storage Blocks on disks, records in blocks, fields in records Indexing & Hashing B-Trees, hashing, Query Processing Methods to execute SQL queries efficiently Crash Recovery Failures, stable storage, logging policies, . Concurrency Control Correctness, serializability, locks, 2 Simplified DBMS structure Storage manager Query processor Transaction processor Buffers Permanent storage User/ Application Indexes User Data System Data 3 Why study DBMS implementation techniques? Computer scientists’ core knowledge Techniques applicable in implementing DBMS-like systems Understanding of DBMS internals necessary for database administrators NB: This course is not about designing DBbased applications or about using some specific database systems 4 GRADING By Group Assignments To be announced .
