NoSQL

A Not Only SQL database provides a mechanism for storage and retrieval of data that modeled in means other than the tabular relations used in relational databases. Advantages of this approach include simplicity of design, horizontal scaling and finer control over availability. The data structure differs from the RDBMS, and therefore some operations are faster in this database and some in RDBMS. There are differences though and the particular suitability of a given Not Only SQL DB depends on the problem to be solved.

Not Only SQL comes in many flavors including MongoDB, CassandraDB, and CoachDB.

NoSQL is growing fast, even in Big Data industries

NoSQL Services

There have been various approaches to classify NoSQL databases, each with different categories and subcategories. Because of the variety of approaches and overlaps it is difficult to get and maintain an overview of non-relational databases.

NoSQL is a new idea and there is room to grow

Classification can be based on the data model or the feature. There are a number of potential examples to guide future use.

With NoSQL there are a lot of options

Document store, Graph, KV Store, and Cell Databases.

With the growth of NoSQL there are a growing number of examples

NoSQL databases can be run on-premises, but are also often run on IaaS or PaaS platforms like Amazon Web Services, RackSpace or Heroku. There are three common deployment models for NoSQL on the cloud: Virtual Machine, Database as a service, and Native cloud NoSQL databases.

Simple, NoSQL cloud based systems have many advantages

NoSQL is Growing

Not Only SQL databases are finding significant and growing industry use in big data and real-time web applications. NoSQL systems can allow SQL-like query languages to be used. Many Not Only SQL stores compromise consistency in favor of availability and partition tolerance.

It's worth looking at NoSQL as an option

There are some disadvantages to Not Only SQL, including the use of low-level query languages, the lack of standardized interfaces, and the investments already made in SQL by enterprises. Most Not Only SQL stores lack true ACID transactions, although a few recent systems have made them central to their designs.

© Copyright 2012 - Acumen Consulting - St. Louis