Network Model in DBMS

Rumman Ansari   Software Engineer   2023-03-23   12148 Share
☰ Table of Contents

Table of Content:


A network model is a database model that is designed as a flexible approach to representing objects and their relationships. A unique feature of the network model is its schema, which is viewed as a graph where relationship types are arcs and object types are nodes. Unlike other database models, the network model's schema is not confined to be a lattice or hierarchy; the hierarchical tree is replaced by a graph, which allows for more basic connections with the nodes.

Charles Bachman was the original inventor of the network model. In 1969, the Conference on Data Systems Languages (CODASYL) Consortium developed the network model into a standard specification. A second publication was introduced in 1971, which later turned into the basis for virtually all implementations.

The benefits of the network model include:

  • Simple Concept: Similar to the hierarchical model, this model is simple and the implementation is effortless.
  • Ability to Manage More Relationship Types: The network model has the ability to manage one-to-one (1:1) as well as many-to-many (N: N) relationships.
  • Easy Access to Data: Accessing the data is simpler when compared to the hierarchical model.
  • Data Integrity: In a network model, there's always a connection between the parent and the child segments because it depends on the parent-child relationship.
  • Data Independence: Data independence is better in network models as opposed to the hierarchical models.

The drawbacks of the network model include:

  • System Complexity: Each and every record has to be maintained with the help of pointers, which makes the database structure more complex.
  • Functional Flaws: Because a great number of pointers is essential, insertion, updates, and deletion become more complex.
  • Lack of Structural Independence: A change in structure demands a change in the application as well, which leads to lack of structural independence.