General Information

When:   Tuesday/Thursday, 11:00am - 12:15pm (Regular)
    Friday, 11:00am - 12:15 pm (Make-up)
Where: 5313 Sennott Square Building (map)
Instructor: Prof. Panos K. Chrysanthis (contact)
TA: Daniel Petrov (contact)

Purpose: The principle objective of this course is to provide an in-depth knowledge of Database Management Systems design. Important aspects of distributed database systems and new data processing paradigms (such as data streams) will also be covered.
Prereq: Knowledge of data structures and files, basic operating systems concepts, and exposure to data models (i.e., CS1555/CS2055 or its equivalent). Working knowledge of Java (or C/C++) is assumed.
Enrollment: max 24 students (18 currently registered)
Textbook: Database Systems: The Complete Book, 2nd Edition Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom Published by Prentice Hall (c) 2009
(ISBN-10: 0-13-187325-3; ISBN-13: 978-0-13-187325-4)
Fundamentals of Database Systems, 7th Edition Ramez Elmasri and Shamkant B. Navathe, Pearson (c) 2015
(ISBN-10: 0-13-397077-9; ISBN-13: 978-0-13-397077-7)
Reference: Transactional Information Systems, by Gerhard Weikum and Gottfried Vossen. © 2001 Morgan Kaufmann Publishers (ISBN: 1-55860-508-8).
Additional required reading material will be made available electronically or distributed to class.

Announcements
Apr. 12: Special Office Hours on Monday April 23, 4:30-6:30pm
Apr. 12: Notes on Distributed DBMSs & Transaction Processing were posted
Apr. 11: HW6 sample solution was posted
Apr. 11: Notes on MVCC were posted
Apr. 11: Notes on Certifiers and OCC were posted
Apr. 3: Notes on Timestamp Ordering were posted
Apr. 3: Notes (Set #2) on Recovery Techniques were posted
Mar. 27: Notes (Set #1) on Recovery Techniques were posted
Mar. 22: Notes (Set #2) on Lock-based schedulers were posted
Mar. 21: Notes (Set #1) on Lock-based schedulers were posted
Mar. 17: HW6 was released & is due on Mar. 28
Mar. 17: Notes on Query Optimization were posted
Mar. 17: HW5 sample solution was posted
Mar. 2: Project was released & has multiple due dates
Feb. 28: Notes on Query Processing were posted
Feb. 28: Notes on Relational Algebra were posted
Feb. 28: HW5 was released & is due on Mar. 14

[ News Archive ]