A new model for measuring the complexity of SQL commands

Abstract

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.