Natural language user interfaces to database systems have been studied for several decades now. They have mainly focused on parsing and interpreting natural language queries to generate them in a formal database language. We envision the reverse functionality, where the system would be able to take the internal result of that translation, say in SQL form, translate it back into natural language, and show it to the initiator of the query for verification. Likewise, information extraction has received considerable attention in the past ten years or so, identifying structured information in free text so that it may then be stored appropriately and queried. Validation of the records stored with a backward translation into text would again be very powerful. Verification and validation of query and data input of a database system correspond to just one example of the many important applications that would benefit greatly from having mature techniques for translating such database constructs into free-flowing text. The problem appears to be deceivingly simple, as there are no ambiguities or other complications in interpreting internal database elements, so initially a straightforward translation appears adequate. Reality teaches us quite the opposite, however, as the resulting text should be expressive, i.e., accurate in capturing the underlying queries or data, and effective, i.e., allowing fast and unique interpretation of them. Achieving both of these qualities is very difficult and raises several technical challenges that need to be addressed. In this paper, we first expose the reader to several situations and applications that need translation into natural language, thereby, motivating the problem. We then outline, by example, the research problems that need to be solved, separately for data translations and query translations.
[1]
Georgia Koutrika,et al.
Synthesizing structured text from logical database subsets
,
2008,
EDBT '08.
[2]
Peter Thanisch,et al.
Natural language interfaces to databases – an introduction
,
1995,
Natural Language Engineering.
[3]
Elisabeth Métais,et al.
Database Schema Design: A Perspective From Natural Language Techniques to Validation and View Integration
,
1993,
ER.
[4]
Veda C. Storey.
Understanding and Representing Relationship Semantics in Database Design
,
2000,
NLDB.
[5]
R. Cole,et al.
Survey of the State of the Art in Human Language Technology
,
2010
.
[6]
Michael Jason Minock,et al.
A Phrasal Approach to Natural Language Interfaces over Databases
,
2005,
NLDB.
[7]
Eriks Sneiders,et al.
Automated Question Answering Using Question Templates That Cover the Conceptual Model of the Database
,
2002,
NLDB.
[8]
Georgia Koutrika,et al.
Comprehensible Answers to Précis Queries
,
2006,
CAiSE.
[9]
Veda C. Storey,et al.
Naive Semantics to Support Automated Database Design
,
2002,
IEEE Trans. Knowl. Data Eng..
[10]
Yannis E. Ioannidis.
From Databases to Natural Language: The Unusual Direction
,
2008,
NLDB.