Drawbacks of Data Models and Architecture of Data Model | DBMS

In this article, we are going to discuss about the drawbacks of data models name hierarchical, network and relational data model and the architecture of data model.
Submitted by Bharti Parmar, on September 11, 2018

Hierarchical Data Model

This model is like a hierarchical tree that means tree structure is used to construct a hierarchy of records in form of node and branches; first introduced (IMS) information management system in the 1960's.

Drawbacks of Hierarchical Model

  1. A hierarchical model is not enough to present all the data between the data element.
  2. It cannot demonstrate the overall data model for the enterprise because of the non-availability of actual data at the time of designing the data model.
  3. It cannot follow many to one and many to many relations.

Network Data Model

This model based on graph data structure proposed by IBM in 1969. It is an improvement of the hierarchical model.

Drawbacks of Network Model

  • Its complexity is the main drawback because all records are maintained by using pointers so, whole database structure becomes very complex.
  • A transaction is maintained using the pointer and tracing the pointer is the drawback of its design.
  • The relation between data element must be re-stabilized. We cannot stabilize relationship as per need requirement during their uses.
  • Structure changes to the database are very difficult.

Relational Data Model

In 1970's Dr. EF-Codd (Edgar F. Codd) working as a mathematician in IBM proposed a simple data model which is based on table and relation. A relation is a 2D array or matrix-like structure. He proposed 12 rules of which are known as golden rules of EF-Codd. Any DBMS follow all the 12 rules is known as complete RDBMS. There is no DBMS in the world follow all the 12 rules maximum 11.5 rules have been followed by present RDBMS. If any DBMS follow less than 11.5 rules called partial RDBMS. Microsoft SQL Server 2008 is a popular example of RDBMS.

Drawbacks of Relational Data Model

RDBMS used an object-oriented programming language like java. So, there is a limitation of the language.

Architecture of Data model

You can study what is data model here: Different types of Data Model in DBMS.

Architecture of Data model

Physical data organization

Architecture of Data model | Example


In this article, we have learned the drawbacks of hierarchical, network and relational data model and Architecture of data model. In the next article, we will discuss the 12 golden rules of EF-Codd. Stay tuned for the next article. Have a nice day! Happy Learning!

Related Tutorials


Comments and Discussions!

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.