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

Zyl, Pieter van; Kourie, Derrick G.; Coetzee, Louis; Boake, Andrew

doi:10.1145/1632149.1632169

“…As already discussed in Section 4.4, to maximally ensure comparability of our results, we disabled these mechanisms in our benchmarks. In the case of Object-Relational Mappers (ORMs), the impact of performance optimizations has already been studied [28,29]. A similar study can prove useful for ONDMs and should be considered future work.…”

Section: External Validitymentioning

confidence: 99%

Object-NoSQL Database Mappers: a benchmark study on the performance overhead

Reniers

¹

,

Rafique

²

,

Landuyt

³

et al. 2017

J Internet Serv Appl

View full text Add to dashboard Cite

In recent years, the hegemony of traditional relational database management systems (RDBMSs) has declined in favour of non-relational databases (NoSQL). These database technologies are better adapted to meet the requirements of large-scale (web) infrastructures handling Big Data by providing elastic and horizontal scalability. Each NoSQL technology however is suited for specific use cases and data models. As a consequence, NoSQL adopters are faced with tremendous heterogeneity in terms of data models, database capabilities and application programming interfaces (APIs). Opting for a specific NoSQL database poses the immediate problem of vendor or technology lock-in. A solution has been proposed in the shape of Object-NoSQL Database Mappers (ONDMs), which provide a uniform abstraction interface for different NoSQL technologies. Such ONDMs however come at a cost of increased performance overhead, which may have a significant economic impact, especially in large distributed setups involving massive volumes of data. In this paper, we present a benchmark study quantifying and comparing the performance overhead introduced by Object-NoSQL Database Mappers, for create, read, update and search operations. Our benchmarks involve five of the most promising and industry-ready ONDMs: Impetus Kundera, Apache Gora, EclipseLink, DataNucleus and Hibernate OGM, and are executed both on a single node and a 9-node cluster setup. Our main findings are summarised as follows: (i) the introduced overhead is substantial for database operations in-memory, however on-disk operations and high network latency result in a negligible overhead, (ii) we found fundamental mismatches between standardised ONDM APIs and the technical capabilities of the NoSQL database, (iii) search performance overhead increases linearly with the number of results, (iv) DataNucleus and Hibernate OGM's search overhead is exceptionally high in comparison to the other ONDMs.

show abstract

“…The influence of optimizations and configurations on the performance of the object-relational mapping tool Hibernate is evaluated in [23] and [24]. Hibernate performance is also discussed in [25] and [26], comparing with outdated solutions of object-oriented databases through benchmarks.…”

Section: Related Workmentioning

confidence: 99%

Engineering the Performance of a Meta-modeling Architecture

Fioravanti

¹

,

Patara

²

,

Vicario

³

2017

Proceedings of the 8th ACM/SPEC on International Conference on Performance Engineering Companion

View full text Add to dashboard Cite

The Reflection architectural pattern is an elegant reusable solution to design software applications based on a metamodel that provides a self-representation of the types used in the domain model. This provides significant benefits in terms of adaptability, maintainability, self-awareness, and direct involvement of domain experts in the configuration stage. However, while virtuous in the perspective of objectoriented development, the meta-model adds a level of indirection that may result in poor performance. The complexity is further exacerbated when the object-oriented domain model is mapped to a relational database. We identify four performance anti-patterns that may naturally occur in the design of a meta-modeling architecture, and for each of them we propose a refactoring intervention on the object model and on the database mapping strategy. Experimental results are reported to characterize the gain obtained applying the proposed refactoring techniques to a real case of data management system, in order to provide a roadmap for engineering the performance of meta-modeling architectures.

show abstract

“…Performance of object-relational mapping is analyzed in few studies. The influence of optimizations and configurations on the performance of the object-relational mapping tool Hibernate is evaluated in [23] and [24]. Hibernate performance is also discussed in [25] and [26], comparing with outdated solutions of object-oriented databases through benchmarks.…”

Section: Related Workmentioning

confidence: 99%

Performance Assessment of High-availability Systems using Markov Chains

Avritzer¹

2017

Proceedings of the 8th ACM/SPEC on International Conference on Performance Engineering Companion

0

View full text Add to dashboard Cite

The Reflection architectural pattern is an elegant reusable solution to design software applications based on a metamodel that provides a self-representation of the types used in the domain model. This provides significant benefits in terms of adaptability, maintainability, self-awareness, and direct involvement of domain experts in the configuration stage. However, while virtuous in the perspective of objectoriented development, the meta-model adds a level of indirection that may result in poor performance. The complexity is further exacerbated when the object-oriented domain model is mapped to a relational database. We identify four performance anti-patterns that may naturally occur in the design of a meta-modeling architecture, and for each of them we propose a refactoring intervention on the object model and on the database mapping strategy. Experimental results are reported to characterize the gain obtained applying the proposed refactoring techniques to a real case of data management system, in order to provide a roadmap for engineering the performance of meta-modeling architectures.

show abstract

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

Cited by 5 publications

References 5 publications

Object-NoSQL Database Mappers: a benchmark study on the performance overhead

Object-NoSQL Database Mappers: a benchmark study on the performance overhead

Engineering the Performance of a Meta-modeling Architecture

Performance Assessment of High-availability Systems using Markov Chains

Contact Info

Product

Resources

About