ArrayQL Integration into Code-Generating Database Systems

Maximilian E. Schüle, Tobias Götz, Alfons Kemper, Thomas Neumann

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

7 Scopus citations

Abstract

Array database systems offer a declarative language for array-based access on multidimensional data. Although ArrayQL formulates the operators for a standardised query language, the corresponding syntax is not fully defined nor integrated in a productive system. Furthermore, we see potential in a uniform array query language to fill the gap between linear and relational algebra. This study explains the integration of ArrayQL inside a relational database system, either addressable through a separate query interface or integrated into SQL as user-defined functions. With a relational database system as the target, we inherit the benefits such as query optimisation and multi-version concurrency control by design. Apart from SQL, having another query language allows processing the data without extraction or transformation out of its relational form. This is possible as we work on a relational array representation, for which we translate each ArrayQL operator into relational algebra. This study provides an extended ArrayQL grammar specification to address each ArrayQL operator. In our evaluation, ArrayQL within Umbra computes matrix operations faster than state of the art database extensions and outperforms traditional array database systems on predicate evaluation and aggregations.

Original languageEnglish
Title of host publicationProceedings - 25th International Conference on Extending Database Technology, EDBT 2022
PublisherOpenProceedings.org
Pages40-51
Number of pages12
ISBN (Electronic)9783893180868
DOIs
StatePublished - 2022
Event25th International Conference on Extending Database Technology, EDBT 2022 - Edinburgh, United Kingdom
Duration: 29 Mar 20221 Apr 2022

Publication series

NameAdvances in Database Technology - EDBT
Volume25
ISSN (Electronic)2367-2005

Conference

Conference25th International Conference on Extending Database Technology, EDBT 2022
Country/TerritoryUnited Kingdom
CityEdinburgh
Period29/03/221/04/22

Fingerprint

Dive into the research topics of 'ArrayQL Integration into Code-Generating Database Systems'. Together they form a unique fingerprint.

Cite this