Distributed Database Application and System

Download the Question Bank


Distributed Database Application and System

Introduction.
File Systems, Database Management, Motivation, Distributed Computing, Distributed Computing & What is distributed, What is a Distributed Database System?, What is not a DDBS?, Centralized DBMS on a Network, Distributed DBMS Environment, Implicit Assumptions, Shared-Memory Architecture, Shared-Disk Architecture, Shared-Nothing Architecture, Applications, Distributed DBMS Promises of DDBS, Transparent Management of Distributed and Replicated data, Transparencies, Distributed Database - User View, Distributed DBMS – Reality, Potentially Improved Performance, Complicating Factors, Problem Areas, Parallelism Requirements, System Expansion, Distributed DBMS Issues, Distributed DBMS Issues, Relationship Between Issues

Overview of Relational DBMS.
Relational database Concepts, normalization, Integrity Rule, Relational data Languages, Relational DBMS

Review of Computer Networks.
Data Communication Concepts, Types of Networks, Protocol Standards, Broadband Networks Wireless Networks, Internet

Distributed DBMS Architecture.
Architecture, ANSI/SPARC Architecture, Standardization, Conceptual Schema Definition, Conceptual Schema Definition, Internal Schema Definition, External View Definition - Example 1, External View Definition - 10 Example 2, DBMS implementation Alternatives, Dimensions of the Problem, Data logical Distributed DBMS Architecture, Data logical Multi-DBMS Architecture, Timesharing Access to a Central Database, Multiple Clients/Single Server , Task Distribution , Advantages of Client-Server Architectures, Problems With Multiple-Client/Single Server, Multiple Clients/Multiple Servers, Server-to-Server, Peer-to-Peer Component Architecture, Components of a Multi-DBMS

Distributed Database Design.
Design Problem, Dimensions of the Problem, Distribution Design, Top-Down Design, Distribution Design Issues, Fragmentation, Fragmentation Alternatives – Horizontal, Fragmentation Alternatives – Vertical Degree of Fragmentation, Correctness of Fragmentation, Allocation Alternatives, Allocation Model

Semantic Data Control.
View management, Views in centralized DBMSs, update through views, Views in DDBMS, Data Security, centralized Authorization Control, Distributed Authorization Control, Semantic Integrity Control, Centralized and Distributed Semantic Integrity Control

Overview of Query Processing.
Query Processing, Query Processing Components , Selecting Alternatives, What is the Problem?, Cost of Alternatives, Query Optimization Objectives, Complexity of Relational Operations, Query Optimization Issues , Types of Optimizers, Query Optimization Issues Optimization Granularity, Query Optimization Issues Ò Optimization Timing, Query Optimization Issues ,Statistics, Query Optimization Issues, Query Optimization Issues Network Topology, Distributed Query Processing Methodology, Step Query Decomposition, Normalization, Analysis, Analysis Example, Analysis Simplification Example, Restructuring, Transformation Rules, Example : Equivalent Query, Provides Parallelism, Query Decomposition and Data Localization. , Optimization of Distributed Queries. , Introduction to Transaction Management. , Distributed Concurrency Control. , Distributed DBMS Reliability. , Parallel Database Systems. , Distributed Object Database Management Systems. , Database Interoperability

Text Books: 
1. Principles of Distributed database systems, By M. tamer Ozsu, Petrick Valduriez,
Pearson
2. Distributed Database Systems By Chhanda Ray, Pearson.
Reference Books:
1. Distributed Databases:Principles and Systems, Stefano Ceri, McGrawHill