<p>Approximate query processing (<b>AQP</b>) 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 <Emphasis Type="Underline">G</Emphasis>raph <Emphasis Type="Underline">RE</Emphasis>presentation <Emphasis Type="Underline">L</Emphasis>earning-based <Emphasis Type="Underline">A</Emphasis>QP model (<b>GRELA</b> 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 <InlineEquation ID="IEq1"> <InlineMediaObject> <ImageObject Color="BlackWhite" FileRef="778_2025_914_Article_IEq1.gif" Format="GIF" Height="13" Rendition="HTML" Resolution="72" Type="Linedraw" Width="62" /> </InlineMediaObject> <EquationSource Format="TEX">\(\texttt {Encoder}\)</EquationSource> <EquationSource Format="MATHML"><math> <mi mathvariant="monospace">Encoder</mi> </math></EquationSource> </InlineEquation> module coalesces query predicates and underlying data into the representations of clause nodes. The <InlineEquation ID="IEq2"> <InlineMediaObject> <ImageObject Color="BlackWhite" FileRef="778_2025_914_Article_IEq2.gif" Format="GIF" Height="16" Rendition="HTML" Resolution="72" Type="Linedraw" Width="45" /> </InlineMediaObject> <EquationSource Format="TEX">\(\mathbf {\texttt {Graph}}\)</EquationSource> <EquationSource Format="MATHML"><math> <mi mathvariant="monospace">Graph</mi> </math></EquationSource> </InlineEquation> 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.</p>

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

GRELA: Exploiting graph representation learning in effective approximate query processing

  • Pengfei Li,
  • Yong Zhang,
  • Wenqing Wei,
  • Rong Zhu,
  • Bolin Ding,
  • Jingren Zhou,
  • Shuxian Hu,
  • Hua Lu

摘要

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 \(\texttt {Encoder}\) Encoder module coalesces query predicates and underlying data into the representations of clause nodes. The \(\mathbf {\texttt {Graph}}\) Graph 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.