mca Syllabus

Elective I
Distributed Database
Code :CS 704A
Credits: 3

Module I [5]
Distributed DBMS features and needs. Reference architecture. Levels of distribution transparency, replication. Distributed database design - fragmentation, allocation criteria.

Module II [10]
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 [10]
Partitioned networks. Checkpoints and cold starts. Management of distributed transactions- 2 phase unit protocols. Architectural aspects. Node and link failure recoveries.

Module IV [10]
Distributed data dictionary management. Distributed database administration. Heterogeneous databases-federated database, reference architecture, loosely and tightly coupled.

Module V [10]
Alternative architecture. Development tasks, Operation- global task management. Client server databases-SQL server, open database connectivity. Constructing an application.

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