CS606 ADVANCED DATABASE TECHNOLOGY

UNIT I                             RELATIONAL MODEL ISSUES                

ER Model - Normalization - Query Processing - Query Optimization - Transaction Processing - Concurrency Control - Recovery - Database Tuning.

UNIT II                           DISTRIBUTED DATABASES

Parallel Databases - Inter and Intra Query Parallelism - Distributed Database Features - Distributed Database Architecture - Fragmentation - Distributed Query Processing -Distributed Transactions Processing - Concurrency Control - Recovery - Commit Protocols.

UNIT III                         OBJECT ORIENTED DATABASES 
Introduction to Object Oriented Data Bases - Approaches - Modeling and Design - Persistence - Query Languages - Transaction - Concurrency - Multi Version Locks -Recovery - POSTGRES - JASMINE -GEMSTONE - ODMG Model.

UNIT IV                    EMERGING SYSTEMS

Enhanced Data Models - Client/Server Model - Data Warehousing and Data Mining - Web Databases - Mobile Databases- XML and Web Databases. 


UNIT V                           CURRENT ISSUES

Rules - Knowledge Bases - Active and Deductive Databases - Multimedia DatabasesMultimedia Data Structures - Multimedia Query languages - Spatial Databases. 

TEXT BOOKS:

1. Thomas Connolly and Carlolyn Begg, “Database Systems, A Practical Approach to Design, Implementation and Management”, Third Edition, Pearson Education 2003.
REFERENCES:

1. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Fifth Edition, Pearson Education, 2006.

2. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Fifth Edition, Tata McGraw Hill, 2006.

3. C.J.Date, A.Kannan, S.Swamynathan, “An Introduction to Database Systems”, Eighth Edition, Pearson Education, 2006.