SQL-PL4OCL: an automatic code generator from OCL to SQL procedural language

Regular Paper

DOI: 10.1007/s10270-017-0597-6

Cite this article as:
Egea, M. & Dania, C. Softw Syst Model (2017). doi:10.1007/s10270-017-0597-6


In this paper, we introduce a SQL-PL code generator for OCL expressions that, in contrast to other proposals, is able to map OCL iterate and iterator expressions thanks to our use of stored procedures. We explain how the mapping presented here introduces key differences to the previous version of our mapping in order to (i) simplify its definition, (ii) improve the evaluation time of the resulting code, and (iii) consider OCL three-valued evaluation semantics. Moreover, we have implemented our mapping to target several relational database management systems, i.e., MySQL, MariaDB, PostgreSQL, and SQL server, which allows us to widen its usability and to benchmark the evaluation time of the SQL-PL code produced.


OCL UML SQL Stored procedures Code generator 

Copyright information

© Springer-Verlag Berlin Heidelberg 2017

Authors and Affiliations

  1. 1.Minsait (by Indra)MadridSpain
  2. 2.IMDEA Software InstituteMadridSpain

Personalised recommendations