Distributed Database Syallabus

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITYHYDERABAD

IV Year B.Tech. CSE - II Semester

DISTRIBUTED DATABASES(ELECTIVE - III)

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, ParametricQueries.

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-HillREFERENCES:1. Principles of Distributed Database Systems, M.Tamer Ozsu, Patrick Valduriez – Pearson Education.