Keyword Aggregate Query Based on Query Template

Abstract

For keywords query, we propose a keyword aggregate query method based on query template. During the keywords processing, symbol table is used to locate the position of the keywords in the database to get a series of query items. In the query template generating stage, we design a heuristic query template generation algorithm. We use the improved scoring rules to rate the query templates, and select the optimal query template. The experimental results have shown that the aggregate query method is effective. I. INTRODUCTION Along with the extensive application of database technology, a large amount of information is stored in the database. In order to retrieve the required information from database, the users must not only master complex grammar specification, but also know the mode information of database. However, it is difficult for the general users who have no background of database knowledge. The advantage of information retrieval technology is that it is simple and convenient, the information can be obtained just by keywords. Information retrieval techniques are applied to the query in the database, we can access database through keyword query, just as using a search engine to retrieve the information, which make it intuitive and easy-to-use for users to access databases. Keyword query which is implemented in database can simplify the query process, reduce the difficulty and complexity, and furthermore, it is based on the entire contents of the database, without the restrictions of relationships and properties the generated result is not just confined to a single attribute, a tuple or a single table, we need to connect the structure that contains different keywords information in the user query, maybe it is a tuple connected by multiple tables, expanding the coverage of the query. In this background, the research about database queries based on the keywords has become one of the hot issues, which attracted scholars' attention in different areas, such as information retrieval, Internet and database. In this paper, according to the keywords query in the database, we proposed a of query template-based aggregation query method. When processing the user- specified keywords, the symbol table (1) is used to locate the position of the keywords in a relational database, forming a query term. When generating query templates, we design a heuristic query template generation algorithm. In the query result generating, we exploit the improved scoring rules to rate the generated query templates, and then, select the optimal query template to generate results. Finally, the experimental results show that the aggregate query method is effective.