Skip to content

Instantly share code, notes, and snippets.

@sumonst21
Last active February 10, 2019 12:46
Show Gist options
  • Save sumonst21/d81d3b0ad7b2ff866fdd143a8e93db23 to your computer and use it in GitHub Desktop.
Save sumonst21/d81d3b0ad7b2ff866fdd143a8e93db23 to your computer and use it in GitHub Desktop.
Types of Database Management Systems

Types of Database Management Systems

There are multiple types of database management systems such as relational, object, and document. In this article we discuss the types of Database Management Systems or DBMS.

Database Management Systems

A Database is a collection of records. Database management systems are designed as the means of managing all the records. Database Management is a software system that uses a standard method and running queries with some of them designed for the oversight and proper control of databases.

Types of Database Management Systems

There are four structural types of database management systems:

  • Hierarchical databases
  • Network databases
  • Relational databases
  • Object-oriented databases
  • Graph databases
  • ER model databases
  • Document databases

Hierarchical Databases (DBMS)

In the Hierarchical Database Model we have to learn about the databases. It is very fast and simple. In a hierarchical database, records contain information about there groups of parent/child relationships, just like as a tree structure. The structure implies that a record can have also a repeating information. In this structure Data follows a series of records, It is a set of field values attached to it. It collects all records together as a record type. These record types are the equivalent of tables in the relational model, and with the individual records being the equivalent of rows. To create links between these record types, the hierarchical model uses these type Relationships.

hierarical-2.gif hierarical-1.gif

Advantage

Hierarchical database can be accessed and updated rapidly because in this model structure is like as a tree and the relationships between records are defined in advance. This feature is a two-edged.

Disadvantage

This type of database structure is that each child in the tree may have only one parent, and relationships or linkages between children are not permitted, even if they make sense from a logical standpoint. Hierarchical databases are so in their design. it can adding a new field or record requires that the entire database be redefined.

Network Database

ref: https://www.c-sharpcorner.com/UploadFile/65fc13/types-of-database-management-systems/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment