Back to search

Institutional Repository of Vilnius University

OCL invariantų užtikrinimas SQL duomenų vientisumo reikalavimais /

Abstract

dc:description

The 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.*

Chain of custody

source
Harvested from
Vilnius University
Base URL
epublications.vu.lt/oai
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
related terms
citation

Gelčys, Juozapas,. OCL invariantų užtikrinimas SQL duomenų vientisumo reikalavimais /. Institutional Repository of Vilnius University, 2023. https://repository.vu.lt/VU:ELABAETD192846393&prefLang=en_US