0% found this document useful (0 votes)

17 views89 pages

Module-III MongoDB

The document outlines a module on MongoDB, detailing its features, CRUD operations, and data handling techniques. It includes learning objectives, session plans, and an agenda covering topics such as JSON, data types, and the MapReduce framework. Additionally, it provides examples of MongoDB commands for creating, updating, and querying data.

Uploaded by

chinnu.200420

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

17 views89 pages

Module-III MongoDB

Uploaded by

chinnu.200420

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

You are on page 1/ 89

RNS INSTITUTE OF Technology

Module -III
Mongo DB
SUNIL G L
Assistant Professor
Department of CSE(DS)
RNS Institute of Technology
Bangalore-560098

Sunil G L, CSE(DS),RNSIT
Sunil G L, CSE(DS),RNSIT
Learning Objectives and Learning Outcomes
Learning Objectives Learning Outcomes
Introduction to MongoDB

1. To study the features of MongoDB. a) To comprehend the reasons

behind the popularity of NoSQL
2. To learn how to perform CRUD database.
operations.
b) To be able to perform CRUD
3. To study aggregation. operations.

4. To study the MapReduce c) To comprehend MapReduce

Framework. framework.

5. To import from and export to CSV d) To understand the aggregation.

format.
e) To be able to successfully
import from and export to CSV.

Sunil G L, CSE(DS),RNSIT
Session Plan

Lecture time 90 to 120 minutes

Q/A 15 minutes

Sunil G L, CSE(DS),RNSIT
Agenda

➢ What is MongoDB?

➢ Why MongoDB?
❖ Using JSON
❖ Creating or Generating a Unique Key
❖ Support for Dynamic Queries
❖ Storing Binary Data
❖ Replication
❖ Sharding
❖ Terms used in RDBMS and MongoDB

➢ Data Types in MongoDB

➢ CRUD (Insert(), Update(), Save(), Remove(), Find())

❖ MapReduce Functions
❖ Aggregation
❖ Java Scripting
❖ MongoImport
❖ MongoExport
Sunil G L, CSE(DS),RNSIT
MongoDB– An Introduction

Sunil G L, CSE(DS),RNSIT
What is MongoDB?

MongoDB is:

1. Cross-platform.

2. Open source.

3. Non-relational.

4. Distributed.

5. NoSQL.

6. Document-oriented data store.

Sunil G L, CSE(DS),RNSIT
Why MongoDB?

• Open Source

• Distributed

• Fast In-Place Updates

• Replication

• Full Index Support

• Rich Query Language

• Easy Scalability

• Auto sharding

Sunil G L, CSE(DS),RNSIT
JSON

Sunil G L, CSE(DS),RNSIT
JSON (Java Script Object Notation)

Sample JSON Document

{
FirstName: John,
LastName: Mathews,
ContactNo: [+123 4567 8900, +123 4444 5555]
}

Sunil G L, CSE(DS),RNSIT
Unique Identifier

Each JSON document should have a unique identifier. It is the _id key.

0 1 2 3 4 5 6 7 8 9 10 11
Timestamp Machine ID Process ID Counter

• Data Base
• Collection
• Document

Sunil G L, CSE(DS),RNSIT
Support for Dynamic Queries

MongoDB has extensive support for dynamic queries.

This is in keeping with traditional RDBMS wherein we have static data and
dynamic queries.

Sunil G L, CSE(DS),RNSIT
Storing Binary Data
MongoDB provides GridFS to support the storage of binary data.

It can store up to 4 MB of data.

Sunil G L, CSE(DS),RNSIT
Replication in MongoDB

Client Application

Writes Reads

Primary

Replication Replication
Replication

Secondary Secondary Secondary

Sunil G L, CSE(DS),RNSIT
Sharding in MongoDB

Collection 1

1 TB database

Shard 1 Shard 2 Shard 3 Shard 4

(256 GB) (256 GB) (256 GB) (256 GB)

Logical Database (Collection 1)

Sunil G L, CSE(DS),RNSIT
Terms Used in RDBMS and MongoDB

RDBMS MongoDB
Database Database
Table Collection
Record Document
Columns Fields / Key Value pairs
Index Index
Joins Embedded documents
Primary Key Primary key (_id is a identifier)

Sunil G L, CSE(DS),RNSIT
Sunil G L, CSE(DS),RNSIT
Sunil G L, CSE(DS),RNSIT
Data Types in MongoDB

Sunil G L, CSE(DS),RNSIT
Data Types in MongoDB
String Must be UTF-8 valid.
Most commonly used data type.
Integer Can be 32-bit or 64-bit (depends on the server).
Boolean To store a true/false value.
Double To store floating point (real values).
Min/Max keys To compare a value against the lowest or highest
BSON elements.
Arrays To store arrays or list or multiple values into one
key.
Timestamp To record when a document has been modified or
added.
Null To store a NULL value. A NULL is a missing or
unknown value.
Date To store the current date or time in Unix time
format. One can create object of date and pass day,
month and year to it.
Object ID To store the document’s id.
Binary data To store binary data (images, binaries, etc.).
Code To store javascript code into the document.
Sunil G L, CSE(DS),RNSIT
Regular expression To store regular expression.
Creating a Data base

Sunil G L, CSE(DS),RNSIT
Drop Data base

Sunil G L, CSE(DS),RNSIT
Creating a Data base

Sunil G L, CSE(DS),RNSIT
CRUD in MongoDB

Sunil G L, CSE(DS),RNSIT
Collections

To create a collection by the name “Person”. Let us take a look at the

collection list prior to the creation of the new collection “Person”.

db.createCollection(“Person”);

Sunil G L, CSE(DS),RNSIT
Collections

To drop a collection by the name “food”.

db.food.drop();

Sunil G L, CSE(DS),RNSIT
Insert Method

Create a collection by the name “Students” and store the following data in it.

db.Students.insert({_id:1, StudName:"Michelle Jacintha", Grade: "VII", Hobbies:

"Internet Surfing"});

Sunil G L, CSE(DS),RNSIT
Update Method

Insert the document for “Aryan David” into the Students collection only if it
does not already exist in the collection. However, if it is already present in
the collection, then update the document with new values. (Update his
Hobbies from “Skating” to “Chess”.) Use “Update else insert” (if there is an
existing document, it will attempt to update it, if there is no existing
document then it will insert it).