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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: FENG XIAONA, YAN YANLI, LIU JIANHUI, WEN SHUAIYING, LIU TAO, MENG WEI, CHEN JING
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
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.