Skip to content

Read-only version: For security reasons, the Research Information System (FIS) has been temporarily replaced by this read-only version. All public content and full texts remain available; login, editing, submission and statistics are not available. Questions: fis@uni-bamberg.de

Home › Publications › The Duck’s Brain : Training and Inference of Neural Networks within Database Engines

Publication

The Duck’s Brain : Training and Inference of Neural Networks within Database Engines

Schüle, Maximilian; Neumann, Thomas; Kemper, Alfons (2024): The Duck’s Brain : Training and Inference of Neural Networks within Database Engines, in: Datenbank-Spektrum, Berlin ; Heidelberg: Springer, Jg. 24, Nr. 3, S. 209–221, doi: 10.1007/s13222-024-00485-2.

Details

Faculty/Chair
Faculty/Professorship
Author
Neumann, Thomas
Kemper, Alfons
Title of the Journal
Datenbank-Spektrum
ISSN
1610-1995
Publisher Information
Springer : Berlin ; Heidelberg
Year of publication
2024
Volume
24
Issue
3
Language
English
DOI
Abstract

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.

GND Keywords
SQL/92
Neuronales Netz
Differenzierung
In-Memory-Datenbank
Maschinelles Lernen
Keywords
SQL-92
Neural Networks
Automatic Differentiation
In-Memory Database Systems
Machine Learning
DDC Classification
004 Computer science
RVK Classification
ST 270
Type
Article
URI
Activation date
2025-02-28
Project(s)

Permalink: https://fis.uni-bamberg.de/handle/uniba/106797 · Data as JSON · Cite: BibTeX · RIS

Data as of: 2026-11-16

Restricted read-only access: login, editing and submission are temporarily disabled.