Analysis of software for building relational database models

Authors: Simonov M.F., Korostelev V.M., Guzilov A.V.
Published in issue: #4(45)/2020
DOI: 10.18698/2541-8009-2020-4-595
Category: Informatics, Computer Engineering and Control | Chapter: System Analysis, Control, and Information Processing, Statistics
Keywords: software design, CASE-tool, quality assessment, quality metric, software tool, relational database, data model, notation IDEF1X
Published: 21.04.2020

The purpose of the work is the rationale for choosing a CASE-tool for designing a database model for a specific project. The relevance of the study is due to the large number of software tools in the software market, which creates the problem of choosing a CASE-tool for a particular project. The analysis is carried out of software tools for the design and construction of relational database models in the IDEF1X notation (the “entity-relationship” model) presented on the Russian market. During the study, for each of the selected CASE-tools for analysis, the procedures were performed for installing and building test database models. Based on the conducted experiments, a brief review of CASE-tools was made with a description of their main functional characteristics, advantages and disadvantages. A quality metric based on the results of experiments was developed for a comprehensive quality assessment and justification of CASE-tools choice. The developed quality metric is presented, as well as the results of a comprehensive quality assessment and classification of software tools. Based on results analysis, recommendations are given on the selection of CASE-tools for a specific software project.

References

[1] ISO/IEC 14882: 2017 International standard. Programming language C++.

[2] Odintsov I.O. Professional’noe programmirovanie. Sistemnyy podkhod [Professional programming. System approach]. Sankt-Petersburg, BKhV-Peterburg Publ., 2004 (in Russ.).

[3] DBDesigner: website. URL: https://www.dbdesigner.net (accessed: 23.10.2019).

[4] MySQL workbench. mysql.com: website. URL: https://www.mysql.com/products/workbench (accessed: 23.10.2019).

[5] GenMyModel: website. URL: https://www.genmymodel.com/rds (accessed: 23.10.2019).

[6] Free Valentina Studio features & benefits at a glance. valentina-db.com: website. URL: https://www.valentina-db.com/ru/valentina-studio-overview (accessed: 23.10.2019).

[7] WWW SQL Designer. github.com: website. URL: https://github.com/ondras/wwwsqldesigner/wiki (accessed: 23.10.2019).

[8] Visual Paradigm: website. URL: https://www.visual-paradigm.com (accessed: 26.10.2019).

[9] ERwin Data modeler. erwin.com: website. URL: https://erwin.com/products/erwin-data-modeler (accessed: 26.10.2019).

[10] Oracle SQl developer data modeler. erwin.com: website. URL: https://www.oracle.com/database/technologies/appdev/datamodeler.html (accessed: 26.10.2019).

[11] Vertabelo: website. URL: https://vertabelo.com (accessed: 26.10.2019).

[12] GOST R ISO/MEK 9126-93. Informatsionnaya tekhnologiya. Otsenka programmnoy produktsii. Kharakteristiki kachestva i rukovodstva po ikh primeneniyu [State standard R ISO/MEK 9126-93. Information technology. Software product evaluation. Quality characteristics and guidelines for their use]. Moscow, Gosstandart Rossii Publ., 1993 (in Russ.).

[13] Myshenkov K.S. Modeli i metody proektirovaniya avtomatizirovannykh sistem upravleniya dlya zernopererabatyvayushchikh predpriyatiy [Design models and methods of automated control systems for grain mills]. Moscow, MGUPP Publ., 2010 (in Russ.).

[14] Myshenkov K.S., Karpov V.I., Get’man V.V. Svidetel’stvo ob ofits. registr. progr. dlya EVM № 2006613936 RF. Kompleksnaya otsenka kachestva i klassifikatsiya mnogomernykh ob’’ektov [Software registration certificate no. 2006613936 RU. Complex quality assessment and classification of multidimensional objects]. Appl. 02.11.2006, reg. 16.11.2006 (in Russ.).