University of Pittsburgh

School of Information Sciences

Graduate Information Science &Technology Program

INFSCI 2710: Database Management

Spring 2014

Class Time and Place: Mon  3:00-5:50, IS406

Instructor:  Vladimir Zadorozhny
Office Hours: by appointment
Tel:    (412) 624 9411
e-mail: vladimir@sis.pitt.edu

GSA: Xidao Wen
Office: 2A04
Office Hour: Tuesday 10-12
Tel: (412) 624 9437
e-mail:xiw55@pitt.edu

This is  a basic graduate course on database systems. The major focus of this course is on centralized database systems. The coursework consists of homeworks, exams, and a team-oriented database design and implementation project.

Prerequisites

INFSCI 2500 (co-requisite) or permission of instructor.

Topics Covered

•  Database System Architecture - data abstraction; external, conceptual, and internal schemata; data independence.

•  Data models - Entity-relationship and relational data model; SQL.

•  Theory of database design - Functional dependencies; normal forms; dependency preservation; information loss.

•  Introduction to OLAP - Multidimensional data model, data aggregation.

•  Storage Strategies - Indices and B-trees.

•  Transaction Management - ACID properties, concurrency control and recovery. 

Class Requirements and Grading

This course is being offered for three credits. The grading is as follows:

Late Policy: Homework and Project reports are due at the beginning of class on the due date. Homework and project reports can be turned in the following class for a 25% penalty. No assignments will be accepted after that time.

Communication

All students are required to periodically check the class home page on the WWW. We will use this page to make announcements and to post information about the assignments and projects.

Project

Through the project, you will gain hands-on experience in designing and implementing a Data Intensive Application. The project is done in groups of 3 students and is documented by a written group report. A demo will be scheduled for each group.  The groups are ``self-policed''.

Project description will be posted here

Textbook

 Raghu Ramakrishnan, Johannes Gehrke. Database Management Systems. 3d Edition. WCB/McGraw-Hill  2003

Homeworks

Homeworks will be posted here

Class Materials

• Introduction
• The Relational Model
• The Entity-Relationship Model

Class Schedule (approximate --- subject to change)