Machine Learning, Linear Algebra, and More: Is SQL All You Need?
Blacher M, Giesen J, Laue S, Klaus J, Leis V (2022)
Publication Language: English
Publication Type: Conference contribution
Publication year: 2022
Event location: Santa Cruz, CA
URI: https://vldb.org/cidrdb/papers/2022/p17-blacher.pdf
Abstract
SQL is the standard language for retrieving and manipulating relational data. Although SQL is ubiquitous for simple analytical queries, it is rarely used for more complex computations like machine learning, linear algebra, and other computationally-intensive algorithms. These algorithms are often programmed in a procedural fashion and look very different from declarative SQL queries. However, SQL actually does provide constructs to perform all kinds of computations. In this paper, we show how to translate procedural constructs to SQL - enabling complex SQL-only algorithms. Using SQL for algorithms keeps computations close to the data, requires minimal user permissions, and increases software portability. The performance of the resulting SQL algorithms depends heavily on the underlying DBMS and the SQL code. Surprisingly, we find that query engines like HyPer can achieve very high performance - in some cases even outperforming state-of-the-art linear algebra packages like NumPy.
Authors with CRIS profile
Involved external institutions
Germany (DE)How to cite
APA:
Blacher, M., Giesen, J., Laue, S., Klaus, J., & Leis, V. (2022). Machine Learning, Linear Algebra, and More: Is SQL All You Need? In Proceedings of the 12th Annual Conference on Innovative Data Systems Research, CIDR 2022. Santa Cruz, CA, US.
MLA:
Blacher, Mark, et al. "Machine Learning, Linear Algebra, and More: Is SQL All You Need?" Proceedings of the 12th Annual Conference on Innovative Data Systems Research, CIDR 2022, Santa Cruz, CA 2022.
BibTeX: Download