Logo des Repositoriums
 

Efficient handling of recursive relationships in ORM frameworks using Entity Framework Core as an example

dc.contributor.authorKillisch, Benjamin Uwe
dc.contributor.editorKönig-Ries, Birgitta
dc.contributor.editorScherzinger, Stefanie
dc.contributor.editorLehner, Wolfgang
dc.contributor.editorVossen, Gottfried
dc.date.accessioned2023-02-23T14:00:23Z
dc.date.available2023-02-23T14:00:23Z
dc.date.issued2023
dc.description.abstractORM frameworks are a popular method to bridge the differences between object-oriented programming and relational data management. At the same time, recursive relationships are present in many schemas to represent tree-like or net-like structures. This paper discusses how to efficiently build and execute queries for data with recursive relationships in ORM frameworks. Five possible solutions are conceived and then implemented in Entity Framework Core (EF Core), while making sure that they can be used like regular LINQ queries. Next, the solutions are tested with different SQL dialects. The results of these tests are then analyzed by a variety of test parameters. This analysis shows that queries with recursive common table expressions and queries using key loading are the most efficient. Queries with auxiliary property, vertical unrolling or horizontal unrolling are either too slow or only usable under particular circumstances. The analysis also shows that the performance of the solutions is always dependent on the circumstances, especially the SQL dialect.en
dc.identifier.doi10.18420/BTW2023-78
dc.identifier.isbn978-3-88579-725-8
dc.identifier.urihttps://dl.gi.de/handle/20.500.12116/40388
dc.language.isoen
dc.publisherGesellschaft für Informatik e.V.
dc.relation.ispartofBTW 2023
dc.relation.ispartofseriesLecture Notes in Informatics (LNI) - Proceedings, Volume P-331
dc.subjectObject-Relational Mapping
dc.subjectRecursive
dc.subjectRelationships
dc.subjectQueries
dc.titleEfficient handling of recursive relationships in ORM frameworks using Entity Framework Core as an exampleen
dc.typeText/Conference Paper
gi.citation.endPage1111
gi.citation.publisherPlaceBonn
gi.citation.startPage1105
gi.conference.date06.-10. März 2023
gi.conference.locationDresden, Germany

Dateien

Originalbündel
1 - 1 von 1
Vorschaubild nicht verfügbar
Name:
C4-8.pdf
Größe:
90.85 KB
Format:
Adobe Portable Document Format