University of Pittsburgh

School of Information Sciences

Graduate Information Science &Technology Program

INFSCI 2710: Database Management

Fall 2007

  Knowledge Tree tutorial is posted here  pdf.  

Knowledge Tree Website    Link

Announcements:

Please refresh this page, every time you visit (use Ctrl+F5)

  11/26/07: Project demo schedule is posted here. Please choose a timeslot for your group. 

11/26/07: Div will be out of office for next two weeks.
Mark Voortman (mark@voortman.name) will be the GSA for the remaining part of the semester.
Please address all your queries to mark@voortman.name and CC to dsharma@sis.pitt.edu

11/25/07:Homework3 solutions are posted below

11/09/07:Homework3 is posted below

10/25/07:Homework solutions are posted below.

10/11/07:Homework 2 is posted!

10/11/07:Project References and Code Samples are posted below.

10/04/07:Today (Oct 4,2007), the second half of the class (7:15 pm-8:30 pm) would be an Unix and SQL Lab in Room 828 (8th Floor)

Where's room 828 on the 8th floor? Click here.

9/27/07: Homework #1 is posted below.

9/27/07: Those students who still do not have their paradox or oracle accounts,
please send another email to dsharma@sis.pitt.edu with '2710' in the subject by 12:00 noon, Friday (September 28, 2007).

9/13/07: Project description has been posted.

9/6/07: Paradox and Oracle account passwords will be given soon. Thanks for the emails.

Class Time and Place: Thu  6:00-8:50, IS405

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

GSA (for remaining semester): Mark Voortman
Office: DSL Lab, 2nd floor, SIS, Room B210
Office Hour: 5 - 6 pm, Thursdays
Tel: (412) 624 7378 (O)
e-mail:mark@voortman.name

This is  a basic graduate course on database systems. The major focus of this course is on centralized database systems. We will also cover  more advanced topics including data warehousing and OLAP as well as principles of distributed database systems. The coursework consists of homeworks, exams, and a team-oriented database design and implementation project.

Prerequisites

INFSCI 2500 or permission of instructor.

Topics Covered

•  Database System Architecture - ANSI/SPARC 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.

•  Data warehousing and OLAP - Multidimensional data model, data extraction, cleaning, summarization; efficient implementation of data warehouses .

•  Storage Strategies - Indices and B-trees.

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

•  Principles of distributed data management - Distributed data storage, query processing, transaction management .

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.

Project

Through the project, you will gain hands-on experience in designing and implementing a Data Warehouse System. 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

• Project References

• Code Sample

• Unix Lab Notes    Notes

• SQL Lab Notes    Notes

Textbook

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

Homeworks

• Homework #1: pdf   Solution: html

• Homework #2: html     Solution: html

• Homework #3: html     Solution: Q1  Q2, Q3, Q4   Q5