Introduction; Distributed Data Processing, Distributed Database System, Promises of DDBSs, Problem areas.
Distributed DBMS Architecture:
Architectural Models for Distributed DBMS, DDMBS Architecture.
Distributed Database Design:
Alternative Design Strategies, Distribution Design issues, Fragmentation, Allocation.
Query processing and decomposition:
Query processing objectives, characterization of query processors, layers of query processing, query decomposition, localization of distributed data.
Distributed query Optimization:
Query optimization, centralized query optimization, distributed query optimization algorithms.
Transaction Management:
Definition, properties of transaction, types of transactions, distributed concurrency control: serializability, concurrency control mechanisms & algorithms, time - stamped & optimistic concurrency control Algorithms, deadlock Management.
Distributed DBMS Reliability:
Reliability concepts and measures, fault-tolerance in distributed systems, failures in Distributed DBMS, local & distributed reliability protocols, site failures and network partitioning.
Parallel Database Systems:
Parallel database system architectures, parallel data placement, parallel query processing, load balancing, database clusters.
Distributed object Database Management Systems:
Fundamental object concepts and models, object distributed design, architectural issues, object management, distributed object storage, object query Processing.
Object Oriented Data Model:
Inheritance, object identity, persistent programming languages, persistence of objects, comparison OODBMS and ORDBMS
TEXT BOOKS:
1. M. Tamer OZSU and Patuck Valduriez: Principles of Distributed Database Systems, Pearson Edn. Asia, 2001.
2. Stefano Ceri and Giuseppe Pelagatti: Distributed Databases, McGraw Hill.
REFERENCE BOOKS:
1. Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom: “Database Systems: The Complete Book”, Second Edition, Pearson International Edition
Course Outcomes:
1. Understand theoretical and practical aspects of distributed database systems.
2. Study and identify various issues related to the development of distributed database system.
3. Understand the design aspects of object-oriented database system and related development.