Distributed Databases
Get the full GTU study material, English & Gujarati textbook PDFs, syllabus curriculum, and solved previous year question papers.
English Book & Chapters
English Book Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for UpdatesGTU Previous Year Papers
Distributed Databases Syllabus — Unit-wise Content
The official GTU curriculum for Distributed Databases (subject code 3722321) as prescribed for ITAC · Semester 2 divides the course into 13 units, covering 56 listed topics. The unit-wise breakdown below is read from the GTU syllabus document for this subject code, so you can check what the course actually covers before deciding which papers to attempt.
Download the official syllabus PDF (3722321)Unit 1 Introduction
- Distributed Data Processing
- Promises of DDBs
- Complicating Factors, and Problem Areas
Unit 2 Distributed DBMS Architecture
- DBMS Standardization
- Architectural Models for Distributed DBMS
- Distributed DBMS Architecture
Unit 3 Distributed Database Design
- Alternative Design Strategies
- Distribution Design Issues
- Distribution Transparency, and Allocation
Unit 4 Semantic Data Control
- Authentication and Access Rights
- View Management
- Data Security
- Semantic Integrity Control & its Enforcement
Unit 5 Overview of Query Processing
- Query Processing Problem
- Objective of Query Processing
- Complexity of Relational Algebra Operations
- Query Processing in Centralized System
- Query Processing in Distributed System
- Characterization of Query Processors
- Layers of Query Processing
- Subject Code: 3722321 w.e.f
Unit 6 Query Decomposition & Data Localization
- Query Decomposition
- Localization of Distributed Data
Unit 7 Optimization of Distributed Queries
- Query Optimization
- Centralized Query Optimization
- Join Ordering in Fragmented Queries
- Distributed Query Optimization Algorithms
Unit 8 Introduction to Transaction Management
- Definition of Transaction
- Properties of Transactions
- Types of Transactions
Unit 9 Distributed Concurrency Control
- Serializability Theory
- Taxonomy of Concurrency Control Mechanisms
- Lock based Concurrency Control Mechanisms
- Time Stamp based Concurrency Control Algorithms
- Optimistic Concurrency Control Algorithms
- Deadlock Management
- Relaxed Concurrency Control
Unit 10 Distributed DBMS Reliability
- Reliability Concepts & Measures
- Failures & Fault Tolerance in Distributed Systems
- Failures in Distributed DBMS
- Local Reliability Protocols
- Distributed Reliability Protocols
- Dealing with Site Failures
- Network Partitioning
Unit 11 Parallel Database Systems
- Database Servers
- Parallel Architectures
- Parallel DBMS Techniques
- Parallel Execution Problems
- Parallel Execution for Hierarchical Architecture
Unit 12 Implementation
- Overview of Java Messaging Service(JMS)
- J2EE Support for Distributed Process Platform Requirements
- Microsoft .Net Support for Distributed Process Platform Requirements, RMI, CORBA
Unit 13 Current Issues
- Data Delivery Alternatives
- Push-based Technologies
- Mobile Databases
- Models and Current Trends in Improving the Performance of Distributed Database
Study on Android App:
