RDBMS

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.

 

Vangie Beal
Vangie Beal
Vangie Beal is a freelance business and technology writer covering Internet technologies and online business since the late '90s.

Related Articles

Human Resources Management System

A Human Resources Management System (HRMS) is a software application that supports many functions of a company's Human Resources department, including benefits administration, payroll,...

How To Defend Yourself Against Identity Theft

Almost every worldwide government agency responsible for identity theft issues will tell you the same thing: The first step to fighting identity theft is...

Infographic

An infographic is a visual representation of information or data. It combines the words information and graphic and includes a collection of imagery, charts,...

Phishing

What is phishing? Phishing is a type of cybercrime in which victims are contacted by email, telephone, or text message by an attacker posing as...

ScalaHosting

ScalaHosting is a leading managed hosting provider that offers secure, scalable, and affordable...

HRIS

Human resources information system (HRIS) solutions help businesses manage multiple facets of their...

Best Managed Service Providers...

In today's business world, managed services are more critical than ever. They can...