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

GSA: Xidao Wen
Office Hours:Tuesday 10-12 
Tel:(412) 624 9437 
e-mail: wenxidao@gmail.com

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.

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

The project is done in groups and is documented by a written group report. A demo will be scheduled for each group.  The groups are ``self-policed''. 

Homework

Homework assignments will be posted here.    

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)
• Anand Rajaraman, Jure Leskovec, Jeffrey Ullman. Mining of Massive Datasets, Cambridge University Press,2011, ISBN-13: 9781107015357 (selected chapters, please download the latest edition at http://infolab.stanford.edu/~ullman/mmds.html)
• Dean Allemang and James Hendler. Semantic Web for Working Ontologists (Second Edition), Morgan Kaufmann, 2011, ISBN: 978-0-12-385965-5 (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.

• Drowning in numbers -- Digital data will flood the planet-and help us understand it better. The Economist, Nov 18, 2011

Class Handouts

• Adwanced Database System Architecture
  
• OLAP and Data Warehousing
  
• Transaction Management and Concurrency Control(Refresher)
  
• Distributed Databases (part 1)
  

Class Schedule (approximate --- subject to change)