Data Models in DBMS

In this tutorial, we will learn about data models in DBMS.

A data model is a set of tools to summarize the database‘s description. The modeling of the data description, data semantics, and data consistency constraints is basically a data model. It gives you the conceptual tools you need to describe a database’s design at every level of data abstraction. As a result, there are four data models that can be useful to comprehend the database’s structure.

Object-based Data Models:

Functions, encapsulation, and object identification are all principles present in this version of the ER model. This paradigm encourages the use of a comprehensive type system that includes structured and collection types. As a result, many database systems based on the object-oriented paradigm were created in the 1980s. The objects are nothing more than the data that contains their characteristics.

Relational Data Models:

This model arranges data in a table in the form of rows and columns. Tables represent data and in-between relationships in a relational paradigm. Tables are basically the relationships. Edgar F. Codd was the first to describe this model in 1969. The relational data model is extensively is use model, with commercial data processing systems using it the most.

Entity-Relationship Data Model (ERDM):

An ERDM is a logical representation of data as objects and their relationships. Entities are the objects in question, while relationships are the connections between them. Peter Chen created this model, which was there in 1976 articles. A set of properties characterizes each entity. An ‘entity set’ is a collection of the same type of entities, while a ‘relationship set’ is a collection of the same type of relationships.

Semi-structured Data Model:

Unlike the other three data models, this one is semi-structured. Where distinct data objects of the same kind may have various attribute sets, the semi-structured data model allows for data specifications. For describing semi-structured data, the Extensible Markup Language, generally known as XML, is frequently in use. Although XML came with the intention of adding markup information to text documents, it has grown in popularity due to its usage in data interchange.