Distributed Database Application System
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
Papers Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for UpdatesDistributed Database Application System Syllabus — Unit-wise Content
The official GTU curriculum for Distributed Database Application System (subject code 2740202) as prescribed for CE · Semester 4 divides the course into 8 units, covering 30 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 (2740202)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 DBMSs
- Distributed DBMS Architecture
Unit 3 Distributed Database Design
- Alternative Design Strategies
- Distribution Design Issues
- Distribution Transparency
- Impact of distribution on user queries, 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
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
Study on Android App:
