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.
Author(s): Ftoon Kedwan
Publisher: CRC Press
Year: 2023
Language: English
Pages: 176
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
