Types of Databases
Learn the major types of databases and the considerations for choosing the right one.
We can divide databases into two main types:
Relational databases
Non-relational databases
Relational database
A relational database is a type of database that stores data in tables. We usually connect tables by relationships; this allows the data to be easily accessed and used. For example, a “Customer” table might contain customer information such as their names, addresses, and phone numbers. But the “Customer” table might also include a relationship to the “Product” table, which would store information about each product a customer has purchased. A relational database allows the data to be easily accessed and used. Relational databases are also called SQL databases.
ACID property of a database
ACID is a set of four properties that guarantee the consistency and integrity of data in a database. The ACID properties are:
Atomicity: All of the queries in a group must be executed, or none of them will be executed.
Consistency: The database needs to be consistent after all of the queries in a group have been executed.
Isolation: The execution of one group of queries will not affect the execution of another.
Durability: The results of all of the queries in a group will be permanent, even if the system fails.
The ACID properties are essential because they guarantee that data in a database is consistent and reliable. Without the ACID properties, it would be possible for data to become corrupted or lost.
Popular relational databases
There are many different relational databases available, but some of the most popular ones include the following:
MySQL: is an open-source relational database, and the most popular one in use today.
...