Data query method and apparatus, and storage medium

A data query apparatus, comprising:

• at least one processor, and
• a non-transitory memory with instructions thereon,
• wherein the instructions upon execution by the processor, cause the processor to:
• receive parameters by a plurality of storage systems of different types on a computer device, wherein the parameters comprise computer data and the computer data is distributed in the plurality of storage systems, the plurality of storage systems of different types support different query manners, and a difference between the query manners comprises a difference in a format of a query statement;
• obtain a query requirement through a query page, wherein the query requirement comprises an index parameter used for querying and a target parameter queried based on the index parameter;
• store a correspondence between a parameter and a storage file that stores the parameter, and match the index parameter and the target parameter with the correspondence respectively, to determine a to-be-queried storage file, wherein the to-be-queried storage file comprises a storage file that stores the index parameter and a storage file that stores the target parameter;
• obtain at least one query solution that satisfies the query requirement based on the to-be-queried storage file, wherein each of the at least one query solution is used to indicate a storage file that needs to be queried to obtain the target parameter based on the index parameter, and the storage file that needs to be queried to obtain the target parameter based on the index parameter is part or all of the storage files included in the to-be-queried storage file;
• automatically generate a query statement corresponding to a query solution corresponding to a minimum query overhead in the at least one query solution and execute the query statement to execute the query solution corresponding to the minimum query overhead, to query and obtain the target parameter, wherein the query overhead of each query solution is determined based on a storage system associated with the query solution in the plurality of storage systems, and the storage system associated with the query solution comprises a storage system corresponding to a storage file involved in the query solution;
• and
• determine, for each of the at least one query solution, a query overhead corresponding to the query solution based on a query overhead value of a storage file involved in the query solution, wherein the storage file involved in the query solution comprises a target storage file, and the query overhead value of the target storage file is determined based on a storage system corresponding to the target storage file,
• wherein the target storage file comprises at least one dimension of indicator, the query overhead value of the target storage file is equal to a sum of query overhead values corresponding to each indicator, and the query overhead value of each indicator is equal to a product of a statistical value corresponding to the indicator and a weight of the indicator, wherein the weight respectively corresponding to each of the at least one dimension of indicator is determined based on the storage system corresponding to the target storage file, and
• wherein the target parameter comprises a third parameter, and the processor is further caused to:
• match the index parameter and the target parameter with the correspondence respectively, to obtain a fourth storage file that stores the index parameter and an intermediate parameter, and a fifth storage file that stores the intermediate parameter and the third parameter;
• obtain a fourth query solution based on the fourth storage file and the fifth storage file, wherein the fourth query solution indicates to first query the fourth storage file based on the index parameter, and then query the fifth storage file based on the intermediate parameter obtained by querying the fourth storage file, to obtain the third parameter;
• determine storage files which are involved in the query solution;
• generate the query statement corresponding to each of storage files based on each of the storage files which are involved in the query solution, query input corresponding to a storage file, query result corresponding to the storage file, and a query statement format supported by each of the storage files which are involved in the query solution, wherein the query input comprises the index parameter for querying the fourth storage file and the intermediate parameter for querying the fifth query file, and the query result comprises the intermediate parameter obtained by querying the fourth storage file and the third parameter obtained by querying the fifth query file;
• and
• execute the query statement to query based on a query order of the fourth storage file and the fifth query file and obtain the target parameter.

A non-transitory computer-readable storage medium storing instructions that cause at least a processor to:

• receive parameters by a plurality of storage systems of different types on a computer device, wherein the parameters comprise computer data and the computer data is distributed in the plurality of storage systems, the plurality of storage systems of different types support different query manners, and a difference between the query manners comprises a difference in a format of a query statement;
• obtain a query requirement through a query page, wherein the query requirement comprises an index parameter used for querying and a target parameter queried based on the index parameter;
• store a correspondence between a parameter and a storage file that stores the parameter, and match the index parameter and the target parameter with the correspondence respectively, to determine a to-be-queried storage file, wherein the to-be-queried storage file comprises a storage file that stores the index parameter and a storage file that stores the target parameter;
• obtain at least one query solution that satisfies the query requirement based on the to-be-queried storage file, wherein each of the at least one query solution is used to indicate a storage file that needs to be queried to obtain the target parameter based on the index parameter, and the storage file that needs to be queried to obtain the target parameter based on the index parameter is part or all of the storage files included in the to-be-queried storage file;
• automatically generate a query statement corresponding to a query solution corresponding to a minimum query overhead in the at least one query solution and execute the query statement to execute the query solution corresponding to the minimum query overhead, to query and obtain the target parameter, wherein the query overhead of each query solution is determined based on a storage system associated with the query solution in the plurality of storage systems, and the storage system associated with the query solution comprises a storage system corresponding to a storage file involved in the query solution;
• and
• determine, for each of the at least one query solution, a query overhead corresponding to the query solution based on a query overhead value of a storage file involved in the query solution, wherein the storage file involved in the query solution comprises a target storage file, and the query overhead value of the target storage file is determined based on a storage system corresponding to the target storage file,
• wherein the target storage file comprises at least one dimension of indicator, the query overhead value of the target storage file is equal to a sum of query overhead values corresponding to each indicator, and the query overhead value of each indicator is equal to a product of a statistical value corresponding to the indicator and a weight of the indicator, wherein the weight respectively corresponding to each of the at least one dimension of indicator is determined based on the storage system corresponding to the target storage file, and
• wherein the target parameter comprises a third parameter, and the processor is further caused to:
• match the index parameter and the target parameter with the correspondence respectively, to obtain a fourth storage file that stores the index parameter and an intermediate parameter, and a fifth storage file that stores the intermediate parameter and the third parameter;
• obtain a fourth query solution based on the fourth storage file and the fifth storage file, wherein the fourth query solution indicates to first query the fourth storage file based on the index parameter, and then query the fifth storage file based on the intermediate parameter obtained by querying the fourth storage file, to obtain the third parameter;
• determine storage files which are involved in the query solution;
• generate the query statement corresponding to each of storage files based on each of the storage files which are involved in the query solution, query input corresponding to a storage file, query result corresponding to the storage file, and a query statement format supported by each of the storage files which are involved in the query solution, wherein the query input comprises the index parameter for querying the fourth storage file and the intermediate parameter for querying the fifth query file, and the query result comprises the intermediate parameter obtained by querying the fourth storage file and the third parameter obtained by querying the fifth query file;
• and
• execute the query statement to query based on a query order of the fourth storage file and the fifth query file and obtain the target parameter.