Showing posts with label DBMS. Show all posts
Showing posts with label DBMS. Show all posts

Saturday, September 28, 2013

Mongodb: Loading and querying the data

This blog post explains how can we load data from json files and perform simple queries on it. If you wish to install and configure the mongodb, please refer previous post abut the same.

Building database

You can go to mongo shell by clicking on "mongo" or running "./mongo" in bin folder. You can use following simple command to get list of all databases,

> show dbs
admin 0.03125GB
local(empty)

MongoDB: Installation and configuration

This post talks about installing and configuring MongoDB.

Installation:

Go to http://www.mongodb.org/downloads and refer the production release section. Go to corresponding operating system, in this case OS X and click on download. Prefer 64 bit version.[1]

Decompress the downloaded file. Rename the folder as mongodb. You will get a bin directory and few other files. In bin directory there are two files which we will use most frequently, called "mongo" and "mongod". The "mongo" executable will be used to start interactive mongo shell and "mongod" will be used to start mongodb server.

Sunday, April 28, 2013

Introduction to NoSQL

What is NoSQL?

A NoSQL database gives means of storage and retrieval of data with less constrained consistency models than traditional relational databases like Oracle, SQL Server, MySQL. Generally it leads to good performance at big scale. 

Why do we need NoSQL?

"Interactive applications have changed dramatically over the last 15 years, and so have the data management needs of those apps. Today, three interrelated megatrends – Big Data, Big Users, and Cloud Computing – are driving the adoption of NoSQL technology. And NoSQL is increasingly considered a viable alternative to relational databases, especially as more organizations recognize that operating at scale is better achieved on clusters of standard, commodity servers, and a schema-less data model is often better for the variety and type of data captured and processed today." - couchbase