CODEWITHSUNDEEP
pythonsqldatabasenlp
Lahari
Lahari

Reputation: 479

Natural language interface to database using python

I am working on a project related to natural language process using python. In my project, I have my database and some data related to finance and I have to create my own page and if I give a question for example what is the net income of apple? then I have to transfer my question into a query like select net_income from finance where name = apple and get the answer to my question.

I've completed tokenizing the given question and removed stop words from it. I am unable to convert the tokens and add them into the query. I am very thankful if anyone could help me by giving your ideas?

Upvotes: 0

Views: 1581

Answers (1)

Mahendra S. Chouhan
Mahendra S. Chouhan

Reputation: 545

Introduction

Natural Language Interfaces for Data Bases.

What if you could ask the question on your mind in the language of your choice and we add additional computational work within the system to automatically convert it into a SQL-like format to retrieve the results? Think of this as a hyper-intelligent ChatBot that converses with you seamlessly — without obstructing your thought flow with errors and other bugs.

Techniques for converting NL to SQL The broader category of techniques

  • Semantic parsing
  • Neural Network Models

Methods available in the literature

  • Pattern Matching Systems
  • Syntax-based Systems
  • Semantic Grammar Systems
  • Intermediate representation languages:
  • Seq2Seq models Key Challenges
  • Input request in natural language
  • Type of database
  • Parsing system to convert natural language

Libraries

References

Upvotes: 1

Related Questions