arrow
Return

GRELA: Exploiting graph representation learning in effective approximate query processing

delete2025-04-24
delete0
delete
OA
AI
P
Pengfei Li *
张勇 (Yong Zhang)
W
Wenqing Wei
R
Rong Zhu
B
Bolin Ding
S
Shu‐Xian Hu
H
Hua Lu
DOI:10.1007/s00778-025-00914-ydelete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

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

Journal

VLDB Journal cover
VLDB Journal
IF:
3.8
Papers:
75
Citations:
2.4K

Organization

A
alibaba grp
Scholars:
55
Papers: 24
Citations: 1
U
USTC
Scholars:
114
Papers: 55
Citations: 10
B
baidu
Scholars:
577
Papers: 470
Citations: 1
researcher View more organizations