Short Notes on : DBMS, RDBMS, ORDBMS

Short Notes on : DBMS, RDBMS, ORDBMS

DBMS

A Database Management System (DBMS) is system software for creating and managing databases. A DBMS Makes it Possible for and users to create, read, update, and delete data in a database. The most prevalent type of data management platform, the DBMS essentially serves as an interface between databases and end-users or application programs ensuring that data is consistently organized and remains easily accessible.

RDBMS

RDBMS stands for "Relational Database Management System". An RDBMS is a DBMS designed specifically for relational databases. Therefore, RDBMSes are a subset of DBMSes. A relational database refers to a database that stores data in a structured format, using rows and columns. RDBMS is the most popular database system among organizations across the world. It provides a dependable method of storing and retrieving large amounts of data while offering a combination of system performance and ease of implementation.

ORDBMS

ORDBMS stands for "Object-Relational Database Management system". An ORDBMS is a database management system that is a hybrid between the object-oriented model and the relational model. Each of those two models has its strengths and weaknesses. By combining the two models, a DBMS can take advantage of various strengths from each model.

Examples of ORDBMS:-

> PostgreSQL:-  Open Source ORDBMS developed by the PostgreSQL Global Development Group.

> Oracle Database: By Oracle Corporation.

> Informix: By IBM

> SQL Server: By Microsoft.

> Greenplum Database: By Pivotal Software.

Some of these systems can also be classified as simply RDBMS. The number of ORDBMS attributes varies between these systems. However, their vendors all claim that they are ORDBMS.