Institutional Repository of Vilnius University
OCL invariantų užtikrinimas SQL duomenų vientisumo reikalavimais /
Abstract
dc:descriptionThe UML class diagram can be used to represent the structure of the database, but the class diagram alone is not sufficient to express the more complex business logic conditions that the data stored in the database must satisfy, so OCL is used. OCL provides the ability to describe invariants that specify constraints on UML classes and their attributes. Since a UML class diagram can be used to represent the structure of a database, OCL invariants should also be enforced at the level where the data is stored. There is not yet a comprehensive and efficient methodology describing explicit steps to convert OCL expressions into equivalent SQL code, but the tools analysed in this work address various conversion-related problems with their own specific methodologies. In this work, a methodology for ensuring OCL invariants in a relational database is developed and described, implemented by SQL statements and a SQL procedural extension. Also, possible applications of the methodology with already developed tools and implementation of the methodology in different databases are presented. The study of the effectiveness of the methodology in a SQL environment shows that the developed methodology is more effective than existing tools, and therefore it is worth developing it for tool development.
Degree
thesis:*- Grantor dc:publisher
- Institutional Repository of Vilnius University
- Year dc:date
- 2023
Author and committee
dc:creator, dc:contributor.*- Author dc:creator
-
- Gelčys, Juozapas,
Rights
dc:rights- Statement dc:rights
-
- info:eu-repo/semantics/openAccess
- Language dc:language
- lit
Identifiers
dc:identifier.*- Repository record dc:identifier
- https://repository.vu.lt/VU:ELABAETD192846393&prefLang=en_US