Interactively Discovering and Ranking Desired Tuples without Writing SQL Queries

Xuedi Qin, Chengliang Chai, Yuyu Luo, Nan Tang, Guoliang Li

科研成果: 书/报告/会议事项章节会议稿件同行评审

11 引用 (Scopus)

摘要

The very first step of many data analytics is to find and (possibly) rank desired tuples, typically through writing SQL queries - this is feasible only for data experts who can write SQL queries and know the data very well. Unfortunately, in practice, the queries might be complicated (for example, "find and rank good off-road cars based on a combination of Price, Make, Model, Age, Mileage, and so on" is complicated because it contains many if-then-else, and, or and not logic) such that even data experts cannot precisely specify SQL queries; and the data might be unknown, which is common in data discovery that one tries to discover desired data from a data lake. Naturally, a system that can help users to discover and rank desired tuples without writing SQL queries is needed. We propose to demonstrate such as a system, namely DExPlorer. To use DExPlorer for data exploration, the user only needs to interactively perform two simple operations over a set of system provided tuples: (1) annotate which tuples are desired (i.e., true labels) or not (i.e., false labels), and (2) annotate whether a tuple is more preferred than another one (i.e., partial orders or ranked lists). We will show that DExPlorer can find user's desired tuples and rank them in a few interactions, even for complicated queries.

源语言英语
主期刊名SIGMOD 2020 - Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data
出版商Association for Computing Machinery
2745-2748
页数4
ISBN(电子版)9781450367356
DOI
出版状态已出版 - 14 6月 2020
已对外发布
活动2020 ACM SIGMOD International Conference on Management of Data, SIGMOD 2020 - Portland, 美国
期限: 14 6月 202019 6月 2020

出版系列

姓名Proceedings of the ACM SIGMOD International Conference on Management of Data
ISSN(印刷版)0730-8078

会议

会议2020 ACM SIGMOD International Conference on Management of Data, SIGMOD 2020
国家/地区美国
Portland
时期14/06/2019/06/20

指纹

探究 'Interactively Discovering and Ranking Desired Tuples without Writing SQL Queries' 的科研主题。它们共同构成独一无二的指纹。

引用此

Qin, X., Chai, C., Luo, Y., Tang, N., & Li, G. (2020). Interactively Discovering and Ranking Desired Tuples without Writing SQL Queries. 在 SIGMOD 2020 - Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data (页码 2745-2748). (Proceedings of the ACM SIGMOD International Conference on Management of Data). Association for Computing Machinery. https://doi.org/10.1145/3318464.3384695