DB-EnginesCrateDB bannerEnglish
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

Encyclopedia > Article


NoSQL Database Systems are an alternative to the mainstream Relational DBMS. They don't use a relational data model and typically have no SQL interface.

Although this type of systems exists for many years (some even longer than relational systems), the term NoSQL was first introduced in 2009 when many new systems were developed in order to cope with the new requirements for database management systems at that time. E.g.  Big Data, scalability and fault tolerance for large web applications.

The acronym NoSQL is often understood as "Not Only SQL", implying that relational systems are a proven technology but not necessarily the optimal choice for each kind of intended use.


NoSQL systems are a heterogenous group of very different database systems. Therefore each attempt for a classification fails in classifying one or another system. However, the following categegories are well accepted:


Not all of the above mentioned classes have the same general advantages, but they benefit from a combination of the following aspects.

  • higher performance
  • easy distribution of data on different nodes (e.g. sharding), thereby achieving scalability and fault tolerance
  • higher flexibility by using a schema-free data model.
  • simpler administration


These advantages are achieved by means of one or more of the following approaches:

  • No normalized relational data model
  • Abandoning one or more of the ACID criteria
  • Less powerful possibilities for querying the data

Featured Products

Couchbase logo

Power, flexibility & scale.
All open source.
Get started now.

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandraâ„¢ from the Cassandra experts.
Learn more.

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here