Database Management Systems

Course Description
Study of the techniques for building traditional, relational Database Management Systems (DBMS). This course focuses on design, implementation, performance and reliability considerations and highlights the interdependencies among the choices facing the system engineer. Topics include: Reviews of ER-model, Relational Model, Relational Algebra, and Structured Query Language (SQL). Major emphasis on Database Engine Architecture, Disk Storage Organization, Buffer Management, B+-trees indexing, Hash-based indexing, Traditional Join Algorithms, Two-Phase Locking and Concurrency, Write-Ahead Logging, Query Optimization, Database Benchmarking, Object-Oriented Databases, Data Warehousing and Data Mining. A semester-long project involves constructing modules of a small relational database system that incorporates many of the techniques studied in class.

Download PPT Lecture Notes

No comments: