Estimating the costs of refactoring the database of the information system that is being operated

Abstract

The object of research is the decision-making work on the expediency of refactoring the database of the information system that is being operated. It was determined that the main recommendations for the formation and adoption of such decisions are based on the use of the intuition and experience of the person making the decision. Modern research in the field of database refactoring is mainly devoted to the analysis and improvement of applied refactoring techniques. The problem of determining the expediency of database refactoring and, in particular, determining the possibility of refactoring in the conditions of the current limitations of the IT project remains practically unsolved. Therefore, conducting research to solve this problem is relevant from a theoretical and applied point of view. The COCOMO II model was chosen as the basis of the cost estimation model. The specifics of using these models when calculating labor costs for IT projects of modification or development of software systems are determined. Basic SQL commands that are most often used during database refactoring are installed. Models for estimating the number of lines of source code of each of these SQL commands have been developed. The model for estimating the number of lines of source code for an IT project of system modification or development has been improved, a special case of which is proposed to be database refactoring. Experimental verification of the obtained scientific results was carried out. The database of the information and accounting system of the organization, which performs the functions of an Internet provider, was selected for such verification. For this system, two requests for changes were formulated for which the database should be refactored. The sequence of actions for estimating labor costs and time spent on database refactoring based on specified change requests is described. The obtained evaluation results allow to make a decision about the possibility of refactoring the database of the information and accounting system.