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

GSA: Andrii Cherniak
Office Hours: Monday 10-11 am
Tel:    (412) 624 7378
e-mail: aic3@pitt.edu

This is  an advanced graduate course on database systems. The focus of this course is on distributed and unstructured database management, as well as on core relationship between database management, information retrieval, and semantic technologies.

Announcements

Prerequisites

INFSCI 2710, or permission of instructor .

Topics Covered

•  Introduction (centralized vs distributed databases; homogeneous vs heterogeneous databases; OLAP and data warehousing, wide area networks and databases; structured vs unstructured data management; Web and databases; wireless networks and databases).

• Architectures of modern database systems (client/server, advanced networked systems, OLAP and data warehousing systems).

• Principles of distributed data management (distributed data storage, query processing, transaction management).

• Unstructured data management (limitations of structured data models, data management and information retrieval).

• Web-based data management (semi-structured data and querying XML, semantic Web data management, cloud computing and data management).

• Advanced networked information systems (pervasive and mobile data management, stream data management, sensor data management.).

Class Requirements and Grading

This course is being offered for three credits. The coursework consists of Homeworks, Exams, and  a team-oriented Project. The grading is as follows:

Late Policy: Homeworks are due at the beginning of class on the due date. Homework 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

For the project report, you may follow the same guidance from the last semester. However, please clearly provide the following information, if your project involves data warehousing:

• Which data source you use (what kind of data is there)
• What questions are you trying to answer using this data set?
• How do you process your data? What is the schema of your data warehouse?

Homework

homework 1

homework 1 (solutions, updated)

homework 2.2

homework 2 (solutions, updated)

homework 3.1

homework 3 (solutions)

References

Textbooks

• Silberschatz, Korth, and Sudarshan Database System Concepts, 6th edition , McGraw-Hill, 2010, ISBN 0-07-352332-1  (selected chapters)

• Christopher D. Manning, Prabhakar Raghavan, and Hinrich Schütze. Introduction to Information Retrieval, Cambridge University Press. 2008, ISBN 0521865719  (selected chapters)

• Grigoris Antoniou and Frank van Harmelen.  A Semantic Web Primer. The MIT Press; 2 edition, 2008 . ISBN-10: 0262012421, ISBN-13: 978-0262012423 (selected chapters)

         Additional references will be posted here or provided in class.

Class Handouts

Class Schedule (approximate --- subject to change)

Last Modified: January 15, 2013.