Transforming Method for Natural Language to SQL Code
Chen Li · Jisuanji gongcheng · 2011
To solve the problem of generate SQL code automatically in an intelligent study system,this paper proposes a method to transform natural language to SQL code.This paper builds a dictionary as the base of scanning and comprehension of natural language,uses the improved word collecting technique to distinguish the words and build a semantic dependency-tree,uses the set-block technology to separate the tree to several set blocks,and scans the set blocks and generate the SQL code.Experimental results show that this method simple and effective.