Model for estimating the complexity of physical schema for relational database

Abstract

Model for estimating the complexity of physical schema for relational database

Rybanov A. A., Sviridova O. V., Korotkova N. N., Lyasin D.N., Abramova O.F.

Incoming article date: 07.05.2019

In work area of application for quantitative metrics of databases are considered. Quality control of the database scheme is impossible without numerical indicators. Metrics of the database can be calculated it is automated that guarantees the accuracy and recurrence of such measurements. In article the model for assessment of complexity of the physical scheme for relational database based on metrics of the table of the database is offered. For the offered model by using the method of T. Saati, received coefficients which consider extent of influence of each metrics on complexity of the database. On the example of real projects for databases quantitative measurements of their metrics in MySQL are executed. The comparative analysis of the results obtained for the model of complexity estimates for various projects of physical schemes for databases and the amount of information contained in sql-scripts of these databases are described.

Keywords: evaluation of complexity, database, physical schema, model, SQL, entropy