General Information

When:   Tuesday/Thursday, 9:25am - 10:40am
Where: 323 Alumni Hall 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 (15 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. 27: HW5 sample solution was posted
Apr. 27: Project new due time is 11:59pm on 4/29
Apr. 20: Final Examon April 29 @ 9:15-11:50 am
Apr. 20: Final Exam Review during last lecture on April 27
Apr. 22: Notes/Video Distributed Database Systems
Apr. 20: Notes/Video (Set #2) Concurrency Control Techniques
Apr. 13: Notes/Video (Set #1) Concurrency Control Techniques
Apr. 9: Notes/Video (Set #3) Recovery Techniques
Apr. 9: Project Optional Design new deadline is 4/15
Apr. 7: Notes/Video (Set #2) Recovery Techniques
Apr. 5: HW5 was released and is due @8pm on Apr. 21
Apr. 3: Notes/Video (Set #1) Recovery Techniques
Apr. 3: Notes/Video (Set #2) Query Optimization

[ News Archive ]