Location

Class: Mondays 5:30 PM - 8:00 PM
Date Range: August 28 - Dec. 19, 2023
Location: Tuttleman Learning Center 0402

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

- NA

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 textbooks:
- Database Management Systems, 3rd edition, by Raghu Ramakrishnan and Johannes Gehrke book website
- Database System Concepts (Sixth Edition) by Avi Silberschatz, Henry F. Korth, S. Sudarshan book website
A number of topics will be covered from
- Readings in Database Systems, 5th Edition, Peter Bailis, Joseph M. Hellerstein, Michael Stonebraker, editors. And
- 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 6, not more than 8)
- A semester long project.
- One presentation. This includes reading the selected paper, submitting a summary of minimum one page and maximum 2 pages, and giving a 15 min presentation. See list of papers here
- Midterm Exam (Date: TBD)
- Final Exam (Date: TBD). Final exam is cumulative.

Grading

The final grade will be based upon the following:
- Homeworks: 30%.
- Project: 25%.
- Presentation: 5% (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.

TEMPLE AND COVID-19

Temple University's motto is Perseverance Conquers, and we will continue to meet the challenges of the COVID pandemic with flexibility and resilience. Working together as a community to deliver a meaningful learning experience is a responsibility we all share: we are in this together so we can be together.

Attendance Protocols and Your Health

To achieve course learning goals, students must attend in-person classes, and/or participate in classes or portions of classes that are taught remotely, to the extent that they are able. However, if you feel unwell or if you are under quarantine because you have been exposed to the virus, you should not come to campus, and you will not be penalized for your absence. Instructors are required to ensure that attendance is recorded for each in-person class session. The primary reason for documentation of attendance is to facilitate contact tracing, so that if a student or instructor with whom you have had close contact tests positive for COVID-19, the university can contact you. Students should contact their instructors to create a plan for participation and engagement in the course as soon as they are able to do so. Faculty and students agree to act in good faith and work with mutual flexibility. The expectation is that students will be honest in representing class attendance.

Expectations for Class Conduct

In order to maintain a safe and focused learning environment, we must all comply with the four public health pillars, wearing face coverings, maintaining physical distancing, washing our hands, and monitoring our health. It is also important to foster a respectful and productive learning environment that includes all students in our diverse community of learners. Our differences, some of which are outlined in the University's nondiscrimination statement, will add richness to this learning experience. Therefore, all opinions and experiences, no matter how different or controversial they may be perceived, must be respected in the tolerant spirit of academic discourse.
Treat your classmates and instructor with respect in all communication, class activities, and meetings. You are encouraged to comment, question, or critique an idea but you are not to attack an individual. Please consider that sarcasm, humor and slang can be misconstrued in online interactions and generate unintended disruptions. Profanity should be avoided as should the use of all capital letters when composing responses in discussion threads, which can be construed as "shouting" online. Remember to be careful with your own and others' privacy. In general, have your behavior mirror how you would like to be treated by others.