Analyzing and Measuring the Task Complexity of Coding SQL Statements

• Main Authors: Chun-Wei Hsu, 許峻維
• Other Authors: Chi-Chung Lee
• Format: Others
• Language: zh-TW
• Published: 2011
• Online Access: http://ndltd.ncl.edu.tw/handle/11978051936034598686

碩士 === 中華大學 === 資訊管理學系碩士班 === 99 === Nowadays, businesses store their operational data in the database and therefore the SQL statement coding has been became a critical task for of database application system developers. To evaluate the performance of the developers, the issue of measuring the task complexity of coding SQL statements is necessary to be raised. However, little work has been done on this issue. Only two methods, that is, Halstead method and operator weight method, had been proposed to measure the task complexity of coding the SQL statement. Unfortunately, the measured task complexities of coding SQL statements on the use of Halstead method and operator weight method are not consistent with that of developers actually performed. For the reason, this study proposed a method which its measured task complexities were consistent with those of the developers actually performed and called the proposed method the enhanced Halstead method. To evaluate the performance of the proposed method, the experiments were performed to compare the effectiveness among the enhanced Halstead, the Halstead, and the operator weight methods in terms of the order degree. The results showed that the proposed method, i.e. the enhanced Halstead method, obtained the largest order degree. This conformed that the measured task complexity of coding SQL statements on the use of the enhanced Halstead method was closer to the task complexity of the developers actually performed than those on the use of the Halstead, and the operator weight methods. This study thus concludes that the enhanced Halstead method is able to measure the task complexity of coding the SQL statements effectively.