Distributed DBMS features and needs. Reference architecture. Levels of distribution transparency, replication.
Distributed database design - fragmentation, allocation criteria.
Module II
Storage mechanisms. Translation of global queries. / Global query optimisation. Query execution and access plan.
Concurrency control - 2 phases locks. Distributed deadlocks. Time based and quorum based protocols. Comparison.
Reliability- non-blocking commitment protocols.
Module III
Partitioned networks. Checkpoints and cold starts. Management of distributed transactions- 2 phase unit protocols.
Architectural aspects. Node and link failure recoveries.
Module IV
Distributed data dictionary management. Distributed database administration. Heterogeneous databases-federated
database, reference architecture, loosely and tightly coupled.
Module V
Alternative architecture. Development tasks, Operation- global task management. Client server databases-SQL server,
open database connectivity. Constructing an application.
Text Books:
1. Database System Concepts, Silberschatz Korth, Sudarshan, MH
2. Distributed Database, Tannenbaum, Pearson
3. Principles of Distributed Database Systems, M. Tamerozsu Patrick Valduriez, Pearson
3. Database Management Systems,Ramakrishnan, MH
4. Beginning SQL Server 2000 programming, Dewson,SPD/WROX
6. Database Management Systems, Leon, VIKAS
7. My SQL :Enterprise Solutions, Alexender Pachev, Wiley Dreamtech