munotes®
Sign in
Home / Syllabus / B.E. (Computer Engineering) / Third Year CE / Semester 5 / Advance Database Management System

B.E. (Computer Engineering) Advance Database Management System Syllabus - Mumbai University 2026

The University has moved this degree onto NEP 2020 one year at a time. The first and second years are NEP 2020 syllabi; the third and fourth years are still examined on the REV-2019 'C' Scheme, which is what the University sets for them this year.

Advance-Database-Management-System.pdf
Semester 5 · Third Year CE

Loading syllabus...

Syllabus for Advance Database Management System

Semester 5 · Third Year CE

Module 1: Distributed Databases

  • 1.1 Introduction, Distributed DBMS Architecture, Data Fragmentation, Replication and Allocation Techniques for Distributed Database Design.

Module 2: Distributed Database Handling

  • 2.1 Distributed Transaction Management – Definition, properties, types, architecture Distributed Query Processing - Characterization of Query Processors, Layers/ phases of query processing.
  • 2.2 Distributed Concurrency Control- Taxonomy, Locking based, Basic TO algorithm, Recovery in Distributed Databases: Failures in distributed database, 2PC and 3PC protocol.

Module 3: Data interoperability – XML and JSON

  • 3.1 XML Databases: Document Type Definition, XML Schema, Querying and Transformation: XPath and XQuery.
  • 3.2 Basic JSON syntax, (Java Script Object Notation),JSON data types, Stringifying and parsing the JSON for sending & receiving, JSON Object retrieval using key-value pair and JQuery, XML Vs JSON

Module 4: NoSQL Distribution Model

  • 4.1 NoSQL database concepts: NoSQL data modeling, Benefits of NoSQL, comparison between SQL and NoSQL database system.
  • 4.2 Replication and sharding, Distribution Models Consistency in distributed data, CAP theorem, Notion of ACID Vs BASE, handling Transactions, consistency and eventual consistency
  • 4.3 Types of NoSQL databases: Key-value data store, Document database and Column Family Data store, Comparison of NoSQL databases w.r.t CAP theorem and ACID properties.

Module 5: NoSQL using MongoDB

  • 5.1 NoSQL using MongoDB: Introduction to MongoDB Shell, Running the MongoDB shell, MongoDB client, Basic operations with MongoDB shell, Basic Data Types, Arrays, Embedded Documents
  • 5.2 Querying MongoDB using find() functions, advanced queries using logical operators and sorting, simple aggregate functions, saving and updating document. MongoDB Distributed environment: Concepts of replication and horizonal scaling through sharding in MongoDB

Module 6: Trends in advance databases

  • 6.1 Temporal database: Concepts, time representation, time dimension, incorporating time in relational databases.
  • 6.2 Graph Database: Introduction, Features, Transactions, consistency, Availability, Querying, Case Study Neo4J
  • 6.3 Spatial database: Introduction, data types, models, operators and queries

Useful Links

  • 1 Korth, Siberchatz,Sudarshan, “Database System Concepts”, 6thEdition, McGraw Hill
  • 2 Elmasri and Navathe, “Fundamentals of Database Systems”, 5th Edition, Pearson Education
  • 3 Ozsu, M. Tamer, Valduriez, Patrick, “Principles of distributed database systems”,3rd Edition, Pearson Education, Inc.
  • 4 PramodSadalge, Martin Fowler, NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Addison Wesely/ Pearson
  • 5 Jeff Friesen , Java XML and JSON,Second Edition, 2019, après Inc.
  • 1 Peter Rob and Carlos Coronel,Database Systems Design, Implementation and Management, Thomson Learning, 5th Edition.
  • 2 Dr. P.S. Deshpande, SQL and PL/SQL for Oracle 10g, Black Book, Dreamtech Press.
  • 3 Adam Fowler, NoSQL for dummies, John Wiley & Sons, Inc.
  • 4 Shashank Tiwari, Professional NOSQL, John Willy & Sons. Inc
  • 5 Raghu Ramkrishnan and Johannes Gehrke, Database Management Systems, TMH
  • 6 MongoDB Manual : https://docs.mongodb.com/manual
  • 1 https://cassandra.apache.org
  • 2 https://www.mongodb.com
  • 3 https://riak.com
  • 4 https://neo4j.com
  • 5 https://martinfowler.com/articles/nosql-intro-original.pdf

Reproduced from the University of Mumbai syllabus for B.E. (Computer Engineering) under REV-2019 'C' Scheme, in force from the academic year 2021-22. Wording is as printed in that syllabus. Module numbering is as printed there too.

The complete syllabus

This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.

PDF 7.9 (R-A) B.E. (Computer Engineering) Sem I & II (Revised, NEP 2020) NEP 2020 syllabus Read full PDF Read
PDF 6.24 (N) B.E. (Computer Engineering) Sem III & IV (NEP 2020) NEP 2020 syllabus Read full PDF Read
PDF 6.15 B.E. (Computer Engineering) Third Year, Sem V & VI (REV-2019 'C' Scheme) REV-2019 'C' Scheme syllabus Read full PDF Read
PDF 6.41 (R) B.E. (Computer Engineering) Fourth Year, Sem VII & VIII (REV-2019 'C' Scheme) REV-2019 'C' Scheme syllabus Read full PDF Read
Report or request
Done!