关系数据库中的关键字查询问题使得用户无需掌握查询SQL语言与数据库模式相关知识就可以进行数据库查询,因此受到人们的广泛关注,许多方法和原型被提出。当前流行的关系数据库中关键字查询技术存在较慢的查询时间或者不准确的查询结果。针对这两个问题,提出了一种基于用户反馈的查询方法,根据用户输入的关键字动态地生成一个在数据库中包含关键字的属性所组成的Form表单提供给用户,用户在Form中进行选择并提交,最后,根据用户的选择和数据库模式图进行连接算法并执行SQL获得最终结果。
Keyword query problem in relational database allows users to query the database without having to master SQL and knowledge of database schema, therefore it receives widespread attention, many methods and prototypes are proposed. There exists slow query timc and inaccurate results ofkeyword queries technology in the popular relational database. For these two issuse, the paper presents a method of inquiry based on user feedback. In the method, the keywords input by users dynamically generate a Form to users, which consists of the attributes containing keywords in the database. The users would choose in the Form and submit. Finally, based on users' choice and database schema diagram, SQL join algorithm is performed and the final results are obtained in the paper.