All original content is created in Ukrainian. Not all content has been translated yet. Some posts may only be available in Ukrainian.Learn more

What does relational mean (in the context of relational databases)?

Post cover: What does relational mean (in the context of relational databases)?
Table of contentsClick link to navigate to the desired location
This content has been automatically translated from Ukrainian.
Term "relational"derived from the word "relation", which means "relation" or "connection". In the context of databases and informatics, relational means related tables, where the data is structured in the form of rows and columns and can be related to each other.
Perhaps it will be easier for someone to remember the meaning of this term by referring to its version in English, namely - relational (relational database). That is, relation in English - relationship or connection. So the term relational databases / relational databases it becomes as clear as possible when you know the translation.

Relational database

Relational database <TAG1> is a type of database in which data is stored in tables. Each table consists of rows (records) and columns (fields). A key aspect of relational databases is that relationships can be created between different tables based on shared fields.

An example of a relationship between tables

The Students table can contain information about students, and the Courses table — can contain information about courses. These two tables can be linked together through the "Student ID" or "Course ID" field, which will create connections between students and the courses they are enrolled in.
Relational databases are thus the backbone of many modern storage systems, like MySQL, PostgreSQL, SQLite, Oracle, etc.
This post has a very simplified description of the term, but hopefully provides a basic understanding of the topic.

This post doesn't have any additions from the author yet.

Що таке ідемпотентний метод?
21 Aug 20:57

Що таке ідемпотентний метод?

meme code
meme code@memecode
What is a repository?
21 Aug 21:25

What is a repository?

meme code
meme code@memecode
What is a commit in the context of programming and SCM/Git?
21 Aug 21:37

What is a commit in the context of programming and SCM/Git?

meme code
meme code@memecode
What is SCM (Source Control Management)?
21 Aug 21:46

What is SCM (Source Control Management)?

meme code
meme code@memecode
What hierarchy does the DOM (Document Object Model) have?
23 Aug 09:22

What hierarchy does the DOM (Document Object Model) have?

meme code
meme code@memecode
Як працює модель штучного інтелекту?
15 Sep 16:42

Як працює модель штучного інтелекту?

meme code
meme code@memecode
What is RDBMS (relational database management system)?
21 Sep 08:56

What is RDBMS (relational database management system)?

meme code
meme code@memecode
 What does the ACID principle mean in programming?
24 Sep 20:31

What does the ACID principle mean in programming?

meme code
meme code@memecode
What is Sonvention over Sonfiguration (in the context of RoR and beyond)?
26 Sep 07:47

What is Sonvention over Sonfiguration (in the context of RoR and beyond)?

meme code
meme code@memecode
Округлення десяткових чисел: математичні правила, JavaScript і Ruby
18 Oct 12:59

Округлення десяткових чисел: математичні правила, JavaScript і Ruby

meme code
meme code@memecode
[Фікс] Factory not registered: "user" (KeyError) (FactoryBot / Rails 7)
07 Dec 10:46

[Фікс] Factory not registered: "user" (KeyError) (FactoryBot / Rails 7)

meme code
meme code@memecode
Що таке PORO в Ruby?
08 Dec 12:46

Що таке PORO в Ruby?

meme code
meme code@memecode