JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY 
HYDERABAD 
III Year B.Tech. IT I-Sem T P C 
4+1* 0 4 
DISTRIBUTED DATABASES 

UNIT - I 
Features of Distributed versus Centralized Databases, Principles Of Distributed Databases , Levels Of Distribution Transparency, Reference Architecture for Distributed Databases , Types of Data Fragmentation, Integrity Constraints in Distributed Databases. 

UNIT – II 
Translation of Global Queries to Fragment Queries, Equivalence Transformations for Queries, Transforming Global Queries into Fragment Queries, Distributed Grouping and Aggregate Function Evaluation, Parametric Queries. 

UNIT – III 
Optimization of Access Strategies, A Framework for Query Optimization, Join Queries, General Queries. 

UNIT – IV 
The Management of Distributed Transactions, A Framework for Transaction Management , Supporting Atomicity of Distributed Transactions, Concurrency Control for Distributed Transactions, Architectural Aspects of Distributed Transactions. 

UNIT - V 
Concurrency Control, Foundation of Distributed Concurrency Control, Distributed Deadlocks, Concurrency Control based on Timestamps, Optimistic Methods for Distributed Concurrency Control. 

UNIT – VI 
Reliability, Basic Concepts, Nonblocking Commitment Protocols, Reliability and concurrency Control, Determining a Consistent View of the Network, Detection and Resolution of Inconsistency, Checkpoints and Cold Restart, Distributed Database Administration, Catalog Management in Distributed Databases, Authorization and Protection 

UNIT - VII 
Architectural Issues, Alternative Client/Server Architectures, Cache Consistency Object Management, Object Identifier Management, Pointer Swizzling, Object Migration, Distributed Object Storage, Object Query Processing, Object Query Processor Architectures, Query Processing Issues, Query Execution , Transaction Management, Transaction Management in Object DBMSs , Transactions as Objects. 

UNIT - VIII 
Database Integration, Scheme Translation, Scheme Integration, Query Processing Query Processing Layers in Distributed Multi-DBMSs, Query Optimization Issues. Transaction Management Transaction and Computation Model Multidatabase Concurrency Control, Multidatabase Recovery, Object Orientation And Interoperability Object Management Architecture CORBA and Database Interoperability Distributed Component Model COM/OLE and Database Interoperability, PUSH-Based Technologies 

TEXT BOOKS : 
1. Distributed Database Principles & Systems, Stefano Ceri, Giuseppe Pelagatti  McGraw-Hill 

REFERENCES: 
1. Principles of Distributed Database Systems, M.Tamer Ozsu, Patrick Valduriez  – Pearson Education.