The Epsilon Solution to the OCL2PSQL Case

Antonio Garcia-Dominguez

The Epsilon Solution to the OCL2PSQL Case

Antonio Garcia-Dominguez^*

^*Corresponding author for this work

College of Engineering and Physical Sciences

Research output: Contribution to journal › Conference article › peer-review

16 Downloads (Pure)

Abstract

There have been several attempts to map Object Constraint Language queries to SQL: one of these is the OCL2PSQL mapping proposed by Nguyen and Clavel. In this paper, I describe an implementation of OCL2PSQL using two languages from the Eclipse Epsilon project: 744 lines of ETL code for the model-to-model transformation itself, and 97 lines of EGL code for a model-to-text transformation that produces more readable SQL than the reference version. The solution passes all correctness tests set out in the original framework: the transformation has a median time of 0.93s across all scenarios.

Original language	English
Journal	CEUR workshop proceedings
Volume	3089
Publication status	Published - 15 Feb 2022
Event	Joint 13th and 14th Tool Transformation Contests, TTC 2020/2021 - Virtual, Bergen, Norway Duration: 25 Jun 2021 → …

Bibliographical note

Keywords

Abstract syntax graphs
Model transformation
OCL
SQL

Access to Document

ttc21_paper12_ocl2sql_GarciaDominguez_solution
© 2021 Copyright for this paper by its authors. Use permitted under Creative Commons License Attribution 4.0 International (CC BY 4.0)
Final published version, 711 KBLicence: CC BY 4.0

Cite this

@article{d7e160e0156b41e0aea80d90b7a6749b,

title = "The Epsilon Solution to the OCL2PSQL Case",

abstract = "There have been several attempts to map Object Constraint Language queries to SQL: one of these is the OCL2PSQL mapping proposed by Nguyen and Clavel. In this paper, I describe an implementation of OCL2PSQL using two languages from the Eclipse Epsilon project: 744 lines of ETL code for the model-to-model transformation itself, and 97 lines of EGL code for a model-to-text transformation that produces more readable SQL than the reference version. The solution passes all correctness tests set out in the original framework: the transformation has a median time of 0.93s across all scenarios.",

keywords = "Abstract syntax graphs, Model transformation, OCL, SQL",

author = "Antonio Garcia-Dominguez",

note = "{\textcopyright} 2021 Copyright for this paper by its authors. Use permitted under Creative Commons License Attribution 4.0 International (CC BY 4.0).; Joint 13th and 14th Tool Transformation Contests, TTC 2020/2021 ; Conference date: 25-06-2021",

year = "2022",

month = feb,

day = "15",

language = "English",

volume = "3089",

journal = "CEUR workshop proceedings",

issn = "1613-0073",

publisher = "CEUR-WS",

}

TY - JOUR

T1 - The Epsilon Solution to the OCL2PSQL Case

AU - Garcia-Dominguez, Antonio

PY - 2022/2/15

Y1 - 2022/2/15

N2 - There have been several attempts to map Object Constraint Language queries to SQL: one of these is the OCL2PSQL mapping proposed by Nguyen and Clavel. In this paper, I describe an implementation of OCL2PSQL using two languages from the Eclipse Epsilon project: 744 lines of ETL code for the model-to-model transformation itself, and 97 lines of EGL code for a model-to-text transformation that produces more readable SQL than the reference version. The solution passes all correctness tests set out in the original framework: the transformation has a median time of 0.93s across all scenarios.

AB - There have been several attempts to map Object Constraint Language queries to SQL: one of these is the OCL2PSQL mapping proposed by Nguyen and Clavel. In this paper, I describe an implementation of OCL2PSQL using two languages from the Eclipse Epsilon project: 744 lines of ETL code for the model-to-model transformation itself, and 97 lines of EGL code for a model-to-text transformation that produces more readable SQL than the reference version. The solution passes all correctness tests set out in the original framework: the transformation has a median time of 0.93s across all scenarios.

KW - Abstract syntax graphs

KW - Model transformation

KW - OCL

KW - SQL

UR - https://www.scopus.com/pages/publications/85125388536

UR - https://ceur-ws.org/Vol-3089/

M3 - Conference article

AN - SCOPUS:85125388536

SN - 1613-0073

VL - 3089

JO - CEUR workshop proceedings

JF - CEUR workshop proceedings

T2 - Joint 13th and 14th Tool Transformation Contests, TTC 2020/2021

Y2 - 25 June 2021

ER -

The Epsilon Solution to the OCL2PSQL Case

Abstract

Bibliographical note

Keywords

Access to Document

Other files and links

Fingerprint

Cite this