TY - GEN
T1 - ArrayQL Integration into Code-Generating Database Systems
AU - Schüle, Maximilian E.
AU - Götz, Tobias
AU - Kemper, Alfons
AU - Neumann, Thomas
N1 - Publisher Copyright:
© 2022 Copyright held by the owner/author(s).
PY - 2022
Y1 - 2022
N2 - 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.
AB - 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.
UR - http://www.scopus.com/inward/record.url?scp=85127225758&partnerID=8YFLogxK
U2 - 10.5441/002/edbt.2022.04
DO - 10.5441/002/edbt.2022.04
M3 - Conference contribution
AN - SCOPUS:85127225758
T3 - Advances in Database Technology - EDBT
SP - 40
EP - 51
BT - Proceedings - 25th International Conference on Extending Database Technology, EDBT 2022
PB - OpenProceedings.org
T2 - 25th International Conference on Extending Database Technology, EDBT 2022
Y2 - 29 March 2022 through 1 April 2022
ER -