Distributed database design, query processing and recovery
Notes, papers, solutions, question banks, practical files and viva questions.
Unit 1
Introduction: Features of Distributed databases, Features of Centralized databases, Level of Distributed Transparency, Reference Architecture, Types of Data Fragmentation, Distribution Transparency, access primitives, integrity constraints in Distributed Database.
Unit 2
DISTRIBUTED DATABASE DESIGN: Framework for Distributed Database Design, Database Fragmentation Design - horizontal fragmentation, vertical fragmentation, Allocation of Fragments, allocation problem, allocation model, Translation of Global Queries to Fragment Queries, The Equivalence Transformation for Queries, Transforming Global Queries into Fragment Queries, Distributed Grouping, Aggregate Function Evaluation, Parametric Queries, Database Integration, Schema Matching, Schema Integration, Schema Mapping.
Unit 3
QUERY DECOMPOSITION AND DATA LOCALIZATION: Overview of Query Processing objectives, Characterization of Query Processors, Layers of Query Processing, Query Decomposition and Data Localization, Localization of Distributed Data, Optimization of Distributed Queries, Centralized Query Optimization, Join Ordering in Distributed Queries, Distributed Query Optimization.
Unit 4
DISTRIBUTED TRANSACTION MANAGEMENT AND CONCURRENCY CONTROL:
Introduction to Transaction Management, Properties of Transactions, Types of Transactions, Distributed Concurrency Control, Taxonomy of Concurrency Control Mechanisms, Locking - Based Concurrency Control Algorithms, Timestamp Based Concurrency Control Algorithms, Optimistic Concurrency Control Algorithms, Deadlock Management, The System R * The Architecture of System R*, Compilation, Execution and Recompilation of Queries, Protocols for Data Definition and Authorization in R*, Transaction and Terminal Management.
Unit 5
RELIABILITY AND REPLICATION: Distributed DBMS Reliability, Reliability Concepts and Measures, Failures in Distributed DBMS, Local Reliability Protocols, Distributed Reliability Protocols, Data Replication, Consistency of Replicated Databases, Update Management Strategies, Replication Protocols.
Where can I download Distributed Databases (MTCS041) notes for AKTU?
This page has upcoming Distributed Databases notes for AKTU M.Tech CSE semester 2, aligned with the latest AKTU syllabus. Free resources download instantly; premium ones unlock right after payment.
Are previous year question papers (PYQ) available for Distributed Databases?
PYQs for Distributed Databases (MTCS041) are being added. Meanwhile, check the notes and other resources on this page, and join our channel to get notified.
Which semester is Distributed Databases taught in for CSE?
Distributed Databases (MTCS041) is a semester 2 subject in the AKTU M.Tech Computer Science & Engineering (CSE) curriculum.
📚 New notes & PYQs — straight to your phone
Join our channel and get notified whenever we add material for your branch. Exam updates too.
REFERENCES:
1. Stefano Ceri, Guiseppe Pelagatti, “Distributed Databases - Principles and Systems”, Tata McGraw Hill, 2008.
2. Ozsu M.T./ Sridhar S., “Principles of Distributed database systems”, Pearson education, 2011.
3. Raghu RamaKrishnan, Johnaas Gehrke, “Database Management Systems”, Tata McGrawHill, 2000.
4. Elmasri, Navathe, “Fundamentals of Database Systems”, Addison-Wesley, Fifth Edition 2008.
5. Peter Rob, Carlos Coronnel, “Database Systems- Design, Implementation and Management”, Course Technology, 2000.
SOFTWARE PROJECT PLANNING & MANAGEMENT (
As per the latest AKTU syllabus — cross-check electives with your college.