图 书 馆
通过直接操作嵌套关系结果构建表达性查询Expressive Query Construction through Direct Manipulation of Nested Relational Results |
|
| 课程网址: | https://videolectures.net/videos/kdd2016_bakke_relational_results |
| 主讲教师: | Eirik Bakke |
| 开课单位: | KDD 2016研讨会 |
| 开课时间: | 2025-02-04 |
| 课程语种: | 英语 |
| 中文简介: |  |
| 课程简介: | Despite extensive research on visual query systems, the standard way to interact with relational databases remains to be through SQL queries and tailored form interfaces. We consider three requirements to be essential to a successful alternative: (1) query specification through direct manipulation of results, (2) the ability to view and modify any part of the current query without departing from the direct manipulation interface, and (3) SQL-like expressiveness. This paper presents the first visual query system to meet all three requirements in a single design. By directly manipulating nested relational results, and using spreadsheet idioms such as formulas and filters, the user can express a relationally complete set of query operators plus calculation, aggregation, outer joins, sorting, and nesting, while always remaining able to track and modify the state of the complete query. Our prototype gives the user an experience of responsive, incremental query building while pushing all actual query processing to the database layer. We evaluate our system with formative and controlled user studies on 28 spreadsheet users; the controlled study shows our system significantly outperforming Microsoft Access on the System Usability Scale. |
| 关 键 词: | 嵌套关系; 表达性查询; 可视化查询系统 |
| 课程来源: | 视频讲座网 |
| 数据采集: | 2025-02-27：liyq |
| 最后编审: | 2025-02-27：liyq |
| 阅读次数: | 6 |