Diploma Website   Student Corner   Pay Fees   NIRF

Distributed DBMS (2170714)

Teaching Scheme (in Hours)

Theory Tutorial Practical Total
3 0 2 5

Subject Credit :  5

Examination Scheme (in marks)

PA (M)
ESE Viva (V)
PA (I)
70 30 30 20 150

Syllabus Content    Download

Unit-1:  Introduction

Distributed Data Processing, Distributed Database Systems, Promises of DDBSs, Complicating factors, Problem areas

Unit-2:  Overview of RDBMS

Concepts, Integrity, Normalization

Unit-3:  Distributed DBMS Architecture

Autonomy, Distribution, Heterogeneity DDBMS Architecture – Client/Server, Peer to peer, MDBS

Unit-4:  Data Distribution Alternatives

Design Alternatives – localized data, distributed data Fragmentation – Vertical, Horizontal (primary & derived), hybrid, general guidelines, correctness rules Distribution transparency – location, fragmentation, replication Impact of distribution on user queries – No Global Data Dictionary(GDD), GDD containing location information Example on fragmentation

Unit-5:  Semantic Data Control

View Management, Authentication – database authentication, OS authentication, Access Rights, Semantic Integrity Control – Centralized & Distributed , Cost of enforcing semantic integrity

Unit-6:  Query Processing

Query Processing Problem, Layers of Query Processing Query Processing in Centralized Systems – Parsing & Translation, Optimization, Code generation, Example Query Processing in Distributed Systems – Mapping global query to local, Optimization,

Unit-7:  Optimization of Distributed Queries

Query Optimization, Centralized Query Optimization, Join Ordering Distributed Query Optimization Algorithms

Unit-8:  Distributed Transaction Management & Concurrency Control

Transaction concept, ACID property, Objectives of transaction management, Types of transactions, Objectives of Distributed Concurrency Control, Concurrency Control anomalies, Methods of concurrency control, Serializability and recoverability, Distributed Serializability, Enhanced lock based and timestamp based protocols, Multiple granularity, Multi version schemes, Optimistic Concurrency Control techniques

Unit-9:  Distributed Deadlock & Recovery

Deadlock concept, Deadlock in Centralized systems, Deadlock in Distributed Systems – Detection, Prevention, Avoidance, Wait-Die Algorithm, Wound-Wait algorithm Recovery in DBMS - Types of Failure, Methods to control failure, Different techniques of recoverability, Write- Ahead logging Protocol, Advanced recovery techniques- Shadow Paging, Fuzzy checkpoint, ARIES, RAID levels, Two Phase and Three Phase commit protocols

Reference Books

Sr. Title Author Publication Amazon Link
1 Principles of Distributed Database Systems Ozsu Pearson Publication
2 Principles of Distributed Database Systems Ozsu Pearson Publication
3 Distributed Database Mangement Systems Rahimi & Haug, Wiley
4 Distributed Database Systems Chanda Ray Pearson Publication
5 Distributed Databases, Sachin Deshpande Dreamtech

About Us

Darshan Institute of Engineering & Technology is a leading institute offering undergraduate (B.E.), postgraduate (M.E.) and Diploma programs in engineering.

Our Contacts

At Hadala, Rajkot - Morbi Highway,
Gujarat-363650, INDIA

(+91) 97277 47310
(+91) 97277 47311

More contact details