Exasol-Database Machine-Learning Framework

A framework for extending SQL for machine learning on Exasol database systems. This framework is not associated with the Exasol company.

Warning

This page is still under construction.

Introduction

CREATE MODEL "model" ON employees PREDICT (salary) USING ("position", birthyear);

SELECT name, "position", birthyear, PREDICT "model" USING ("position", birthyear)
FROM employees WHERE salary IS NULL;

Syntax for Training a Model

Syntax for Predicting using a Model

Layers and Elements

Currently supported Algorithms

Library	Namespace	Algorithm	Output Type
Scikit-Learn	ensemble	RandomForestClassifier	Classification
Scikit-Learn	linear.model	LinearRegression	Regression
Scikit-Learn	svm	SVR	Regression
Scikit-Learn	tree	DecisionTreeClassifier	Classification
Scikit-Learn	tree	DecisionTreeRegressor	Regression

Related Publications

• C. Großmann, J. Schildgen: Integrating Machine Learning into SQL with Exasol. LWDA 2023
• C. Großmann: Extending SQL for Machine Learning, Master thesis, Ostbayerische Tech- nische Hochschule Regensburg, 2023. https://doi.org/10.35096/othr/pub-6059.