On the Optimization of Recursive Relational Queries: Application to Graph Queries - Inria - Institut national de recherche en sciences et technologies du numérique Access content directly
Conference Papers Year : 2020

On the Optimization of Recursive Relational Queries: Application to Graph Queries

Pierre Genevès
Nils Gesbert
  • Function : Author
  • PersonId : 899056
Nabil Layaïda


Graph databases have received a lot of attention as they are particularly useful in many applications such as social networks, life sciences and the semantic web. Various languages have emerged to query graph databases, many of which embed forms of recursion which reveal essential for navigating in graphs. The relational model has benefited from a huge body of research in the last half century and that is why many graph databases rely on techniques of relational query engines. Since its introduction, the relational model has seen various attempts to extend it with recursion and it is now possible to use recursion in several SQL or Datalog based database systems. The optimization of recursive queries remains, however, a challenge. We propose mu-RA, a variation of the Relational Algebra equipped with a fixpoint operator for expressing recursive relational queries. mu-RA can notably express unions of conjunctive regular path queries. Leveraging the fact that this fixpoint operator makes recursive terms more amenable to algebraic transformations, we propose new rewrite rules. These rules makes it possible to generate new query execution plans, that cannot be obtained with previous approaches. We present the syntax and semantics of mu-RA, and the rewriting rules that we specifically devised to tackle the optimization of recursive queries. We report on practical experiments that show that the newly generated plans can provide significant performance improvements for evaluating recursive queries over graphs.
Fichier principal
Vignette du fichier
mura-sigmod20.pdf (965.89 Ko) Télécharger le fichier
Origin : Files produced by the author(s)

Dates and versions

hal-01673025 , version 1 (28-12-2017)
hal-01673025 , version 2 (17-12-2018)
hal-01673025 , version 3 (08-01-2019)
hal-01673025 , version 4 (28-11-2019)
hal-01673025 , version 5 (29-02-2020)
hal-01673025 , version 6 (19-06-2021)



Louis Jachiet, Pierre Genevès, Nils Gesbert, Nabil Layaïda. On the Optimization of Recursive Relational Queries: Application to Graph Queries. SIGMOD 2020 - ACM International Conference on Management of Data, Jun 2020, Portland, United States. pp.1-23, ⟨10.1145/3318464.3380567⟩. ⟨hal-01673025v6⟩
2248 View
1969 Download



Gmail Facebook X LinkedIn More