{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,7,25]],"date-time":"2024-07-25T07:18:12Z","timestamp":1721891892856},"reference-count":32,"publisher":"Springer Science and Business Media LLC","issue":"1","license":[{"start":{"date-parts":[[2017,5,4]],"date-time":"2017-05-04T00:00:00Z","timestamp":1493856000000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Softw Syst Model"],"published-print":{"date-parts":[[2019,2]]},"DOI":"10.1007\/s10270-017-0597-6","type":"journal-article","created":{"date-parts":[[2017,5,4]],"date-time":"2017-05-04T06:27:55Z","timestamp":1493879275000},"page":"769-791","update-policy":"http:\/\/dx.doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":11,"title":["SQL-PL4OCL: an automatic code generator from OCL to SQL procedural language"],"prefix":"10.1007","volume":"18","author":[{"given":"Marina","family":"Egea","sequence":"first","affiliation":[]},{"given":"Carolina","family":"Dania","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2017,5,4]]},"reference":[{"key":"597_CR1","unstructured":"Armonas, A., Nemurait\u00e9, L.: Pattern based generation of full-fledged relational schemas from UML\/OCL models. Inf. Technol. Control, 35(1), (2006)"},{"key":"597_CR2","unstructured":"Basin, D., Clavel, M., Egea, M., de\u00a0Dios, M.A.G., Dania, C., Ortiz, G., Valdazo, J.: Model-driven development of security-aware guis for data-centric applications. In: Foundations of Security Analysis and Design VI\u2014FOSAD Tutorial Lectures, volume 6858 of LNCS, pp. 101\u2013124. Springer, (2011)"},{"issue":"5","key":"597_CR3","doi-asserted-by":"publisher","first-page":"815","DOI":"10.1016\/j.infsof.2008.05.011","volume":"51","author":"DA Basin","year":"2009","unstructured":"Basin, D.A., Clavel, M., Doser, J., Egea, M.: Automated analysis of security-design models. Inf. Softw. Technol. 51(5), 815\u2013831 (2009)","journal-title":"Inf. Softw. Technol."},{"key":"597_CR4","doi-asserted-by":"crossref","unstructured":"Berrabah, D., Boufar\u00e8s, F.: Constraints checking in UML class diagrams: SQL vs OCL. In: Wagner, R., Revell, N., Pernul, G. (eds.) Database and Expert Systems Applications, 18th International Conference, DEXA 2007, Regensburg, Germany, September 3\u20137, 2007, Proceedings, volume 4653 of LNCS, pp. 593\u2013602. Springer, (2007)","DOI":"10.1007\/978-3-540-74469-6_58"},{"key":"597_CR5","unstructured":"Carlos, X.D., Sagardui, G., Trujillo, S.: MQT, an approach for run-time query translation: From EOL to SQL. In: Brucker, A.D., Dania, C., Georg, G., Gogolla, M. (eds.) Proceedings of the 14th International Workshop on OCL and Textual Modelling co-located with 17th International Conference on Model Driven Engineering Languages and Systems (MODELS 2014), Valencia, Spain, September 30, 2014, volume 1285 of CEUR Workshop Proceedings, pp. 13\u201322. CEUR-WS.org, (2014)"},{"key":"597_CR6","unstructured":"Clavel, M., Egea, M., de\u00a0Dios, M.A.G.: ECEASST building an efficient component for OCL evaluation. ECEASST, 15, 27\u201333 (2008)"},{"key":"597_CR7","unstructured":"Cort\u00e1zar, S.C.: Transformaci\u00f3n de las restricciones OCL de un esquema UML a consultas de SQL. trabajo de fin de grado. Technical report, Universidad Carlos III de Madrid, (2012). \n                    http:\/\/e-archivo.uc3m.es\/bitstream\/handle\/10016\/16799\/TFG_Sergio_Casillas_Cortazar.pdf?sequence=1&isAllowed=y"},{"key":"597_CR8","unstructured":"Cosentino, V.: A model-based approach for extracting business rules out of legacy information systems. PhD thesis, \u00c9cole des mines de Nantes, France (2013)"},{"key":"597_CR9","unstructured":"Dania, C.: MySQL4OCL: Un compilador de OCL a MySQL. Master thesis. Universidad Complutense de Madrid (2011)"},{"key":"597_CR10","unstructured":"Dania, C. Egea, M.: SQLPL4OCL tool (2016). \n                    http:\/\/software.imdea.org\/~dania\/tools\/sqlpl4ocl"},{"key":"597_CR11","unstructured":"Demuth, B., Hu\u00dfmann, H.: Using UML\/OCL Constraints for Relational Database Design. In: France, R.B., Rumpe, B. (eds.) UML, volume 1723 of LNCS, pp. 598\u2013613. Springer, (1999)"},{"key":"597_CR12","doi-asserted-by":"crossref","unstructured":"Demuth, B., Hu\u00dfmann, H., Loecher, S.: OCL as a Specification Language for Business Rules in Database Applications. In: Gogolla, M., Kobryn, C. (eds.) UML, volume 2185 of LNCS, pp. 104\u2013117. Springer, (2001)","DOI":"10.1007\/3-540-45441-1_9"},{"key":"597_CR13","unstructured":"Egea, M., Dania, C., Clavel, M.: MySQL4OCL: A stored procedure-based MySQL code generator for OCL. ECEASST, 36, (2010)"},{"key":"597_CR14","unstructured":"I.O. for Standardization. Object Management Group Object Constraint Language (OCL), (2012). \n                    https:\/\/www.iso.org\/obp\/ui\/#iso:std:iso-iec:19507:ed-1:v1:en"},{"key":"597_CR15","unstructured":"Heidenreich, F., Wende, C., Demuth, B.: A framework for generating query language code from OCL invariants. ECEASST, 9, (2008)"},{"key":"597_CR16","volume-title":"MDA Explained: The Model Driven Architecture\u2013Practice and Promise","author":"A Kleppe","year":"2003","unstructured":"Kleppe, A., Bast, W., Warmer, J.B., Watson, A.: MDA Explained: The Model Driven Architecture\u2013Practice and Promise. Addison-Wesley, Boston (2003)"},{"key":"597_CR17","unstructured":"MariaDB (2016) \n                    https:\/\/mariadb.org\/"},{"key":"597_CR18","unstructured":"Microsoft. SQL Server (2016). \n                    https:\/\/www.microsoft.com\/es-es\/server-cloud\/products\/sql-server\/overview.aspx"},{"key":"597_CR19","doi-asserted-by":"crossref","unstructured":"Monperrus, M., J\u00e9z\u00e9quel, J., Baudry, B., Champeau, J., Hoeltzener, B.: Model-driven generative development of measurement software. Softw. Syst. Model. 10(4), 537\u2013552 (2011)","DOI":"10.1007\/s10270-010-0165-9"},{"key":"597_CR20","unstructured":"MySQL 5.7 Reference Manual. \n                    http:\/\/dev.mysql.com\/doc\/refman\/5.7\/"},{"key":"597_CR21","unstructured":"Object Management Group: Common Warehouse Metamodel specification. (March 2003). OMG document available at \n                    http:\/\/www.omg.org\/technology\/documents\/formal\/cwm.htm"},{"key":"597_CR22","unstructured":"Object Management Group: Object Constraint Language specification. (May 2006). OMG document available at \n                    http:\/\/www.omg.org\/cgi-bin\/doc?formal\/2006-05-01"},{"key":"597_CR23","unstructured":"Object Management Group: Object constraint language specification version 2.4. Technical report, OMG, (2014). \n                    http:\/\/www.omg.org\/spec\/OCL\/2.4"},{"key":"597_CR24","unstructured":"Object Management Group: Unified modeling language version 2.5. Technical report, OMG, (2015). \n                    http:\/\/www.omg.org\/spec\/UML\/2.5\/PDF\/"},{"key":"597_CR25","unstructured":"Oriol, X., Teniente, E.: Incremental checking of OCL constraints through SQL queries. In: Brucker, A.D., Dania, C., Georg, G., Gogolla, M. (eds.) Proceedings of the 14th International Workshop on OCL and Textual Modelling co-located with 17th International Conference on Model Driven Engineering Languages and Systems (MODELS 2014), Valencia, Spain, September 30, 2014., volume 1285 of CEUR Workshop Proceedings, pp. 23\u201332. CEUR-WS.org, (2014)"},{"key":"597_CR26","unstructured":"Pinet, F., Kang, M., Vigier, F.: Spatial Constraint Modelling with a GIS Extension of UML and OCL: Application to Agricultural Information Systems. In: Wiil, U.K. (ed), Metainformatics, volume 3511 of LNCS, pp. 160\u2013178. Springer, (2004)"},{"key":"597_CR27","unstructured":"PL\/pgSQL - SQL procedural language (2016). \n                    https:\/\/www.postgresql.org\/docs\/9.2\/static\/plpgsql.html"},{"key":"597_CR28","unstructured":"Schmidt, A.: Untersuchungen zur Abbildung von OCL-ausdr\u00fccken auf SQL. Master\u2019s thesis, Institut f\u00fcr Softwaretechnik II - Technische Universit\u00e4t Dresden, Germany, (1998)"},{"key":"597_CR29","doi-asserted-by":"crossref","unstructured":"Siripornpanit, N., Lekcharoen, S.: An adaptive algorithms translating and back-translating of object constraint language into structure query language. In: International Conference on Information and Multimedia Technology, 2009. ICIMT\u201909, pp. 149\u2013151. IEEE, (2009)","DOI":"10.1109\/ICIMT.2009.55"},{"key":"597_CR30","unstructured":"Sobotka, P.: Transformation from OCL into SQL, 2012. Master thesis. Charles University in Prague. \n                    https:\/\/is.cuni.cz\/webapps\/zzp\/download\/120076745"},{"key":"597_CR31","unstructured":"ISO\/IEC 9075-(1\u201310) Information technology\u2014Database languages\u2014SQL. Technical report, International Organization for Standardization, (2011). \n                    http:\/\/www.iso.org\/iso\/home\/store\/catalogue_tc\/catalogue_detail.htm?csnumber=63555"},{"key":"597_CR32","unstructured":"SQL Dialects Reference (2016). \n                    https:\/\/en.wikibooks.org\/wiki\/SQL_Dialects_Reference\/Print_version"}],"container-title":["Software & Systems Modeling"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s10270-017-0597-6\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10270-017-0597-6.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10270-017-0597-6.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,2,23]],"date-time":"2019-02-23T07:26:15Z","timestamp":1550906775000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s10270-017-0597-6"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017,5,4]]},"references-count":32,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2019,2]]}},"alternative-id":["597"],"URL":"https:\/\/doi.org\/10.1007\/s10270-017-0597-6","relation":{},"ISSN":["1619-1366","1619-1374"],"issn-type":[{"value":"1619-1366","type":"print"},{"value":"1619-1374","type":"electronic"}],"subject":[],"published":{"date-parts":[[2017,5,4]]},"assertion":[{"value":"23 November 2016","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"25 February 2017","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"11 April 2017","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"4 May 2017","order":4,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}]}}