What is NoSQL?

A collective term for databases other than relational databases, including key-value, document, column-oriented and graph types. Many products are easy to scale out across multiple servers and allow flexible data formats, but they are often poor at complex queries such as table joins and at strict consistency.

Japanese name: NoSQL

NoSQL appears in 2 practice questions across 1 topic, including Database Basics.

Field: Database Basics

Try it: questions about NoSQL

Among the databases called NoSQL, which is generally a correct description of the characteristics of a key-value store?

  1. AIt can process complex SQL including table joins and subqueries faster than a relational database
  2. BBefore any data is written, the names and types of all columns must be strictly defined as a schema
  3. CIt specializes in the simple operation of reading and writing a value by specifying its key and is easy to scale out across multiple servers, but it is not suited to complex queries such as table joins
Show answer and explanation

Answer: C. It specializes in the simple operation of reading and writing a value by specifying its key and is easy to scale out across multiple servers, but it is not suited to complex queries such as table joins

NoSQL is a collective term for databases other than relational databases, including key-value, document, column-oriented (wide-column) and graph types. A key-value store saves pairs of a key (identifier) and a value and specializes in the simple operation of retrieving a value by specifying its key. Because data can easily be divided by key and distributed across multiple servers, it is used by web services with very heavy traffic, for example to store information about logged-in users (sessions). On the other hand, it is poor at searching by the contents of values and at complex queries such as table joins, so the application has to work around this. Many products also do not require the format of values to be strictly decided in advance (schemaless). Some products also allow eventual consistency, in which updates are not immediately reflected in all the distributed copies.

NoSQL in the explanations

Questions that mention NoSQL (2)

  1. Among the databases called NoSQL, which is generally a correct description of the characteristics of a key-value store?
  2. Which is an appropriate description of the CAP theorem for a distributed database that keeps copies of data on multiple servers?

Books on Database Basics Ad

As an Amazon Associate I earn from qualifying purchases.

Related terms

ACID properties Database index Database view E-R diagram Foreign key Isolation level Normalization Primary key Relational database SQL

Back to the glossary