Movatterモバイル変換

A. D. Patel Institute Of TechnologyBig Data and Analytics [2171607] : A. Y. 2019-20Installing MongoDB , Querying through MongoDB &MongoDB through JavaScript ShellPrepared By :Dhruv V. Shah (160010116053)B.E. (IT) Sem - VIIGuided By :Dr. Narendra Chauhan(Head Of IT Dept. , ADIT)Department Of Information TechnologyA.D. Patel Institute Of Technology (ADIT)New Vallabh Vidyanagar , Anand , Gujarat1

Outline Introduction Why Use MongoDB ? & What is MongoDB great for? MongoDB : CAP Approach. Steps for MongoDB Installation MongoDB CRUD Operations MongoDB through JavaScript Shell References2

Introduction What is MongoDB ? MongoDB is a general purpose, document-based, distributed database built for modernapplication developers and for the cloud era. MongoDB is a document database, which means it stores data in JSON-like documents (calledBSON [Binary JavaScript Object Notation]). It falls under the category of a NoSQL database. MongoDB is Scalable High-Performance Open-source, Document-orientated database. Built for Speed. Rich Document based queries for Easy readability. Full Index Support for High Performance. Replication and Failover for High Availability. Auto Sharding for Easy Scalability. Map / Reduce for Aggregation.3

Cont..4Fig 1. Terms of SQL & MongoDB Key points of MongoDB1. Develop Faster2. Deploy Easier3. Scale Bigger In MongoDB , Fields contains set of key & value pair.

Why use MongoDB ? MongoDB stores documents (or) objects. Now-a-days, everyone works with objects (Python/Ruby/Java/etc.). And we need Databases to persist our objects. Then why not store objects directly ? Embedded documents and arrays reduce need for joins. No Joins and No-multi documenttransactions.5What is MongoDB great for? RDBMS replacement for Web Applications. Semi-structured Content Management. Real-time Analytics & High-Speed Logging. Caching and High ScalabilityWeb 2.0, Media, SAAS, Gaming, HealthCare, Finance, Telecom, Government

MongoDB : CAP Approach Focus on Consistency and Partitiontolerance. Consistency all replicas contain the same version of the data. Availability system remains operationalon failing nodes. Partition Tolerance multiple entry points system remains operationalon system split6CA PCAP Theorem: satisfying all three at the same timeis impossible.

Steps for MongoDB Installation7Link For MongoDB : https://www.mongodb.com/download-center/enterprise

15 Suppose in my laptop MongoDB location is as below : Path : C:Program FilesMongoDBServer4.2bin In window, we can write this path as follow :cd C:Program FilesMongoDBServer4.2binand then after write mongo.exe then press enter to start the mongoDB.Cont..Fig. MongoDB Terminal

MongoDB CRUD Operations16Fig. MongoDB Operations

 Create or insert operations add new documents to a collection. If the collection does not currently exist, insert/save operations will create the collection. MongoDB provides the following methods to insert documents into a collection :1) db.collection_name.insertOne() .2) db.collection_name.insertMany() . Other than this two methods one another method also available for creating collections which iswritten below: db.createCollection(“collection_name”) .17Create Operations

db.collection_name.insertOne() This command is use for inserting one document at a time in the collection.18 For Eg. :

db.collection_name.insertMany() This command is use for inserting multiple document at a time in the collection.19 For Eg. :

db.createCollection(“collection_name”) This command is use for creating collection.20 For Eg. :

 Read operations retrieves documents from a collection; i.e. queries a collection for documents. MongoDB provides the following methods to read documents from a collection:1) db.collection_name.find() . If we execute the above query for read or display the collection data then it is not produce outputin human readable form or we can say that it produces output in linear sequence. If we want to display the output in humane readable or well formatted way then write belowcommand: db.collection_name.find().pretty() .21Read Operations

 Update operations modify existing documents in a collection. MongoDB provides the following methods to update documents of a collection:1) db.collection_name.updateOne() : This command is use for updating or modifying document value or add a new keyattribute into the existing collection at a time only one updated.2) db.collection_name.updateMany() : This command is use for updating or modifying document value or add a new keyattribute into the existing collection at a time multiple updated.3) db.collection_name.replaceOne() : This method actually work by replacing entire existing document with newdocument. It is not use for modifying the existing document. In MongoDB, update operations target a single collection. All write operations in MongoDB areatomic on the level of a single document.23Update Operations

