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

Data Visualization

Data visualization is the graphic representation of data so that analysts, readers, clients, and stakeholders can more easily see the implications of the raw...

RSA SecurID

RSA SecurID is multi-factor authentication (MFA) technology used to protect network resources, such as applications and websites. Its purpose is to mitigate risk and...

Logo

A logo is a symbol, mark, or other visual element that a company uses in place of or in conjunction with its business title....

E-Commerce

E-commerce, or electronic commerce, is online-conducted business, including marketing, sales, and fulfillment. Consumers and businesses place and track orders at least partially through the...

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