Course Outcome ( CO) Bloom’s Knowledge Level (KL)
At the end of course , the student will be able to:
CO 1 Understand theoretical and practical aspects of distributed database systems. K2
CO 2 Study and identify various issues related to the development of distributed
database system
K3
CO 3 Understand the design aspects of object-oriented database system and related
development
K4
CO 4 Equip students with principles and knowledge of distributed reliability. K3
CO 5 Equip students with principles and knowledge of parallel and object-oriented
databases.
K5
DETAILED SYLLABUS
Unit Topic ProposedLecture
I
Introduction: 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.
II
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.
III
Transaction Management: Definition, properties of transaction, types of
transactions, distributed concurrency control: Serializability, concurrency control
mechanisms & algorithms, time - stamped & optimistic concurrency control
Algorithms, deadlock Management.
IV
Distributed DBMS Reliability: Reliability concepts and measures, faulttolerance 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.
V
Distributed object Database Management Systems: 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
Text books:
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. REFERENCE
BOOKS: 1. Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom: “Database Systems: The
Complete Book”, Second Edition, Pearson International Edition
