demonstration

NaLIR: an interactive natural language interface for querying relational databases

Authors:

Fei Li,

Hosagrahar V JagadishAuthors Info & Claims

SIGMOD '14: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data

Pages 709 - 712

https://doi.org/10.1145/2588555.2594519

Published: 18 June 2014 Publication History

Get Access

Abstract

In this demo, we present NaLIR, a generic interactive natural language interface for querying relational databases. NaLIR can accept a logically complex English language sentence as query input. This query is first translated into a SQL query, which may include aggregation, nesting, and various types of joins, among other things, and then evaluated against an RDBMS. In this demonstration, we show that NaLIR, while far from being able to pass the Turing test, is perfectly usable in practice, and able to handle even quite complex queries in a variety of application domains. In addition, we also demonstrate how carefully designed interactive communication can avoid misinterpretation with minimum user burden.

References

[1]

I. Androutsopoulos, G. D. Ritchie, and P. Thanisch. Natural language interfaces to databases - an introduction. Natural Language Engineering, 1(1):29--81, 1995.

Crossref

Google Scholar

[2]

S. Bergamaschi, F. Guerra, M. Interlandi, R. T. Lado, and Y. Velegrakis. Quest: A keyword search system for relational data based on semantic and machine learning techniques. PVLDB, 6(12):1222--1225, 2013.

Digital Library

Google Scholar

[3]

L. Blunschi, C. Jossen, D. Kossmann, M. Mori, and K. Stockinger. Soda: Generating sql for business users. PVLDB, 5(10):932--943, 2012.

Digital Library

Google Scholar

[4]

J. Danaparamita and W. Gatterbauer. Queryviz: helping users understand sql queries and their patterns. In EDBT, pages 558--561, 2011.

Digital Library

Google Scholar

[5]

M.-C. de Marneffe, B. MacCartney, and C. D. Manning. Generating typed dependency parses from phrase structure parses. In LREC, pages 449--454, 2006.

Google Scholar

[6]

A. Kokkalis, P. Vagenas, A. Zervakis, A. Simitsis, G. Koutrika, and Y. E. Ioannidis. Logos: a system for translating queries into narratives. In SIGMOD Conference, pages 673--676, 2012.

Digital Library

Google Scholar

[7]

Y. Li, H. Yang, and H. V. Jagadish. Nalix: an interactive natural language interface for querying xml. In SIGMOD Conference, pages 900--902, 2005.

Digital Library

Google Scholar

[8]

A.-M. Popescu, O. Etzioni, and H. A. Kautz. Towards a theory of natural language interfaces to databases. In IUI, pages 149--157, 2003.

Digital Library

Google Scholar

[9]

A. Simitsis, G. Koutrika, and Y. E. Ioannidis. Précis: from unstructured keywords as queries to structured databases as answers. VLDB J., 17(1):117--149, 2008.

Digital Library

Google Scholar

[10]

S. Tata and G. M. Lohman. Sqak: doing more with keywords. In SIGMOD Conference, pages 889--902, 2008.

Digital Library

Google Scholar

[11]

D. Xin, Y. He, and V. Ganti. Keyword+: A framework to improve keyword search over entity databases. PVLDB, 3(1):711--722, 2010.

Digital Library

Google Scholar

[12]

J. X. Yu, L. Qin, and L. Chang. Keyword Search in Databases. Synthesis Lectures on Data Management. Morgan & Claypool Publishers, 2010.

Digital Library

Google Scholar

Cited By

View all

Trummer I(2024)Generating Succinct Descriptions of Database Schemata for Cost-Efficient Prompting of Large Language ModelsProceedings of the VLDB Endowment10.14778/3681954.368201717:11(3511-3523)Online publication date: 30-Aug-2024
https://doi.org/10.14778/3681954.3682017
Li BLuo YChai CLi GTang N(2024)The Dawn of Natural Language to SQL: Are We Fully Ready?Proceedings of the VLDB Endowment10.14778/3681954.368200317:11(3318-3331)Online publication date: 30-Aug-2024
https://doi.org/10.14778/3681954.3682003
Tian YKummerfeld JLi TZhang T(2024)SQLucid: Grounding Natural Language Database Queries with Interactive ExplanationsProceedings of the 37th Annual ACM Symposium on User Interface Software and Technology10.1145/3654777.3676368(1-20)Online publication date: 13-Oct-2024
https://dl.acm.org/doi/10.1145/3654777.3676368
Show More Cited By

Index Terms

NaLIR: an interactive natural language interface for querying relational databases
1. Human-centered computing
  1. Human computer interaction (HCI)
    1. Interaction paradigms
      1. Natural language interfaces

Recommendations

The determination of synonyms for fuzzy modifiers in a fuzzy database based on user community consensus
ACMSE '06: Proceedings of the 44th annual ACM Southeast Conference

