UNIQUE SERIES AKTU Syllabus
BBC015BMI015

Distributed DBMS

Session2026-27 TypeTheory
Appears in 2 semesters · 2 branches

BCA · Sem 5 (Elective-1, code BBC015) · MCA Integrated · Sem 5 (Elective-1, code BMI015)

Download PDF

Syllabus

5 units · 40 lecture hours
Unit1

Unit 1: Introduction

8 hrs

Distributed Data Processing, Distributed Database System, Promises of DDBSs, Problem areas. Distributed DBMS Architecture: Architectural Models for Distributed DBMS, DDMBS Architecture. Distributed Database Design: Alternative Design Strategies, Distribution Design issues, Fragmentation, Allocation.

Unit2

Unit 2

8 hrs

Query processing and decomposition: Query processing objectives, characterization of query processors, layers of query processing, query decomposition, localization of distributed data. Distributed query Optimization: Query optimization, centralized query optimization, distributed query optimization algorithms.

Unit3

Unit 3: Transaction Management

8 hrs

Definition, properties of transaction, types of transactions, distributed concurrency control: Serializability, concurrency control mechanisms & algorithms, time - stamped & optimistic concurrency control Algorithms, deadlock Management.

Unit4

Unit 4: Distributed DBMS Reliability

8 hrs

Reliability concepts and measures, fault- tolerance in distributed systems, failures in Distributed DBMS, local & distributed reliability protocols, site failures and network partitioning. Parallel Database Systems: Parallel database system architectures, parallel data placement, parallel query processing, load balancing, database clusters.

Unit5

Unit 5: Distributed object Database Management Systems

8 hrs

Fundamental object concepts and models, object distributed design, architectural issues, object management, distributed object storage, object query Processing. Object Oriented Data Model: Inheritance, object identity, persistent programming languages, persistence of objects, comparison OODBMS and ORDBMS

Course Outcomes (COs)5 outcomes

After completion of the course student will be able to:

  1. CO1Understand theoretical and practical aspects of distributed database systems.K2
  2. CO2Study and identify various issues related to the development of distributed database systemK3
  3. CO3Understand the design aspects of object-oriented database system and related developmentK2
  4. CO4Equip students with principles and knowledge of distributed reliability.K3
  5. CO5Equip students with principles and knowledge of parallel and object-oriented databases.K3

Suggested Readings

  1. M. Tamer OZSU and Patuck Valduriez: Principles of Distributed Database Systems, Pearson Edn. Asia, 2001.
  2. Stefano Ceri and Giuseppe Pelagatti: Distributed Databases, McGraw Hill.
  3. Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom: “Database Systems: TheComplete Book”, Second Edition, Pearson International Edition

Official AKTU syllabus

This subject is on page 19, 20 of the original AKTU PDF.

Official AKTU syllabus PDF ↗