NLP Application: Natural Language Questions and SQL using Computational Linguistics

Description

Applying Natural Language Processing (NLP) concepts to help humans in their daily life, this book discusses an automatic translation of an unstructured Natural Language Question (NLQ) into a Structured Query Language (SQL) statement. Using SQL as a Relational DataBase (RDB) interaction language, database administrators or general users with little to no SQL querying abilities are provided with all the knowledge necessary to perform queries on RDBs in an interactive manner. Key Features Includes extensive and illustrative examples to simplify the discussed concepts Discusses a novel, and yet simple, approach to NLP Introduces a lightweight NLQ into SQL translation approach through the use of RDB MetaTables as a Hash table Extensive literature review and thorough background information on every tool, concept and technique applied Providing a unique approach to NLQ into SQL translation, as well as comprising disparate resources on NLP as a whole, this shortform book is of direct use to administrators and general users of databases. Cover Half Title Title Page Copyright Page Table of Contents Preface Chapter 1: Introduction Basic research framework organization Chapter 2: Background Study NLQ input processing interface, the NLIDB Interactive Form-Based Interface [ 16 ] Keyword-Based Query Interface [ 17 ] NLQ-Based Interface [ 18 ] Part Of Speech (POS) recognition Linguistic Components Layers Syntactic parser (rule-based) Semantic parser (rule-based) Lexicon Intermediate Language Representation Layer Annotator Disambiguation Matcher/Mapper SQL template generator SQL execution and result Chapter 3: Literature Review Related works NLP ML Algorithms NLQ to SQL Mapping Current research work justification Authoring Interface-Based Systems [ 131 ] Enriching the NLQ/SQL Pair Using MLA Algorithms Restricted NLQ Input [ 35 ] Lambda Calculus [ 7, 112, 114 ] Tree Kernels Models [ 29, 47, 78, 100, 126 ] Unified Modeling Language (UML) [ 34, 118 ] Weighted Links [ 81 ] Mapping NLQ tokens into RDB lexica NLQ Tokens Extraction RDB Lexica Mapping RDB Lexica Relationships NLP Syntax and Semantics Definition Mapping RDB lexica into SQL clauses SQL Clauses Mapping Complexity vs Performance SQL Formation vs SQL Templates Intermediate Representations Chapter 4: Implementation Plan NLQ input interface POS recognition Disambiguation Matcher/mapper Mapping NLQ Tokens into RDB Elements Mapping RDB Lexica into SQL Clauses SQL template generator SQL execution and result Chapter 5: Implementation User Case Scenario User case scenario Chapter 6: Implementation Testing and Performance Measurements Implementation environment and system description DataBase Implementation testing and validation Performance evaluation measurements Chapter 7: Implementation Results Discussion Implementation limitations Mapping Limitations SQL Generation Limitations General Implementation Limitations Chapter 8: Conclusion and Future Work Conclusion Future work Appendix 1 Appendix 2 Appendix 3 Appendix 4 Appendix 5 Appendix 6 Appendix 7 Appendix 8 Appendix 9 Glossary References Index