Analyzing and Measuring the Task Complexity of Coding SQL Statements
碩士 === 中華大學 === 資訊管理學系碩士班 === 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...
Main Authors: | , |
---|---|
Other Authors: | |
Format: | Others |
Language: | zh-TW |
Published: |
2011
|
Online Access: | http://ndltd.ncl.edu.tw/handle/11978051936034598686 |
id |
ndltd-TW-099CHPI5396047 |
---|---|
record_format |
oai_dc |
spelling |
ndltd-TW-099CHPI53960472015-10-13T20:22:59Z http://ndltd.ncl.edu.tw/handle/11978051936034598686 Analyzing and Measuring the Task Complexity of Coding SQL Statements 分析與衡量結構化查詢語言敘述的任務複雜度 Chun-Wei Hsu 許峻維 碩士 中華大學 資訊管理學系碩士班 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. Chi-Chung Lee 李之中 2011 學位論文 ; thesis 76 zh-TW |
collection |
NDLTD |
language |
zh-TW |
format |
Others
|
sources |
NDLTD |
description |
碩士 === 中華大學 === 資訊管理學系碩士班 === 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.
|
author2 |
Chi-Chung Lee |
author_facet |
Chi-Chung Lee Chun-Wei Hsu 許峻維 |
author |
Chun-Wei Hsu 許峻維 |
spellingShingle |
Chun-Wei Hsu 許峻維 Analyzing and Measuring the Task Complexity of Coding SQL Statements |
author_sort |
Chun-Wei Hsu |
title |
Analyzing and Measuring the Task Complexity of Coding SQL Statements |
title_short |
Analyzing and Measuring the Task Complexity of Coding SQL Statements |
title_full |
Analyzing and Measuring the Task Complexity of Coding SQL Statements |
title_fullStr |
Analyzing and Measuring the Task Complexity of Coding SQL Statements |
title_full_unstemmed |
Analyzing and Measuring the Task Complexity of Coding SQL Statements |
title_sort |
analyzing and measuring the task complexity of coding sql statements |
publishDate |
2011 |
url |
http://ndltd.ncl.edu.tw/handle/11978051936034598686 |
work_keys_str_mv |
AT chunweihsu analyzingandmeasuringthetaskcomplexityofcodingsqlstatements AT xǔjùnwéi analyzingandmeasuringthetaskcomplexityofcodingsqlstatements AT chunweihsu fēnxīyǔhéngliàngjiégòuhuàcháxúnyǔyánxùshùderènwùfùzádù AT xǔjùnwéi fēnxīyǔhéngliàngjiégòuhuàcháxúnyǔyánxùshùderènwùfùzádù |
_version_ |
1718046390972579840 |