Page 54 of 93
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY
III Year B.Tech. IT I-SemT P C
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
1. Principles of Distributed Database Systems, M.Tamer Ozsu, Patrick Valduriez
– Pearson Education.