The Duck’s Brain
Datenbank-Spektrum · 2024-11 · 24 (3) · 209-221
DOI: 10.1007/s13222-024-00485-2 ↗Kurz gefasst
Fachartikel in der Zeitschrift Datenbank-Spektrum, online erschienen am 09.10.2024. Verfasst von Maximilian Schüle und 2 weiteren Autor:innen. Die Arbeit wurde bisher 4-mal zitiert (Crossref) und nennt 52 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0). Gefördert von: Otto-Friedrich-Universität Bamberg.
Abstract (Originalsprache)
Although database systems perform well in data access and manipulation, their relational model hinders data scientists from formulating machine learning algorithms in SQL. Nevertheless, we argue that modern database systems perform well for machine learning algorithms expressed in relational algebra. To overcome the barrier of the relational model, this paper shows how to transform data into a coordinate relational representation for training neural networks in SQL: We first describe building blocks for data transformation, model training and inference in SQL-92 and their counterparts using an extended array data type. Then, we compare the implementation for model training and inference using array data types to the one using a coordinate relational representation in SQL-92 only. The evaluation in terms of runtime and memory consumption proves the suitability of modern database systems for matrix algebra, although specialised array data types perform better than matrices in coordinate relational representation.
Förderung
- Otto-Friedrich-Universität Bamberg
Zitieren
APA
Schüle, M., Neumann, T., & Kemper, A. (2024). The Duck’s Brain. Datenbank-Spektrum, 24(3), 209-221. https://doi.org/10.1007/s13222-024-00485-2
Vancouver
Schüle M, Neumann T, Kemper A. The Duck’s Brain. Datenbank-Spektrum. 2024;24(3):209-221. doi:10.1007/s13222-024-00485-2
BibTeX
@article{Schle2024,
author = {Schüle, Maximilian and Neumann, Thomas and Kemper, Alfons},
title = {The Duck’s Brain},
journal = {Datenbank-Spektrum},
year = {2024},
volume = {24},
number = {3},
pages = {209--221},
doi = {10.1007/s13222-024-00485-2}
}
EUVIMED