RDBMS Definition & Meaning

RDBMS is an acronym for Relational Database Management System and is a type of database management system that stores data in a structured format using rows and columns, making it easy to locate and access data in relation to another piece of data in the database.

While a relational database describes the type of database, a RDBMS refers to the database software itself. It executes the queries on the data including adding, updating, and searching for values. It can also provide a visual representation of data.

Relational databases

A relational database is organized into tables that are used to hold information about the objects to be represented in the database. Each column in a table holds a certain kind of data, and a field stores the actual value or attribute. The rows represent a collection of related values of one object. Each row in a table can be marked with a unique identifier, and rows within multiple tables can be made related using foreign keys. The data of a relational database can be accessed in many ways without reorganizing the tables themselves. Important aspects of a relational database include:

  • Structured Query Language (SQL): The primary interface used to communicate with a relational database. It’s the standardized query language for requesting information from a database.
  • Data integrity: The overall completeness, accuracy, and consistency of data.
  • Database transactions: One or more SQL statements that are executed as a sequence of operations that form a single unit of work.
  • ACID compliance: All database transactions must be ACID compliant to ensure data integrity: Atomic, Consistent, Isolated, and Durable

Popular RDBMS vendors

  • MySQL: An open source RDBMS that relies on SQL for processing data in the database.
  • PostgreSQL: An open source database not controlled by any corporation. Typically used for web application development
  • Oracle DB: A multi-model database management system produced and marketed by Oracle Corporation
  • SQL Server: A RDBMS owned by Microsoft that is closed source
  • SQLite: A RDBMS contained in a C library. In contrast to many other database management systems, SQLite is not a client server database engine. Rather, it is embedded into the end program.

 

Abby Dykes
Abby Dykes
Abby Dykes is a newly-graduated writer and editor for websites such as TechnologyAdvice.com, Webopedia.com, and Project-Management.com. When she’s not writing about technology, she enjoys giving too many treats to her dog and coaching part-time at her local gym.

Top Articles

Huge List Of Texting and Online Chat Abbreviations

From A3 to ZZZ we list 1,559 text message and online chat abbreviations to help you translate and understand today's texting lingo. Includes Top...

How To Create A Desktop Shortcut To A Website

This Webopedia guide will show you how to create a desktop shortcut to a website using Firefox, Chrome or Internet Explorer (IE). Creating a desktop...

The History Of Windows Operating Systems

Microsoft Windows is a family of operating systems. We look at the history of Microsoft's Windows operating systems (Windows OS) from 1985 to present...

Hotmail [Outlook] Email Accounts

  By Vangie Beal Hotmail is one of the first public webmail services that can be accessed from any web browser. Prior to Hotmail and its...

Common Business-Oriented Language (COBOL)...

What is COBOL? COBOL stands for Common Business-Oriented Language. It is a 60-year-old programming...

Shared Hosting Definition &...

Shared hosting is a web hosting model in which multiple sites occupy the...

Database Integration Definition &...

Database integration consolidates data from multiple sources to provide businesses with more comprehensive...