A natural language interface is one that allows a database to be accessed using common language, in this case English, rather than a query language, such as SQL. A fuzzy database is one in which membership is not an absolute yes or no condition. This ...
Database Skeleton and Its Application to Fuzzy Query Translation

This paper treats the problem of fuzzy query translation using the concept of database skeleton. An imprecise, or fuzzy, query is represented by a query graph, which can be analyzed for translatability with respect to a given database skeleton. The ...
Answering imprecise database queries: a novel approach
WIDM '03: Proceedings of the 5th ACM international workshop on Web information and data management

A growing number of databases especially those published on the Web are becoming available to external users. Users of these databases are provided simple form-based query interfaces that hide the underlying schematic details. Constrained by the ...

Comments

Information & Contributors

Information

Published In

SIGMOD '14: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data

June 2014

1645 pages

ISBN:9781450323765

DOI:10.1145/2588555

General Chairs:
Curtis Dyreson
Utah State University, USA
,
Feifei Li
University of Utah, USA
,
Program Chair:
M. Tamer Özsu
University of Waterloo, Canada

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]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 18 June 2014

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Demonstration

Funding Sources

Division of Information and Intelligent Systems

Conference

SIGMOD/PODS'14

Sponsor:

SIGMOD

SIGMOD/PODS'14: International Conference on Management of Data

June 22 - 27, 2014

Utah, Snowbird, USA

Acceptance Rates

SIGMOD '14 Paper Acceptance Rate 107 of 421 submissions, 25%;

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

84
Total Citations
View Citations
1,020
Total Downloads

Downloads (Last 12 months)78
Downloads (Last 6 weeks)12

Reflects downloads up to 10 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Trummer I(2024)Generating Succinct Descriptions of Database Schemata for Cost-Efficient Prompting of Large Language ModelsProceedings of the VLDB Endowment10.14778/3681954.368201717:11(3511-3523)Online publication date: 30-Aug-2024
https://doi.org/10.14778/3681954.3682017
Li BLuo YChai CLi GTang N(2024)The Dawn of Natural Language to SQL: Are We Fully Ready?Proceedings of the VLDB Endowment10.14778/3681954.368200317:11(3318-3331)Online publication date: 30-Aug-2024
https://doi.org/10.14778/3681954.3682003
Tian YKummerfeld JLi TZhang T(2024)SQLucid: Grounding Natural Language Database Queries with Interactive ExplanationsProceedings of the 37th Annual ACM Symposium on User Interface Software and Technology10.1145/3654777.3676368(1-20)Online publication date: 13-Oct-2024
https://dl.acm.org/doi/10.1145/3654777.3676368
Giunchi DNuman NGatti ESteed A(2024)DreamCodeVR: Towards Democratizing Behavior Design in Virtual Reality with Speech-Driven Programming2024 IEEE Conference Virtual Reality and 3D User Interfaces (VR)10.1109/VR58804.2024.00078(579-589)Online publication date: 16-Mar-2024
https://doi.org/10.1109/VR58804.2024.00078
Ko MBose DWang WSeyam MBrown C(2024)Understanding the Performance of Large Language Model to Generate SQL Queries2024 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)10.1109/VL/HCC60511.2024.00048(359-361)Online publication date: 2-Sep-2024
https://doi.org/10.1109/VL/HCC60511.2024.00048
Trummer I(2024)Large Language Models: Principles and Practice2024 IEEE 40th International Conference on Data Engineering (ICDE)10.1109/ICDE60146.2024.00404(5354-5357)Online publication date: 13-May-2024
https://doi.org/10.1109/ICDE60146.2024.00404
Ren TFan YHe ZHuang RDai JHuang CJing YZhang KYang YWang X(2024)PURPLE: Making a Large Language Model a Better SQL Writer2024 IEEE 40th International Conference on Data Engineering (ICDE)10.1109/ICDE60146.2024.00009(15-28)Online publication date: 13-May-2024
https://doi.org/10.1109/ICDE60146.2024.00009
Perezhohin YPeres FCastelli M(2024)Combining computational linguistics with sentence embedding to create a zero-shot NLIDBArray10.1016/j.array.2024.10036824(100368)Online publication date: Dec-2024
https://doi.org/10.1016/j.array.2024.100368
Wang WLi JKu WWang H(2024)Multilingual spatial domain natural language interface to databasesGeoinformatica10.1007/s10707-023-00496-328:1(29-52)Online publication date: 1-Jan-2024
https://dl.acm.org/doi/10.1007/s10707-023-00496-3
Afonso AMartins Pda Silva A(2024)SEREIA: document store exploration through keywordsKnowledge and Information Systems10.1007/s10115-024-02151-166:10(6101-6132)Online publication date: 10-Jun-2024
https://doi.org/10.1007/s10115-024-02151-1
Show More Cited By

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.

Cited By

Index Terms

Recommendations

The determination of synonyms for fuzzy modifiers in a fuzzy database based on user community consensus

Database Skeleton and Its Application to Fuzzy Query Translation

Answering imprecise database queries: a novel approach