Generation of Natural Language Queries from ER-Diagram

Authors

  • Srinivasa K  Department of Computer Science and Engineering, Siddaganga Institute of Technology, Tumakuru, Karnataka, India
  • Kavitha M  Department of Computer Science and Engineering, Siddaganga Institute of Technology, Tumakuru, Karnataka, India

Keywords:

ER-diagram, NLP, NLQ, SQL, NLU.

Abstract

The concept of object-oriented modelling makes the real world represented in some kinds of logical forms.ER-diagram is one of those logical forms, which is used in database design. Many tools are available to generate ER-diagram from natural language database requirement specifications and SQL queries from natural language queries (NLQs). Here we address the problem of generating natural language queries from ER diagram so that user efforts in typing NLQs can be reduced. The proposed method first converts the given ER-diagram to understandable format that is intermediate text or sentence form and then the NLQs are generated from the intermediate form using Natural Language Processing (NLP) techniques.

References

  1. Natural Language Statement to SQL Query Translator .Pranali P. Chaudhari      Asst. Professor, I.T. Department  MIT Academy of Engineering Alandi (D), Pune.                    
  2. Natural language queries for Information Retrieval in Structured Documents. XavierTannier, Jean-Jacques Girardot and Mihaela Mathieun...cole Nationale SupÈrieure des Mines de Saint-Etienne 158 Cours F auriel F-42023 Saint ...tienne cedex2.
  3. Generating ER Diagrams from Requirement Specifications  Based On Natural Language Processing. Eman S. Btoush and Mustafa M.  Hammad Department Of Computer Science, Mutah University, Jordan.
  4. SQL generation and execution from natural language processing. Saravjeet Kaur, Rashmeet Singh Bali, Student, MMU, Mullana.
  5. SQ-HAL: Natural language to SQL Translator, http://www.csse.monash.edu.au/hons/projects/2000/Supun.Ruwanpura/

IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology

Downloads

Published

2017-06-30

Issue

Volume 2, Issue 3, May-June-2017

Section

Research Articles

License

Copyright (c) IJSRCSEIT

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite

[1]
Srinivasa K, Kavitha M, " Generation of Natural Language Queries from ER-Diagram, IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology(IJSRCSEIT), ISSN : 2456-3307, Volume 2, Issue 3, pp.682-684, May-June-2017.