General Information

When:   Mon/Wed, 11:30 am - 12:45 pm (Regular)
    Fri, 11:30 am - 12:45 pm (Make-up)
Where: 5313 Sennott Square Building (map)
Instructor: Prof. Prof. Panos K. Chrysanthis (contact)
TA: Panickos Neophytou (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 (12 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)
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. 21: Notes on Distributed Databases are posted
Apr. 16: Notes on MV CC are posted
Apr. 16: HW3 sample solution is posted
Apr. 9: Notes on Timestamp Ordering are posted
Apr. 11: Notes on SSG testers and Certifiers are posted
Mar. 28: Notes on recovery techniques are posted
Mar. 21: Notes on locking are posted
Mar. 20: HW3 on Serializability is released
Feb. 25: Term Project is released
Mar. 18: Notes on Serializability theory are posted
Mar. 3: Notes on transaction models and theory of recovery are posted
Feb. 25: HW2 sample solution is posted
Feb. 25: Notes (#3) on query processing are posted
Feb. 17: HW2 on Storage & Indexing is released
Feb. 17: HW1 sample solution is posted
Feb. 17: Notes (#1 & #2) on query processing are posted
Feb. 17: Notes on access methos & indexing are posted
Feb. 17: Notes on file organization are posted
Jan. 31: HW1 on SQL is released
Jan. 30: Notes on record placement are posted
Jan. 28: Notes on storage are posted
Jan. 28: Notes on DB programming at large are posted
Jan. 21: Notes on Integrity Constraints are posted
Jan. 18: Notes on Query Language Design are posted
Jan. 12: Notes of 1st class are posted
Jan. 12: HW0 on Sample eSubmission is released
Jan. 9: First day of class: 11:30 am - 12:45 pm

[ News Archive ]