How to Install MongoDB 3.2 on CentOS/RHEL

This article will help you to install MongoDB 3.2.X on CentOS, and RHEL . MongoDB is a free, cross-platform, open source, NoSQL document-oriented database. MongoDB is available as two editions, Community and Enterprise edition. MongoDB community edition is free for personal usage, whereas enterprise edition is paid version that have more features and support than the community edition. In this article, we will… Read More »

Cap Theorem

The BASE acronym was defined by Eric Brewer, who is also known for formulating the CAP theorem. The CAP theorem states that a distributed computer system cannot guarantee all of the following three properties at the same time: Consistency:  every read would get you the most recent write,  all executions of reads and writes seen by all nodes… Read More »

SQL vs. NoSQL; An Overview

In this article, we’ll outline the differences between SQL and NoSQL, the vast array of differences within NoSQL technologies themselves, and discuss if  RDBMS  really are a thing of the past. NoSQL is a category of databases distinctly different from SQL databases. NoSQL is often used to refer to data management systems that are “Not SQL” or an… Read More »

Mysql useful production query script

How to start MySQL # service mysqld start # /etc/init.d/mysqld start How to set root password in MySQL # mysqladmin password “redhat” How to Login in Mysql # mysql -u root -predhat mysql> How to change root and Users password mysql> UPDATE mysql.user SET Password=PASSWORD(‘redhat123′) WHERE User=’root’; How to Create database mysql> create database DB-NAME; How to Check… Read More »

What is and why Nosql and What is big data?

NoSQL, or “not only SQL,” offers a new approach to managing large volumes of structured, semi-structured and unstructured data. NoSQL distributes workloads across commodity hardware which enables cost effective storage, processing and analysis of disparate data sets quickly. As an open source platform, NoSQL encompasses a wide variety of different database technologies that were developed in response to… Read More »

Types of NoSQL Databases

Types of NoSQL Databases Document Oriented DatabasesA document database is designed to store semi-structured data as documents, typically in JSON or XML format.At a collection level, this allows for putting together a diverse set of documents into a single collection. Document databases allow indexing of documents on the basis of not only its … Document Oriented Databases A… Read More »

Categories of Databases

OLTP  is a class of systems that supports or facilitates high transaction-oriented applications it is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second.

Introduction OF MongoDB

MongoDB is an open-source document database. It is developed in C++ and hence, it provides flexibility with object-oriented concepts MongoDB provides MapReduce VPI’s. There is a tool called Gird FS which is used to store huge amount of data comprising different structure Schema less is big advantage of MongoDB over RDBMS . one collection holds any no of… Read More »

MYSQL installation step on Linux using RPM packages

MySQL is one of the best RDBMS being used for developing web-based software applications. It’s very easy to learn and maintained. The purpose of writing this tutorials will help you to quick start with Mysql Download Mysql tar file from valid sources. The recommended way to install MySQL on a Linux system is via RPM Now, follow the… Read More »

Find the top 2 Candidate who have the highest vote

Try this query for getting the highest two records.