Data table query methods, devices, computing equipment, and storage media in databases

CN116775697BActive Publication Date: 2026-03-13BEIJING VOLCANO ENGINE TECH CO LTD
View PDF 1 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2023-07-06
Publication Date
2026-03-13

AI Technical Summary

Technical Problem

In existing technologies, runtime filters cannot accurately determine whether they are applicable in hash join queries, leading to increased performance overhead and impacting data query performance.

Method used

After constructing the hash data table, we use the actual table statistics to determine whether a runtime filter needs to be built, ensuring that the runtime filter is used accurately in hash join queries, thereby improving the accuracy and rationality of the judgment.

Benefits of technology

This approach enables the proper use of runtime filters, improving data query performance and ensuring the accuracy and efficiency of query results.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN116775697B_ABST
    Figure CN116775697B_ABST
Patent Text Reader

Abstract

This disclosure provides a method, apparatus, computer device, and storage medium for querying data tables in a database. The method includes: obtaining a data table query instruction, the instruction being used to perform a hash join query operation on target join columns of multiple data tables in the database; during the hash join construction phase, constructing a hash data table based on table data corresponding to the target join columns of a first data table in the multiple data tables; determining, based on table statistics of the hash data table, whether a runtime filter for filtering data in a second data table of the multiple data tables needs to be constructed during the hash join probing phase; and if so, using the constructed runtime filter to determine the data query result based on the hash data table and the second data table.
Need to check novelty before this filing date? Find Prior Art

Citation Information

Patent Citations

  • Techniques for evaluating query predicates during in-memory table scans

    US20160350347A1