Relational databases are databases that store information in the form of tables. The tables are linked together on the basis of common data. This structure, in particular, allows you to organize queries to a large amount of information simultaneously.
The structure of a relational database is a specific set of elements:
- Table architecture: data is stored in columns and rows.
- Fields: different categories of data, such as phone numbers, calendar dates, or product prices.
- Records: individual records with an assigned unique key (primary key) that identifies the data.
- Relationships: relationships between tables, based on common data known as external keys.
Relational DBMS are used to work with relational databases. They are the most popular solution on the market and are used to organize OLTP solutions (real-time transaction processing). A relational DBMS can handle a large number of small transactions, cancel and edit them under certain conditions.
| Suitable | Not suitable | Popular relational DBMS |
| For systems with large amounts of homogeneous data and complex queries. |
|
|