Babasaheb Ambedkar University
MCA Syllabus
Advance Database Management System
UNIT I
Query Processing, Optimization & Database Tuning: Algorithms for executing query operations, heuristics for query optimization, estimations of query processing cost, join strategies, 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, Datalog, Nested Relational Model and Expert Database System.
UNIT III
Distributed Database System & Database Security: 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
Database Security, Access Control, Grant & Revoke on Views and Integrity Constraints, Discretionary Access Control, Role of DBA Security in Statistical Databases.
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, Isuses in Real Time Database Design.
For more details, visit http://www.bbauindia.org
|
No responses found. Be the first to respond and make money from revenue sharing program.
|