Article

Design of a simple and effective object-to-relational mapping technique

Authors:

Muhammad Ahmad GhazaliAuthors Info & Claims

SAC '07: Proceedings of the 2007 ACM symposium on Applied computing

Pages 1445 - 1449

https://doi.org/10.1145/1244002.1244312

Published: 11 March 2007 Publication History

Abstract

Currently, most object-oriented applications use relational databases to meet their needs for persistent storage. However, object-oriented and relational paradigms represent information in manners that are quite different from each other. This results in two different models for representing the same information, thus increasing the design and maintenance efforts. Several attempts have been made to overcome this impedance mismatch but all of them have fallen short of providing satisfactory results from one aspect or the other. This paper outlines a simple and straightforward approach to effectively overcome this challenge. Our methodology yields a data model that is mechanically derived from the object model without compromising the performance of the system. The physical schema and the basic object persistence and population operations are automatically generated, thus, resulting in a system that makes design and maintenance much easier tasks than before.

References

[1]

Ambler, S. Building Object Applications That Work, SIGS Books/Cambridge University Press, 1998.

Digital Library

[2]

Ambler, S. Mapping Objects to Relational Databases, IBM DeveloperWorks Magazine, July 2000.

Digital Library

[3]

Ambler, S. Agile Database Techniques: Effective Strategies for the Agile Software Developer, Wiley, 2003.

Digital Library

[4]

Bauer, C., and King, G. Hibernate in Action, Manning Publications, 2004.

Digital Library

[5]

Behm, A. Migrating Relational Databases to Object Technology, PhD Thesis, University of Zurich, Switzerland, 2001.

[6]

Blaha, M., Premerlani, W., and Shen, H. Converting OO Models into RDBMS Schema, IEEE Software, 11 (3), May/June 1994, 28--39.

Digital Library

[7]

Brown, K., and Whitenack, B. Crossing Chasms, A Pattern Language for Object-RDBMS Integration, in Pattern Languages of Program Design 2 (PLoPD 2), Vlissides, J., Coplien, J., and Kerth, N. eds., Addison-Wesley, 1996.

Digital Library

[8]

DeMichiel, L. G. SQL3 Object Extensions, Position paper presented at OOPSLA'95 - Workshop#24 on Objects and Relational Databases, Austin, Texas, 1995.

[9]

Gulutzan, P., and Pelzer, T. SQL Performance Tuning, Addison-Wesley, 2003.

Digital Library

[10]

Keller, A. M., Jensen, R., and Agarwal, S. Persistence Software: Bridging Object-Oriented Programming and Relational Databases, In Proceedings of the ACM SIGMOD International Conference on Management of Data, Washington, D.C., May 1993.

Digital Library

[11]

Knight, A. GLORP: Generic Lightweight Object-Relational Persistence, Addendum to the Proceedings of OOPSLA 2000, Minneapolis, Minnesota, USA, 2000, 173--174.

Digital Library

[12]

Leavitt, N. Whatever happened to object-oriented databases?, IEEE Computer, 33 (8), August 2000, 16--19.

Digital Library

[13]

McClure, S. Object Database vs. Relational Databases, International Data Corporation (IDC) Bulletin # 14821E, August 1997.

[14]

