/    /  DBMS – Types

Types Of Databases

Let’s take a look at the most common types of databases that are used-

Centralized Database

In this system, the data is stored in a single location, and it can be accessed from any device, at any time, and at any location. In-built authentication processes allow users to access data securely. 

Distributed Database

A Distributed Database is quite the opposite of a Centralized Database. Here, data is s in different locations of that Cooperation. The data between these locations are connected with the help of communication links which helps in the easy retrieval of data across the other locations.

Distributed Databases are further divided into 2 different types-

  1. Homogeneous – These follow the same application procedure as well as run on the same Operating System
  2. Heterogeneous – These can have different application procedures and operating systems. 

Relational Database

This kind of database stores Data in the form of rows and columns or also called tuples and attributes respectively. They together form a Table or relation. 

The relational database uses SQL for storing, as well as maintenance of data. Some Examples of Relational Databases are MySQL, Oracle. 

 

The ACID properties of the relational model are most commonly known as :

 

  • The A (Atomicity)- This means the operation will only work if it is successful or fails. For example, payment will either be carried out or terminated.
  • The  C (Consistency)- When an operation is performed on the data, the value before and after the operation is performed, is preserved 
  • The I (Isolation)- This means operations performed by one user should not be visible to another user while simultaneous operations are being performed. For example, transactions made in one account should not be visible in another. 
  • The D (Durability)- This ensures that the data that is once committed remains permanent. 

No SQL Database

The No-SQL database is used for Large Distributed Data sets. It is used to build modern-day applications. The No-SQL data type is further divided into 4 types:

    1. Key-Value Storage: This holds data items as keys with their value, similar to that of dictionaries in python.
  • Document-Oriented Database: It helps to store data in the same format as that of the application.
  • Graph Database: This helps to store huge data in the form of Graphs.
  • Wide-Column stores: Here data is stored in the form of huge columns only. No rows are involved here unlike relational databases. 

Reference :

Database types