DocumentCode :
2224849
Title :
Study on the static analysis and the similarity comparing of SQL code
Author :
He-Biao, Yang ; Li, Chen ; Li-Fan, Yang
Author_Institution :
Sch. of CS & CE, Jiangsu Univ., Zhenjiang, China
Volume :
6
fYear :
2010
fDate :
20-22 Aug. 2010
Abstract :
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.
Keywords :
SQL; computer aided instruction; program diagnostics; source coding; DFA technology; NFA technology; SQL code; e-learning system; source code; static analysis; target code; Doped fiber amplifiers; Semantics; Software; Similarity analysis; abstract syntactic tree; lexical analysis; syntactic analysis;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Advanced Computer Theory and Engineering (ICACTE), 2010 3rd International Conference on
Conference_Location :
Chengdu
ISSN :
2154-7491
Print_ISBN :
978-1-4244-6539-2
Type :
conf
DOI :
10.1109/ICACTE.2010.5579400
Filename :
5579400
Link To Document :
بازگشت