research-article

The influence of optimisations on the performance of an object relational mapping tool

Authors:

Pieter van Zyl,

Derrick G. Kourie,

Andrew BoakeAuthors Info & Claims

SAICSIT '09: Proceedings of the 2009 Annual Research Conference of the South African Institute of Computer Scientists and Information Technologists

Pages 150 - 159

https://doi.org/10.1145/1632149.1632169

Published: 12 October 2009 Publication History

Abstract

Object Relational Mapping (ORM or also known as O-R) tools provide a mapping between the object model and the relational model, acting as an intermediary between an object oriented code base, and a relational database. Over the last few years the use of object relational mapping tools have grown. Today their exist many ORM tools for programming languages, like C++ (LiteSQL), Java (Hibernate, Apache OJB), Python (SQLAlchemy), Ruby, PHP, .Net (iBATIS) and Perl to name a few. ORM tools provide an extra layer between the business logic layer and the data layer. It is important that this layer is not a bottleneck. The aim of the study was to investigate the influence of this extra layer against the use of object databases that remove the need for this extra mapping layer. During this investigation the impact of certain optimisation techniques on performance was investigated. In this paper we only report on how vendor-recommended optimisation techniques influenced the performance of Hibernate. The OO7 benchmark, tailored to investigate Java based object persistence, was used to create a database; to traverse it; to query it; and to delete and update data. An initial experiment used "out of the box" Hibernate settings with regard to the use of indexes, lazy and eager loading, and caching. The times taken were submitted to Hibernate for comment. The experiment was then re-run, using optimised settings as recommended by the vendor. The extent of improvement is reported.

References

[1]

William R. Cook discussion on Query 8. http://developer.db4o.com/forums/thread/29669.aspx.

[2]

Hibernate. http://www.hibernate.org/, 2008.

[3]

Versant. www.versant.com, 2008.

[4]

EXT3 file system. http://en.wikipedia.org/wiki/Ext3, 2009.

[5]

Oracle TopLink. http://www.oracle.com/technology/products/ias/toplink, 2009.

[6]

Transaction Processing Performance Council (TPC). www.tpc.org, 2009.

[7]

S. Ambler. Building Object Applications That Work Your Step-by-Step Handbook for Developing Robust Systems With Object Technology. SIGS Books/Cambridge University Press, New York., 1998.

Digital Library

[8]

T. Anderson, A. Berre, M. Mallison, H. Porter, and B. Schneider. The HyperModel benchmark. In F. Bancilhon, C. Thanos, and D. Tsichritzis, editors, The HyperModel benchmark, In Proceedings Conference on Extending Database Technology, volume Springer-Verlag Lecture Notes, pages 416, 317--331., Venice, Italy, March 1990 1990. Springer-Verlag.

Digital Library

[9]

C. Bauer and G. King. Hibernate in Action. Manning Publications Co., Greenwich, CT, USA, 2005.

Digital Library

[10]

C. Berg. Advanced Java Development for Enterprise Applications. New Jersey, Second edition, 2000.

Digital Library

[11]

M. J. Carey, D. Dewitt, and J. F. Naughton. The OO7 benchmark. CS Tech Report. Technical report, University of Wisconsin-Madison, 1993.

[12]

M. J. Carey, D. Dewitt, and J. F. Naughton. The OO7 benchmark. CS Tech Report. Technical report, University of Wisconsin-Madison, January 1994.

[13]

M. J. Carey, D. J. DeWitt, and J. F. Naughton. The OO7 Benchmark. SIGMOD Rec., 22(2):12--21, 1993.

Digital Library

[14]

R. Cattell. Object Data Management: object-oriented and extended relational database systems. Addison-Wesley Publishing Company, 1991.

Digital Library

[15]

R. G. G. Cattell and J. Skeen. Object operations benchmark. ACM Trans. Database Syst., 17(1):1--31, 1992.

Digital Library

[16]

db4objects Inc. db4o. http://db4o.com, 2008.

[17]

EJB3 Expert Group. JSR 220: Enterprise JavaBeans Version 3.0 Java Persistence API. Sun Microsystems, Santa Clara, CA, June 2005.

[18]

Hibernate. Hibernate Annotations Reference Guide, 3.2.1.GA edition, 2007.

[19]

Hibernate. Hibernate Tools Reference Guide, 3.2.0.beta10 edition, 2007.

[20]

Hibernate. Hibernate Reference Manual, 3.2.2 edition, 2008.

[21]

