US 12,216,655 B2
Data association query method and apparatus, device, and storage medium
Taibao Wang, Shenzhen (CN); Donghui Xu, Shenzhen (CN); Yaofeng Tu, Shenzhen (CN); Qiang Zhang, Shenzhen (CN); and Dezheng Wang, Shenzhen (CN)
Assigned to ZTE CORPORATION, Shenzhen (CN)
Appl. No. 18/012,903
Filed by ZTE CORPORATION, Shenzhen (CN)
PCT Filed Jun. 21, 2021, PCT No. PCT/CN2021/101362
§ 371(c)(1), (2) Date Dec. 23, 2022,
PCT Pub. No. WO2021/259217, PCT Pub. Date Dec. 30, 2021.
Claims priority of application No. 202010583764.3 (CN), filed on Jun. 23, 2020.
Prior Publication US 2023/0259509 A1, Aug. 17, 2023
Int. Cl. G06F 16/2453 (2019.01)
CPC G06F 16/24542 (2019.01) 15 Claims
OG exemplary drawing
 
1. A data association query method, comprising:
parsing a data query statement to obtain association query information; wherein the association query information comprises query key information of a first association table;
determining a query policy according to the query key information; wherein the query policy comprises a partition filtering policy, a scan-while-filter policy and a scan-before-filter policy; and
querying, based on the query policy, data in a second association table to obtain target data;
wherein determining the query policy according to the query key information comprises:
determining a statement format of the query key information; and
determining the query policy according to the statement format;
wherein determining the query policy according to the statement format comprises:
in response to the statement format being a partition column format, determining the query policy as the partition filtering policy;
accordingly, querying the data in the second association table based on the query policy of the first association table comprises:
filtering out partitions that do not match the query key information from the second association table; and
performing a data query in remaining partitions after filtering according to the query key information.