Musto, A., Polese, G., and Pannella, A. Automatic Generation of RDBMS Based Applications from Object Oriented Design Schemes, In Proceedings of the ACM Symposium on Applied Computing (SAC'00), Como, Italy, 2000, 398--402.

Digital Library

[15]

Rio, L., and Ramos, P. Mapping Object Oriented Models into Relational Models: A Formal Approach, In Proceedings of SSGRR 2002, L'Aquila, Italy, 2002.

Cited By

Michail PChristos K(2022)Object Relational Mapping Vs. Event-Sourcing: Systematic ReviewElectronic Government and the Information Systems Perspective10.1007/978-3-031-12673-4_2(18-31)Online publication date: 22-Aug-2022
https://dl.acm.org/doi/10.1007/978-3-031-12673-4_2
Roberts PDesai BPokorny JBernardino J(2012)ORDB holistic designProceedings of the 16th International Database Engineering & Applications Sysmposium10.1145/2351476.2351507(239-242)Online publication date: 8-Aug-2012
https://dl.acm.org/doi/10.1145/2351476.2351507
Roberts P(2010)Seamlessness as a Desirable Aspect of Quality for MDEProceedings of the 2010 Seventh International Conference on the Quality of Information and Communications Technology10.1109/QUATIC.2010.47(253-258)Online publication date: 29-Sep-2010
https://dl.acm.org/doi/10.1109/QUATIC.2010.47
Show More Cited By

Index Terms

Design of a simple and effective object-to-relational mapping technique
1. Information systems
  1. Information retrieval
    1. Evaluation of retrieval results
2. Software and its engineering
  1. Software creation and management
    1. Software development techniques
      1. Object oriented development
  2. Software notations and tools
    1. Development frameworks and environments
      1. Object oriented frameworks

Recommendations

Object-relational mapping with SqueakSave
IWST '09: Proceedings of the International Workshop on Smalltalk Technologies

Object persistence is an important aspect of application architectures and development processes. Different solutions in this field evolved over the last decades and new approaches are still subject to research. While object-oriented databases become ...
Query processing over object views of relational data

This paper presents an approach to object view management for relational databases. Such a view mechanism makes it possible for users to transparently work with data in a relational database as if it was stored in an object-oriented (OO) database. A ...
Federating Object-Oriented and Relational Databases: The IRO-DB Experience
COOPIS '97: Proceedings of the Second IFCIS International Conference on Cooperative Information Systems

From the beginning of 1994 to the end of 1996, the IRO-DB (Interoperable Relational and Object-Oriented Databases) ESPRIT project has developed tools for accessing relational and object-oriented databases in an integrated way, and for designing and ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SAC '07: Proceedings of the 2007 ACM symposium on Applied computing

March 2007

1688 pages

ISBN:1595934804

DOI:10.1145/1244002

Conference Chairs:
Yookun Cho
Seoul National University, Seoul, Korea
,
Roger L. Wainwright
University of Tulsa, Tulsa, Oklahoma
,
Hisham M. Haddad
Kennesaw State University, Kennesaw, Georgia
,
Sung Y. Shin
South Dakota State University, Brookings, South Dakota
,
Program Chair:
Yong Wan Koo
The University of Suwon, Gyeongggi-do, Korea

Copyright © 2007 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

SIGAPP: ACM Special Interest Group on Applied Computing

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 11 March 2007

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Conference

SAC07

Sponsor:

SIGAPP

SAC07: The 2007 ACM Symposium on Applied Computing

March 11 - 15, 2007

Seoul, Korea

Acceptance Rates

Overall Acceptance Rate 1,650 of 6,669 submissions, 25%

Upcoming Conference

SAC '25

Sponsor:
sigapp

The 40th ACM/SIGAPP Symposium on Applied Computing

March 31 - April 4, 2025

Catania , Italy

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

5
Total Citations
View Citations
1,093
Total Downloads

Downloads (Last 12 months)9
Downloads (Last 6 weeks)0

Reflects downloads up to 07 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Michail PChristos K(2022)Object Relational Mapping Vs. Event-Sourcing: Systematic ReviewElectronic Government and the Information Systems Perspective10.1007/978-3-031-12673-4_2(18-31)Online publication date: 22-Aug-2022
https://dl.acm.org/doi/10.1007/978-3-031-12673-4_2
Roberts PDesai BPokorny JBernardino J(2012)ORDB holistic designProceedings of the 16th International Database Engineering & Applications Sysmposium10.1145/2351476.2351507(239-242)Online publication date: 8-Aug-2012
https://dl.acm.org/doi/10.1145/2351476.2351507
Roberts P(2010)Seamlessness as a Desirable Aspect of Quality for MDEProceedings of the 2010 Seventh International Conference on the Quality of Information and Communications Technology10.1109/QUATIC.2010.47(253-258)Online publication date: 29-Sep-2010
https://dl.acm.org/doi/10.1109/QUATIC.2010.47
Kowark THirschfeld RHaupt MDucasse SBergel ABouraqadi N(2009)Object-relational mapping with SqueakSaveProceedings of the International Workshop on Smalltalk Technologies10.1145/1735935.1735951(87-100)Online publication date: 31-Aug-2009
https://dl.acm.org/doi/10.1145/1735935.1735951
Murdaca C(2009)An Object-Relational CompilerProceedings of the 2009 WRI World Congress on Computer Science and Information Engineering - Volume 0710.1109/CSIE.2009.856(438-442)Online publication date: 31-Mar-2009
https://dl.acm.org/doi/10.1109/CSIE.2009.856

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten