Accelerating machine learning queries with linear algebra query processing

Wenbo Sun*, Asterios Katsifodimos, Rihan Hai

*Corresponding author for this work

Research output: Contribution to journalArticleScientificpeer-review

16 Downloads (Pure)

Abstract

The rapid growth of large-scale machine learning (ML) models has led numerous commercial companies to utilize ML models for generating predictive results to help business decision-making. As two primary components in traditional predictive pipelines, data processing, and model predictions often operate in separate execution environments, leading to redundant engineering and computations. Additionally, the diverging mathematical foundations of data processing and machine learning hinder cross-optimizations by combining these two components, thereby overlooking potential opportunities to expedite predictive pipelines. In this paper, we propose an operator fusion method based on GPU-accelerated linear algebraic evaluation of relational queries. Our method leverages linear algebra computation properties to merge operators in machine learning predictions and data processing, significantly accelerating predictive pipelines by up to 317x. We perform a complexity analysis to deliver quantitative insights into the advantages of operator fusion, considering various data and model dimensions. Furthermore, we extensively evaluate linear algebra query processing and operator fusion utilizing the widely-used Star Schema and TPC-DI benchmarks. Through comprehensive evaluations, we demonstrate the effectiveness and potential of our approach in improving the efficiency of data processing and machine learning workloads on modern hardware.
Original languageEnglish
Article number8
Number of pages41
JournalDistributed and Parallel Databases
Volume43
Issue number1
DOIs
Publication statusPublished - 2025

Keywords

  • Database
  • Machine learning
  • Operator fusion
  • Query optimization

Fingerprint

Dive into the research topics of 'Accelerating machine learning queries with linear algebra query processing'. Together they form a unique fingerprint.

Cite this