CBCGS [2018 - current]
CBGS [2014 - 2017]
Old [2000 - 2013]
Units and Topics
# | Unit/Topic | Marks |
---|---|---|
100 | Concept And Overview Distributed Database System | - |
200 | Distributed Database Design | - |
300 | Distributed Transaction And Concurrency Control | - |
400 | Distributed Deadlock And Recovery | - |
500 | Distributed Query Processing And Optimization | - |
600 | Heterogeneous Database | - |
700 | XML | - |
Total | - |
Syllabus
100 Concept And Overview Distributed Database System
- What is Distributed Database System (DDBS), Features of DDBS, promises of DDBS, Design issue in DDBS, Distributed DBMS architecture:- Client/server System, Peer-to-Peer, Multi-Database system.
200 Distributed Database Design
- Distributed database design concept, objective of Data Distribution, Data Fragmentation, The allocation of fragment, Transparencies in Distributed Database Design.
300 Distributed Transaction And Concurrency Control
- Basic concept of Transaction management, objective Distributed transaction management, Model for Transaction management
- Distributed Concurrency control:- Objective, concurrency control anomalies, Distributed Serializability, Locking based algorithm, Timestamp based algorithm.
400 Distributed Deadlock And Recovery
- Introduction to Deadlock, Distributed Deadlock prevention, avoidance, detection and recovery, Two-Phase and Three-Phase Commit Protocol.
500 Distributed Query Processing And Optimization
- Concept, objective, and phases of distributed query processing;
- join strategies in fragment relation, Global query optimization
600 Heterogeneous Database
- Architecture of Heterogeneous Database, Database Integration:- Schema Translation and schema Integration, Query processing issues in Heterogeneous database.
700 XML
- XML for data integration, structure of XML, XML document schema, Querying and Transformation, storage of XML data, XML application.
Advertisement Remove all ads
Advertisement Remove all ads