Название: NLP Application: Natural Language Questions and SQL using Computational Linguistics
Автор: Ftoon Kedwan
Издательство: CRC Press
Год: 2024
Страниц: 176
Язык: английский
Формат: pdf (true)
Размер: 10.1 MB

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.

This book applies Natural Language Processing (NLP) concepts to help humans in their daily life. It discusses an automatic translation of an unstructured Natural Language Question (NLQ) into a Structured Query Language (SQL) statement. SQL is used as a Relational DataBase (RDB) interaction language with special query syntax and a computer-executable artificial language. This way, DataBase (DB) administrators or general users with little or no SQL querying abilities can perform queries on RDBs in an interactive manner. The Human–Computer Interaction (HCI) happens using users’ NLQs, which is in English in the proposed research. Users do not need to know any RDB schema elements or structures such as tables’ names, relationships, formats, attributes, or data types. The RDB schema is a brief description of the RDB elements’ organization, excluding any RDB values. In this work, a lightweight NLQ into SQL translation approach is implemented by utilizing an RDB MetaTable as a Hash table. The main goal is to exploit a manually written rule-based mapping constraints algorithm.

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.