Skip to main content
SpringerLink
Log in

Translation of Natural Language Queries to SQL that Involve Aggregate Functions, Grouping and Subqueries for a Natural Language Interface to Databases

  • Chapter
  • First Online:
Fuzzy Logic Augmentation of Neural and Optimization Algorithms: Theoretical Aspects and Real Applications

Part of the book series: Studies in Computational Intelligence ((SCI,volume 749))

  • 1259 Accesses

Abstract

Currently, huge amounts of information are stored in databases (DBs). In order to facilitate access to information to all users, natural language interfaces to databases (NLIDBs) have been developed. To this end, these interfaces translate natural language queries to a DB query language. For businesses, the main application of NLIDBs is for decision making by facilitating access to information in a flexible manner. For a NLIDB to be considered complete, it must deal with queries that involve aggregate functions: COUNT, MIN, MAX, SUM and AVG. The prototype developed at the Instituto Tecnológico de Cd. Madero (ITCM) can translate queries in natural language to SQL; however, it did not have a module for dealing with aggregate functions, grouping and subqueries. In this paper a new module of this NLIDB for dealing with aggregate functions, grouping and subqueries is described, and experimental results are presented, which show that this interface has a performance (recall) better than that of C-Phrase.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 219.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. R. Pazos, M. Aguirre, J. Gonzalez, J. Martínez, J. Pérez, A. Verástegui, Comparative study on the customization of Natural Language Interfaces to Databases. SpringerPlus 5, 553 (2016)

    Google Scholar 

  2. M. Minock, C-phrase: a system for building robust natural language interfaces to databases. Data Knowl. Eng. 69, 290–302 (2010)

    Article  Google Scholar 

  3. L. Tang, R. Mooney, Using multiple clause constructors in inductive logic programming for semantic parsing, in Proceedings of the 12th European Conference on Machine Learning, pp. 466–477 (2001)

    Google Scholar 

  4. Linguistic Data Consortium, “ATIS2”. https://catalog.ldc.upenn.edu/ LDC93S5. Accessed 2017

Download references

Author information

Authors and Affiliations

  1. Instituto Tecnológico de Ciudad Madero, Ciudad Madero, Mexico

    Rodolfo A. Pazos R., Andres A. Verastegui, José A. Martínez F. & Juana Gaspar H.

  2. Instituto Tecnológico de León, León, Mexico

    Martin Carpio

Authors
  1. Rodolfo A. Pazos R.
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Andres A. Verastegui
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. José A. Martínez F.
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Martin Carpio
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Juana Gaspar H.
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Rodolfo A. Pazos R. .

Editor information

Editors and Affiliations

  1. Division of Graduate Studies and Research, Tijuana Institute of Technology, Tijuana, Baja California, Mexico

    Oscar Castillo

  2. Division of Graduate Studies and Research , Tijuana Institute of Technology , Tijuana, Baja California, Mexico

    Patricia Melin

  3. Systems Research Institute, Polish Academy of Sciences , Warszawa, Poland

    Janusz Kacprzyk

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer International Publishing AG

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Pazos R., R.A., Verastegui, A.A., Martínez F., J.A., Carpio, M., Gaspar H., J. (2018). Translation of Natural Language Queries to SQL that Involve Aggregate Functions, Grouping and Subqueries for a Natural Language Interface to Databases. In: Castillo, O., Melin, P., Kacprzyk, J. (eds) Fuzzy Logic Augmentation of Neural and Optimization Algorithms: Theoretical Aspects and Real Applications. Studies in Computational Intelligence, vol 749. Springer, Cham. https://doi.org/10.1007/978-3-319-71008-2_31

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-71008-2_31

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-71007-5

  • Online ISBN: 978-3-319-71008-2

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation