JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

Course Objectives:

To introduced Distributed Data Processing and Concepts of Relational Databases. To learn Query Processing and Optimization. To learn about Object Oriented Database Management Systems.

Course Outcomes:

Understand theoretical and practical aspects of distributed database systems. Study and identify various issues related to the development of distributed database system. Understand the design aspects of distributed database system and related development.

UNIT - I

Introduction; Distributed Data Processing, Distributed Database System, Promises of DDBSs, Problem areas. Overview of Relational DBMS: Relational Database Concepts, Normalization, Integrity rules, Relational data languages. Distributed DBMS Architecture: Architectural Models for Distributed DBMS, DDMBS Architecture. Distributed Database Design: Alternative Design Strategies, Distribution Design issues, Fragmentation, Allocation.

UNIT - 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.

UNIT - 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.

UNIT - IV

Distributed DBMS Reliability: 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: Database Series, Parallel Architecture, Parallel DBMS Techniques, Parallel exception problems, Parallel Execution for Hierarchical architecture.

UNIT - 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, comparing OODBMS and ORDBMS

Text Books:

M. Tamer OZSU and Pauck Valduriez: Principles of Distributed Database Systems, Pearson Edn. Asia, 2001. Stefano Ceri and Willipse Pelagatti: Distributed Databases, McGraw Hill. Henry F Korth, A Silberchatz and Sudershan: Database System Concepts, MGH Raghuramakrishnan and Johhanes Gehrke: Database Management Systems, MGH

M.Tech. (Data Science) II Year I Semester