CENG 436

Distributed Information Management

Prerequisites: CENG 315

This course investigates principles of distributed database systems including design and architecture, security, integrity, query processing and optimization, transaction management, concurrency control, and fault tolerance. The course blends theory with practice in that each student will use distributed database concepts to develop a JDBC application and to implement a JDBC driver onto Web-based distributed databases.

Course Objectives

1.To enrich his technical background

2.To make him able to think analytically

3.To gain the skill of proposing solutions for a given need

4.To gain the skill of using new technologies.

Recommended or Required Reading

M. T. Ozsu and P. Valduriez, Principles of Distributed Database Systems , Springer, 3rd Edition, 2011

Learning Outcomes

Upon the completion of this course a student :

1. Learn design and planning principles of distributed database management systems

2. Gain the ability of creating and using distributed database

3. Learn the methods to provide consistency and security methods in distributed database management systems

4. Learn query optization in distributed databases in detail

5. Gain the skills to prepare projects as teams

Topics
Introduction to distributed databases
Revisiting relational database management systems
Computer networks
Distributed database architectures
Distributed database design- Horizontal partitioning
Distributed database design- Vertical partitioning
Semantic data management
Query processing in general
Query decomposition and data localization
Distributed query optization
Distributed concurrency
Distributed consistency protocols
Distributed security protocols
Presentation and discussion of team projects

Grading

Midterm: 30%

Research Presentation: 30%

Final: 40%