Abstract
Most natural language database interfaces suffer from the translation knowledge portability problem, and are vulnerable to ill-formed questions because of their deep analysis. To alleviate those problems, this paper proposes a lightweight approach to natural language interfaces, where translation knowledge is semi-automatically acquired and user questions are only syntactically analyzed. For the acquisition of translation knowledge, first, a target database is reverse-engineered into a physical database schema on which domain experts annotate linguistic descriptions to produce a pER (physically-derived Entity-Relationship) schema. Next, from the pER schema, initial translation knowledge is automatically extracted. Then, it is extended with synonyms from lexical databases. In the stage of question answering, this semi-automatically constructed translation knowledge is then used to resolve translation ambiguities.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Androutsopoulos, I.: Interfacing a Natural Language Front-End to Relational Database. Master’s thesis, Technical Report 11, Department of Artificial Intelligence, University of Edinburgh (1993)
Androutsopoulos, I., Ritchie, G.D., Thanisch, P.: Natural Language Interfaces to Databases – An Introduction. Natural Language Engineering 1(1), 29–81 (1995)
Ballard, B.W., Lusth, J.C., Tinkham, N.L.: LDC-1: A Transportable, Knowledge- Based Natural Language Processor for Office Environments. ACM Transactions on Office Information Systems 2(1), 1–25 (1984)
Damerau, F.: Problems and Some Solutions in Customization of Natural Language Database Front Ends. ACM Transactions on Office Information Systems 3(2), 165–184 (1985)
Grosz, B.J., Appelt, D.E., Martin, P.A., Pereira, F.C.N.: TEAM: An Experiment in the Design of Transportable Natural-Language Interfaces. Artificial Intelligence 32(2), 173–243 (1987)
Hendrix, G.G., Sacerdoti, D., Sagalowicz, D., Slocum, J.: Developing a Natural Language Interface to Complex Data. ACM Transactions on Database Systems 3(2), 105–147 (1978)
Kang, I.S., Bae, J.H., Lee, J.H.: Natural Language Database Access using Semi- Automatically Constructed Translation Knowledge. In: Proceedings of the 1st International Joint Conference on Natural Language Processing, Hainan, China, pp. 512–519 (2004)
Lee, H.D., Park, J.C.: Interpretation of Natural language Queries for Relational Database Access with Combinatory Categorial Grammar. International Journal of Computer Processing of Oriental Languages 15(3), 281–304 (2002)
Meng, F., Chu, W.W.: Database Query Formation from Natural Language using Semantic Modeling and Statistical Keyword Meaning Disambiguation. Technical Report, CSD-TR 990003,University of California, Los Angeles (1999)
Miller, G.A., Beckwith, R., Fellbaum, C., Gross, D., Miller, K.: Five Papers on WordNet. Special Issue of International Journal of Lexicography 3(4), 235–312 (1990)
Schutze, H.: Context Space. In: Schutze, H. (ed.) Working Notes of AAAI Fall Symposium on Probabilistic Approaches to Natural Language, Cambridge, MA, pp. 113–120 (1992)
Templeton, M., Burger, J.: Problems in Natural Language Interface to DBMS with Examples with EUFID. In: Proceeding of the 1st Conference on Applied Natural Language Processing, Santa Monica, California, pp. 3–16 (1983)
Waltz, D.L.: An English Language Question Answering System for a Large Relational Database. Communications of the ACM 21(7), 526–539 (1978)
Warren, D., Pereira, F.: An Efficient Easily Adaptable System for Interpreting Natural Language Queries. Computational Linguistics 8(3-4), 110–122 (1982)
Zhang, G., Chu, W.W., Meng, F., Kong, G.: Query Formulation from High-level Concepts for Relational Databases. In: Proceedings of the 1st International Workshop on User Interfaces to Data Intensive Systems, Edinburgh, Scotland, pp. 64–75 (1999)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kang, IS., Na, SH., Lee, JH., Yang, G. (2004). Lightweight Natural Language Database Interfaces. In: Meziane, F., Métais, E. (eds) Natural Language Processing and Information Systems. NLDB 2004. Lecture Notes in Computer Science, vol 3136. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-27779-8_7
Download citation
DOI: https://doi.org/10.1007/978-3-540-27779-8_7
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-22564-5
Online ISBN: 978-3-540-27779-8
eBook Packages: Springer Book Archive