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.
Get the Free Newsletter
Subscribe to Daily Tech Insider for top news, trends & analysis
This email address is invalid.
Get the Free Newsletter
Subscribe to Daily Tech Insider for top news, trends & analysis
This email address is invalid.

Related Articles

Virtual Private Network (VPN)

A virtual private network (VPN) encrypts a device's Internet access through a secure server. It is most frequently used for remote employees accessing a...

Gantt Chart

A Gantt chart is a type of bar chart that illustrates a project schedule and shows the dependency between tasks and the current schedule...

Input Sanitization

Input sanitization is a cybersecurity measure of checking, cleaning, and filtering data inputs from users, APIs, and web services of any unwanted characters and...

IT Asset Management Software

IT asset management software (ITAM software) is an application for organizing, recording, and tracking all of an organization s hardware and software assets throughout...

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...