What is Hive in Hadoop?

By | October 19, 2016

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… Read More »

Cap Theorem

By | October 15, 2016

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… Read More »

SQL vs. NoSQL; An Overview

By | October 15, 2016

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… Read More »

Mysql useful production query script

By | October 13, 2016

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;… Read More »

What is and why Nosql and What is big data?

By | October 11, 2016

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… Read More »

Types of NoSQL Databases

By | October 7, 2016

Types of NoSQL Databases Document Oriented Databases A 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 …… Read More »

Categories of Databases

By | October 7, 2016

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… Read More »

Introduction OF MongoDB

By | October 6, 2016

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… Read More »

MYSQL installation step on Linux using RPM packages

By | January 2, 2016

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… Read More »

Tempdb has grown and disk is almost full

By | December 28, 2015

Most of us must have encountered this problem when tempdb data file has grown and the disk is almost full.You can follow below steps. 1.It may be possible that by the time you have logged in into the server,those temporary objects or the queries which caused data file to grown are gone.You can try to shrink… Read More »