ML2SQL: Compiling a declarative machine learning language to SQL and python

Maximilian E. Schüle, Matthias Bungeroth, Dimitri Vorona, Alfons Kemper, Stephan Günnemann, Thomas Neumann

Publikation: Beitrag in Buch/Bericht/KonferenzbandKonferenzbeitragBegutachtung

17 Zitate (Scopus)

Abstract

This demonstration presents a machine learning language MLearn that allows declarative programming of machine learning tasks similarly to SQL. Our demonstrated machine learning language is independent of the underlying platform and can be translated into SQL and Python as target platforms. As modern hardware allows database systems to perform more computational intense tasks than just retrieving data, we introduce the ML2SQL compiler to translate machine learning tasks into stored procedures intended to run inside database servers running PostgreSQL or HyPer. We therefore extend both database systems by a gradient descent optimiser and tensor algebra. In our evaluation section, we illustrate the claim of running machine learning tasks independently of the target platform by comparing the run-time of three in MLearn specified tasks on two different database systems as well as in Python. We infer potentials for database systems on optimising tensor data types, whereas database systems show competitive performance when performing gradient descent.

OriginalspracheEnglisch
TitelAdvances in Database Technology - EDBT 2019
Untertitel22nd International Conference on Extending Database Technology, Proceedings
Redakteure/-innenZoi Kaoudi, Irini Fundulaki, Berthold Reinwald, Helena Galhardas, Carsten Binnig, Melanie Herschel
Herausgeber (Verlag)OpenProceedings.org
Seiten562-565
Seitenumfang4
ISBN (elektronisch)9783893180813
DOIs
PublikationsstatusVeröffentlicht - 2019
Veranstaltung22nd International Conference on Extending Database Technology, EDBT 2019 - Lisbon, Portugal
Dauer: 26 März 201929 März 2019

Publikationsreihe

NameAdvances in Database Technology - EDBT
Band2019-March
ISSN (elektronisch)2367-2005

Konferenz

Konferenz22nd International Conference on Extending Database Technology, EDBT 2019
Land/GebietPortugal
OrtLisbon
Zeitraum26/03/1929/03/19

Fingerprint

Untersuchen Sie die Forschungsthemen von „ML2SQL: Compiling a declarative machine learning language to SQL and python“. Zusammen bilden sie einen einzigartigen Fingerprint.

Dieses zitieren