Data Models in DBMS

In this course, we will study about Data Models in DBMS and their types: entity-relationship, relational, object-oriented, object-relational, semi-structured.

Data models in the database management system

It is a logical frame or view in which data is stored. This model describes the relationship between different parts and also defines how data is processed and stored in the system.

Data Models in DBMS

There are various types of data models that are used for understanding the structures. They can be enlisted as follow:

  1. Relational data model
  2. Entity-relationship data model
  3. Object-oriented data model
  4. Semistructured data model

Relational data model

  1. This model designs the data in the form of tables that are rows and columns.
  2. Thus, a relational model uses tables for the representation of data and relationships.
    Tables are also known as relations.
  3. The Relational Model is the most widely used.
  4. The data is maintained in a two-dimensional table.
  5. All the information or data is stored in the form of rows and columns.
  6. The basic structure of this model is the tables.
  7. In this model, the relationship between tables is maintained by storing a common field.

Advantages of the Relational Model

Simple

This model is much simpler compared to the network and hierarchical.

Scalable

This model is easily scaled, we can add as many rows and columns we wish to.

Structural Independence

Changes in database structure can be done without changing the way in which data is accessed and hence we can say that structural independence has been achieved.

Disadvantages of the Relational Model

Hardware Overheads

This model requires more powerful hardware computers and data storage devices for hiding the complexities and making things easier for the user.

Bad Design

Because the relational model is very easy to design and use. So there is no need for the users to know how the data is stored in order to access it. This ease of design leads to the development of a poor database which will further result in slow down if the database grows.

Entity-relationship model

Advantages of ER Model

Simple

Conceptually ER Models are easy to build. By just knowing the relationship between the attributes and the entities one can easily build the ER Diagram for the model.

Effective Communication Tool

This model is widely used by database designers for communicating.

Easy Conversion to any Model

This model maps well to the relational model and can be easily converted to a relational model by converting the ER model to the table. This model can easily be converted to any other model like the network model, hierarchical model, etc.

Disadvantages of ER Model

No industry standard for notation

No industry standard is available for developing an ER model. So one developer must use notations which can be easily understood by other developers.

Hidden data

Some data might be lost or hidden. There are chances that some details of information might be hidden as it is a high-level view.

Object-oriented model

Advantages of the object-oriented model

Extensibility

New data types can be made from the existing ones.

Efficient

Is capable of handling a large variety of data types.

More expressive

It is more expressive as it has navigational access from the objects. Navigational access is used for handling parts explosion, recursive queries, and much more.

Supports longer duration

It uses a different approach to handle the types of long-duration transactions that are very common in many advanced database applications.

Disadvantages of the object-oriented model

Complexity

Increase in functionality provided by the object-oriented model makes it difficult to use and there is an increase in cost.

Security issues

Adequate security measures are not there.

Lack of universal data models

No universally agreed data model for the object-oriented data model.

Semi-structured data model

Advantages of the semi-structured data model

Flexible

Schema can be easily changed.

User friendly

Supports users who are not able to express their needs in SQL.

Portable

Data is portable.

Disadvantages of the semi-structured data model

Schema

Lack of fixed rigid schema leads to problems in the storage of data.

Efficiency

Queries are less efficient than structured data.

Cost

Cost is high.