Class: Wednesday 5:30 PM - 8:00 PM
Date Range: Aug 25, 2014 - Dec 17, 2014
Location: Tuttleman Learning Center 0401A
- Name: Eduard C. Dragut
- Email: edragut@temple.edu
- Office: Wachman Hall 315
- Office Hours: Wednesday 10:00AM - 12:00 AM or by email appointment
- TBD
This course covers fundamental and advanced topics in Database Management Systems. It introduces you to the relational database management system (DBMS) implementation (under-the-hood stuff).
You will learn what it takes to build a relational Database Management System. There is a significant component of Java development. We will cover the following topics:
- Relational modeling
- DBMS Architectures
- Query Languages: SQL, algebra, calculus
- Storage and Indexing
- Query Evaluation and Optimization
- Transaction Management
- Schema Refinement, Database Tuning
- Other topics: Database Integration, Distributed, Parallel Databases, Column stores vs. Row stores
- CIS 5511 (Programming Techniques) and CIS 5512 (Operating Systems).
- Basic familiarity with the relational data model.
- Programming ability in Java, C/C++, or C# are also required.
- If you do not meet any of these prerequisites, please see me asap.
- Recommended: Database Management Systems, (Third Edition), by Raghu Ramakrishnan and Johannes Gehrke. McGraw Hill, 2003 book website
- Readings in Database Systems, Joseph M. Hellerstein and Michael Stonebraker, editors, 4th ed, MIT Press. (Direct links to papers from this book will generally be provided.)
- Principles of Data Integration, AnHai Doan, Alon Halevy, and Zachary Ives, Morgan-Kaufmann
- Additional materials will be provided in the form of technical papers.
- Homework (at least 4, not more than 6)
- Projects
- One presentation. See list of papers here
- Midterm Exam (Date: TBD)
- Final Exam (Date: TBD). Final exam is cumulative.
- TBD
- Each student will make a 15-20 minute presentation of a research paper to the rest of the class. There will be a list of papers to choose from. Please send me an email to sign up for a presentation.
The final grade will be based upon the following:
- Homeworks: 20%.
- Project: 30%.
- Presentation: 10%.
- Midterm Exam: 20%
- Final Exam: 20%
- Extra-credit points may be given, up to 5%, based on the activity in class and the labs.
Late submission is subject to a 10% penalty for each day late. After three days, late submissions will not be accepted. Students are strongly advised that any act of cheating will result in a score of 0 for the entire assignment and repeat offences will be reported to the Office of the Dean of Students and will result in an automatic F grade. You are encouraged to discuss problems and ideas but the final solution or code must be your own.
Any student who has a need for accommodation based on the impact of a disability should contact me privately to discuss the specific situation as soon as possible. Contact Disability Resources and Services at 215-204-1280 in Room 100, Ritter Annex to coordinate reasonable accommodations for students with documented disabilities.