Breaking News: Grepper is joining You.com. Read the official announcement!
Check it out

What are the main problems of Object Relational Impedance Mismatch?

Pragya Keshap answered on February 10, 2023 Popularity 3/10 Helpfulness 1/10

Contents


More Related Answers

  • What is Object Relational Impedance Mismatch?

  • What are the main problems of Object Relational Impedance Mismatch?

    0

    Object model and Relational models (RDBMS) have following

    problems that are part of Object Relational Impedance Mismatch:

    Granularity: Object model is more granular than Relational model.

    There are more classes in object model than the corresponding

    tables in relational model.

    Inheritance: Object model supports inheritance. But Relational

    model does not have any concept of inheritance.

    Identity: Relational model has just one criteria for sameness of data.

    It is based on primary key. In object model like Java we can have

    equals as well as == for sameness of objects.

    Associations: In Object model associations are uni-directional. In

    RDBMS, there is a concept of foreign key for association. Also

    multiplicity of a relationship is hard to judge by looking at object

    model.

    Data navigation: In Object model, you can move from one object to

    another object for getting data. Egg. you can retrieve and Employee

    object, then go to its department object and then get the employees

    in the department object. In RDBMS, we try to minimize the SQL

    calls, so we get all the data by using joins

    https://medium.com/booleanbhushan/object-relational-impedance-mismatch-28fc2440dee4

    Popularity 3/10 Helpfulness 1/10 Language whatever
    Source: Grepper
    Link to this answer
    Share Copy Link
    Contributed on Feb 10 2023
    Pragya Keshap
    0 Answers  Avg Quality 2/10


    X

    Continue with Google

    By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.
    X
    Grepper Account Login Required

    Oops, You will need to install Grepper and log-in to perform this action.