UNIT - I 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. (Chapter - 1) UNIT - II 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. (Chapter - 2) UNIT - III 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. (Chapter - 3) UNIT - IV 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. (Chapter - 4) UNIT - V 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. (Chapter - 5)
