FINAL EXAM HAS BEEN POSTED! Follow this link

NEW: SLIDES FOR EX1 have been posted! Follow this link

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.

Instructor

Manuel Rodriguez-Martinez, Ph.D.

Office: T-212

          Phone: (787)-832-4040, x-3023

          E-mail: manuelr@acm.org

          Office hours: M-W 3:30pm-5:30pm, or by appointment.

Lecture Time

Tu -Th 4:30pm-5:50pm, S-227

© 2001 University of Puerto Rico-Mayaguez. All rights reserved.