Affiliation:
1. Univ. of Michigan, Ann Arbor
Abstract
Natural language has been the holy grail of query interface designers, but has generally been considered too hard to work with, except in limited specific circumstances. In this paper, we describe the architecture of an interactive natural language query interface for relational databases. Through a carefully limited interaction with the user, we are able to correctly interpret complex natural language queries, in a generic manner across a range of domains. By these means, a logically complex English language sentence is correctly translated into a SQL query, which may include aggregation, nesting, and various types of joins, among other things, and can be evaluated against an RDBMS. We have constructed a system, NaLIR (Natural Language Interface for Relational databases), embodying these ideas. Our experimental assessment, through user studies, demonstrates that NaLIR is good enough to be usable in practice: even naive users are able to specify quite complex ad-hoc queries.
Subject
General Earth and Planetary Sciences,Water Science and Technology,Geography, Planning and Development
Cited by
183 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献
1. Continuous and Interactive Language Learning and Grounding;Synthesis Lectures on Human Language Technologies;2024
2. Text to Data;Natural Language Interfaces to Databases;2023-11-25
3. Building an NLIDB: The Basics;Natural Language Interfaces to Databases;2023-11-25
4. On the Vulnerabilities of Text-to-SQL Models;2023 IEEE 34th International Symposium on Software Reliability Engineering (ISSRE);2023-10-09
5. TUR2SQL: A Cross-Domain Turkish Dataset For Text-to-SQL;2023 8th International Conference on Computer Science and Engineering (UBMK);2023-09-13