General Information

When:   Tuesday/Thursday, 11:00am - 12:15pm (Regular)
    Friday, 1:00 - 1:55 pm (Make-up)
Where: 5313 Sennott Square Building (map)
Instructor: Prof. Panos K. Chrysanthis (contact)
TA: Xiaoyu (Steve) Ge (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.

Apr. 24: Solutions of HW 5 was posted
Apr. 14: Notes on Distributed Databases were posted
Apr. 11: HW5 was released and is date is Apr. 23
Apr. 11: Notes on Multiversion CC were posted
Apr. 11: Notes on Timestamp Ordering were posted
Apr. 4: Project's first phase new deadline is 4/7
Apr. 4: Notes on Certifiers / Optimistic CC were posted
Mar. 31: Notes (Set #2) on Lock-based Schedulers were posted
Mar. 30: Notes (Set #1) on Lock-based Schedulers were posted

[ News Archive ]