Database Management System Models

So far we have discussed about what is a database and database management systems. You can view both articles here : Databases , Database Management Systems

It’s time to see what models of DBMS you may encounter out in the industry. Below are the few basic ones.

Models of Database Management Systems.

  1. Hierarchical database
  2. Network database
  3. Relational database

 

Hierarchical Database:

This model has a tree like relationship between data. If you see the diagram below , You can see that we have a root at the top , root being the starting point you can also all it the Parent .  In this model data is presented in such a way that one data item is present as the children of its above one. Which means , that there is a child parent relationship between data items.

One-To-Many relationship exists between data items, which means a parent can have many children , but children will have only one parent. Only movement between data items ,  is moving downwards .

 

type of database

 

This model has a huge disadvantage , you cannot enter the data in a child without entering it first into it’s parent ( Because of parent-child relationship) . Why is it bad?

Well this will create a huge amount of redundancy  in database which affects the performance and efficiency of system.

Network Database Model :

This model looks a lot like hierarchical model , which is understandable since it’s was derived from it for better results. Here , data items have many-to-many relationships between them , which mean a child can have more than one parent if needed be.

let’s try to understand the diagram below ,

 

Network Database Model.jpg

 

Taking a real-life example , for a store if we try to apply a hierarchical  model child  , it will create a strict and complex relationship to handle orders , since orders cannot have more than one parent in that model. With Network model , this problem is solved as orders now have more than one parents.

This solution was better than the it’s predecessor but it also created a much complex structure to maintain and handle as the system grow . The brightest minds in world then came up with a best solution to the problems . This model is being used extensively in the world now.

Relational Model   :

In late 1960’s a mathematician  Dr. E. F. Codd came up with another data model , which handled and removed the limitations of existing models. This model is based on concepts of maths and set theory.

Data items consisted of tables ( also called relation ) attributes-members-represented in columns and rows to handle and stored the data.  It’s a lot like a spreadsheet but you can create one-to-one , one-to-many and many-to-many relationships between tables .

Dr. Codd also gave 12 rules , which were followed ever since to create relational databases.  The relationships that can be created among the tables enable a relational database to efficiently store huge amount of data, and effectively retrieve selected data.  A SQL (Standard Query Language )  was developed to work with relational databases.

 

RelationalDatabase

I am planning soon to write a detailed article on how can you read this diagram and signs in it. Keep following the blog if it’s useful to you and suggest your friends!

 

 

 

Advertisements

2 thoughts on “Database Management System Models

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s