MCA-405 Elective-I : E1(e) Advanced DataBase Management System:

UNIT-I

Objected Oriented and Object Relational Databases

Modeling Complex Data Semantics, Specialization, Generalization, Aggregation and Association,Objects, Object Identity and its implementation, Clustering, Equality and Object Reference, Architecture of Object Oriented and Object Relational databases, Persistent Programming Languages, Cache Coherence. Case Studies: Gemstone, O2, Object Store, SQL3, Oracle xxi, DB2.

UNIT-II

Deductive Databases

Data log and Recursion, Evaluation of Data log program, Recursive queries with negation.

Parallel and Distributed Databases

Parallel architectures, shared nothing/shared disk/shared memory based architectures, Data partitioning,Intra-operator parallelism, pipelining. Distributed Data Storage – Fragmentation & Replication, Location and Fragment Transparency Distributed Query Processing and Optimization, Distributed Transaction Modeling and concurrency Control, Distributed Deadlock, Commit Protocols, Design of Parallel Databases, and Parallel Query Evaluation.

UNIT-III

Advanced Transaction Processing

Advanced transaction models: Savepoints, Nested and Multilevel Transactions, Compensating Transactions and Saga, Long Duration Transactions, Weak Levels of Consistency, Transaction Work Flows, Transaction Processing Monitors, Shared disk systems.

UNIT-IV

Active Database and Real Time Databases

Triggers in SQL, Event Constraint and Action: ECA Rules, Query Processing and Concurrency Control,Recursive query processing, Compensation and Databases Recovery, multi-level recovery.

UNIT-V

Image and Multimedia Databases

Modeling and Storage of Image and Multimedia Data, Data Structures – R-tree, k-d tree, Quad trees,Content Based Retrieval: Color Histograms, Textures, etc., Image Features, Spatial and Topological Relationships, Multimedia Data Formats, Video Data Model, Audio & Handwritten Data, Geographic Information Systems (GIS).

WEB Database

Accessing Databases through WEB, WEB Servers, XML Databases, Commercial Systems – Oracle xxi,DB2.

BOOKS:

1. Elmarsi, “Fundamentals of Database Systems”, 4 th Edition, Pearson Education

2. R. Ramakrishnan, “Database Management Systems”, 1998, McGraw Hill International Editions

3. Elmagarmid.A.K. “Database transaction models for advanced applications”, Morgan Kaufman.

4. Transaction Processing, Concepts and Techniques, J. Gray and A. Reuter, Morgan Kauffman..

5. S. Abiteboul, R. hull and V. Vianu, “Foundations of Databases”, 1995, Addison – Wesley Publishing

Co., Reading Massachusetts.

6. W. Kim, “Modern Database Systems”, 1995, ACM Press, Addison – Wesley.

7. D. Maier, “The Theory of Relational Databases”, 1993, Computer Science Press, Rockville, Maryland.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------