Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2014
    Posts
    3

    Unanswered: Converting a relational model to object relatonal model

    I designed a data model in dbDesigner4 based on a relational model intending to use MySQL. However postgresSQL has caught my attention.

    Would you mind looking at my model and suggesting how it might change in an object relational model? Could I use this model as is in postgresSQL?

    Thanks in advance.
    Attached Thumbnails Attached Thumbnails model.png  

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    An ORM (Object Relational Model) is basically an Object Oriented wrapper than can be placed around an ERM (Entity-Relationship Model). PostgreSQL can actually implement the ERM using Relational Tables.

    I'm not sure which of these tools you had in mind for your question, but PostgreSQL can serve as the storage engine for any or all of them.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,932
    Provided Answers: 12
    Quote Originally Posted by Pat Phelan View Post
    An ORM (Object Relational Model) is basically an Object Oriented wrapper than can be placed around an ERM (Entity-Relationship Model)
    I beg to differ: ORM is (usually) the abbreviation of Object Relational Mapper: https://en.wikipedia.org/wiki/Object-relational_mapping which is a framework that maps your programming language objects (e.g. Java objects) to a relational model. Hibernate or EclipseLink are typical ORMs

    An Object Relation Model is something completely different: it's a relational model that incorporates certain aspects of object oriented programming, e.g. inheritance: https://en.wikipedia.org/wiki/Object...ional_database
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I understand your point, and if you check the link I actually pointed to the Object Relational Mapper article at Wikipedia because that worked as well or better for my point.

    At least as I see it, an Object Relational Model is a special case of an Object Relational Mapper that maps OO (Object-Oriented) concepts and objects to a physical store. In my experience, that is the same thing as an Object Relational Model. In this specific case, both of them do exactly the same thing in exactly the same way.

    Other cases can be quite different, I'm only considering the question as posed and not all possible cases.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •