O'Reilly logo

Object-Role Modeling Fundamentals by Terry Halpin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix A: Generating SQL Code

As discussed, ORM allows you to visualize and verbalize in rich detail the semantics underlying the information requirements for a business domain. Using appropriate transformation procedures, an ORM model may also be used to facilitate the design of high quality models in other approaches such as ER and UML, even though many of the ORM constraints and rules might need to be represented only in textual form in such systems. Basic procedures for mapping ORM to ER and UML are discussed in sections 8.5 and 9.8 respectively of Halpin & Morgan (2008).

For implementation, ORM models may at least in principle also be mapped to a variety of target systems such as relational database systems, deductive databases, semantic ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required