1 / 20

EASYASK NLP to SQL Translator

EASYASK NLP to SQL Translator. Aditya Khandekar Ashish Jain Kunal Dabir Praveen Awasthy. Contents. Introduction and concept Chosen platform Objective Application. Introduction & Concept. 21st century is the information age BUT some facts about our country India

theta
Download Presentation

EASYASK NLP to SQL Translator

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. EASYASKNLP to SQL Translator • Aditya Khandekar • Ashish Jain • Kunal Dabir • Praveen Awasthy

  2. Contents • Introduction and concept • Chosen platform • Objective • Application

  3. Introduction & Concept 21st century is the information age BUT • some facts about our country India • population = 100 billion • literacy rate = around 65 % • estimated no of computer users in 2003 = 23 million • use of Computers largely confined to Eng speaking population(10%) Indications • in developing countries like India, computer usage has not even attained 1/10 of ideal

  4. Why So? • Software developed at the inception of computers was cryptic • Uses were also limited, so did not appeal to the normal person THEN in the 90s, came GUI • Provided a graphical interaction between user & system BUT still, GUI was found wanting in some cases • language constraints • size of forms • information retrival-always a problem

  5. NLP & NLI Problem solved with the concept of NLP (Natural Language Processing) "Natural Language Processing (NLP) is a technology that allows computers to understand the main linguistic concepts within a question or solution. Its goal is to design and build Computers that analyze, understand and generate language that humans use naturally." Using the concept - NLP & NLIs (Natural Language Interfaces). Helpful coz: • Don’t require knowledge of technical jargon • Eliminate language problem • Work better than GUIs • Are highly modifiable • Do not require excessive typing or clicking

  6. Our Project Coming to Project :Easy Ask, an NLP based info retrieval System (translates queries from English statements to SQL) Why we chose this project: • Information the world over, stored in databases • Information retrieval by SQL, limited to tech people • By way of forms (GUI) is inefficient & rigid We hope, that our software Easy Ask can overcome these problems

  7. Platforms used No compromises • Easy-of-use versus power • Safety versus efficiency • Rigidity versus extensiblity

  8. Why Java • OS Independent • Easily Available • Resources Available • Reusable Classes Available

  9. Platform Trends in Technology .NET J2EE

  10. Backend Database • Oracle • MS SQL Server • MS Access

  11. Objective • To create a software that provides a Natural Language Interface to a database Application • Desired requirements • To make the above application as generic as possible (OS, DB) • Generate relevent results efficiently.

  12. EasyAsk Working Result English EASYASK SQL Back End Database Data

  13. Similar Work • English Query (MS SQL Server) • KDA (knowledge-based database assistant) • SQ-HAL

  14. Example

  15. Applications NLP applications • User interfaces • Knowledge acquisition • Information retrieval • Translation

  16. Applications Practical uses of our project • Railway enquiry • Banking enquiry • Online troubleshooting • Directory system

  17. Limitation • Database systems that do not comply with SQL are not supported. • The software works well only for small designs, typically having not more that 5-6 tables. • Results obtained may not be very efficient and according to user expectation. • The same errors may be repeated if error reporting is not supported.

  18. Extension • Support for large databases • Support for multiple languages (other than English) • Automatic Learning capability from previous mistakes

  19. References References • http://research.microsoft.com/nlp • http://www.csse.monash.edu.au/hons/projects/2000/Supun.Ruwanpura/

  20. Thanks

More Related