- Support of 1:1 and 1:M relationships
- Recursive relationships
- Referential integrity
- Flexibility to changing data and access requirements
- Access to record types
The network model was the first attempt to address the inefficiencies of the hierarchical model. In the network model, you could create a network showing how data related to each other. The network model never caught on, and was eventually replaced by the relational model. Click here for more information on the network model.
The relational model has proven to be the most efficient and most flexible database model in use today. There are many advantages of the relational model over the other models, which is why the most popular databases in use today employ this methodology. Click here for more information on the relational model.
The hierarchical model really only implements 1:1 relations, as defined in the strict hierarchy. The other two models do implement 1:m relationships.
This was first published in November 2006