The Research of Automatic Transforming The Chinese Natural Language Queries into SQL

• Main Authors: Lyu Chun-Yen, 呂俊彥
• Other Authors: Yang Yen-Ju
• Format: Others
• Language: zh-TW
• Published: 2003
• Online Access: http://ndltd.ncl.edu.tw/handle/38272041146687629576

碩士 === 大同大學 === 資訊經營研究所 === 91 === Abstract This paper aims at transforming Chinese natural language queries into SQL commands to provide an intelligent query system with a human-machine dialogue interface. The system is composed of three modules: Chinese keywords fuzzy extraction, semantic analysis, and SQL transformation. The first module is based on LCS (longest common subsequence algorithm) that supports fuzzy matching. The second module decides semantic frames from semantic lexicon, which is generated from a database beforehand. Finally, rules are used to convert the semantic frames into SQL. In the end, we have achieved initial experimental results to supply a flexible, convenient and efficient method for users to query actual data they want from database.