In this article, you’ll learn about Database Models in DBMS
A Database model defines the logical design and structure of a database and defines how data will be stored, accessed, and updated in a database management system.
Types of Database models are:
- Hierarchical database
- Network database
- Relational database
- Entity-relationship database
- Object-Oriented database
In a Hierarchical database, model data is organized in a tree-like structure. Data is Stored Hierarchically (top-down or bottom-up) format. Data is represented using a parent-child relationship. In Hierarchical DBMS parents may have many children, but children have only one parent.
The network database model allows each child to have multiple parents. It helps you to address the need to model more complex relationships like the orders/parts many-to-many relationship. In this model, entities are organized in a graph which can be accessed through several paths.
Relational DBMS is the most widely used DBMS model because it is one of the easiest. This model is based on normalizing data in the rows and columns of the tables. Relational model stored in fixed structures and manipulated using SQL.
Entity-Relationship (ER) Model is based on the notion of real-world entities and relationships among them. In this database model, relationships are created by dividing objects of interest into entities and their characteristics into attributes.
In an Object-oriented Model, data is stored in the form of objects. The structure is called classes which display data within it. It defines a database as a collection of objects which stores both data members’ values and operations.