Study on the Static Analysis and the Similarity Comparing of SQL Code

摘要：

To address the problem of assessing the SQL code automatically in an E-learning system, this paper offers a way to calculate the similarity between SQL codes using the static analysis technology. We use the regular expressions, NFA and DFA technology to analyze the code and then generate the AST of the source code and target code. Based on the ASTs created before, the method proceeds the measuring by calculating the similarity between ASTs using tree edit distance and taking this as the similarity between SQL codes.

关键词： Similarity analysis lexical analysis syntactic analysis abstract syntactic tree

作者: Yang He-Biao Chen Li Yang Li-Fan

作者单位: School of CS & CEJiangsu UniversityZhenjiang, China School of CS & CE Jiangsu University Zhenjiang, China

会议类型: 国际会议

会议名称: 2010 3rd International Conference on Advanced Computer Theory and Engineering(2010年第三届先进计算机理论与工程国际会议 ICACTE 2010)

会议地点: 成都

会议语种:英文

页码: 1-4

在线出版日期: 2010-08-20（万方平台首次上网日期，不代表论文的发表时间）