Advertisement

Semantic Model for Improving the Performance of Natural Language Interfaces to Databases

  • Rodolfo A. Pazos R.
  • Juan J. González B.
  • Marco A. Aguirre L.
Part of the Lecture Notes in Computer Science book series (LNCS, volume 7094)

Abstract

Despite the fact that since the late 60s many Natural Language Interfaces to Databases (NLIDBs) have been developed, up to now many problems continue, which prevent the translation process from natural language to SQL to be totally successful. Some of the main problems that have been encountered relate to 1) achieving domain independence, 2) the use of words or phrases of different syntactic categories for referring to tables and columns, and 3) semantic ellipsis. This paper introduces a new method for modeling databases that includes relevant information for improving the performance of NLIDBs. This method will be useful for solving many problems found in the translation from natural language to SQL, using a database model that contains linguistic information that provides more semantic information than that found in conventional database models (such as the extended entity-relationship model) and those used in previous NLIDBs.

Keywords

Natural Language Interfaces to Databases semantic modeling 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Cimiano, P., Haase, P., Heizmann, J.: Porting Natural Language Interfaces Between Domains: an Experimental User Study with the ORAKEL System. In: Proc. 12th International Conference on Intelligent User Interfaces, Honolulu, Hawaii, USA, pp. 180–190 (2007)Google Scholar
  2. 2.
    BBC News. Bill Gates Says: Mouse is Out, Touch Screen and Natural Language Interface Are In, http://news.bbc.co.uk/player/nol/newsid_7170000/newsid_7174300/7174330.stm?bw=bb&mp=wm&asb=1&news=1&bbcws=1
  3. 3.
  4. 4.
    DARPA Air Travel Information System (ATIS0), http://www.ldc.upenn.edu/Catalog/readme_files/atis/sdtd/trn_prmp.html
  5. 5.
    Pazos R., R.A., Pérez O., J., González B., J.J., Gelbukh, A., Sidorov, G., Rodríguez M., M.J.: A Domain Independent Natural Language Interface to Databases Capable of Processing Complex Queries. In: Gelbukh, A., de Albornoz, Á., Terashima-Marín, H. (eds.) MICAI 2005. LNCS (LNAI), vol. 3789, pp. 833–842. Springer, Heidelberg (2005)Google Scholar
  6. 6.
    Pazos R., R.A., Rojas P., J.C., Santaolaya S., R., Martínez F., J.A., Gonzalez B., J.J.: Dialogue Manager for a NLIDB for Solving the Semantic Ellipsis Problem in Query Formulation. In: Setchi, R., Jordanov, I., Howlett, R.J., Jain, L.C. (eds.) KES 2010. LNCS (LNAI), vol. 6277, pp. 203–213. Springer, Heidelberg (2010)CrossRefGoogle Scholar
  7. 7.
    Zhang, G., Chu, W.W., Meng, F., Kong, G.: Query Formulation from High-Level Concepts for Relational Databases. In: Proc. User Interfaces to Data Intensive Systems, pp. 64–74 (1999)Google Scholar
  8. 8.
    Stratica, N.: Using Semantic Templates for a Natural Language Interface to the CINDI Virtual Library. Data & Knowledge Engineering 55, 4–19 (2005)CrossRefGoogle Scholar
  9. 9.
    Hallett, C.: Generic Querying of Relational Databases using Natural Language Generation Techniques. In: Proc. INLG 2006, Nottingham, United Kingdom, pp. 88–95 (2006)Google Scholar
  10. 10.
    Minock, M., Olofsson, P., Näslund, A.: Towards Building Robust Natural Language Interfaces to Databases. In: Kapetanios, E., Sugumaran, V., Spiliopoulou, M. (eds.) NLDB 2008. LNCS, vol. 5039, pp. 187–198. Springer, Heidelberg (2008)CrossRefGoogle Scholar
  11. 11.
    Giordani, A., Moschitti, A.: Semantic Mapping between Natural Language Questions and SQL Queries via Syntactic Pairing. In: Horacek, H., Métais, E., Muñoz, R., Wolska, M. (eds.) NLDB 2009. LNCS, vol. 5723, pp. 207–221. Springer, Heidelberg (2010)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Rodolfo A. Pazos R.
    • 1
  • Juan J. González B.
    • 1
  • Marco A. Aguirre L.
    • 1
  1. 1.Instituto Tecnológico de Ciudad MaderoMexico

Personalised recommendations