Framework-Agnostic Query Adaptation: Ensuring SQL Compatibility Across .NET Database Frameworks
| Název práce v češtině: | Zajištění kompatibility SQL dotazů napříč různými databázovými frameworky v .NET |
|---|---|
| Název v anglickém jazyce: | Framework-Agnostic Query Adaptation: Ensuring SQL Compatibility Across .NET Database Frameworks |
| Klíčová slova: | porovnání ORM|překlad ORM|optimalizace|výkon dotazování |
| Klíčová slova anglicky: | ORM comparison|ORM translation|optimization|query performance |
| Akademický rok vypsání: | 2024/2025 |
| Typ práce: | diplomová práce |
| Jazyk práce: | angličtina |
| Ústav: | Katedra softwarového inženýrství (32-KSI) |
| Vedoucí / školitel: | Ing. Pavel Koupil, Ph.D. |
| Řešitel: | Mgr. Milan Abrahám - zadáno a potvrzeno stud. odd. |
| Datum přihlášení: | 20.11.2024 |
| Datum zadání: | 20.11.2024 |
| Datum potvrzení stud. oddělením: | 26.11.2024 |
| Datum a čas obhajoby: | 09.09.2025 09:00 |
| Datum odevzdání elektronické podoby: | 16.07.2025 |
| Datum odevzdání tištěné podoby: | 17.07.2025 |
| Datum proběhlé obhajoby: | 09.09.2025 |
| Oponenti: | doc. RNDr. Irena Holubová, Ph.D. |
| Zásady pro vypracování |
| There are numerous .NET frameworks available for accessing database systems, each with its own unique features and methods for executing SQL queries. These frameworks differ in their support for database functionalities, and when an application is migrated from one .NET framework to another, query compatibility issues may arise. For example, certain features or SQL constructs supported by one framework may not be available in another, leading to difficulties in query execution and application performance.
The goal of this thesis is to perform a static and experimental comparison of selected .NET frameworks used for database access, focusing on their query execution capabilities and feature support. The student will analyze differences in how these frameworks handle SQL queries and identify potential compatibility issues when switching between frameworks. Based on the findings, the student will design a solution to adapt queries when migrating between frameworks, ensuring smooth transitions even when feature support varies across frameworks. |
| Seznam odborné literatury |
| (1) CALVANESE, Diego, et al. What is query rewriting?. In: International Workshop on Cooperative Information Agents. Berlin, Heidelberg: Springer Berlin Heidelberg, 2000. p. 51-59.
(2) Wide World Importers sample databases for Microsoft SQL https://learn.microsoft.com/en-us/sql/samples/wide-world-importers-what-is?view=sql-server-ver16 (3) Dapper Repository https://github.com/DapperLib/Dapper (4) PetaPoco Repository https://github.com/CollaboratingPlatypus/PetaPoco (5) RepoDB documentation https://repodb.net (6) NHibernate https://nhibernate.info (7) Entity Framework Core https://learn.microsoft.com/cs-cz/ef/core/ (8) linq2db Repository https://github.com/linq2db/linq2db |