TY - GEN
T1 - A new model for measuring the complexity of SQL commands
AU - Subali, Made Agus Putra
AU - Rochimah, Siti
N1 - Publisher Copyright:
© 2018 IEEE.
PY - 2018/11/13
Y1 - 2018/11/13
N2 - Software that uses database system has different complexity with software without database system, therefore required model that can pay attention to attribute or parameter in software with the database system. In this study, we propose a new model for measuring software complexity by taking into account the SQL query attributes in the database system. The model is divided into five stages, among others: Reading program module, forming SQL query model, giving SQL query weight, calculating SQL complexity, and module complexity result. The results of a series of tests performed, showing the accuracy value in accordance with the assessment made by the expert. Based on the test results, the proposed model can be applied to measure the complexity of SQL queries.
AB - Software that uses database system has different complexity with software without database system, therefore required model that can pay attention to attribute or parameter in software with the database system. In this study, we propose a new model for measuring software complexity by taking into account the SQL query attributes in the database system. The model is divided into five stages, among others: Reading program module, forming SQL query model, giving SQL query weight, calculating SQL complexity, and module complexity result. The results of a series of tests performed, showing the accuracy value in accordance with the assessment made by the expert. Based on the test results, the proposed model can be applied to measure the complexity of SQL queries.
KW - SQL complexity measurement
KW - SQL query
UR - http://www.scopus.com/inward/record.url?scp=85058395080&partnerID=8YFLogxK
U2 - 10.1109/ICITEED.2018.8534782
DO - 10.1109/ICITEED.2018.8534782
M3 - Conference contribution
AN - SCOPUS:85058395080
T3 - Proceedings of 2018 10th International Conference on Information Technology and Electrical Engineering: Smart Technology for Better Society, ICITEE 2018
SP - 1
EP - 5
BT - Proceedings of 2018 10th International Conference on Information Technology and Electrical Engineering
PB - Institute of Electrical and Electronics Engineers Inc.
T2 - 10th International Conference on Information Technology and Electrical Engineering, ICITEE 2018
Y2 - 24 July 2018 through 26 July 2018
ER -