Advance DBMS II

Paper Code: 
MCA 425A
Credits: 
04
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

 The course will enable the students to

  1. Ability to apply acquired knowledge for developing holistic solutions based on database systems/database techniques.
  2. Understand architectures of new database systems like Parallel Database, Distributed DBMS, Object-Oriented DBMS and XML Database
  3. Understand query processing, query optimization, concurrency, security, storage and transaction management of advanced database concepts.
  4. Gain in-depth information about system implementation techniques,  data element representation, complex types and data models of emerging database technologies and applications.

 Course Learning Outcomes (CLOs):

 

Learning Outcome (at course level)

Students will be able to:

Learning and teaching strategies

Assessment Strategies

  1. Explain and evaluate the fundamental theories and requirements that influence the design of modern database systems
  2. Assess and apply database functions and packages suitable for enterprise database development and database management
  3. Critically evaluate alternative designs and architectures for databases and data warehouses
  4. Discuss and evaluate methods of storing, managing and interrogating complex data
  5. Analyze the background processes involved in queries and transactions, and explain these impacts on database operation and design.

Approach in teaching:

Interactive Lectures, Discussion, Demonstration with real world examples, Role plays, tool based experiment

 

Learning activities for the students:

Self-learning assignments, Quiz activity, Effective questions, case study based learning approach, presentation, flip classroom

 

  • Assignments
  • Written test in classroom
  • Classroom Activity
  • Continuous Assessment
  • Semester End Examination

 

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 databse, 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: 
2019-20
  • Printer-friendly version