Saved in:
Bibliographic Details
Main Authors: Stöckl, Bernhard, Schüle, Maximilian E.
Format: Preprint
Published: 2025
Subjects:
Online Access:https://arxiv.org/abs/2512.09836
Tags: Add Tag
No Tags, Be the first to tag this record!
Table of Contents:
  • Learning models over factorized joins avoids redundant computations by identifying and pre-computing shared cofactors. Previous work has investigated the performance gain when computing cofactors on traditional disk-based database systems. Due to the absence of published code, the experiments could not be reproduced on in-memory database systems. This work describes the implementation when using cofactors for in-database factorized learning. We benchmark our open-source implementation for learning linear regression on factorized joins with PostgreSQL -- as a disk-based database system -- and HyPer -- as an in-memory engine. The evaluation shows a performance gain of factorized learning on in-memory database systems by 70\% to non-factorized learning and by a factor of 100 compared to disk-based database systems. Thus, modern database engines can contribute to the machine learning pipeline by pre-computing aggregates prior to data extraction to accelerate training.