TY - GEN
T1 - ArrayQL for Linear Algebra within Umbra
AU - Schule, Maximilian
AU - Gotz, Tobias
AU - Kemper, Alfons
AU - Neumann, Thomas
N1 - Publisher Copyright:
© 2021 ACM.
PY - 2021/7/6
Y1 - 2021/7/6
N2 - Array database systems offer a declarative language for array-based access on multidimensional data. 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. In our evaluation, ArrayQL within Umbra computes matrix operations faster than state of the art database extensions.
AB - Array database systems offer a declarative language for array-based access on multidimensional data. 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. In our evaluation, ArrayQL within Umbra computes matrix operations faster than state of the art database extensions.
UR - http://www.scopus.com/inward/record.url?scp=85112769768&partnerID=8YFLogxK
U2 - 10.1145/3468791.3468838
DO - 10.1145/3468791.3468838
M3 - Conference contribution
AN - SCOPUS:85112769768
T3 - ACM International Conference Proceeding Series
SP - 193
EP - 196
BT - 33rd International Conference on Scientific and Statistical Database Management, SSDBM 2021, Proceedings
A2 - Zhu, Qiang
A2 - Zhu, Xingquan
A2 - Tu, Yicheng
A2 - Xu, Zichen
A2 - Kumar, Anand
PB - Association for Computing Machinery
T2 - 33rd International Conference on Scientific and Statistical Database Management, SSDBM 2021
Y2 - 6 July 2021
ER -