SQL-PL4OCL: an automatic code generator from OCL to SQL procedural language.
Saved in:
| Title: | SQL-PL4OCL: an automatic code generator from OCL to SQL procedural language. |
|---|---|
| Authors: | Egea, Marina1 msegea@minsait.com, Dania, Carolina2 carolina.dania@imdea.org |
| Source: | Software & Systems Modeling. Feb2019, Vol. 18 Issue 1, p769-791. 23p. |
| Subjects: | Code generators, PL/SQL (Computer program language), Iterative methods (Mathematics), User-centered system design, Mathematical mappings |
| Abstract: | 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. [ABSTRACT FROM AUTHOR] |
| Copyright of Software & Systems Modeling is the property of Springer Nature and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) | |
| Database: | Engineering Source |
|
Full text is not displayed to guests.
Login for full access.
|
|
| FullText | Links: – Type: pdflink Text: Availability: 1 |
|---|---|
| Header | DbId: egs DbLabel: Engineering Source An: 134892260 AccessLevel: 6 PubType: Academic Journal PubTypeId: academicJournal PreciseRelevancyScore: 0 |
| IllustrationInfo | |
| Items | – Name: Title Label: Title Group: Ti Data: SQL-PL4OCL: an automatic code generator from OCL to SQL procedural language. – Name: Author Label: Authors Group: Au Data: <searchLink fieldCode="AR" term="%22Egea%2C+Marina%22">Egea, Marina</searchLink><relatesTo>1</relatesTo><i> msegea@minsait.com</i><br /><searchLink fieldCode="AR" term="%22Dania%2C+Carolina%22">Dania, Carolina</searchLink><relatesTo>2</relatesTo><i> carolina.dania@imdea.org</i> – Name: TitleSource Label: Source Group: Src Data: <searchLink fieldCode="JN" term="%22Software+%26+Systems+Modeling%22">Software & Systems Modeling</searchLink>. Feb2019, Vol. 18 Issue 1, p769-791. 23p. – Name: Subject Label: Subjects Group: Su Data: <searchLink fieldCode="DE" term="%22Code+generators%22">Code generators</searchLink><br /><searchLink fieldCode="DE" term="%22PL%2FSQL+%28Computer+program+language%29%22">PL/SQL (Computer program language)</searchLink><br /><searchLink fieldCode="DE" term="%22Iterative+methods+%28Mathematics%29%22">Iterative methods (Mathematics)</searchLink><br /><searchLink fieldCode="DE" term="%22User-centered+system+design%22">User-centered system design</searchLink><br /><searchLink fieldCode="DE" term="%22Mathematical+mappings%22">Mathematical mappings</searchLink> – Name: Abstract Label: Abstract Group: Ab Data: 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. [ABSTRACT FROM AUTHOR] – Name: AbstractSuppliedCopyright Label: Group: Ab Data: <i>Copyright of Software & Systems Modeling is the property of Springer Nature and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract.</i> (Copyright applies to all Abstracts.) |
| PLink | https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=egs&AN=134892260 |
| RecordInfo | BibRecord: BibEntity: Identifiers: – Type: doi Value: 10.1007/s10270-017-0597-6 Languages: – Code: eng Text: English PhysicalDescription: Pagination: PageCount: 23 StartPage: 769 Subjects: – SubjectFull: Code generators Type: general – SubjectFull: PL/SQL (Computer program language) Type: general – SubjectFull: Iterative methods (Mathematics) Type: general – SubjectFull: User-centered system design Type: general – SubjectFull: Mathematical mappings Type: general Titles: – TitleFull: SQL-PL4OCL: an automatic code generator from OCL to SQL procedural language. Type: main BibRelationships: HasContributorRelationships: – PersonEntity: Name: NameFull: Egea, Marina – PersonEntity: Name: NameFull: Dania, Carolina IsPartOfRelationships: – BibEntity: Dates: – D: 01 M: 02 Text: Feb2019 Type: published Y: 2019 Identifiers: – Type: issn-print Value: 16191366 Numbering: – Type: volume Value: 18 – Type: issue Value: 1 Titles: – TitleFull: Software & Systems Modeling Type: main |
| ResultId | 1 |
