Generation of Natural Language Queries from ER-Diagram

Authors(2) :-Srinivasa K, Kavitha M

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.

Authors and Affiliations

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

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

  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/

Publication Details

Published in : Volume 2 | Issue 3 | May-June 2017
Date of Publication : 2017-06-30
License:  This work is licensed under a Creative Commons Attribution 4.0 International License.
Page(s) : 682-684
Manuscript Number : CSEIT1723224
Publisher : Technoscience Academy

ISSN : 2456-3307

Cite This Article :

Srinivasa K, Kavitha M, "Generation of Natural Language Queries from ER-Diagram", International 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.
Journal URL : http://ijsrcseit.com/CSEIT1723224

Article Preview

Follow Us

Contact Us