Advanced Database Management Systems

Course number: 
CIS 5301
Semester: 
Fall 2015
Instructors:
Name E-mail Office location
Eduard Dragut edragut@temple.edu
Science Education and Research Center (SERC), Room 348
Prerequisites: 
  • Must be enrolled as graduate student.  
  • Programming ability in Java, C/C++, or C# are also required.
Textbooks: 
Required:
Database System Concepts (Sixth Edition) by Avi Silberschatz, Henry F. Korth, S. Sudarshan book website.

Recommended:
  • Database Management Systems, (Third Edition), by Raghu Ramakrishnan and Johannes Gehrke. McGraw Hill, 2003 book website.
  • Oracle Database 11g SQL and PL/SQL: A Brief Primer. download/pdf
  • ORACLE 10g PROGRAMMING A Primer. Rajshekhar Sunderraman. book website
Topics covered: 
This course also introduces database application development using Java and Oracle database. We will cover the following topics:
- Database Introductions, Basic Concepts
- Database System Concepts and Architecture
- Relational Model
- Relation Algebra
- SQL
- Database Application Development: JAVA
- Data Modelling Using the Entity-Relationship (ER) Model
- Transform ER Schema to Relational Schema
- PL/SQL
- Views, Stored Procedures, Triggers
- Database Application Development: JAVA
- Introduction to Indexing
- Introduction to Transaction and Locking
- Introduction to Concurrent Control
- Other topics: Distributed Databases, Column stores vs. Row stores, NoSQL
Course goals: 
Database systems from user/developer perspective: querying using SQL and relational algebra, design database schemas using ER/UML diagrams, normalization, and programming using database APIs. Construction of database-driven applications (e.g., websites, e-ecommerce) and experience with current database technologies.
 
Attendance policy: 
Attendance to all meetings of the class is mandatory.
Accomodations for Students with Disabilities: 
Any student who has a need for accommodation based on the impact of a documented disability, including special accommodations for access to technology resources and electronic instructional materials required for the course, should contact me privately to discuss the specific situation by the end of the second week of classes or as soon as practical. If you have not done so already, please contact Disability Resources and Services (DRS) at 215-204-1280 in 100 Ritter Annex to learn more about the resources available to you. I will work with DRS to coordinate reasonable accommodations for all students with documented disabilities. (http://www.temple.edu/studentaffairs/disability/accommodations/).
Student and Faculty Academic Rights and Responsibilities: 
Freedom to teach and freedom to learn are inseparable facets of academic freedom. The University has a policy on Student and Faculty and Academic Rights and Responsibilities (Policy #03.70.02) which can be accessed through the following http://policies.temple.edu/PDF/99.pdf.