CN101206654B - Database query system and method with intelligent query capability - Google Patents

Abstract

The invention discloses a database query system and a database query method with intelligent query capability. The system disclosed by the invention comprises the following components: the system comprises an intelligent memory base, a database and an analysis query module. After the user inputs the query objects, the intelligent memory library is used for searching whether corresponding query sentences exist or not, if so, the database is queried by the query sentences, if not, the query objects are delivered to the analysis query module to generate a plurality of query sentences, the database is queried to calculate corresponding query combination scores, and the query sentences with lower query cost are found and recorded in the intelligent memory library. Then, if the user queries with the same query object again, the query statement can be automatically selected for querying data, so that the query efficiency of the database is reduced by using the query statement with poor efficiency to query the database.

Description

Database query system and method with intelligent query capability

technical field

The invention relates to a database query system and method, in particular to a database query system and method with intelligent query capability and capable of automatically generating query combinations corresponding to input query objects.

Background technique

With the popularization of computer use, the recording of data and data has gradually changed from being recorded in paper documents to being recorded in electronic media (or files). Various data can be recorded in these electronic media (or files) and compiled into a database. The most commonly used function in the database is querying data. Users can retrieve associated data from the database by issuing query commands, such as querying with SQL commands. For example, the questionnaire survey data, including the sex, age, hobbies, income, and weekly movie times of the testees, etc. are stored in the database. If the user wants to know the movie market whose age group is older than 20, he can know it by issuing a simple query command, for example: Select Movie_Times_Week From Survey--_Inf where age>20, and the user can also use more complex query commands and Calculate, to know the total value of the potential film market of the above age group, the user can issue an example: Select SUM (ICOME) From Survey_Inf where age > 20 to know the total income of the subjects whose age group is over 20 years old, and issue For example: SelectSUM(Movie_Times_Week) From Survey_Inf where age > 20 Know the total number of times that the subjects over the age of 20 watch movies every week, and subtract the total income of the subjects over the age of 20 from the query channel The total value of the potential movie market mentioned above can be obtained from the amount spent on the total number of times the movie is watched in a week.

However, to fully utilize the functions of the database often depends on the quality of the query commands issued, and the quality of the query commands depends on the user's understanding of the database (such as the meaning of fields) and the complexity of the query commands issued For example, retrieving data with one more complex SQL command may take more time than retrieving data with multiple simpler SQL commands, so a more complex SQL can be regarded as a poor quality query command. It can be seen that human operation factors may force the performance of collecting and managing database data to be greatly reduced. Therefore, a database query system and method independent of human operation is needed to avoid and improve the above-mentioned defects.

Contents of the invention

The technical problem to be solved by the present invention is to automatically generate a corresponding query statement after inputting a query object to query data in a database.

In order to achieve the above object, the present invention is achieved through two aspects of system and method. The system disclosed in the present invention includes: an intelligent memory bank for storing multiple query objects and their corresponding query statements; a database for storing The data is for users to query; and an analysis and query module is used to generate multiple object combinations corresponding to these query objects, and generate corresponding query statements according to a query algorithm to query the database and output a result set. Wherein, the above-mentioned analysis and query module further calculates the query combination scores corresponding to these query statements, and records the query statements corresponding to the smallest query combination scores in the intelligent memory, and collects the output from the database into a result set.

The database query method with intelligent query capability disclosed by the present invention includes the following steps: firstly input at least one query object to query at least one corresponding query statement; afterward, if it is determined that there is a corresponding query statement, then according to these query statements Query the database to output a result set; then, if it is judged that there is no corresponding query statement, generate multiple object combinations based on these query objects, and generate query statements corresponding to these object combinations according to a query algorithm to query the database; then According to the output of the database, multiple query combination scores corresponding to these query statements are calculated; finally, the smallest query combination score is found, and the query statement corresponding to the query combination score is recorded, and the result set corresponding to the query statement is output.

As can be seen from the above system and method, the present invention generates query statements corresponding to query objects, and calculates and records a query statement corresponding to these query statements with a relatively small query cost, so that when querying with the same query object in the future, it can automatically Take out the corresponding query statement to query the data, so as to avoid reducing the efficiency of the database system by issuing poor efficiency or wrong query statements when man-operating the database.

