Types of databases under development

Types of databases

There are many different types of databases. Choosing the best database for a particular company depends on how it intends to use the data.

Relational Databases Relational databases became prevalent in the 1980s. Data in a relational database is organized in the form of tables consisting of columns and rows. A relational DBMS provides fast and efficient access to structured information.

Object-oriented databases Information in an object-oriented database is represented in object form, as in object-oriented programming.

Distributed databases A distributed database consists of two or more parts located on different servers. Such a database can be stored on multiple computers.

Data repositories As a centralized repository for data, a data warehouse is a type of database specifically designed for rapid querying and analysis.

Oracle NoSQL Database A NoSQL database, or non-relational database, gives you the ability to store and process unstructured or weakly structured data (as opposed to a relational database that defines the structure of the data it contains). NoSQL databases are growing in popularity as Web applications proliferate and become more complex.

Graph databases A graph database stores data in the context of entities and relationships between entities. OLTP databases. An OLTP database is a database designed to perform business transactions executed by multiple users.

These are just a few of the dozens of types of databases currently in use. Other, less common databases are designed for very specific scientific, financial, and other tasks. In addition to the emergence of new types, databases are evolving in completely new directions – changing approaches to technology development, significant shifts are taking place, such as the introduction of cloud technologies and automation. In particular, the following databases have recently emerged.

Open Source Databases Such databases are open source and can be managed by both SQL and NoSQL tools.

Cloud databases A cloud database is a set of structured or unstructured data hosted on a private, public, or hybrid cloud computing platform. There are two types of cloud database models: traditional database and database as a service (DBaaS).

In the DBaaS model, administrative tasks and maintenance are performed by the cloud service provider. Multi-model databases. A multi-model database combines different types of database models into a single integrated server-side DBaaS. This means that it can contain different types of data.

Document databases/JSON Document databases are designed to store, retrieve, and process document-oriented information and provide a modern way to store data in JSON format rather than as rows and columns.

Self-Managed Databases Self-managed databases (also called autonomous databases) are the latest and most revolutionary cloud-based databases that use machine learning to automate configuration, protection, backup, updates, and other standard maintenance tasks typically performed by database administrators.