1

Is the built in ability of PostgreSQL and Oracle Object-Relational mapping the same as an ORM like Hibernate, SQLAlchemy, or Doctrine? Are these databases queried and used just like objects you'd get back from ORMs?

EDIT: Do I misunderstand what an ORDBMS is? Stil learning. http://www.postgresql.org/docs/8.2/static/intro-whatis.html http://docs.oracle.com/cd/E11882_01/appdev.112/e11822/toc.htm

EDIT: I found it here also.

http://en.wikipedia.org/wiki/Comparison_of_object-relational_database_management_systems

johnny
  • 19,272
  • 52
  • 157
  • 259

1 Answers1

3

The "O" in ORDBMS (Object Relational Database Management System) refers to some object-oriented features in PostgreSQL:

  • OIDs (mostly deprecated for non-system tables)

  • Inheritance

  • Dot function call syntax

  • User-definable type system including composite types

  • Context-sensitive operators and functions.

It's up for debate where to draw the line exactly. Here is a recent discussion on the pgsql-advocacy list with more details.

All of this is very different in nature from "ORMs like Hibernate, SQLAlchemy or Doctrine".
An ORM (Object-relational mapping) is trying to translate objects of the respective programming language to relations in a database.

Community
  • 1
  • 1
Erwin Brandstetter
  • 605,456
  • 145
  • 1,078
  • 1,228