Nothing Special   »   [go: up one dir, main page]

skip to main content
10.1145/3183713.3193548acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
research-article
Public Access

SQuID: Semantic Similarity-Aware Query Intent Discovery

Published: 27 May 2018 Publication History

Abstract

Recent expansion of database technology demands a convenient framework for non-expert users to explore datasets. Several approaches exist to assist these non-expert users where they can express their query intent by providing example tuples for their intended query output. However, these approaches treat the structural similarity among the example tuples as the only factor specifying query intent and ignore the richer context present in the data. In this demo, we present SQuID, a system for Semantic similarity-aware Query Intent Discovery. SQuID takes a few example tuples from the user as input, through a simple interface, and consults the database to discover deeper associations among these examples. These data-driven associations reveal the semantic context of the provided examples, allowing SQuID to infer the user's intended query precisely and effectively. SQuID further explains its inference, by displaying the discovered semantic context to the user, who can then provide feedback and tune the result. We demonstrate how SQuID can capture even esoteric and complex semantic contexts, alleviating the need for constructing complex SQL queries, while not requiring the user to have any schema or query language knowledge.

References

[1]
A. Bonifati, R. Ciucanu, and S. Staworko. 2014. Interactive Inference of Join Queries. In EDBT. 451--462.
[2]
A. Bonifati, R. Ciucanu, and S. Staworko. 2016. Learning Join Queries from User Examples. ACM Trans. Database Syst. Vol. 40, 4 (2016), 24:1--24:38.
[3]
D. Deutch and A. Gilad. 2016. QPlain: Query by explanation. In ICDE. 1358--1361.
[4]
G. Diaz, M. Arenas, and M. Benedikt. 2016. SPARQLByE: Querying RDF Data by Example. Proc. VLDB Endow. Vol. 9, 13 (Sept. 2016), 1533--1536.

Cited By

View all
  • (2024)Wred: Workload Reduction for Scalable Index TuningProceedings of the ACM on Management of Data10.1145/36393052:1(1-26)Online publication date: 26-Mar-2024
  • (2021)Social media intention mining for sustainable information systems: categories, taxonomy, datasets and challengesComplex & Intelligent Systems10.1007/s40747-021-00342-99:3(2773-2799)Online publication date: 5-Apr-2021
  • (2020)Query by Example for Cross-Lingual Event RetrievalProceedings of the 43rd International ACM SIGIR Conference on Research and Development in Information Retrieval10.1145/3397271.3401283(1601-1604)Online publication date: 25-Jul-2020
  • Show More Cited By

Recommendations

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Conferences
SIGMOD '18: Proceedings of the 2018 International Conference on Management of Data
May 2018
1874 pages
ISBN:9781450347037
DOI:10.1145/3183713
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 27 May 2018

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. query by example
  2. semantic similarity
  3. sql query discovery

Qualifiers

  • Research-article

Funding Sources

Conference

SIGMOD/PODS '18
Sponsor:

Acceptance Rates

SIGMOD '18 Paper Acceptance Rate 90 of 461 submissions, 20%;
Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)58
  • Downloads (Last 6 weeks)7
Reflects downloads up to 12 Nov 2024

Other Metrics

Citations

Cited By

View all
  • (2024)Wred: Workload Reduction for Scalable Index TuningProceedings of the ACM on Management of Data10.1145/36393052:1(1-26)Online publication date: 26-Mar-2024
  • (2021)Social media intention mining for sustainable information systems: categories, taxonomy, datasets and challengesComplex & Intelligent Systems10.1007/s40747-021-00342-99:3(2773-2799)Online publication date: 5-Apr-2021
  • (2020)Query by Example for Cross-Lingual Event RetrievalProceedings of the 43rd International ACM SIGIR Conference on Research and Development in Information Retrieval10.1145/3397271.3401283(1601-1604)Online publication date: 25-Jul-2020
  • (2019)A hybrid deep neural network model for query intent classificationJournal of Intelligent & Fuzzy Systems: Applications in Engineering and Technology10.3233/JIFS-18268236:6(6413-6423)Online publication date: 11-Jun-2019
  • (2019)Example-driven query intent discoveryProceedings of the VLDB Endowment10.14778/3342263.334226612:11(1262-1275)Online publication date: 1-Jul-2019
  • (2019)Explain3DProceedings of the VLDB Endowment10.14778/3317315.331732012:7(779-792)Online publication date: 1-Mar-2019
  • (2019)SimG: A Semantic Based Graph Similarity Search Engine2019 Seventh International Conference on Advanced Cloud and Big Data (CBD)10.1109/CBD.2019.00030(114-120)Online publication date: Sep-2019
  • (2019)S2R-tree: a pivot-based indexing structure for semantic-aware spatial keyword searchGeoinformatica10.1007/s10707-019-00372-z24:1(3-25)Online publication date: 8-Jul-2019
  • (2019)QED: Out-of-the-Box Datasets for SPARQL Query EvaluationThe Semantic Web10.1007/978-3-030-21348-0_32(491-506)Online publication date: 25-May-2019
  • (2019)Semantic locality‐based approximate knowledge graph queryConcurrency and Computation: Practice and Experience10.1002/cpe.534531:24Online publication date: 17-May-2019

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media