CIS 616 - Data management

Data Management

CIS 616 – Spring 2005

Meeting days:

Monday, 4:40P - 7:10P, TL403B

Instructor:

Slobodan Vucetic, 304 Wachman Hall, phone: 204-5535, www.ist.temple.edu/~vucetic

Office Hours:

Wednesday 3:00 pm - 4:00 pm, Friday 3:00pm - 4:00pm, or by appointment

prerequisites:

CIS551 and CIS561. If you have not taken these courses, please see me asap.

textbooks:

Required:

A. Silberschatz, H.F. Korth, and S. Sudarshan, Database System Concepts, 4th edition, McGraw Hill Inc.

Optional:

Raghu Ramakrishnan: Database Management Systems, McGraw Hill

Jeffrey Ullman: Principles of database and knowledge-base systems

Patrick O'Neil: Database Principles Programming Performance, Morgan Kaufmann

Raymond Lorie and Jean-Jacques Daudenarde: SQL and Its Applications

Topics:

Data models:
- Entity-relationship
- Relational data models;
Relational Databases:
- SQL
- Query-by-Example, Datalog
- Integrity and Security
- Relational Database Design
Data Storage and Querying
- Storage and File Structure
- Indexing and hashing
- Query Processing and Optimization
Transaction Management
Database System Architecture, Distributed Databases
Object and Relational-Based Databases
Other topics: Advanced Data Types; Mobile databases; Web databases; Future directions

PROJECT:

The course load involves a project in Oracle/MSAccess. Through this project you will get hands-on experience, designing and implementing an application on a database system.

Grading:

Homework 20%, Class Presentation 10%, Midterm 20%, Individual Project 20%, Final Exam 30%.

LATE POLICY AND ACADEMIC HONESTY:

The projects and homework assignments are due in class, on the specified due date. NO LATE SUBMISSIONS will be accepted. For fairness, this policy will be strictly enforced. Academic honesty is taken seriously. You must write up your own solutions and code. For homework problems or projects you are allowed to discuss the problems or assignments verbally with other class members or instructor. You MUST acknowledge the people with whom you discussed your work. Any other sources (e.g. Web, research papers, books) used for solutions and code MUST also be acknowledged.

DISABILITY DISCLOSURE STATEMENT:

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 100 Ritter Annex to coordinate reasonable accommodations for students with documented disabilities.