Quick links
Latest articles
Internship
Members
New...
Algorithms
Discrete Mathematics
Big data
Languages
C
C++
C++ STL
Java
Data Structure
C#.Net
Android
Kotlin
SQL
Web
PHP
Python
JavaScript
CSS
Ajax
Node.js
Web prog.
Programs
C
C++
DS
Java
C#
Python
Aptitude
C
C++
Java
DBMS
Interview
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

Home » DBMS

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

Conclusion:

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!






Quick links:
C FAQ(s) C Advance programs C/C++ Tips & Tricks Puzzles JavaScript CSS Python Linux Commands PHP Android Articles More...

Featured post:
Introduction to Linux (Its modes, Safety, Most popular Applications)
Linux Best Distribution Software (Distros) of 2018

Was this page helpful? Please share with your friends...

Are you a blogger? Join our Blogging forum.

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 (2015-2018), Some rights reserved.