Supporting CRUD Model Operations from EOL to SQL

Xabier De Carlos, Goiuria Sagardui, Salvador Trujillo

2016

Abstract

Model-based software development promises improvements in terms of quality and cost by raising the abstraction level of the development from code to models, but also requires mature techniques and tools. Although Eclipse Modelling Framework (EMF) introduces a default persistence mechanism for models, namely XMI, its usage is often limited as model size increases. To overcome this limitation, during the last years alternative persistence mechanisms have been proposed in order to store models in RDBMS and NoSQL databases. Under this new paradigm, model operations can be performed at model-level and persistence-level, e.g., mapping EOL model operations into SQL statements. In this paper, we extend our framework (called MQT) to support CRUD (Create, Read, Update and Delete) operations from model- (EOL) to persistence-level (SQL), using a streaming execution of queries at run-time. Through comparable evaluation metrics, we evaluate the performance and memory footprint of the framework using the GraBaTs scenario.

References

  1. Atkinson, C. and Kuhne, T. (2003). Model-driven development: a metamodeling foundation. Software, IEEE, 20(5):36-41.
  2. Bagnato, A., Brosse, E., Sadovykh, A., Maló, P., Trujillo, S., Mendialdua, X., and Carlos, X. D. (2014). Flexible and scalable modelling in the MONDO project: Industrial case studies. In Proceedings of the 3rd Workshop on Extreme Modeling, Valencia, Spain, September 29, 2014., pages 42-51.
  3. Benelallam, A., G ómez, A., Sunyé, G., Tisi, M., and Launay, D. (2014). Neo4EMF, A Scalable Persistence Layer for EMF Models. In Cabot, J. and Rubin, J., editors, Modelling Foundations and Applications, volume 8569 of Lecture Notes in Computer Science, pages 230-241. Springer International Publishing.
  4. Carlos, X. D., Sagardui, G., Murguzur, A., Trujillo, S., and Mendialdua, X. (2015). Model Query Translator - A Model-Level Query Approach For Large-Scale Models. In Proceedings of the 3rd International Conference on Model-Driven Engineering and Software Development, Angers, France.
  5. Demuth, B., Hussmann, H., and Loecher, S. (2001). OCL as a Specification Language for Business Rules in Database Applications. In Gogolla, M. and Kobryn, C., editors, UML 2001 The Unified Modeling Language. Modeling Languages, Concepts, and Tools, volume 2185 of Lecture Notes in Computer Science, pages 104-117. Springer Berlin Heidelberg.
  6. Demuth, B. and Wilke, C. (2009). Model and object verification by using dresden ocl. In Proceedings of the Russian-German Workshop Innovation Information Technologies: Theory and Practice, Ufa, Russia, pages 687-690.
  7. Egea, M., Dania, C., and Clavel, M. (2010). MySQL4OCL: A Stored Procedure-Based MySQL Code Generator for OCL. Electronic Communications of the EASST, 36.
  8. Espinazo Pagán, J. and García Molina, J. (2014). Querying Large Models Efficiently. Inf. Softw. Technol., 56(6):586-622.
  9. Gómez, A., Tisi, M., Sunyé, G., and Cabot, J. (2015). Mapbased transparent persistence for very large models. In Egyed, A. and Schaefer, I., editors, Fundamental Approaches to Software Engineering, volume 9033 of Lecture Notes in Computer Science, pages 19-34. Springer Berlin Heidelberg.
  10. Heidenreich, F., Wende, C., and Demuth, B. (2007). A Framework For Generating Query Language Code From OCL Invariants. Electronic Communications of the EASST, 9.
  11. Hunter, A. (2015). EMF Query. https://projects.eclipse. org/projects/modeling.emf.query. [Online; accessed 02-February-2015].
  12. Kolovos, D., Paige, R., and Polack, F. (2006). The epsilon object language (eol). In Rensink, A. and Warmer, J., editors, Model Driven Architecture Foundations and Applications, volume 4066 of Lecture Notes in Computer Science, pages 128-142. Springer Berlin Heidelberg.
  13. Kolovos, D. S., Rose, L. M., and Paige, R. F. (2010). The epsilon book (2010).
  14. Marder, U., Ritter, N., and Steiert, H. (1999). A DBMSBased Approach for Automatic Checking of OCL Constraints. In Proceedings of OOPSLA, volume 99, pages 1-5.
  15. Pagán, J. E., Cuadrado, J. S., and Molina, J. G. (2013). A Repository for Scalable Model Management. Software & Systems Modeling, pages 1-21.
  16. Parreiras, F. S. (2012). Semantic Web and Model-driven Engineering. John Wiley & Sons.
  17. Sottet, J.-S., Jouault, F., et al. (2009). Program comprehension. In Proc. 5th Int. Workshop on Graph-Based Tools.
  18. Ujhelyi, Z., Bergmann, G., Heged üs, Í., Horváth, Í., Izsó, B., Ráth, I., Szatmári, Z., and Varr ó, D. (2015). EMFIncQuery: an Integrated Development Environment for Live Model Queries. Sci. Comput. Program., 98:80-99.
Download


Paper Citation


in Harvard Style

De Carlos X., Sagardui G. and Trujillo S. (2016). Supporting CRUD Model Operations from EOL to SQL . In Proceedings of the 4th International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD, ISBN 978-989-758-168-7, pages 153-160. DOI: 10.5220/0005644401530160


in Bibtex Style

@conference{modelsward16,
author={Xabier De Carlos and Goiuria Sagardui and Salvador Trujillo},
title={Supporting CRUD Model Operations from EOL to SQL},
booktitle={Proceedings of the 4th International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD,},
year={2016},
pages={153-160},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005644401530160},
isbn={978-989-758-168-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 4th International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD,
TI - Supporting CRUD Model Operations from EOL to SQL
SN - 978-989-758-168-7
AU - De Carlos X.
AU - Sagardui G.
AU - Trujillo S.
PY - 2016
SP - 153
EP - 160
DO - 10.5220/0005644401530160