Department of Information Technology 1
Advanced Database Management Systems
(20CSH5D/20CBH5D/20DSH5D)
Prerequisites:
Database Management Systems(20IT403)
Course Objectives:
COB 1: Determine the importance of NoSQL Databases and Understand four types of NoSQL Databases
(Document-oriented, KeyValue Pairs, Column-oriented and Graph).
COB 2: Explain the detailed architecture, define objects, load data, query data and performance tune
Document-oriented NoSQL databases.
COB 3: Familiar with MongoDB, installation of mongoDB, CRUD operations, Aggregation framework.
COB 4: Understand the concepts of performance tuning in MongoDB and database sharding.
Course Outcomes:
By the end of the course student will be able to
CO1: Describe NoSQL Databases.
CO2: Manage Document-oriented NoSQL databases.
CO3: Execute CRUD operations on MongoDB database.
CO 4: Evaluate NoSQL database development tools and programming languages.
Mapping of Course outcomes with Program outcomes:
CO/PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12
CO1 - - 2 1 2 1 - - - 2 2 -
CO2 - - - - - - 2 1 1 - 1 -
CO3 - - - 2 3 - - 1 - 1 1 -
CO4 - - - 1 - - - 1 - 1 - -
Bapatla Engineering College
Department of Information Technology 2
Mapping of Course outcomes with Program Specific outcomes:
CO/ PSO1 PSO2 PSO3
PSO
CO1 - 3 1
CO2 - 2 1
CO3 - 1 1
CO4 - 2 3
UNIT - I (15 Periods)
Introduction to NoSQL: Difference between RDBMS and NoSQL Database, Definition of NoSQL,
History of NOSQL, NoSQL Storage Architecture, Types of NoSQL databases- Document Databases, Key-
value databases, Column Oriented databases, Graph databases. When to use NoSQL and when not,
Interfacing and Interacting with NoSQL.
UNIT - II (15 Periods)
Introduction MongoDB: MongoDb Installation, Basics of MongoDb, MongoDb Shell, MongoDb
Datatypes, MongoDb CRUD operations: Adding new documents to a collection, Selecting documents,
updating existing documents, Removing documents from a collection.
UNIT - III (15 Periods)
MongoDb Aggregation Frameworks and MongoDb Aggregation operations:$group, $limit, $project,
$sort, $match, $add fields, $count, $lookup, $out operators. MongoDb sorting, MongoDb Indexing:
Single field Indexes, Sorting with Indexes, Compound Indexes, Partial Indexes.
UNIT - IV (15 Periods)
MongoDB Import and Export, Sharding in MongoDB, MongoDb Python Drivers, Python and MongoDB,
Creating Application with Python and MongoDB.
TEXT BOOKS:
1. MongoDB - The Definitive Guide, 2nd edition, Oreilly.
2. Pramod J. Sadalage, Martin Fowler, “NoSQL Distilled: A Brief Guide to the Emerging World of
Polyglot Persistence”, 1st edition, Pearson Education, 2012.
REFERENCES:
1. MongoDB Cook Book, 2nd edition, Cyrus Dasadia & Amol Nayak, PACKT Publishing.
2. Dan Sullivan,“NoSQL for Mere Mortals”,1st edition, Pearson Education, 2015.
[Link]
Bapatla Engineering College
