What is a Relational Database?

By on

A relational database is a type of structure organizing data into groups through tables, that contain rows and columns. These tables connect by keys associated with each row in other tables.

Data in any relational database can be added to, viewed, filtered, modified or deleted through a standard programming interface called structured query language (SQL). SQL provides the foundation in relational database usage, including forms to interact with the data (e.g. searching data, entering in new data) and reports (displaying results). 

The relational database structure has been around since the 1970s and continues to be in use today.

“IDC forecasts that relational DBs will still account for more than 80% of the total operational database market through 2022 and Gartner forecasts that through 2020, relational technology will continue to be used for at least 70% of new applications and projects.”

Relational databases are typically found in data warehouses.

Other Definitions of Relational Databases Include:

Image Credit: MariaDB
  • “A depiction based on set theory and relational algebra, where data elements or attributes (columns) are related to tuples (rows).”(DAMA-DMBOK2)
  • “An arrangement, invented by Edgar F Codd in 1970, where data is arranged into different rows and columns by associating a specific key for each row.” (Keith D. Foote)
  • A database that is” organized and accessed according to the relationships between data items”. These relationships are expressed by tables. (Gartner IT Glossary)
  • “A database comprised of multiple connected tables.” (MIT Information Systems and Technology Knowledge Base)

Relational Database Use Cases Include:

Businesses Use Relational Databases to:

  • Support business-critical systems operations like provisioning, patching, backing up, etc.
  • Support general business operations like customer payments and bank accounting
  • Store data more efficiently
  • Manage huge amounts of mission-critical customer information.
  • Analyze business data

Image used under license from Shutterstock.com

We use technologies such as cookies to understand how you use our site and to provide a better user experience. This includes personalizing content, using analytics and improving site operations. We may share your information about your use of our site with third parties in accordance with our Privacy Policy. You can change your cookie settings as described here at any time, but parts of our site may not function correctly without them. By continuing to use our site, you agree that we can save cookies on your device, unless you have disabled cookies.
I Accept