Data association query method and apparatus, device, and storage medium

A computer device, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor, when executing the computer program, performs the following:

• 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 the processor is configured to perform determining the query policy according to the query key information by:
• determining a statement format of the query key information;
• and
• determining the query policy according to the statement format;
• wherein the processor is configured to perform determining the query policy according to the statement format by:
• in response to the statement format being a partition column format, determining the query policy as the partition filtering policy;
• accordingly, the processor is configured to perform querying the data in the second association table based on the query policy of the first association table by:
• 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.

A non-transitory computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor, performs the following:

• 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 the computer program is configured to perform determining the query policy according to the query key information by:
• determining a statement format of the query key information;
• and
• determining the query policy according to the statement format;
• wherein the computer program is configured to perform determining the query policy according to the statement format by:
• in response to the statement format being a partition column format, determining the query policy as the partition filtering policy;
• accordingly, the computer program is configured to perform querying the data in the second association table based on the query policy of the first association table by:
• 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.