Download the BYJU'S Exam Prep App for free GATE/ESE preparation videos & tests - Download the BYJU'S Exam Prep App for free GATE/ESE preparation videos & tests -
× DOWNLOAD NOW

Associative Data Model in DBMS

The division property of the associative model splits the real-world things about which data is to be stored into two types: entities and associations. As a result, this model is used to divide real-world data into entities and associations.

In this article, we will dive deeper into the Associative Data Model in DBMS according to the GATE Syllabus for (Computer Science Engineering) CSE. Keep reading ahead to learn more.

Table of Contents

What is the Associative Data Model in DBMS?

A model in which the data is separated into two sections is known as an associative data model. Everything that has its own existence is referred to as an entity, and the relationships between these entities are referred to as associations. Items and links are two types of data that are separated into two components.

1. Item: The name and identifier are included in each item (some numeric value).

2. Links: The identifier, source, verb, and subject are all included in the links.

Examples

Assume we receive the following statement: “Starting from 30 May 2020, London will host the World Cup.”

Two links must be saved in this information:

London is hosting the world cup this year.

  • The source is ‘the world cup,’ the verb is ‘is being,’ and the destination is ‘London.’
  • …Starting from 30 May 2020: The verb is ‘from,’ and the target is ’30 May 2020.’ The source is the preceding link.

Uses of Associative Data Model in DBMS

There are two structures in the associative database: a collection of objects and a set of links that are used to connect them. The entries in the item structure must have a unique indicator, a type, and a name. In addition to indicators for the associated source, object, subject, and verb, entries in the links structure must have a unique indication.

Pros of Associative Data Model in DBMS

The storage room is efficient with the associative model structure since there is no need to set aside existing space for data that is not yet available. This differs from the structure of a relational model. In the relational model, missing data in any given row is represented by a single null byte. In addition, some relational databases reserve the maximum amount of space in each row for a specific column.

When considering maintenance or network resources, the associative database creates an obvious storage of custom data and information for each user or other demands. When diverse types of data need to be stored, the associative model performs better than the relational approach.

Cons of Associative Data Model in DBMS

There is no record in the associative model. When putting together all of the present data in a complicated arrangement, the data store must be revisited several times. This could be a drawback. According to certain calculations, an associative database would require four times the number of data reads as a relational database.

Adding links to the database has a direct impact on all changes and deletions to the associative model. However, it’s important to remember that a deleted association isn’t actually destroyed. Rather, it refers to a statement that has since been removed. Also, when an entity is renamed, it is linked to its new name rather than being renamed.

Keep learning and stay tuned to get the latest updates on the GATE Exam along with Eligibility Criteria, GATE Syllabus for CSE (Computer Science Engineering), GATE CSE Notes, GATE CSE Question Paper, and more.

Also Explore,

Comments

Leave a Comment

Your Mobile number and Email id will not be published.

*

*