Skip to content

Notes on science, software and the craft of support

Martin EvansNotes and resources

Databases

The main types of database

From relational tables and NoSQL documents to object stores, graphs and cloud databases, each database type fits a different job.

Databases are an integral part of modern computing and are used in a variety of applications, from managing large amounts of data to providing access to information. A database is a structured collection of data, organised in a certain way, which allows efficient retrieval, manipulation and storage of information.

A database is a collection of related data organised so that it can be accessed, queried and manipulated in a variety of ways. Most databases use tables to store data and a query language to manipulate it.

Relational and NoSQL

The most common query language is Structured Query Language, or SQL. SQL is a powerful language that allows users to store, retrieve, manipulate and delete data. The most common type of database is the relational database, which stores data in tables and allows relationships between tables. Those relationships can be used to join related data, making it easier to query and manipulate. Relational databases are the most popular type and are used in industries from banking to retail.

NoSQL databases are another type used for storing and managing large amounts of unstructured data. They are typically used for web and mobile applications and are often used alongside a relational database. NoSQL databases allow quick access to data and can scale to accommodate large amounts of data.

Objects, graphs and cloud

Object oriented databases manage complex types of data. They use objects such as classes and instances to store and manage data and are often used for applications such as video games and 3D modelling. Graph databases store and query data related in a graph structure. They are used for social networks and recommendation systems.

Cloud databases are hosted on the cloud and are used to store and manage information there. They are often used for web applications, mobile applications and analytics. Databases are an essential part of modern computing, and different types are used for different applications. Understanding the types and their uses is an important part of being an effective programmer or database administrator.