ADVANCED DBMS

Paper Code: 
MCS 422C
Credits: 
04
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

The objective of this paper is to give the knowledge about Advanced DBMS.

12.00
Unit I: 
Distributed Database:

Introduction, Distributed Data Storage, Distributed Transactions, Commit protocol: 2-phase, 3-phase, Concurrency Control in distributed Environment, Distributed Query Processing: horizontal/vertical fragmentation

12.00
Unit II: 
Parallel Database:

Introduction, Parallel Architecture, I/O Parallelism, Interquery Parallelism, Intra Query Parallelism, Intraoperation Parallelism: Parallel Sort, Parallel Join, Interoperation Parallelism: Pipelined and Independent Parallelism

 

12.00
Unit III: 
Object Oriented DBMS:

Introduction, Object oriented Database, Object oriented Data Model, Features of Object Oriented Languages, Persistent Programming Languages, ORDBMS: Nested Relations, Complex Types, OQL, Inheritance, Reference Types, Storage for Object Databases, Comparison of OODBMS and ORDBMS.

12.00
Unit IV: 
Query Processing and Recovery System

Introduction, Measures of Query Cost, Selection Operation, Sorting, Join Operation, Set Operations, Evaluation of Expressions, Recovery and Atomicity, Failure Classification, Log based recovery and Log Maintenance.

 

12.00
Unit V: 
PL/SQL:

Introduction, Advantages of PL/SQL over SQL, block, architecture, character set, data types, compilation, programming constructs: conditional statement, iteration, exception handling, cursors: implicit, explicit, cursor for loop, procedures, functions, triggers, packages

ESSENTIAL READINGS: 

1. Abraham Silberschatz, Henry F. Korth, S. Sudarshan, “Database System Concept”, Mc Graw Hill International Edition, 2006

REFERENCES: 

1. Raghu Ramakrishnan, Johannes Gehrke, “Database Management Systems”, McGraw Hill International Edition, 2000

2. R.Elmasri and SB Navathe, “Fundamentals of Database Management Systems”, Addison Wesley, 4th Ed., 2004

 

Academic Year: 
2017-18
  • Printer-friendly version