Location

Class: Mondays 5:30 PM - 8:00 PM
Date Range: Jan 16 - May 9, 2018
Location: Tuttleman Learning Center 0401A

Instructor

- Name: Eduard C. Dragut
- Email: edragut@temple.edu
- Office: SERC 348
- Office Hours: Mondays 10:00AM - 12:00 AM or by email appointment

Teaching Assistants

- N/A

Course Descriptions

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:NoSQL, Distributed, Parallel Databases, Column stores vs. Row stores

Prerequisites

- CIS 5511 (Programming Techniques) and CIS 5512 (Operating Systems).
- Basic familiarity with the relational data model and SQL.
- Programming ability in Java, C/C++, or C# are also required.
- If you do not meet any of these prerequisites, please see me asap.

Textbook

The content of the course will mostly from the following textbook:
- Database Management Systems, 3rd edition, by Raghu Ramakrishnan and Johannes Gehrke book website
A number of topics will be covered from
- Readings in Database Systems, 5th Edition, Peter Bailis, Joseph M. Hellerstein, Michael Stonebraker, editors.
- Principles of Distributed Database Systems 3rd ed. 2011 Edition, Tamer Ozsu and Patrick Valduriez.
- Additional materials will be provided in the form of technical papers.

Workload

- Homework (at least 4, not more than 6)
- A semester long project.
- Midterm Exam (Date: TBD)
- Final Exam (Date: TBD). Final exam is cumulative.

Project

- TBD

Grading

The final grade will be based upon the following:
- Homeworks: 20%.
- Project: 30%.
- Presentation: 10% (TBD).
- 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 Policy

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.

Classroom Requirements

  • Cell phones must be turned off or set on vibrate during class.
  • Laptop/notebook computers and tablets cannot be used during class.

Disability Disclosure

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.