Query recommendation method and apparatus

Abstract

The invention relates to a query recommendation method and apparatus. The method comprises the steps of obtaining a historical query statement input by a preset user; analyzing the historical query statement to obtain statement information of the historical query statement; according to the statement information, determining data table item information queried by the historical query statement, and according to the data table item information, determining a cluster tag corresponding to the preset user; according to cluster tags corresponding to a plurality of historical query statements, determining a recommendation query object corresponding to the preset user; and generating a recommendation query statement corresponding to the recommendation query object. During actual application, before the user inputs the query statement next time, the query statement can be displayed through a popup window or a pull-down menu, and correspondingly, the user can finish statement input only by clicking, so that each character does not need to be tapped on a keyboard, the input efficiency of the query statement is improved, and correspondingly the data query efficiency is enhanced.

Description

technical field [0001] The present disclosure relates to the technical field of data processing, and in particular to a query recommendation method and device. Background technique [0002] When performing data query on a relational database, it is necessary to use a database query statement, such as a structured query language (Structured Query Language, referred to as SQL), to expand the corresponding data query. [0003] At present, when using database query statements for data query, technicians need to input a query statement every time they query the data table, and each time they input a query statement, they need to type out each character one by one. The operation is very inconvenient, making the user's When querying, it takes a very long time, which leads to low efficiency. [0004] Although, when some databases are querying, when the user clicks on the query data frame, the user's recent historical query statements will be displayed in the form of a menu, so that...

AI Technical Summary

Problems solved by technology

[0003] At present, when using database query statements for data query, technicians need to input a query statement every time they query the data table, and each time they input a query statement, they need to type out each character one by one. The operation is very inconvenient, making the user's When querying, the time consumed is very long, which leads to low efficiency

[0004] Although, when some databases are querying, when the user clicks on the query data frame, the user's recent historical query statements will be displayed in the form of a menu, so that the user can select the historical query statement, and then make some modifications in the historical query statement, Although this can improve the character input speed when querying, but because they are all historical query statements, users still need to edit and adjust historical instructions every time they query new content, and the efficiency is still low.

Images