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)?
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.
Like it?React
🧵

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

What is an RDBMS (relational database management system)?
Sep 21, '24 08:56

What is an RDBMS (relational database management system)?

What is DDL (Data Definition Language) and DML (Data Manipulation Language)? When and for what purposes are they used?
Mar 27, '24 18:37

What is DDL (Data Definition Language) and DML (Data Manipulation Language)? When and for what purposes are they used?

What is Convention over Configuration (in the context of RoR and beyond)?
Sep 26, '24 07:47

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

What is ORM and why is it needed?
Oct 26, '25 14:00

What is ORM and why is it needed?

What does the error 'is out of range' mean in Ruby on Rails? Range Error - Integer with limit 4 bytes
Jun 13, '24 07:18

What does the error 'is out of range' mean in Ruby on Rails? Range Error - Integer with limit 4 bytes

What does the ACID principle mean in programming?
Sep 24, '24 20:31

What does the ACID principle mean in programming?

How does an artificial intelligence model work?
Sep 15, '24 16:42

How does an artificial intelligence model work?

Rounding decimal numbers: mathematical rules, JavaScript, and Ruby
Oct 18, '24 12:59

Rounding decimal numbers: mathematical rules, JavaScript, and Ruby

What hierarchy does the DOM (Document Object Model) have?
Aug 23, '24 09:22

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

What is SCM (Source Control Management)?
Aug 21, '24 21:46

What is SCM (Source Control Management)?

What is a commit in the context of programming and SCM / Git?
Aug 21, '24 21:37

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

What is a repository?
Aug 21, '24 21:25

What is a repository?

What is an idempotent method?
Aug 21, '24 20:57

What is an idempotent method?

[Fix] Factory not registered: "user" (KeyError) (FactoryBot / Rails 7)
Dec 7, '24 10:46

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

What is PORO in Ruby?
Dec 8, '24 12:46

What is PORO in Ruby?