ISSN 1000-1239 CN 11-1777/TP

计算机研究与发展 ›› 2017, Vol. 54 ›› Issue (6): 1198-1212.doi: 10.7544/issn1000-1239.2017.20160806

所属专题: 2017优青专题

• 综述 • 上一篇    下一篇

查询结果可用性研究综述

柳晴1,高云君1,2   

  1. 1(浙江大学计算机科学与技术学院 杭州 310027); 2(浙江省大数据智能计算重点实验室(浙江大学) 杭州 310027) (liuq@zju.edu.cn)
  • 出版日期: 2017-06-01
  • 基金资助: 
    国家“九七三”重点基础研究发展计划基金项目(2015CB352502);国家自然科学基金优秀青年科学基金项目(61522208);国家自然科学基金项目(61379033,61472348);NSFC-浙江两化融合联合基金重点项目(U1609217)

Survey of Database Usability for Query Results

Liu Qing1, Gao Yunjun1,2   

  1. 1(College of Computer Science and Technology, Zhejiang University, Hangzhou 310027); 2(Key Laboratory of Big Data Intelligent Computing of Zhejiang Province (Zhejiang University), Hangzhou 310027)
  • Online: 2017-06-01

摘要: 数据库可用性研究在数据库领域受到了广泛的关注.其目标在于帮助用户更加高效、方便地使用数据库,从而提高用户对数据库的满意度.主要关注查询结果可用性研究.当前的数据库查询仅仅向用户返回查询结果.如果查询结果不是用户想要的,现有的数据库系统既不能向用户解释为什么会得到这样的结果,也无法给出有效的建议以帮助用户得到满意的查询结果.查询结果可用性研究正是针对当前数据库系统的这一不足而展开.在数据库可用性的视角之上,以查询结果为中心,对当前查询结果可用性工作的最新动态进行了综述.梳理了当前查询结果可用性相关研究中问题的类型及其特点,并从Causality & Responsibility问题、Why-not & Why问题、Why-few & Why-many问题这3个方面对该领域的研究工作现状进行了分类、介绍和总结.最后对该研究领域未来可能的研究方向进行了展望,为相关研究提供参考.

关键词: 数据库可用性, why-not问题, why问题, causality与responsibility, why-few问题, why-many问题

Abstract: Database usability has received much attention in the database community because of its importance. The goal of database usability is to help users utilize database more efficiently and conveniently, and thus improving the user’s satisfaction for the database. In this survey, we focus on the database usability for query results. Currently, the queries only return the query results to users. If the query result is unexpected for the users, it will frustrate users. However, the database system neither gives explanations for the unexpected query results, nor offers any suggestion on how to get the expected results for users. The users only can debug the queries by themselves, which is cumbersome and time-consuming. If the database system can offer such explanations and suggestions, it helps the users understand initial query better, and know how to change the query until the satisfactory results are found, hence improving the usability of the database. Towards this, the studies on unexpected query results have been explored. In this paper, we provide a comprehensive survey of the most recent research on database usability for query results. The paper first analyses the unexpected query results, and introduces the corresponding three problems, i.e., causality & responsibility, why-not & why questions, and why-few & why-many questions, and highlights the importance of these three problems. Then, the state of the art progresses of the unexpected query result research have been surveyed and summarized. Finally, the paper raises some directions for the future work.

Key words: database usability, why-not questions, why questions, causality &, responsibility, why-few questions, why-many questions

中图分类号: