Not logged in.

Contribution Details

Type Working Paper
Scope Discipline-based scholarship
Title A Relational Matrix Algebra and its Implementation in a Column Store
Organization Unit
Authors
  • Oksana Dolmatova
  • Nikolaus Augsten
  • Michael Hanspeter Böhlen
Language
  • English
Institution Cornell University
Series Name ArXiv.org
Number 05517
ISSN 2331-8422
Date 2020
Abstract Text Analytical queries often require a mixture of relational and linear algebra operations applied to the same data. This poses a challenge to analytic systems that must bridge the gap between relations and matrices. Previous work has mainly strived to fix the problem at the implementation level. This paper proposes a principled solution at the logical level. We introduce the relational matrix algebra (RMA), which seamlessly integrates linear algebra operations into the relational model and eliminates the dichotomy between matrices and relations. RMA is closed: All our relational matrix operations are performed on relations and result in relations; no additional data structure is required. Our implementation in MonetDB shows the feasibility of our approach, and empirical evaluations suggest that in-database analytics performs well for mixed workloads.
Free access at Official URL
Official URL https://arxiv.org/pdf/2004.05517.pdf
Related URLs
Other Identification Number merlin-id:20725
PDF File Download from ZORA
Export BibTeX
EP3 XML (ZORA)