关系数据库上关键字查询的若干前沿问题研究

项目名称： 关系数据库上关键字查询的若干前沿问题研究

项目编号： No.61070018

项目类型： 面上项目

立项/批准年度： 2011

项目学科： 武器工业

项目作者： 禹晓辉

作者单位： 山东大学

项目金额： 12万元

中文摘要： 作为一种新兴的关系数据库用户交互方式，关键字查询不要求用户对数据库的模式有所了解，也不需要用户掌握结构化查询语言（如SQL），因此有着直观易用的优点。虽然面向Web和传统IR系统的关键字查询技术已趋成熟，面向关系数据库的关键字查询因其不同于Web和传统IR系统的特点，仍面临着很多挑战。本项目研究提出一系列的方法，提高查询的效率，改善查询的效果。计划针对现有模型及方法的不足，提出便于利用用户反馈的查询结果评价模型，及相应的索引结构和算法。本项目的成果将为这个领域的进一步研究和开发奠定基础，并预期将在商业智能、企业资源管理、客户关系管理等系统中得到广泛的应用。

中文关键词： 关键字查询；关系数据库；文本数据检索

英文摘要： As an emerging mode of user interaction with relational databases, keyword search does not require user knowledge of database schemas, nor does it require the users to have expertise in structured query languages, such as SQL. Therefore, it enjoys the benefit of being intuitive and easy to use. Although keyword search for the Web and traditional IR systems has been well studied, performing keyword search in relational databases still faces many challenges due to its different characteristics than doing keyword search in traditional Web and IR contexts. This project proposes a series of methods that can improve the efficiency and effectivness of keyword search in databases. We plan to address the drawbacks of exiting models and methods, and propose result ranking models that are amenable to user feedbacks. The corresponding index structures and algorithms will also be developed. The results from this project will lay the ground for further research and development in this area, and are expected to have wide applications in business intelligence, enterprise resource planning, and customer relationship management.

英文关键词： keyword search; relational database; text retrieval;