GRELA: Exploiting graph representation learning in effective approximate query processing

Pengfei Li

doi:10.1007/s00778-025-00914-y

GRELA: Exploiting graph representation learning in effective approximate query processing

2025-04-24

0

OA

AI

DOI：10.1007/s00778-025-00914-y

Original

Original request for help

Save

Abstract

En 中文

Approximate query processing (AQP) plays a critical role in modern data analytics. Although machine learning models are used for AQP, existing methods fail to uncover implicit relationships among the underlying data, the aggregate functions in queries, and the query predicates. In this work, we propose a Graph REpresentation Learning-based AQP model (GRELA for short) for answering queries with multiple aggregate functions. GRELA models the aggregate functions and the query predicates as task and clause nodes respectively in a graph and then learns appropriate node representations via its two modules. In particular, the Encoder\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\texttt {Encoder}$$\end{document} module coalesces query predicates and underlying data into the representations of clause nodes. The Graph\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$\mathbf {\texttt {Graph}}$$\end{document} module bridges task nodes and clause nodes such that each task node can aggregate the information from its neighborhood into its representation. Through the inner products of clause and task representations, GRELA is able to make accurate estimates for queries with multiple aggregate functions. Extensive experimental results verify that GRELA outperforms the state-of-the-art AQP methods on different kinds of datasets.

Keywords:

AQP

Graph representation learning

GRELA: Exploiting graph representation learning in effective approximate query processing

Abstract

Journal

Organization

Cited Papers