Cont...24 For Eg. :1) db.collection_name.updateOne() :

Cont...25 For Eg. :2) db.collection_name.updateMany() :

Cont...26 For Eg. :3) db.collection_name.replaceOne() :

 Delete operations remove documents from a collection. MongoDB provides the following methods to delete documents of a collection:1) db.collection_name.deleteOne() : This command is use for removing or deleting document from the collection at atime only one deleted.2) db.collection_name.deleteMany() : This command is use for removing or deleting document from the collection at atime many deleted. In MongoDB, delete operations target a single collection. All write operations in MongoDB are atomic on the level of a single document.27Delete Operations

Cont...28 For Eg. :1) db.collection_name.deleteOne() :

Cont...29 For Eg. :2) db.collection_name.deleteMany() :

 The MongoDB shell is an interactive JavaScript shell. As such, it provides the capability to use JavaScript code directly in the shell or executed as astandalone JavaScript file. You can write scripts for the mongo shell in JavaScript that manipulate data in MongoDB orperform administrative operation.30MongoDB through JavaScript Shell

 OPENING NEW CONNECTIONS From the mongo shell or from a JavaScript file, you can instantiate database connectionsusing the Mongo() constructor: new Mongo() new Mongo(<host>) new Mongo(<host: port>) Consider the following example that instantiates a new connection to the MongoDB instancerunning on localhost on the default port and sets the global db variable to myDatabase usingthe getDB() method: conn = new Mongo(); db = conn.getDB("myDatabase");31Cont...

 DIFFERENCE BETWEEN SHELL HELPERS AND JS EQUIVALENTS32Cont...

 db.adminCommand() db.adminCommand() runs commands against the admin database regardless of the databasecontext in which it runs. EXAMPLE: The following example uses db.adminCommand() to execute therenameCollection administrative database command to rename the orders collection in thetest database to orders-2016.db.adminCommand ({renameCollection: "test.orders",to: "test.orders-2016“})33Cont...

34Cont... db.getCollectionName() Returns an array containing the names of all collections and views in the current database, orif running with access control, the names of the collections according to user’s privilege. EXAMPLE: The following returns the names of all collections in the records database:use recordsdb.getCollectionNames() The method returns the names of the collections in an array:[ "employees", "products", "mylogs", "system.indexes" ]

35Cont... db.getUsers() Returns information for all the users in the database. EXAMPLE:To view all users for the current database who have SCRAM-SHA-256 credentials:db.getUsers({ filter: { mechanisms: "SCRAM-SHA-256" } })

36Cont... Scripting From the system prompt, use mongo to evaluate JavaScript.1) --eval option : Use the --eval option to mongo to pass the shell a JavaScript fragment, as in thefollowing: mongo test --eval "printjson(db.getCollectionNames())"2) Execute a JavaScript file : You can specify a .js file to the mongo shell, and mongo will execute the JavaScriptdirectly. Consider the following example: mongo localhost:27017/test myjsfile.js This operation executes the myjsfile.js script in a mongo shell that connects to the testdatabase on the mongod instance accessible via the localhost interface on port 27017.3) Load a JavaScript : This function loads and executes the myjstest.js file. You can execute a .js file from within the mongo shell, using the load() function, as in thefollowing: load("myjstest.js")

References371) https://www.javatpoint.com/mongodb-tutorial2) https://docs.mongodb.com/manual/tutorial/write-scripts-for-the-mongo-shell/3) https://docs.mongodb.com/manual/crud/4) https://docs.mongodb.com/manual/tutorial/install-mongodb-on-windows/

Movatterモバイル変換

Change Language

MongoDB installation,CRUD operation & JavaScript shell

Embed presentation

Recommended

More Related Content

What's hot

Similar to MongoDB installation,CRUD operation & JavaScript shell

More from ShahDhruv21

Recently uploaded

MongoDB installation,CRUD operation & JavaScript shell