SCS1613 DISTRIBUTED DATABASE

COURSE OBJECTIVES  

  1. To understand the advantage of distributed database 
  2. To know the design issues involved in distributed database. 
  3. To understand distributed concurrency control techniques.

UNIT 1 INTRODUCTION TO DISTRIBUTED DATABASE 9 Hrs.

 Introduction of Distributed Databases-Features of Distributed Databases-Distributed databases versus Centralized Databases- Principles-- Levels Of Distribution-Transparency-Reference Architecture- Types of Data Fragmentation- Integrity Constraints in Distributed Databases- Architectural Issues- Alternative Client/Server Architecture. 

UNIT 2 QUERIES AND OPTIMAZATION 9 Hrs. 

Global Queries to Fragment Queries- Equivalence Transformations for Queries- Distributed Grouping and Aggregate Function Evaluation- Parametric Queries- Optimization of Access Strategies Framework for Query Optimization- Join Queries- General Queries- Introduction to Distributed Transactions. 

UNIT 3 MANAGEMENT OF DISTRIBUTED TRANSACTIONS 9 Hrs. 

Management of Distributed Transactions- Framework for Transaction Management-Supporting Atomicity of Distributed Transactions- Concurrency Control for Distributed Transactions- Architectural Aspects of Distributed Transactions-Concurrency Control- Foundation of Distributed Concurrency Control- Distributed Deadlocks-Concurrency Control based on Timestamps- Optimistic Methods for Distributed Concurrency Control. 

UNIT 4 RELIABILTY AND PROTECTION 9 Hrs. 

Reliability- Basic Concepts- Reliability and concurrency Control- Determining a Consistent View of the Network- Detection and Resolution of Inconsistency- Checkpoints and Cold Restart- Distributed Database Administration- Catalog Management in Distributed Databases-Authorization and Protection 

UNIT 5 DATABASE INTEGRATION AND MANAGEMENT 9 Hrs. 

Database Integration- Scheme Translation- Scheme Integration- Query Processing Query Processing Layers in Distributed Multi-DBMSs- Query Optimization Issues- Transaction Management Transaction and Computation Model- Multidatabase Concurrency Control- Multidatabase RecoveryObject Orientation And Interoperability- Object Management Architecture - Distributed Component Model. 

COURSE OBJECTIVES

  •  To understand the role of databases and database management systems in managing organizational data and information.
  • To understand the techniques used for data fragmentation, replication and allocation during the distributed database design process.
  •  To discuss the issues involved in resource management and process.
  • To Perceive the building blocks and design of information systems.
  • To acquire knowledge of information systems on Business operations