{"id":{"repo_id":"vilnius","oai_identifier":"oai:vu.lt:elaba:308338932"},"canonical_url":"https://search.ndltd.org/etd/vilnius/oai:vu.lt:elaba:308338932","repository":{"repo_id":"vilnius","name":"Vilnius University","base_url":"https://epublications.vu.lt/oai"},"display":{"title":"SQL struktūrinio sudėtingumo indekso taikymas vertinant ORM migracijos sudėtingumą /","abstract":"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.","abstract_html":"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.","abstract_has_math":false,"creators":["Šimonėlis, Lukas,"],"institution":"Institutional Repository of Vilnius University","degree_name":null,"degree_level":null,"degree_discipline":null,"degree_department":null,"school":null,"contributors":[],"advisors":[],"committee_chairs":[],"committee_members":[],"year":2026,"date_issued":"2026","date_published":"2026","updated_at":"2026-11-19T10:12:59Z","subjects":[],"languages":["lit"],"rights":["info:eu-repo/semantics/openAccess"],"rights_urls":[],"identifier_entries":[],"person_identifier_entries":[]},"links":{"outbound_url":"https://repository.vu.lt/VU:ELABAETD308338932&prefLang=en_US","outbound_label":"Repository record","outbound_source":"dc:identifier","record_url":"https://repository.vu.lt/VU:ELABAETD308338932&prefLang=en_US","record_label":"Repository record","record_kind":"record","record_source":"dc:identifier","download_url":null,"download_label":null,"download_source":null,"access_status":"open","embargo_until":null,"access_note":null},"source_record":{"url":"https://epublications.vu.lt/oai?verb=GetRecord&metadataPrefix=oai_dc&identifier=oai%3Avu.lt%3Aelaba%3A308338932","prefix":"oai_dc"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:creator","label":"Author","values":["Šimonėlis, Lukas,"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date","label":"Dc Date","values":["2026"]},{"key":"dc:publisher","label":"Institution","values":["Institutional Repository of Vilnius University"]},{"key":"dc:relation","label":"Dc Relation","values":["https://epublications.vu.lt/object/elaba:308338932/308338932.pdf"]},{"key":"dc:type","label":"Dc Type","values":["info:eu-repo/semantics/bachelorThesis"]}]},{"id":"language_rights","label":"Language and Rights","entries":[{"key":"dc:language","label":"Dc Language","values":["lit"]},{"key":"dc:rights","label":"Dc Rights","values":["info:eu-repo/semantics/openAccess"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["https://repository.vu.lt/VU:ELABAETD308338932&prefLang=en_US"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description","label":"Description","values":["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."]},{"key":"dc:format","label":"Dc Format","values":["application/pdf"]},{"key":"dc:title","label":"Title","values":["SQL struktūrinio sudėtingumo indekso taikymas vertinant ORM migracijos sudėtingumą /","Applying a sql structural complexity index to evaluate orm migration complexity."]}]}],"canonical_facts":{"dc:creator":["Šimonėlis, Lukas,"],"dc:date":["2026"],"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."],"dc:format":["application/pdf"],"dc:identifier":["https://repository.vu.lt/VU:ELABAETD308338932&prefLang=en_US"],"dc:language":["lit"],"dc:publisher":["Institutional Repository of Vilnius University"],"dc:relation":["https://epublications.vu.lt/object/elaba:308338932/308338932.pdf"],"dc:rights":["info:eu-repo/semantics/openAccess"],"dc:title":["SQL struktūrinio sudėtingumo indekso taikymas vertinant ORM migracijos sudėtingumą /","Applying a sql structural complexity index to evaluate orm migration complexity."],"dc:type":["info:eu-repo/semantics/bachelorThesis"]},"updated_at":"2026-11-19T10:12:59Z"}