论文标题
示例驱动的用户意图发现：授权用户通过查询通过查询越过SQL屏障
Example-Driven User Intent Discovery: Empowering Users to Cross the SQL Barrier Through Query by Example
论文作者
论文摘要
传统数据系统需要专门的技术技能，用户需要了解数据组织并编写精确查询以访问数据。因此，缺乏技术专长的新手用户在细读和分析数据方面面临障碍。现有工具通过关键字搜索，查询建议和查询自动完成来协助制定查询，但仍然需要一些技术专业知识。访问数据的另一种方法是查询示例（QBE），用户仅通过提供其预期数据的示例来表达其数据探索意图。我们研究了一个名为Squid的最先进的QBE系统，并将其与传统的SQL查询进行对比。我们的比较用户研究表明，具有不同专业知识的用户在鱿鱼方面比SQL更有效，效率更高。我们发现，Squid消除了研究数据库模式，正式化任务语义和撰写语法上的SQL查询的障碍，从而大大减轻了数据探索技术专业知识的需求。
Traditional data systems require specialized technical skills where users need to understand the data organization and write precise queries to access data. Therefore, novice users who lack technical expertise face hurdles in perusing and analyzing data. Existing tools assist in formulating queries through keyword search, query recommendation, and query auto-completion, but still require some technical expertise. An alternative method for accessing data is Query by Example (QBE), where users express their data exploration intent simply by providing examples of their intended data. We study a state-of-the-art QBE system called SQuID, and contrast it with traditional SQL querying. Our comparative user studies demonstrate that users with varying expertise are significantly more effective and efficient with SQuID than SQL. We find that SQuID eliminates the barriers in studying the database schema, formalizing task semantics, and writing syntactically correct SQL queries, and thus, substantially alleviates the need for technical expertise in data exploration.