W. Kim. Introduction to Object-Oriented Databases. The MIT Press, Massachusetts Institute of Technology, Cambridge, Massachusetts 02142, 1990.

[22]

D. R. Llanos. TPCC-UVa: an open-source TPC-C implementation for global performance measurement of computer systems. SIGMOD Rec., 35(4):6--15, 2006.

Digital Library

[23]

J. C. Mogul. Brittle Metrics in Operating Systems Research. In HOTOS '99: Proc. Seventh IEEE Workshop on Hot Topics in Operating Systems, pages 90--96, 1999.

Digital Library

[24]

P. van Zyl, D. G. Kourie, and A. Boake. Comparing the performance of object databases and ORM tools. In SAICSIT '06: Proc. 2006 Annual Research Conf. South African Institute of Computer Scientists and Information Technologists, pages 1--11.

Digital Library

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
Reniers VRafique AVan Landuyt DJoosen W(2017)Object-NoSQL Database Mappers: a benchmark study on the performance overheadJournal of Internet Services and Applications10.1186/s13174-016-0052-x8:1Online publication date: 5-Jan-2017
https://doi.org/10.1186/s13174-016-0052-x
Fioravanti SPatara FVicario EBinder WCortellessa VKoziolek ASmirni EPoess M(2017)Engineering the Performance of a Meta-modeling ArchitectureProceedings of the 8th ACM/SPEC on International Conference on Performance Engineering Companion10.1145/3053600.3053647(203-208)Online publication date: 18-Apr-2017
https://dl.acm.org/doi/10.1145/3053600.3053647
Show More Cited By

Index Terms

The influence of optimisations on the performance of an object relational mapping tool

Recommendations

Comparing the performance of object databases and ORM tools
SAICSIT '06: Proceedings of the 2006 annual research conference of the South African institute of computer scientists and information technologists on IT research in developing countries

The currently popular distributed, n-tiered, object-oriented application architecture provokes many design debates. Designs of such applications are often divided into logical 'tiers' -- usually user interface, business logic and domain object, or data, ...
Object/relational mapping 2008: hibernate and the entity data model (edm)
SIGMOD '08: Proceedings of the 2008 ACM SIGMOD international conference on Management of data

Object/Relational Mapping (ORM) provides a methodology and mechanism for object-oriented systems to hold their long-term data safely in a database, with transactional control over it, yet have it expressed when needed in program objects. Instead of ...
Multi-platform Performance Analysis for CRUD Operations in Relational Databases from Java Programs Using Hibernate
Big Data Intelligence and Computing
Abstract
A data set is a collection of information about something. Almost every application nowadays needs data persistence to maintain track of its status in the event of a problem. Databases are the primary component of an application for storing data ...

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences

SAICSIT '09: Proceedings of the 2009 Annual Research Conference of the South African Institute of Computer Scientists and Information Technologists

October 2009

225 pages

ISBN:9781605586434

DOI:10.1145/1632149

Conference Chair:
Barry Dwolatzky,
Program Chairs:
Jason Cohen,
Scott Hazelhurst

Copyright © 2009 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]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 12 October 2009

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

SAICSIT '09

SAICSIT '09: 2009 Annual Conference of the South African Institute of Computer Scientists and Information Technologists

October 12 - 14, 2009

Emfuleni, Vanderbijlpark, South Africa

Acceptance Rates

Overall Acceptance Rate 187 of 439 submissions, 43%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

4
Total Citations
View Citations
647
Total Downloads

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

Reflects downloads up to 08 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
Reniers VRafique AVan Landuyt DJoosen W(2017)Object-NoSQL Database Mappers: a benchmark study on the performance overheadJournal of Internet Services and Applications10.1186/s13174-016-0052-x8:1Online publication date: 5-Jan-2017
https://doi.org/10.1186/s13174-016-0052-x
Fioravanti SPatara FVicario EBinder WCortellessa VKoziolek ASmirni EPoess M(2017)Engineering the Performance of a Meta-modeling ArchitectureProceedings of the 8th ACM/SPEC on International Conference on Performance Engineering Companion10.1145/3053600.3053647(203-208)Online publication date: 18-Apr-2017
https://dl.acm.org/doi/10.1145/3053600.3053647
Zhang YXu GWang J(2014)An Implementation of High Performance Cloud Data ManagementApplied Mechanics and Materials10.4028/www.scientific.net/AMM.614.468614(468-471)Online publication date: Sep-2014
https://doi.org/10.4028/www.scientific.net/AMM.614.468

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