Data query method, data query system and computer storage medium

Abstract

The embodiment of the invention discloses a data query method, a data query system and a computer storage medium, which are used for solving the technical problem of system resource waste caused by the fact that a plurality of synonymous SQL statements need to be queried for multiple times. The method comprises the steps that a data query system receives a plurality of synonymous SQL sentences andanalyzes the synonymous SQL sentences, and query results of the synonymous SQL sentences are the same; then, the data query system can sort a plurality of selection fields in the synonymous SQL statement according to a preset sorting rule; if a plurality of synonymous SQL sentences exist, a judgment is made that that the SQL sentences are not synonymous; if yes, the synonymous SQL sentences are subjected to field selection sequence adjustment; the same standard SQL statement can be obtained; therefore, the data query system only needs to query the target data corresponding to the plurality ofselection fields in one standard SQL statement to obtain the same query result of the plurality of synonymous SQL statements, and does not need to perform multiple queries according to the pluralityof synonymous SQL statements, so that the processing resources of the system are saved.

Description

technical field [0001] The embodiments of the present application relate to the field of data processing, and specifically relate to a data query method, a data query system, and a computer storage medium. Background technique [0002] When the user needs to query, access or update the data stored in the database of the application system, he can generate a structured query language (structured query language, SQL) statement through interface configuration or manual writing, and the application system receives the SQL statement input by the user Afterwards, the data corresponding to the SQL statement is queried in the database according to the SQL statement, and the queried data is fed back to the user. [0003] Due to differences in SQL statement generation rules and users' habits of manually writing SQL statements, etc., the generated SQL statements show differences in the order of query fields and the order of where conditions. For example, the following are two SQL stat...

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present application provides a data query method, a data query system, and a computer storage medium, which are used to solve the technical problem that multiple synonymous SQL statements require multiple queries, resulting in waste of system resources

Images