Abstract:Integrated solutions for analytics over relational databases are of great practical importance as they avoid the costly repeated loop data scientists have to deal with on a daily basis: select features from data residing in relational databases using feature extraction queries involving joins, projections, and aggregations; export the training dataset defined by such queries; convert this dataset into the format of an external learning tool; and train the desired model using this tool. These integrated solutions are also a fertile ground of theoretically fundamental and challenging problems at the intersection of relational and statistical data models. This article introduces a unified framework for training and evaluating a class of statistical learning models over relational databases. This class includes ridge linear regression, polynomial regression, factorization machines, and principal component analysis. We show that, by synergizing key tools from database theory such as schema information, query structure, functional dependencies, recent advances in query evaluation algorithms, and from linear algebra such as tensor and matrix operations, one can formulate relational analytics problems and design efficient (query and data) structure-aware algorithms to solve them. This theoretical development informed the design and implementation of the AC/DC system for structure-aware learning. We benchmark the performance of AC/DC against R, MADlib, libFM, and TensorFlow. For typical retail forecasting and advertisement planning applications, AC/DC can learn polynomial regression models and factorization machines with at least the same accuracy as its competitors and up to three orders of magnitude faster than its competitors whenever they do not run out of memory, exceed 24-hour timeout, or encounter internal design limitations.

MLog: towards declarative in-database machine learning

LLM-Enhanced Data Management

Formal Semantics and High Performance in Declarative Machine Learning Using Datalog

Markov-Lipschitz Deep Learning

MLog: Mogrifier LSTM-based Log Anomaly Detection Approach Using Semantic Representation

A Declarative Query Language for Scientific Machine Learning

GaussML: an End-to-End In-Database Machine Learning System

Enabling One-Size-Fits-All Compilation Optimization for Inference Across Machine Learning Computers

Enabling One-size-fits-all Compilation Optimization across Machine Learning Computers for Inference

Multiversion Hindsight Logging for Continuous Training

Doppiodb 2.0

Adapting Large Language Models to Log Analysis with Interpretable Domain Knowledge

LogiCode: an LLM-Driven Framework for Logical Anomaly Detection

DB-GPT: Large Language Model Meets Database

DecLog: Decentralized Logging in Non-Volatile Memory for Time Series Database Systems.

A Unified Transferable Model for ML-Enhanced DBMS

Manu: A Cloud Native Vector Database Management System

Machine Learning for Data Management: A System View

Learning Models over Relational Data using Sparse Tensors and Functional Dependencies

CMLCompiler: A Unified Compiler for Classical Machine Learning

LogLM: From Task-based to Instruction-based Automated Log Analysis