In a nutshell, A Database Management System, commonly abbreviated as DBMS refers to a set of computer programs that assume the role of creating, editing and deleting a database. In short, they generally maintain a database. The types of Database Management Systems are actually predetermined by the database model assumed. A database model itself refers to the mode of storage, management and administration of the actual database. This link will introduce to you to some the major types of Database Management Systems;

Relational Database Management System

Relational Database Management Systems are easy to use compared to the other types of database management systems. Relational database management owe their naming to the characteristic of normalizing the data, usually in a tabulated form. The tables consists of rows and columns upon which the relational model relies on for normalizing data, which can be linked to other data in the same table or other tables. Examples of Relational Database Management systems include but not limited to the following; Oracle, Ms SQLServer, IBM DB2, mySQL, SQLite and PostreSQL. (All require Structured Query Language from their names)

Database sofware

Hierarchical Database Management System

Hierarchical Database System is very fast and simple. Here, records contain information about the groups of parent-child relationships (think the form a tree takes). This form means that a record can have also recurring information. Data follows a series of records; a set of field values is attached to it. All records are collected together as a record type. These record types are the same as tables in the relational model, and with the individual records being the equivalent of rows. One advantage of this type of Database Management System is that it can be accessed and updated quickly since the records are predefined.

Network Database Management System 

Network Database Management Systems are mainly used on large digital computers. Its connections can be made between different types of data. NDMS are considered more efficient since they contain limitations which must be considered when we have to put to use this kind of database system. Network Database Management is similar to hierarchical database system in that they also have a hierarchical structure, though this time compared to a cobweb- interconnected network of records.

Object-Oriented Database Management System

Object- Oriented Database Management Systems use small, recyclable separated of software called objects. Here, object oriented Programming is taken into consideration. However, more than just programming language objects is also required. Object Database Management Systems increase the semantics of the C++ and Java languages by providing full-featured database programming capability, at the same time while containing native language compatibility. It adds the database functionality to object programming languages

Similar Posts:

Facebook Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>