Types of Databases

In this tutorial, we are going to learn about types of databases in use, small introduction of them, their properties and examples.

Centralized Database

It is a centralized database system that stores information in a database. It enables users to access data stored in the system from a variety of locations and through a range of apps. These programs have a mechanism of authentication that allows users to access data in a secure manner. For example, Central Library is a centralized database that contains information from all of a college or university’s libraries.

Distributed Databases

Data in distributed systems is scattered among several database systems inside an organization, as opposed to a centralized database system. The communication links link these database systems. The utilization of such linkages allows end-users to quickly access data. Examples include Apache Cassandra, HBase, Ignite, and other distributed databases.

Relational Database

The relational data model is the database which stores data in the form of rows (tuples) and columns (attributes), which then form a table (relation). In a relational database, SQL helps to store, manipulate, and preserve data. E.F. Codd invented the database in 1970. Each database table has a unique key that separates its data from that of other tables. Relational databases such as MySQL, Microsoft SQL Server, Oracle, and others are examples.

NoSQL Database

Non-SQL/Not Only SQL is a type of database that can hold a wide range of data sets. Because it stores data in a variety of formats, not only tabular, it is not a relational database. It was developed in response to an increase in the demand for modern software. As a result, NoSQL created a variety of database systems in response to the demands.

Hierarchical Databases

It’s a database in which data is present in the form of parent-child relationship nodes. It uses a tree-like structure to organize data here. Data is kept in the form of records that are linked together. Only one parent will be present in each child record in the tree. Each parent record, on the other hand, can have many child records.

Cloud Database

A database that stores information in a virtual environment and runs on a cloud computing platform. It gives users access to the database using a variety of cloud computing services (SaaS, PaaS, IaaS, and so on). There are several cloud systems to choose from, but the top ones are Amazon Web Services (AWS), Microsoft Azure, Google Cloud SQL, and others.