Abstract
Natural language (NL) accessto databases is a problem that has interested researchers for many years. We demonstrate that an ontology-based approach is technically feasible to handle some of the challenges facing NL query processing for database access. This paper presents the architecture, algorithms and results from the prototype thereof which indicate a domain and language independent architecture with high precision and recall rates. Studies are conducted for each of English and Swahili queries, both for same language and cross-lingual retrieval, from which we demonstrate promising precision and recall rates, language and domain independence, and that for language pairs it is sufficient to incorporate a machine translation system at the gazetteer level.
This Research was made possible by Foreign Affairs and International Trade Canada (DFAIT) funding through the Canadian Commonwealth Scholarship Program. It was also supported by a Discovery Grant from the Natural Sciences and Engineering Research Council of Canada.
Chapter PDF
Similar content being viewed by others
References
Bird, C., Loper, E., Klein, E.: NLP with Python-Analyzing Text with the Natural Language Toolkit. O’Reilly Media Inc. (2009)
Bond, T.: The Reasoning Process (2011), ICT New Zealand: http://ictnz.com/ThinkingPages/reasoning.htm (retrieved 2011)
Bootra, R.: NLI: Comparing English Language Front End and English Query. Master’s Thesis, Virginia Common Wealth University, USA (2004)
Damljanovic, D., Agatonovic, M., Cunningham, H.: NLI to Ontologies: Combining Syntactic Analysis and Ontology-based Lookup through the User Interaction. In: Aroyo, L., Antoniou, G., Hyvönen, E., ten Teije, A., Stuckenschmidt, H., Cabral, L., Tudorache, T. (eds.) ESWC 2010, Part I. LNCS, vol. 6088, pp. 106–120. Springer, Heidelberg (2010)
Dittenbach, M., Dieter, M., Helmut, B.: A NL Query Interface for Tourism Information. In: ENTER, 10th Int. Conference on IT in Tourism, pp. 152–162 (2003)
Poon, H., Domingos, P.: Unsupervised Semantic Parsing. In: EMNLP, Singapore, pp. 1–10 (2009)
Kaufmann, E., Bernstein, A., Zumstein, R.: Querix: A NLInterface to Query Ontologies based on Clarification Dialogues. In: International Semantic Web Conference (ISW 2006), Athens, Georgia-USA (2006)
Giordani, A., Moschitti, A.: Corpora for Automatically Learning to Map Natural Language Questions into SQL Queries. In: Proceedings of the 7th International Conference on Language Resources and Evaluation (LREC 2010), Valletta, Malta, pp. 2336–2339 (2010)
Kaufmann, E., Berstein, A., Fischer, L.: NLP-Reduce: A “naive” but Domain Independent NL Interface for Querying Ontologies. In: 4th European Semantic Web Conference (ESW 2007), Innsbruck, Austria (2007)
Levett-Jones and Project Team. Clinical Reasoning (2009), Instructor Resources (retrieved 2011)
Mooney, R.J.: Learning for Semantic Parsing. In: Gelbukh, A. (ed.) CICLing 2007. LNCS, vol. 4394, pp. 311–324. Springer, Heidelberg (2007)
Muchemi, L.: Towards Full Comprehension of Swahili NL for Database Querying. In: Strengthening the Role of ICT in Development, pp. 50–58. Fountain Publishers, Kampala-Uganda (2008)
Paice, C.: Another Stemmer. ACM SIGIR, 56–61 (1990)
Popescu, A., Etzioni, O., Kautz, H.: Towards a Theory of Natural Language Interfaces to Databases. In: 2003 International Conference on Intelligent User Interfaces, pp. 149–157 (2003)
Ran, A., Lencevicius, R.: Natural Language Query System for RDF Repositories (2012), http://alumni.cs.ucsb.edu/~raimisl/SNLP.camera.pdf (retrieved March 12, 2012)
Shin, D.-G., Chu, L.-Y.: Establishing Logical Connectivity between Query Key Words and Database Contents. In: Mercer, R.E. (ed.) Canadian AI 1998. LNCS, vol. 1418, pp. 45–59. Springer, Heidelberg (1998)
Tablan, V., Damljanovic, D., Bontcheva, K.: A Natural Language Query Interface Structured Information. In: Bechhofer, S., Hauswirth, M., Hoffmann, J., Koubarakis, M. (eds.) ESWC 2008. LNCS, vol. 5021, pp. 361–375. Springer, Heidelberg (2008)
Lopez, V., Pasin, M., Motta, E.: AquaLog: An Ontology-Portable Question Answering System for the Semantic Web. In: Gómez-Pérez, A., Euzenat, J. (eds.) ESWC 2005. LNCS, vol. 3532, pp. 546–562. Springer, Heidelberg (2005)
Zettlemoyer, L., Collins, M.: Learning to Map Sentencies to Logical Form. In: Twenty First Conference on Uncertainty in Artificial Intelligence, pp. 658–666. AUAI Press, Edinburgh (2005)
Muchemi, L.: NL Access to Relational Databases: An Ontology Concept Mapping (OCM) Approach.Nairobi, Kenya: Unpublished PhD Doctoral Thesis, University of Nairobi (2012)
Minock, M., Olofsson, P., Näslund, A.: Towards Building Robust NL Interfaces to Databases. In: Kapetanios, E., Sugumaran, V., Spiliopoulou, M. (eds.) NLDB 2008. LNCS, vol. 5039, pp. 187–198. Springer, Heidelberg (2008)
Ge, R., Mooney, R.: A statistical Semantic Parser that Integrates Syntax and Semantics. In: CoNLL0-2005, pp. 9–16. Ann Arbor, Miami (2005)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Muchemi, L., Popowich, F. (2013). An Ontology-Based Architecture for Natural Language Access to Relational Databases. In: Stephanidis, C., Antona, M. (eds) Universal Access in Human-Computer Interaction. Design Methods, Tools, and Interaction Techniques for eInclusion. UAHCI 2013. Lecture Notes in Computer Science, vol 8009. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-39188-0_53
Download citation
DOI: https://doi.org/10.1007/978-3-642-39188-0_53
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-39187-3
Online ISBN: 978-3-642-39188-0
eBook Packages: Computer ScienceComputer Science (R0)