Unit-I
Query Processing, Optimization & Database Tuning:
Algorithms For Executing Query Operations.Heuristics For Query Optimizations, Estimations Of Query Processing Cost, Join Strategies For Parallel Processors, Database Workloads, Tuning Decisions, DBMS Benchmarks, Clustering & Indexing, Multiple Attribute Search Keys, Query Evaluation Plans, Pipelined Evaluations, System Catalogue In RDBMS.
Unit-II
Extended Relational Model & Object Oriented Database System:
New Data Types, User Defined Abstract Data Types, Structured Types, Object Identity, Containment, Class Hierarchy, Logic Based Data Model, Data Log, Nested Relational Model And Expert Database System.
Unit-III
Distributed Database System:
Structure Of Distributed Database, Data Fragmentation, Data Model, Query Processing, Semi Join, Parallel & Pipeline Join, Distributed Query Processing In R * System, Concurrency Control In Distributed Database System, Recovery In Distributed Database System, Distributed Deadlock Detection And Resolution, Commit Protocols.
Unit –IV
Enhanced Data Model For Advanced Applications:
Database Operating System, Introduction To Temporal Database Concepts, Spatial And Multimedia Databases, Data Mining, Active Database System, Deductive Databases, Database Machines, Web Databases, Advanced Transaction Models, Issues In Real Time Database Design.
Unit-V
Introduction To Expert Database And Fuzzy Database System:
Expert DataBases: Use of Rules of Deduction in Databases, Recursive Rules.
Fuzzy DataBases: Fuzzy Set & Fuzzy Logic, Use Of Fuzzy Techniques to Define Inexact and Incomplete DataBases.
References
1. Majumdar & Bhattacharya, “Database Management System”, TMH.
2. Korth, Silbertz, Sudarshan, “ Database Concepts”, McGraw Hill.
3. Elmasri, Navathe, “Fundamentals Of Database Systems”, Addison Wesley.
4. Data C J,” An Introduction To Database System”, Addison Wesley.
5. Ramakrishnan, Gehrke, “Database Management System”, McGraw Hill.
6. Bernstein, Hadzilacous, Goodman, “ Concurrency Control & Recovery”, Addison Wesley.
7. Ceri & Palgatti, “Distributed Databases”, McGraw Hill.