Skip to main content
SpringerLink
Log in

An Approach for Developing Natural Language Interface to Databases Using Data Synonyms Tree and Syntax State Table

  • Conference paper
  • First Online:
Innovations in Computing Sciences and Software Engineering

  • 1213 Accesses

Abstract

The basic idea addressed in this research is developing a generic, dynamic, and domain independent natural language interface to databases. The approach consists of two phases; configuration phase and operation phase. The former builds data synonyms tree based on the database being implemented. The idea behind this tree is matching the natural language words with database elements. The tree hierarchy contains the database tables, attributes, attribute descriptions, and all possible synonyms for each description. The latter phase contains a technique that implements syntax state table to extract the SQL components from the natural language user request. As a result the corresponding SQL statement is generated without interference of human experts.

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 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

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Lappoon R. Tang, “Using Machine Learning Approach for Building Natural Language Interface for Databases,” journal of Computer Science, Information & Electrical Engineering, volume 2, Issue 1, 2008.

    Google Scholar 

  2. I. Androutsopoulos, G.D. Ritchie, and P.Thanisch, "Natural Language Interfaces to Databases – An Introduction", Journal of Natural Language Engineering, v. 1(1), Cambridge University Press, pp. 29-81, 1995.

    Article  Google Scholar 

  3. M. Samsonova, A. Pisarev, and m. Blagov, “ Processing of natural language queries to relational database,” BIOINFORMATICS, Oxford University press, Vol. 1, Suppl. 1, pp i241-i249, 2003.

    Article  Google Scholar 

  4. N. Omar, "Heuristics-based Entity-Relationship modeling through Natural Language Processing," PhD Thesis, University of Ulster, 2004.

    Google Scholar 

  5. A. Mitrovic, "A Knowledge-Based Teaching System for SQL," International Journal of Artificial Intelligence in Education, IOS Press,171-195, 13 (2003).

    Google Scholar 

  6. A. Yates, O. Etzioni, D. Weld, "A Reliable Natural Language Interface to Household Appliances,"Proceedings of the 8 th international conference on intelligent user interfaces, IUI'03, Miami, Florida, USA , ACM, 2003, January 12-15,2003.

    Google Scholar 

  7. http://rovshan876.narod.ru/synonyms.html

  8. Introduction to Languages and the Theory of Computation, John Martin , McGraw-Hill ,2002.

    Google Scholar 

  9. E. Terenzi, and B. Di Eugenio “Building lexical semantic representation for Natural Language instructions,” North American Chapter of the Association for Computational Linguistics on Human Language Technology: companion volume of the Proceedings of HLT-NAACL 2003–short papers - Volume 2, Edmonton, Canada ,Pages: 100 - 102  , 2003

    Google Scholar 

Download references

Acknowledgment

Thanks go to deanship of College of Applied Studies at University of Bahrain for their support to this work.

Author information

Authors and Affiliations

  1. University of Bahrain, Applied Studies College, Sakhir, Bahrain

    Safwan shatnawi & Rajeh Khamis

Authors
  1. Safwan shatnawi
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Rajeh Khamis
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Safwan shatnawi .

Editor information

Editors and Affiliations

  1. School of Engineering, University of Bridgeport, University Avenue 221, Bridgeport, 06604, USA

    Tarek Sobh

  2. School of Engineering, University of Bridgeport, University Avenue 221, Bridgeport, 06604, USA

    Khaled Elleithy

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Springer Science+Business Media B.V.

About this paper

Cite this paper

shatnawi, S., Khamis, R. (2010). An Approach for Developing Natural Language Interface to Databases Using Data Synonyms Tree and Syntax State Table. In: Sobh, T., Elleithy, K. (eds) Innovations in Computing Sciences and Software Engineering. Springer, Dordrecht. https://doi.org/10.1007/978-90-481-9112-3_87

Download citation

  • DOI: https://doi.org/10.1007/978-90-481-9112-3_87

  • Published:

  • Publisher Name: Springer, Dordrecht

  • Print ISBN: 978-90-481-9111-6

  • Online ISBN: 978-90-481-9112-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation