Abstract
This short paper introduces the STEP system for natural language access to relational databases. In contrast to most work in the area, STEP adopts a phrasal approach; an administrator couples phrasal patterns to elementary expressions of tuple relational calculus. This ‘phrasal lexicon’ is used bi-directionally, enabling the generation of natural language from tuple relational calculus and the inverse parsing of natural language to tuple calculus. This ability to both understand and generate natural language enables STEP to engage the user in clarification dialogs when the parse of their query is of questionable quality or is open to multiple interpretations. An on-line demonstration of STEP is accessible at http://www.cs.umu.se/~mjm/step.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Androutsopoulos, I., Ritchie, G.D.: Database interfaces. In: Dale, R., Moisl, H., Somers, H. (eds.) Handbook of Natural Language Processing, pp. 209–240. Marcel Dekker Inc., New York (2000)
Blum, A.: Microsoft english query 7.5: Automatic extraction of semantics from relational databases and OLAP cubes. In: Proc. of VLDB, pp. 247–248 (1999)
Codd, E.: Seven steps to rendezvous with the casual user. In: IFIP Working Conference Data Base Management, pp. 179–200 (1974)
Copestake, A., Sparck Jones, K.: Natural language interfaces to databases. The Natural Language Review 5(4), 225–249 (1990)
Grosz, B., Appelt, D., Martin, P., Pereira, F.: Team: An experiment in the design of transportable natural-language interfaces. AI 32(2), 173–243 (1987)
Ljungberg, J.: Paraphrasing SQL to natural language. In: Proc. of RIAO 1991, Barcelona (1991)
Lowden, B., de Roeck, A.: The REMIT system for paraphrasing relational query expressions into natural language. In: Proc. of VLDB, pp. 365–371 (1986)
May, W.: Information extraction and integration with Florid: The Mondial case study. Technical Report 131, Universität Freiburg, Institut für Informatik (1999)
Miller, G., Beckwith, R., Fellbaum, C., Gross, D., Miller, K.: Five papers on WordNet. Technical report, Princeton University, Princeton, N.J. (1993)
Minock, M.: Knowledge representation using schema tuple queries. In: Proc. of KRDB, Hamburg, Germany, pp. 51–62. IEEE Computer Society Press, Hamburg (2003)
Minock, M.: Modular generation of relational query paraphrases. Journal of Language and Computation special issue on Formal Aspects of NLG (2005) (to appear)
Minock, M.: A phrasal approach to natural language access over relational databases. Technical Report 05.09, Umeå University, Umeå, Sweden (March 2005)
Popescu, A., Etzioni, O., Kautz, H.: Towards a theory of natural language interfaces to databases. In: Intelligent User Interfaces (2003)
Thalheim, B., Kobienia, T.: Generating DB queries for web NL requests using schema information and DB content. In: Proc. of NLDB, pp. 205–209 (2001)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Minock, M. (2005). A Phrasal Approach to Natural Language Interfaces over Databases. In: Montoyo, A., Muńoz, R., Métais, E. (eds) Natural Language Processing and Information Systems. NLDB 2005. Lecture Notes in Computer Science, vol 3513. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11428817_30
Download citation
DOI: https://doi.org/10.1007/11428817_30
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-26031-8
Online ISBN: 978-3-540-32110-1
eBook Packages: Computer ScienceComputer Science (R0)