Seitenvergleich

In the following you get a short introduction to the Mongo Management Studio and will become familiar with the most important functions. The local version serves as the basis. In addition, we assume that you have access to a Mongo database. We use the collection zipcode as  collection as a template for our examples.

...

• Download the Mongo Management Studio version required appropiate for your system
• Run the setup routine
• Start the application

Setting the English Switch language to english

• Click the gear icon next to the button "Connect"
• It will open the application settings
• In the first selection box checkbox,   select "English" as language

Connect

• Click on the button "Connect"
• Enter the connection data for your Mongo database (for example localhost) into the field "Server Connection"
• Click "Save and connect"

...

• Rightclick with the mouse onto the name of the Mongo server
• Select "Add database" in the popup menu
• Enter the database name "demo" and save it

Import of the zipcode collection

• Download the collection zipcode (http://media.mongodb.org/zips.json)
• Rightclick with the mouse button onto the demo database and select Import documents
• Insert "zipcode" as name of the destination collection
• Drag the "zips.json" file into the file upload field   
• Click the "Import"-button

...

• Click in the database "demo" onto the collection "zipcode"
• Switch to table view
• Search for the city of CHESTER. For this enter following query in the search window

city: 'CHESTER'

• Run the query by clicking on the "Run"-button or by the keyboard shortcut CMD + ENTER (MAC) or CTRL + ENTER (Windows / Linux)
• Sort the results by the column "pop" (population)

Edit a document

• Select a document and click the icon for "Edit document"
• Change the field "city" to "CHESTER123"
• Click "Save"

Create a document

• Click the button "Add document"
• Input the following record:

...

• Click "Save"

Querying with regex

• Search for all the cities containing 123

city: /123/

...

• Select "A" (aggregation) in the toolbar for an aggregation Framework query
• Enter the following query in the search window

{
	$group: {
		_id : "$state",
    	totalPop : { $sum : "$pop" } 
	} 
},
{ 
	$match: {
		totalPop : { $gte : 10000000 } 
	} 
} 

...

• Select "C" (console) in the toolbar for the console mode
• Enter the following query in the search window

db.zipcode.stats()

...