Advance DBMS II

Paper Code: 
MCA 425A
Credits: 
04
Periods/week: 
04
Max. Marks: 
100.00
Objective: 
  • This course is intended to provide an understanding of the current theory and practice of advanced database management systems.
  • The syllabus provides an understanding of the context, phases and techniques used for designing typical database systems.
10.00
Unit I: 
Introduction to Distributed Database Management System

Definition, Advantages & Disadvantages, Characteristics, Distributed Database (DDB), Data Independence, Homogeneous Vs Heterogeneous Distributed Database, Distributed DBMS Architecture, Distributed Data Design and Storage- Fragmentation (Horizontal and Vertical) and Replication.

14.00
Unit II: 
Advanced Distributed Database Concepts

Transactions Management, Distributed Concurrency Control, Distributed Deadlock Detection, Commit protocol (2 PC, 3PC), Database Recovery, Distributed Query Processing, Query Decomposition & Data Localization, Optimization of Distributed Queries.

12.00
Unit III: 
Parallel Databases

Introduction, Parallel Database Architecture, Parallel Vs Distributed database, I/O Parallelism, Skew, Inter-Query Parallelism, Intra-Query Parallelism, Intra-Operation Parallelism ( Parallel Join, Parallel Sort, Other Relational Operations), Interoperation Parallelism (Pipelined and Independent Parallelism), Design of Parallel Systems

12.00
Unit IV: 
Object Oriented Database

Introduction, Advantages & Disadvantages,  Characteristics, OODB, Object Oriented Data Model, OORDBMS Vs OODBMS, Object Oriented Languages, Persistent Programming Languages,  Object Relational Databases: Nested Relations, Complex Types, Inheritance, Reference Types, Querying with Complex Types, Functions and Procedures Storage for Object Databases, Optimization of OODBMS

12.00
Unit V: 
XML Database and Information Retrieval

Client server Architecture, Database Vs Web Architecture, Introduction to XML Database, A Data Model for XML, Xquery, FLOWR, XPath, XML Validation, Storage of XML Data, Efficient Evaluation of XML Queries, XML Applications.

Introduction to Information Retrieval, Indexing for Text Search, Web Search Engines, Managing Text in a DBMS, Measuring Retrieval Effectiveness.

ESSENTIAL READINGS: 
  • Elmasri, Navathe, “Fundamentals of Database Systems”, Addison Wesley, 6th Edition, 2011
  • Korth, Silberschatz, Sudarshan, “Database Concepts”, McGraw Hill, 6th Edition, 2010
REFERENCES: 
  • Thomas Connolly and Carolyn Begg, “Database Systems: A Practical Approach to Design, Implementation, and Management”, Addison Wesley , 5th Edition, 2010
  • Ramakrishnan, Gehrke, “Database Management System”, McGraw Hill, 3rd Edition, Jan 2007
  • Date C J, “An Introduction to Database System”, Addision Wesley, 8th Edition 2003
  • Bipin C. Desai, “An Introduction to Database Systems”, Galgotia Publication, Revised Edition, 2010
  • Majumdar & Bhattacharya, “Database Management System”, TMH, 2005
  • Paul Beynon Davies, “Database Systems”, Palgrave Macmillan, 3rd Edition, 2003.
Academic Year: 
2018-19
  • Printer-friendly version