Natural Language to Structured Query.

Date of Submission

December 2020

Date of Award

Winter 12-12-2021

Institute Name (Publisher)

Indian Statistical Institute

Document Type

Master's Dissertation

Degree Name

Master of Technology

Subject Name

Computer Science

Department

Computer Vision and Pattern Recognition Unit (CVPR-Kolkata)

Supervisor

Garain, Utpal (CVPR-Kolkata; ISI)

Abstract (Summary of the Work)

Intelligent interface, to enhance efficient interactions between user and databases, is the need of many commercial applications. Oftentimes, users are not familiar with how to frame a structured query as they may not be aware of structure of the database and it is also not expected that the users are required to learn SQL or other query languages to access the database. Hence to simplify task of accessing the database, text-to-SQL models attempt to translate a user's natural language question to corresponding SQL query. Converting natural language to SQL, the model needs to have the ability to create an accurate mapping between the natural language keywords to SQL keywords along with their corresponding tables and columns. Recently, lots of generative text-to-SQL models have been developed. Some of them are using greedy search in their decoder. Hence we choose one of such model and implemented beam search on that. Apart from this we tried explore a discriminative approach for text-to-SQL generation task. A discriminative re-ranker has been proposed on the top of a generative text-to-SQL model for improvement of the accuracy by extracting the best SQL query from a set of beam search predicted candidates. We proposed a schema agnostic discriminative re-ranker built using XLNet ne-tuned classifier for calculating similarity score between natural language and predicted SQL. We used that score to re-rank the beam candidates in a perfect order.

Comments

ProQuest Collection ID: http://gateway.proquest.com/openurl?url_ver=Z39.88-2004&rft_val_fmt=info:ofi/fmt:kev:mtx:dissertation&res_dat=xri:pqm&rft_dat=xri:pqdiss:28842696

Control Number

ISI-DISS-2020-27

Creative Commons License

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

DOI

http://dspace.isical.ac.in:8080/jspui/handle/10263/7181

This document is currently not available here.

Share

COinS