Improving the Customization of Natural Language Interface to Databases Using an Ontology

  • M. Jose A. Zarate
  • R. Rodolfo A. Pazos
  • Alexander Gelbukh
  • O. Joaquin Perez
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4705)

Abstract

Natural language interfaces to databases are considered one of the best alternatives for final users who wish to make complex, uncommon and frequent queries, which is a very common need in organizations. The use of this type of interfaces has been very limited, due to their limited publicizing and the complexity to adapt them to users’ needs, and because their precision varies widely. We propose as a solution to the problem of customizing this type of interfaces, the use of an ontology as a knowledge base whose design is simple and flexible enough to make the use and acceptance of these interfaces more accessible. This paper describes the design of the ontology, as well as a series of comparative evaluations of this approach versus the customization process of a commercial interface. This evaluation aims at assessing the acceptance of this approach by of those that will potentially customize the interface to a database, in contrast to the precision tests that are commonly applied to this type of interfaces. In spite of the difficulties found to carry out the evaluations, the results show that the use of our approach is preferred as a natural language interface customization means to the process of the most popular commercial interface. The estimations indicate that the potential people on charge of the process of customization of this type of interfaces considers that using the ontology as interface knowledge base would allow to answer a wider diversity of types of queries than those that would allow to answer a commercial interface.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Date, C.J.: An introduction to Database Systems, 7a edn. Addison Wesley Longman, Reading (2000)Google Scholar
  2. 2.
    English Language Front—end, http://www.elf-software.com/other.htm
  3. 3.
    English Language Front—end corpus, http://www.elf-software.com/FaceOff.htm
  4. 4.
    González, J.J., Pazos, B.R.A., Pérez, J.: A Domain Independent Natural Language Interface to Databases Capable of Processing Complex Queries, P.h. thesis, Cenidet, dic. (2005)Google Scholar
  5. 5.
    Inbase (last consult, June 18, 2007), http://www.inbase.artint.ru/english/default-eng.asp
  6. 6.
    Microsoft English Query documentation (last consult, June 18, 2007), http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part9/c3261.mspx
  7. 7.
    Miller, G.: Wordnet, a lexical database. Cognitive Science Laboratory, Princeton University (last consult, June 18, 2007), http://www.cogsci.princeton.edu/~wn/
  8. 8.
    Loos, E.E., Anderson, S., Day Jr., D.H., Jordan, P.C., Douglas Wingate, J. (eds.): Modular book: Glossary of linguistic terms (last consult, June 18, 2007), http://www.sil.org/linguistics/GlossaryOfLinguisticTerms/
  9. 9.
  10. 10.
    Protégé ontology editor: Stanford Medical Informatics at the Stanford University, School of Medicine (last consult, June 18, 2007), http://protege.stanford.edu/index.html
  11. 11.
    Richa, A.B.: Natural Language Interfaces: Comparing English Language Front End and English Query, Master of Science thesis, Virginia Commonwealth University, Richmond, Virginia (December 2004)Google Scholar
  12. 12.
    Sethi, V.: Natural Language Interfaces to Databases: MIS Impact, and a Survey of Their Use and Importance. Graduate School of business, Univ. Of Pittsburg, Pittsburgh, PA 15260Google Scholar
  13. 13.
    Sharoff, S.: SNOOP a system for development of linguistic processors. In: Proceedings of EWAIC93, Moscow (1993)Google Scholar
  14. 14.
    Web Ontology Language (OWL): w3c recommendation, http://www.w3.org/2004/OWL/
  15. 15.
    Woods, W.A., Schmolze, J.: The KLONE family. Computers and mathematics with applications 23, 2–5 (1993)Google Scholar
  16. 16.
    Zarate, M.J.A., Pazos, R.R.A., Gelbukh, A., Padrón, C.J.I.: A Portable Natural Language Interface for Diverse Databases Using Ontologies. In: Gelbukh, A. (ed.) CICLing 2003. LNCS, vol. 2588, Springer, Heidelberg (2003)Google Scholar
  17. 17.
    Zarate, M.J.A., Pazos, R.R.A., Toledo, R.: Acquisition of lexical-syntactic relationships from a dictionary. In: 13tth international Congress on Computer Science Research, Tlanepantla, Mexico (September 2004)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2007

Authors and Affiliations

  • M. Jose A. Zarate
    • 1
  • R. Rodolfo A. Pazos
    • 1
  • Alexander Gelbukh
    • 2
  • O. Joaquin Perez
    • 1
  1. 1.Centro Nacional de Investigación y Desarrollo Tecnológico (Cenidet) 
  2. 2.CIC-IPN, National Polytechnic Institute of Mexico 

Personalised recommendations