350 rub
Journal Dynamics of Complex Systems - XXI century №2 for 2020 г.
Article in number:
Selection rationale of the database modeling software
DOI: 10.18127/j19997493-202002-09
UDC: 004.414:004.415.2
Authors:

K.S. Myshenkov – Dr.Sc. (Eng.), Professor, 

Department «Information Processing and Management Systems», Bauman Moscow State Technical University E-mail: myshenkovks@bmstu.ru

M.F. Simonov – Senior Lecturer, 

Department «Information Processing and Management Systems», Bauman Moscow State Technical University E-mail: simonovmf@bmstu.ru

V.M. Korostelev – Undergraduate Student,   

Department «Information Processing and Management Systems», Bauman Moscow State Technical University E-mail: korostelevvm@student.bmstu.ru

Abstract:

The relevance of the study is due to the presence on the market of a large number of software tools for automating the software life cycle processes, which creates the problem of choosing a specific CASE tool. The software selection for use in a specific information system development project depends on many factors and is a very difficult task.

The aim of the work is to justify the choice of software for designing database models for a specific project based on a comprehensive multidimensional quality assessment and classification of CASE tools.

The analysis of software tools available on the Russian market for designing and building models of relational databases in IDEF1X notation ("entity – relationship" model) is carried out. For each of the software tools selected for analysis, the procedures for installing and building database models were performed. Based on the experiments performed, a comprehensive quality assessment and classification of software tools for building database models was carried out. The hierarchical structure of the quality metric is developed, and the values of the metric's weight coefficients are determined. The evaluation of the values of the quality indicators of CASE tools was carried out by the method of expert evaluation based on the results of experiments. The results of a comprehensive quality assessment and classification of software used for database modeling are presented. Based on the analysis of the results obtained, recommendations are given to justify the choice of CASE tools data modeling for a specific software project.

Applied research results: the description of the main characteristics of CASE tools, the quality metric developed by the authors, as well as the results of a comprehensive quality assessment and classification of CASE tools for building relational database models, will be useful to specialists and software developers when choosing software tools for a specific project.

Pages: 77-83
References
  1. Odincov I.O. Professional'noe programmirovanie. Sistemnyj podhod. Izd. 2-e. SPb: BHV-Peterburg. 2004. 624 s. (In Russian).
  2. DBDesigner. URL: https://www.dbdesigner.net (data obrashhenija: 23.10.2019).
  3. MySQL Workbench. URL: https://www.mysql.com/products/workbench (data obrashhenija: 23.10.2019).
  4. GenMyModel. URL: https://www.genmymodel.com/rds (data obrashhenija: 23.10.2019).
  5. Valentina Studio. URL: https://www.valentina-db.com/ru/valentina-studio-overview (data obrashhenija: 23.10.2019).
  6. WWW SQL Designer. URL: https://github.com/ondras/wwwsqldesigner/wiki (data obrashhenija: 23.10.2019).
  7. Visual Paradigm. URL: https://www.visual-paradigm.com (data obrashhenija: 26.10.2019).
  8. ERwin Data modeler. URL: https://erwin.com/products/erwin-data-modeler (data obrashhenija: 26.10.2019).
  9. Oracle SQl Developer Data Modeler. URL: https://www.oracle.com/database/technologies/appdev/datamodeler.html (data obrashhenija: 26.10.2019).
  10. Vertabelo. URL: https://vertabelo.com (data obrashhenija: 26.10.2019).
  11. GOST R ISO/MJeK 9126-93. Informacionnaja tehnologija. Ocenka programmnoj produkcii. Harakteristiki kachestva i rukovodstva po ih primeneniju. M.: Gosstandart Rossii. 1993. 15 s. (In Russian).
  12. Myshenkov K.S. Modeli i metody proektirovanija avtomatizirovannyh sistem upravlenija dlja zernopererabatyvajushhih predprijatij: monografija. M.: Izd. kompleks MGUPP. 2010. 256 s. (In Russian).
  13. Myshenkov K.S. Metodika obosnovanija vybora CASE-sredstv dlja analiza i proektirovanija sistem upravlenija predprijatijami. Innovacii. 2013. № 10. S. 33-43 (In Russian).
  14. Svidetel'stvo ob ofic. registr. progr. dlja JeVM № 2006613936 (RF). Kompleksnaja ocenka kachestva i klassifikacija mnogomernyh ob’ektov / Myshenkov K.S., Karpov V.I., Get'man V.V. № 2006613704; Zajav. 02.11.2006; Zaregistr. 16.11.2006 (In Russian).
Date of receipt: 5 мая 2020 г.