Technology

Types of Database Management Systems

Types of Database Management Systems

Types of Database Management Systems

A database is a collection of interrelated data. A database management system is a software which can be used to manage the data by storing it on to the database and by retrieving it from the database. A database management system (DBMS) is a software package designed to de me, manipulate, retrieve and manage data in a database. A DBMS generally manipulates the data itself, the data format, field names, record structure, and file structure. It provides users and programmers with a systematic way to create, retrieve, update and manage data.

And DBMS is a collection of interrelated data and some set of programs to access the data.

There are 3 types of Database Management Systems:

(a) Relational Database Management Systems (RDBMS): It is a software system, which can be used to represents data in the form of tables. RDBMS Will use SQL2 as a Queries language. Data in this type of model is stored is fixed predefined structures and are usually manipulated using Structured Query Language (SQL).

(b) Object-Oriented Database Management Systems (OODBMS): It is a software system, which can be used to represent the data in the form of objects. This DBMS will use OQL as a Query language. While other DBMS are designed to handle structured data, an OODBMS is designed to store data from a variety of media sources, such as photographs and text, and produce work, as output, in a multimedia format.

(c) Object-Relational Database Management Systems (ORDBMS): It is a DBMS which will represent some part of the data in the form of tables and some other part of the data in the form of objects. This management system will use SQL3 as a Query Language; it is a combination of SQL2 and OQL.