DB-EnginesextremeDB/rt 2.0: Advanced HARD real-time scheduling and integrated flash memory supportEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

Encyclopedia > Article

NoSQL

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.

Classification

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:

Advantages

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

Methods

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

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

MongoDB logo

Build modern apps where you want, how you want, at the speed you want with MongoDB Atlas.
Get started free.

Bytebase logo

Every schema migration
Every database engine
Every access grant
Every data fix
One Platform

Redgate pgCompare logo

pgCompare - PostgreSQL schema comparison for faster, safer deployments.
Stay in control of schema changes across dev, test, and production.
Try pgCompare

Neo4j logo

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

Present your product here