Automating MySQL Database Complexity Estimation Based on Quantitative Metrics
| Autor: | Pavel Bezkorovaynyi, Alexey Shikov, Igor Kotsyuba, Julia Silko |
|---|---|
| Rok vydání: | 2021 |
| Předmět: |
Scheme (programming language)
Database Basis (linear algebra) business.industry Computer science media_common.quotation_subject Software package computer.software_genre Software Complexity estimation Quality (business) Database manager Metric (unit) business computer computer.programming_language media_common |
| Zdroj: | XIV International Scientific Conference “INTERAGROMASH 2021" ISBN: 9783030816186 |
| Popis: | The article examines the problems of automating assessment of the level of database complexity using quantitative metrics based on the developed application. The main approaches and methods of researching the quality of databases are analyzed. An algorithm for assessing the complexity of a physical database scheme based on metric characteristics: the number of tables, keys, attributes, is presented. As a result of the best solutions review, several directions in the development of software for analyzing database metrics were identified. The necessity of creating a program with the ability to customize the weight coefficients using a matrix of paired comparisons is substantiated, which allows one to get rid of subjectivity and adjust the calculation of the assessment for specific tasks. The main functionality of the developed application, settings and management of the database complexity level estimation are described. A distinctive feature of the developed software package is automatic connection to MySQL, analysis of additional metric characteristics that are absent in similar solutions, calculation of the resulting estimate using matrices of paired comparisons. Integration with other database management systems, the creation of a database manager, which enables to load a dump through the program and delete unnecessary databases, is considered as prospects for the development of the presented approach to automating the assessment of the databases complexity; as well as the introduction of statistics calculation, on the basis of which to create a statistical setting of the coefficients. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|