Course Outline and Topics
This course is the second course in database management. It introduces concepts, approaches, and techniques required for the design and implementation of database management systems.
The course discusses 3 major topics. The topics are covered in parts III, IV and V of the textbook -- chapters 8 through 18.
physical database organization: file organization and indexing. [ Part III (chapters 8, 9, 10, 11)]
query processing: strategies for efficient execution of the relational operation (selection, join, etc) and query optimization. [ Part IV (chapters 12, 13, 14, 15)]
transactions: transaction management, concurrency control, crash recovery. [ Part V (chapters 16, 17, 18)]