Main ⁄ ⁄ Relational database

Relational database

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.
  • For storing unstructured data
  • For very simple “Key-value” structures.
  • Oracle
  • Microsoft SQL
  • PostgreSQL
  • MySQL
  • IBM DB2

Leave a Reply

Your email address will not be published. Required fields are marked *