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.
The term "relational" comes from the word "relation", which means "relationship" or "connection". In the context of databases and computer science, relational means related tables, where data is structured in the form of rows and columns and can be linked to each other.
It may be easier for some to remember the meaning of this term by referring to its English variant, namely - relational (relational database). That is, relation in English means relationship or connection. Thus, the term relational databases / реляційні бази даних becomes maximally clear when you know the translation.

Relational Database

Relational database 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 common fields.

Example of a Relationship Between Tables

The "Students" table may contain information about students, while the "Courses" table contains information about courses. These two tables can be linked to each other through the "Student ID" or "Course ID" field, allowing for the creation of relationships between students and the courses they are enrolled in.
Thus, relational databases are the foundation of many modern data storage systems, such as MySQL, PostgreSQL, SQLite, Oracle, etc.
This post provides a very simplified description of the term, but I hope it gives a basic understanding of the topic.

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

What is an idempotent method?
21 Aug 20:57

What is an idempotent method?

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
How does an artificial intelligence model work?
15 Sep 16:42

How does an artificial intelligence model work?

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

What is an 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 Convention over Configuration (in the context of RoR and beyond)?
26 Sep 07:47

What is Convention over Configuration (in the context of RoR and beyond)?

meme code
meme code@memecode
Rounding decimal numbers: mathematical rules, JavaScript, and Ruby
18 Oct 12:59

Rounding decimal numbers: mathematical rules, JavaScript, and Ruby

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

[Fix] Factory not registered: "user" (KeyError) (FactoryBot / Rails 7)

meme code
meme code@memecode
What is PORO in Ruby?
08 Dec 12:46

What is PORO in Ruby?

meme code
meme code@memecode