RGTU/RGPV MCA-405 Elective-I : E1(e) Advanced DataBase Management System Syllabus MCA 4th -Fourth sem Syllabus
MCA-405 Elective-I : E1(e) Advanced DataBase Management System Course Contents:
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.
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.
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.
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.
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).
Accessing Databases through WEB, WEB Servers, XML Databases, Commercial Systems – Oracle xxi, DB2.
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