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.

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