Data query method and device
The invention discloses a data query method and a data query device. The method comprises the following steps: pre-compiling an SQL (Structured Query Language) template corresponding to each statistical item, wherein the query parameter of each SQL template is a variable, so that the SQL template co...
Gespeichert in:
Hauptverfasser: | , , , , , , |
---|---|
Format: | Patent |
Sprache: | eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | The invention discloses a data query method and a data query device. The method comprises the following steps: pre-compiling an SQL (Structured Query Language) template corresponding to each statistical item, wherein the query parameter of each SQL template is a variable, so that the SQL template corresponding to a statistical item can be searched by only inputting the query parameter when a statistical result of a certain target statistical item is queried by a user; converting the SQL template into a specific SQL statement by utilizing the query parameter; querying the statistical result by utilizing the SQL statement. When the data query is performed by the user by using the method disclosed by the invention, only the query parameter is required to be input; the process of compiling the SQL statement in the prior art is eliminated, so that the workload of the user is reduced, and the query efficiency is greatly improved. |
---|