General Information

When:   Monday/Wednesday, 6:00pm - 7:15pm (Regular)
Where: 5313 Sennott Square Building
Instructor: Prof. Panos K. Chrysanthis (contact)
TA: Xiaozhong Zhang (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 (21 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. 22: Notes & Videos on Distributed DBMSs were posted
Apr. 18: HW5 Sample Solution was posted
Apr. 15: Notes & Videos on Cerifiers and MVCC were posted
Apr. 8: Notes & Videos on Timestamp Ordering were posted
Apr. 3: Notes & Videos on Locking Techniques were posted
Mar. 31: Final Paper was released and is due on Apr. 25
Mar. 29: Notes & Videos on Recovery Techniques were posted
Mar. 26: Project (Phase 2) was released and is due on Apr. 23
Mar. 22: HW5 was released and is due Apr. 6
Mar. 22: Notes & Video (Set #3) on Query Optimization were posted
Mar. 22: Notes (Set #1 & #2) on Relational Algebra and Query Processing were posted
Feb. 27: Project (Phase 1) Data Manager was released with two deadlines
Feb. 27: HW4 Sample Solution was posted
Feb. 27: Extra material were updated with LSM-tree references
Feb. 27: Notes (Set #2) on Access Methods & Indexing were posted
Feb. 17: Notes (Set #1) on Access Methods & Indexing were posted
Feb. 17: Notes on Storage and File Organization were posted
Feb. 17: HW3 Sample Solution was posted
Feb. 14: HW4 was released and is due Feb 27
Feb. 10: HW2 Sample Solution was posted
Feb. 6: HW3 was released and is due on Feb. 13
Feb. 5: Notes on Transaction, IC, Serializability and Recoverability were posted

[ News Archive ]