Back to search

Institutional Repository of Vilnius University

SQL struktūrinio sudėtingumo indekso taikymas vertinant ORM migracijos sudėtingumą /

Abstract

dc:description

This 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 database­specific mechanisms: before migration, it is not always clear which objects can be moved directly to an ORM­based 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 SSCI­based preliminary estimate is assigned before migration­strategy validation and compared with a simplified initial estimate and the observed migration complexity. The results show that, in the selected sample, SSCI­based 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 Server­specific 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.*

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

Šimonėlis, Lukas,. SQL struktūrinio sudėtingumo indekso taikymas vertinant ORM migracijos sudėtingumą /. Institutional Repository of Vilnius University, 2026. https://repository.vu.lt/VU:ELABAETD308338932&prefLang=en_US