Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

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

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Present your product here