Regarding the detailed features and implementation of the present invention, it will be described in detail in the implementation mode with reference to the drawings as follows, the content of which is sufficient for those skilled in the art to understand the technical content of the present invention and implement it accordingly, and according to the content disclosed in this specification With the accompanying drawings, any person skilled in the art can easily understand the related objects and advantages of the present invention.

Description of drawings

Fig. 1 is the schematic diagram of the database inquiry system that the embodiment of the present invention proposes;

FIG. 2 is a flow chart of the database query method proposed in the embodiment of the present invention.

Among them, reference signs:

110: Intelligent Memory Bank

120: database

130: Analysis query module

132: Query calculation module

134: Result value comparison module

Detailed ways

In order to make the above and other objects, features and advantages of the present invention more comprehensible, an embodiment will be exemplified below and described in detail in conjunction with the accompanying drawings.

FIG. 1 is a schematic diagram of a database query system proposed in an embodiment of the present invention. Please refer to Fig. 1, the database query system (hereinafter referred to as the system) of the present embodiment includes an intelligent memory bank 110 for storing input query objects and query statements corresponding to these query objects; a database 120 for storing data for use or query; an analysis query module 130 is used to generate the object combination corresponding to the query object, and generate corresponding query statements according to an algorithm, and use these query statements to query a result set in the database 120 . In addition, the query analysis module 130 calculates the corresponding query combination score according to the time required for each query statement and the number of members of the returned result set. These query combination scores represent the cost of querying the database 120 using these query statements. The analysis query module 130 will find out the minimum value in these query combination scores (in this embodiment, a smaller query combination score represents that the corresponding query statement can query more accurate data in a shorter time), and this The query object and query statement corresponding to the smallest query combination score are stored in the intelligent memory, and the query result set is output to the user.

Continuing from the previous paragraph, the above analysis and query module 130 also includes a query calculation module 132 and a comparison module 134 . The query calculation module 132 stores algorithms for calculating various query statements corresponding to query objects. The query calculation module 132 can use this algorithm to generate some object combinations according to the relationship between query objects, and further generate corresponding query statements based on these object combinations. When the analysis and query module 130 generates several query statements and uses these query statements to query the database 120 to obtain query results, the analysis and query module 130 collects these query results into a result set. At this time, the comparison module 134 will generate corresponding query combination scores based on the number of members of these result sets and the time required to generate these results, and further determine the smallest query combination score and its corresponding query statement. It is used to record the query statement in the intelligent memory bank 110 . When the user inputs the same query object next time, the system does not need to generate the corresponding query statement again, but can directly retrieve the query statement from the intelligent memory bank to query data.

Incidentally, the intelligent memory bank 110 of this system can be, for example, a hard disk or a flash memory, etc., which can be used to store query objects and corresponding query statements. In this embodiment, the query statement is, for example, a structured query Language instructions (Structured Query Language, SQL), anyone skilled in the art, should be modified according to the teachings of this embodiment, and its scope is not limited here.

FIG. 2 is a flow chart of the database query method proposed in the embodiment of the present invention. Please refer to Fig. 2, the database query method of the present embodiment includes the following steps: first, input at least one query object (step 210), these query objects are for example the selection object and range that the user wants to issue, rather than database queries such as SQL Instructions; at this time, the system will judge whether there are query statements corresponding to these query objects. The query statements are, for example, SQL or other query instructions for querying the database. database to output a result set (step 220); if it is judged that there is no corresponding query statement, then generate several object combinations according to these query objects, and generate query statements corresponding to these object combinations according to a query algorithm for querying the database (step 230); then, according to the data output by the database, calculate the query combination scores corresponding to these query statements (step 240); finally, find out the minimum query combination scores, and record the query statements corresponding to the query combination scores, and output the query statements The corresponding result set (step 250).

The query algorithm in the present embodiment is based on the relationship between inputting at least one query object and the database field to generate object combinations and corresponding query statements. It includes the following steps: first find whether the database of the system contains the input query object; If these query objects are not included, an error message will be output, for example: the database does not contain the data you are looking for, please enter again. If it is determined that at least one query object is included, then the arrangement of the object combination is generated according to the relevance of these query objects in several tables of the database. There are 5 tables, 1 table, and 1 table. At this time, the object combination is, for example, ABC, which means querying according to the level of relevance. First query the information related to the A object, then query the B object, and then query the C object; finally, based on these Object composition produces corresponding query statements.

