Institutional Repository of Vilnius University
SQL struktūrinio sudėtingumo indekso taikymas vertinant ORM migracijos sudėtingumą /
Abstract
dc:descriptionThis thesis examines how a SQL Structural Complexity Index can improve preliminary estimates of ORM migration complexity. The problem is relevant when modernizing systems whose data access layer relies on SQL views, repository queries, and databasespecific mechanisms: before migration, it is not always clear which objects can be moved directly to an ORMbased implementation and which require manual restructuring, semantic validation, or retained raw SQL execution. Based on the literature analysis, the SQL Structural Complexity Index (SSCI) is defined using four feature groups: relational scope, query structure, logical branching, and ORM migration risk. The index is applied to 12 anonymized SQL objects from a real information system. For each object, an SSCIbased preliminary estimate is assigned before migrationstrategy validation and compared with a simplified initial estimate and the observed migration complexity. The results show that, in the selected sample, SSCIbased estimates aligned with the observed complexity better than the estimate based only on relational scope. SSCI was most informative when complexity was caused not only by the number of tables or joins, but also by UNION, correlated conditions, CDC/LSN semantics, SQL Serverspecific constructs, or the need for raw SQL fallback.
Degree
thesis:*- Grantor dc:publisher
- Institutional Repository of Vilnius University
- Year dc:date
- 2026
Author and committee
dc:creator, dc:contributor.*- Author dc:creator
-
- Šimonėlis, Lukas,
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:ELABAETD308338932&prefLang=en_US