A Survey of Object-Relational Transformation Patterns for High-performance UML-based Applications

Nemanja Kojić, Dragan Milićev

Abstract

We outline a methodology for automatic and efficient object-relational mapping (ORM) in the context of model-driven development (MDD) of high-performance information systems specified with executable UML models. Although there are various approaches to performance tuning, we focus here on the persistence layer ̶ the relational database. The relational data model is usually designed following the well-known normal forms. However, a fully normalized relational model often does not provide sufficient performance, and improper relational model design can easily lead to a slow and unusable relational database for particular operations. Our ORM approach is intended to exploit smart optimization techniques from the relational paradigm that abandon normalization and its positive effects, and trade them off for better performance. Our ORM approach hence combines the classical denormalization transformations, based on reducing or eliminating expensive database operations by the model restructuring, but applies them to a non-redundant conceptual UML model. In this paper, we also present the first step towards this goal: a catalogue of ORM transformation patterns.

References

  1. Batini, C., Stefano C., Navathe S., 1989. Conceptual Database Design. Entity Relationship Approach, Elsevier Science Publishers BV (North Holland).
  2. Shin, S. K., Sanders, G. L., 2006. Denormalization strategies for data retrieval from data warehouses. Decision Support Systems. 42 (1). p. 267-282.
  3. Sanders, G., Shin. S. K., 2001. Denormalization effects on performance of RDBMS. System Sciences, 2001." Proceedings of the 34th Annual Hawaii International Conference on.
  4. Maier, D. (1983). The theory of relational databases. Rockville: Computer science press. Vol. 11.
  5. Keller, W. 1997. Mapping Objects to Tables: A Pattern Language. Proceedings of the 1997 European Pattern Languages of Programming Conference. Irrsee. Germany.
  6. Keller, W., Coldewey, J. 1997. Relational Database Access Layers: A Pattern Language. Collected Papers from the PLoP'96 and EuroPLoP'96 Conferences. Washington University, Department of Computer Science, Technical Report WUCS 97-07.
  7. Keller, W., Coldewey, J. 1998. Accessing Relational Databases: A Pattern Language. Pattern Languages of Program Design 3. Addison-Wesley.
  8. Milicev, D. (2009). Model-driven development with executable UML. Wrox.
  9. Codd, E.F. 1971. Normalized data base structure: A brief tutorial. ACM SIG- FIDET Workshop on Data Description, Access, and Control. San Diego, California.
  10. Agarwal, S., Keene, C., Keller, A. M. 1995. Architecting object applications for high performance with relational databases. OOPSLA Workshop on Object Database Behaviour, Benchmarks, and Performance, Austin (Vol. 196).
  11. Zaker, M., Phon-Amnuaisuk, S., & Haw, S. C. 2009. Hierarchical Denormalizing: A Possibility to Optimize the Data Warehouse Design. International Journal of Computers. (1).
Download


Paper Citation


in Harvard Style

Kojić N. and Milićev D. (2015). A Survey of Object-Relational Transformation Patterns for High-performance UML-based Applications . In Proceedings of the 3rd International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD, ISBN 978-989-758-083-3, pages 280-285. DOI: 10.5220/0005242302800285


in Bibtex Style

@conference{modelsward15,
author={Nemanja Kojić and Dragan Milićev},
title={A Survey of Object-Relational Transformation Patterns for High-performance UML-based Applications},
booktitle={Proceedings of the 3rd International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD,},
year={2015},
pages={280-285},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005242302800285},
isbn={978-989-758-083-3},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 3rd International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD,
TI - A Survey of Object-Relational Transformation Patterns for High-performance UML-based Applications
SN - 978-989-758-083-3
AU - Kojić N.
AU - Milićev D.
PY - 2015
SP - 280
EP - 285
DO - 10.5220/0005242302800285