Cited By
View all- Katsogiannis-Meimarakis GKoutrika G(2023)A survey on deep learning approaches for text-to-SQLThe VLDB Journal10.1007/s00778-022-00776-832:4(905-936)Online publication date: 23-Jan-2023
Analysis of Database Search Systems with THOR
Pages 2681 - 2684
Abstract
Numerous search systems have been implemented that allow users to pose unstructured queries over databases without the need to use a query language, such as SQL. Unfortunately, the landscape of efforts is fragmented with no clear sight of which system is best, and what open challenges we should pursue in our research. To help towards this direction, we present THOR that makes 4 important contributions: a query benchmark, a framework for comparing different systems, several search system implementations, and a highly interactive tool for comparing different search systems.
References
[1]
L. Blunschi, C. Jossen, D. Kossmann, M. Mori, and K. Stockinger. 2012. SODA: Generating SQL for Business Users. PVLDB, Vol. 5, 10 (2012).
[2]
V. Hristidis, L. Gravano, and Y. Papakonstantinou. 2003. Efficient IR-style Keyword Search over Relational Databases. In VLDB. 850--861.
[3]
V. Hristidis and Y. Papakonstantinou. 2002. Discover: Keyword Search in Relational Databases. In VLDB (Hong Kong, China). 670--681.
[4]
A. Kokkalis, P. Vagenas, A. Zervakis, A. Simitsis, G. Koutrika, and Y. E. Ioannidis. 2012. Logos: a system for translating queries into narratives. In SIGMOD 2012. 673--676.
[5]
F. Li and H. V. Jagadish. 2014. Constructing an Interactive Natural Language Interface for Relational Databases. PVLDB, Vol. 8, 1 (Sept. 2014).
[6]
Y. Luo, X. Lin, W. Wang, and X. Zhou. 2007. Spark: Top-k Keyword Query in Relational Databases. In ACM SIGMOD. 115--126.
[7]
N. Yaghmazadeh, Y. Wang, I. Dillig, and T. Dillig. 2017. SQLizer: Query Synthesis from Natural Language. PACMPL, Article 63 (2017), bibinfonumpages26 pages.
[8]
T. et al Yu. 2018. Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Task. In EMNLP. 3911--3921.
[9]
Z. Zeng, M. Lee, and T. Ling. 2016. Answering Keyword Queries involving Aggregates and GROUPBY on Relational Databases. EDBT (2016), 161--172.
[10]
V. Zhong, C. Xiong, and R. Socher. 2017. Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learning. CoRR, Vol. abs/1709.00103 (2017).
Index Terms
- Analysis of Database Search Systems with THOR
Recommendations
Olio: A Semantic Search Interface for Data Repositories
UIST '23: Proceedings of the 36th Annual ACM Symposium on User Interface Software and TechnologySearch and information retrieval systems are becoming more expressive in interpreting user queries beyond the traditional weighted bag-of-words model of document retrieval. For example, searching for a flight status or a game score returns a dynamically ...
A user interface guide for web search systems
OzCHI '12: Proceedings of the 24th Australian Computer-Human Interaction ConferenceThe amount of information available on the internet has grown unabated over the years. With internet users using web search systems as a starting point into the internet, understanding the tasks involved in a web search is important to designing ...
Search Culture
PCI '11: Proceedings of the 2011 15th Panhellenic Conference on InformaticsThe documentation retrieval applications have been influenced by each other and have contributed in the creation of some search culture which is shared between the hidden design assumptions (existing behind) of search interfaces and the user skills. The ...
Comments
Information & Contributors
Information
Published In
June 2020
2925 pages
ISBN:9781450367356
DOI:10.1145/3318464
- General Chairs:
- David Maier,
- Rachel Pottinger,
- Program Chairs:
- AnHai Doan,
- Wang-Chiew Tan,
- Publications Chairs:
- Abdussalam Alawini,
- Hung Q. Ngo
Copyright © 2020 ACM.
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 ACM 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: 31 May 2020
Check for updates
Author Tags
Qualifiers
- Short-paper
Conference
SIGMOD/PODS '20
Sponsor:
Acceptance Rates
Overall Acceptance Rate 785 of 4,003 submissions, 20%
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- View Citations1Total Citations
- 204Total Downloads
- Downloads (Last 12 months)13
- Downloads (Last 6 weeks)0
Reflects downloads up to
Other Metrics
Citations
Cited By
View all- Katsogiannis-Meimarakis GKoutrika G(2023)A survey on deep learning approaches for text-to-SQLThe VLDB Journal10.1007/s00778-022-00776-832:4(905-936)Online publication date: 23-Jan-2023
View Options
Get Access
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in