A Shallow Parsing Approach to Natural Language Queries of a Database

• 作者: Richard Skeggs Stasha Lauria
• 来源期刊: 软件工程与应用(英文)
• 学科: 工学
• 关键词: NLIDB NATURAL LANGUAGE Processing DATABASE QUERY Data MINING
• 年，卷（期）: 2019,（9）
• 页码范围: 365-382
• 页数: 18页
• 分类号: TP39

摘要

The performance and reliability of converting natural language into structured query language can be problematic in handling nuances that are prevalent in natural language. Relational databases are not designed to understand language nuance, therefore the question why we must handle nuance has to be asked. This paper is looking at an alternative solution for the conversion of a Natural Language Query into a Structured Query Language (SQL) capable of being used to search a relational database. The process uses the natural language concept, Part of Speech to identify words that can be used to identify database tables and table columns. The use of Open NLP based grammar files, as well as additional configuration files, assist in the translation from natural language to query language. Having identified which tables and which columns contain the pertinent data the next step is to create the SQL statement.