General Information

When:   Tuesday/Thursday, 1:00pm - 2:15pm
Where: 5313 Sennott Square and Zoom
Instructor: Prof. Panos K. Chrysanthis (contact)
TA: Rakan Alseghayer (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 30 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. 23: Notes (Set #2 & 3) on Paxos are posted
Apr. 22: HW5 sample solutions are posted
Apr. 20: Notes (Set #1) on Distributed DBMSs are posted
Apr. 14: Notes (Set #1) on Optimistic and MVCC Techniques are posted
Apr. 13: Notes (Set #1) on Timestamp Ordering Techniques are posted
Apr. 9: Notes (Set #1 & #2) on Locking Techniques are posted
Apr. 5: HW5 is released and is due @8pm on Apr. 20
Apr. 3: Notes (Set #2) on Recovery Techniques are posted
Mar. 29: Deadlock detector sample code is posted
Mar. 29: Notes (Set #1) on Recovery Techniques are posted
Mar. 26: Notes (Set #3-4) on Query Processing are posted
Mar. 19: Project is posted with multiple deadlines
Mar. 19: Notes (Set #2) on Query Processing are posted
Mar. 8: HW4 sample solutions are posted
Mar. 3: HW3 sample solutions are posted
Mar. 2: Notes (Set #1) on Relational Algebr (Review) are posted
Mar. 2: Notes (Set #3) on Access Methods & Indexing are posted

[ News Archive ]