Frans Bouma's blog

Generator.CreateCoolTool();

Syndication

News



    Visit LLBLGen Pro's website

    Follow me on Twitter

    Add to Technorati Favorites

About me

Fun stuff I created

My work

ORM and O/R mapping

All of a sudden, people start blogging about O/R mapping, thanks to Steve Eichert. Thanks Steve! :) There is however a funny thing going on in some of those blogs: they use the term ORM.

O/R mapping is something else than ORM. O/R mapping is Object-Relational mapping, ORM is Object Role Modelling. ORM is also sometimes called the successor of NIAM and has its own website at: http://www.orm.net, run by prof. T. A. Halpin, once the researcher who developed NIAM with prof. G. Nijssen and others.

Now, do they relate? Well... in an ideal world, you should be able to use an ORM model as input for the code to generate/configurate by the O/R mapper: then you have both your relational model (abstracted via the E/R model for example) and the classes targeting this relational model. Visio for Visual Studio Enterprise Architect contains an ORM tool, which lets you design your abstract relational model and eventually generate DDL from it (and / or an E/R model).

This as a FYI while you're reading the O/R mapping articles about the pro/con aspects of O/R mapping.

Published Sunday, December 21, 2003 9:38 PM by FransBouma

Comments

# re: ORM and O/R mapping@ Sunday, December 21, 2003 5:08 PM

I'd tend to disagree. I think that "ORM" is an overloaded acronym which - based on the context - either means "Object Role Modelling" or "Object Relational Mapping". I've seen it used in both meanings before ...

Ingo Rammer

# re: ORM and O/R mapping@ Sunday, December 21, 2003 7:50 PM

My pleasure ;-) I believe strongly in O/R Mappers as I'm sure you do too. Its nice to see so many people talking about them!

Steve

# re: ORM and O/R mapping@ Sunday, December 21, 2003 11:59 PM

tomato
tomato

scott

# re: ORM and O/R mapping@ Monday, December 22, 2003 1:35 AM

::I'd tend to disagree.

Without a reason, as I must say.

::I think that "ORM" is an overloaded acronym
::which - based on the context - either
::means "Object Role Modelling" or "Object
::Relational Mapping".

Why do I think "bullshit" hen I read this?

I will tell you.

This hyperlink:

http://www.acronymfinder.com/af-query.asp?String=exact&Acronym=ORM

points to Acronymfinder, which is about THE ressource for overloaded abbreviations :-) I mean - look up CMS, and you sill understand.

it lists a LOT of overloads for ORM, but NONE is "Object / Relational Mapper".

So, with all respect - what you THINK is totally irrelevant. It is no an acronym, whether you try to make it one or not.

If people would keep to use words in the right meaning, they would be understood better. Honor the language you speak, and dont pollute it with your thinking.

Thomas Tomiczek

# re: ORM and O/R mapping@ Monday, December 22, 2003 2:20 AM

Thomas, charming as always!
I'm lovin' it! ;)

Dennis v/d Stelt

# re: ORM and O/R mapping@ Monday, December 22, 2003 3:16 AM

Sorry, Thomas. I refuse to discuss at this level of language and attitude. If you are interested in a discussion of how language evolves, how acronyms are created, and how we should treat them, I'd be happy to respond if you re-post in sane language.

In the meantime:

http://www.google.com/search?q=orm%20%22object%20relational%20mapping%22 (1050 hits)

vs.

http://www.google.com/search?q=orm%20%22object%20role%20modelling%22 (363 hits)

-Ingo

Ingo Rammer

# re: ORM and O/R mapping@ Monday, December 22, 2003 3:23 AM

Ingo: heh :) ok, that means OR not a lot of people use ORM (the modelling) (wouldn't be surpised) OR a lot of people use the wrong acronym ;)

The point of my blogentry was that ORM (the modelling, geezz... because I have to say 'the modelling' proves my point ;)) is a term for Object Role Modelling, which doesn't have another name afaik. This means that to avoid confusion among developers, it's better to stick with the original terms.

Frans Bouma

# re: ORM and O/R mapping@ Monday, December 22, 2003 4:55 AM

Using google statistics is arguable.

http://www.google.com/search?q=%22object%20relational%20mapping%22 (17400 hits),
so one in about 16 pages with "object relational mapping" has the acronym ORM.

http://www.google.com/search?q=%22object%20role%20modelling%22 (636 hits), so more than half of the pages with "object role modelling" contains the acronym ORM.

Conclusion: ORM more used for object role modelling than for object relational mapping.

Vincent Snijders

# re: ORM and O/R mapping@ Monday, December 22, 2003 8:51 AM

Vincent & Frans: Agreed.

I just wanted to support my point that I've seen it used with both meanings (a point with which Thomas didn't agree too much). The google.com query shows this as well and - just as I did - without any notion of whether this is right or wrong. It's just a snapshot of what people actually said.

-Ingo

Ingo Rammer

# Action in the Code Generation World@ Thursday, March 11, 2004 12:12 AM

Code Generation Network: ".NET developers are just starting to realize the abstraction and productivity benefits of code generation. We have interviews with the industry leaders developing new cutting edge tools for .NET code generation, as well as books and articles...

TrackBack

# re: ORM and O/R mapping@ Thursday, March 18, 2004 9:36 AM

s

zolshop