Based on the above, the system automatically queries the database with each generated query statement, and collects the results searched from the database into a result set corresponding to each query statement. The result set contains fields such as query object field, query statement field, and required time field , result member fields, etc., are used to clearly indicate the items the user queries, several query statements generated by the system, the time required to search the database, and the data searched by the database. In addition, the system further calculates the query combination score mentioned in step 240 . The quality of the issued query statement depends on the query time and the amount of data found. Generally speaking, the user hopes to find accurate data in the shortest possible time, and when the query statement issued is more accurate, the individual value of the found result members will be higher. Of course the number is less. For example, if you want to find the selling price information of tea drinks in the product database, if you only use drinks as the query data, you will find too many members in the result, and you may even search for the selling price data of carbonated drinks . If tea drinks, PET bottle packaging, and sales locations are used as query items, although the information found is more accurate, the time for searching the database is increased. The query combination score is used to represent the quality of querying the database with a query statement, and its calculation method is the sum of the number of result members in the result set and the time spent querying the database. Each query statement has a corresponding query combination score. In this embodiment, the quality of the query statement corresponding to the smaller query combination score is higher, while the quality of the query statement corresponding to the larger query combination score is lower. The comparison module in the analysis and query module of the system will select the query statement corresponding to the lowest query combination score as a better query statement, and record it in the intelligent memory bank.

In summary, the present invention uses an intelligent memory bank to store query statements with better query quality, and automatically generates several query statements corresponding to query objects through the analysis query module to input database queries and judge queries with better query quality Statements, and then stored, and at least the following advantages:

(1) The user only needs to input query items to automatically generate query language.

(2) Operations can be performed without an in-depth understanding of the tables or fields of the database.

(3) The system automatically generates query sentences with high query quality, avoiding the use of query sentences with poor efficiency to query the database and reduce the query efficiency of the database.

Of course, the present invention can also have other various embodiments. Without departing from the spirit and essence of the present invention, those skilled in the art can make various corresponding changes and deformations according to the present invention, but these corresponding All changes and deformations should belong to the protection scope of the appended claims of the present invention.

Claims (8)

1. A database query system with intelligent query capability, suitable for automatically generating at least one query statement corresponding to at least one query object of input to query data, characterized in that the database query system includes: An intelligent memory bank, used to store the query objects and the corresponding query statements; a database for storing data for users to query; and An analysis and query module, used to generate several object combinations corresponding to the query objects, and generate the corresponding query statements according to a query algorithm, to query the database and output a result set; The analysis query module also calculates multiple query combination scores corresponding to the query statements, records the query statement corresponding to the smallest query combination scores in the intelligent memory, and outputs the result set. 2. The database query system with intelligent query capability according to claim 1, wherein the analysis query module also includes: A query calculation module, used to generate the plurality of object combinations according to the relationship of the query objects, and generate the query statements corresponding to the object combinations; and A comparison module, used to determine and issue the query statement corresponding to the minimum query combination score. 3. The database query system with intelligent query capability according to claim 1, wherein the intelligent memory bank is a hard disk or a flash memory. 4. The database query system with intelligent query capability according to claim 1, wherein the query statements are structured query language instructions. 5. A database query method with intelligent query capability, suitable for automatically generating at least one query statement corresponding to at least one query object of input for querying data in a database, characterized in that the database query method includes the following steps : input at least one query object; Judging that there are corresponding query statements, querying the database according to the query statements to output a result set; If it is judged that there are no corresponding query statements, multiple object combinations are generated according to the query object, and query statements corresponding to the object combinations are generated according to a query algorithm to query the database; calculating a query combination score corresponding to the query statements according to the output of the database; and Find the smallest query combination score, record the query statements corresponding to the query combination scores, and output the result set corresponding to the query statements. 6. The database query method with intelligent query capability according to claim 5, wherein the query algorithm comprises the following steps: Find whether the database contains the input query objects; If it is judged that these query objects are not included at all, an error message is output; judging that at least one of the query objects is included, generating an arrangement of combinations of the objects according to the relevance of the query objects in several tables of the database; and The query statements corresponding to the object combinations are generated. 7. The database query method with intelligent query capability according to claim 5, wherein the query combination scores are the sum of the number of result members of the result set and the query time. 8. The database query method with intelligent query capability according to claim 5, wherein the fields of the result set include a query object field, a query statement field, a required time field, and a result member field.

Images