- Teacher: Nagarajan G
- Teacher: Maya Gopal P S
COURSE OBJECTIVES
- To understand the advantage of distributed database
- To know the design issues involved in distributed database.
- 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.
- Teacher: Deepa D
- Teacher: Joshila Grace
- Teacher: Ashok Kumar K
- Teacher: Srinivasan N
- Teacher: Mercy Paul Selvan Paul selvan
- Teacher: Vignesh R
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
- Teacher: Pravin A
- Teacher: Ronald Tony A
- Teacher: Yovan Felix A
- Teacher: SANDHIYA B
- Teacher: RAMALAKSHMI D
- Teacher: Saravanan D
- Teacher: MURALI E
- Teacher: Ramya Franklin G
- Teacher: Gopika G S
- Teacher: Sabeena Gnanaselvi G
- Teacher: Refonaa J
- Teacher: Dr T Prem Jacob
- Teacher: Dr. S. Jancy
- Teacher: Suji Helen L
- Teacher: Gowri M
- Teacher: NAFEES MUNEERA M
- Teacher: Bobby M P
- Teacher: Roobini M S
- Teacher: JEMSHIA MIRIAM
- Teacher: Kamalesh Murari Devakannan
- Teacher: MANJU C NAIR
- Teacher: Asha P
- Teacher: SANTHIYA P
- Teacher: Asha R
- Teacher: Vignesh R
- Teacher: Gomathi R M
- Teacher: Dhamodaran S
- Teacher: Saranya S
- Teacher: Anandhi T
- Teacher: BHANU SHREE T
- Teacher: Divya V K