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 »

Bharat Negi

HIVE USES

Uses of HIVE 1. The Apache Hive distributed storage. 2. Hive provides tools to enable easy data extract/transform/load (ETL) 3. It provides the structure on a variety of data formats. 4. By using Hive, we can access files stored in Hadoop Distributed File System (HDFS is used to querying and managing large datasets residing in) or in other… Read More »

Abhishek Sharma

What is Hive in Hadoop?

Apache Hive is a data warehouse system for Hadoop, which enables data summarization, querying, and analysis of data by using HiveQL (a query language similar to SQL). Hive can be used to interactively explore your data or to create reusable batch processing jobs. After you define the structure, you can use Hive to query that data without knowledge… Read More »

Abhishek Sharma

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 »

Bharat Negi

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 »

Bharat Negi

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 »

Bharat Negi

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 »

Bharat Negi

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 »

Bharat Negi

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.

Bharat Negi

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 »

Bharat Negi