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
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
Jan. 25: Notes on Query Language Design were posted
Jan. 22: HW2 was released and is due on Feb. 6
Jan. 22: TA office hour has been updated
Jan. 15: HW1 was released and is due on Jan. 23
Jan. 11: New class time: 6:00-7:30pm
Jan. 11: First class: on Jan. 15

[ News Archive ]