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
- Hierarchical database
- Network database
- Relational database
- Entity-relationship database
- Object-Oriented database
A Hierarchical database arranges data in a tree-like structure, with a clear hierarchy. The data can be stored in a top-down or bottom-up format. It uses a parent-child relationship to represent the data, where each data item has a link to its parent item. In Hierarchical DBMS, parents can have multiple children, while each child can have only one parent.
The network database model allows for a child to have multiple parents, making it suitable for representing complex relationships like many-to-many connections, such as orders and parts. Entities are organized in a graph, accessible through various paths.
The relational DBMS is the most widely used model due to its simplicity. It normalizes data into rows and columns within tables. Data is stored in fixed structures and manipulated using SQL.
The Entity-Relationship (ER) Model is based on real-world entities and their relationships. It represents connections by dividing objects of interest into entities and their characteristics into attributes.
In the Object-Oriented Model, data is stored as objects with defined classes that contain data values and associated operations. It views the database as a collection of objects.