Geodesic
Choosing a data versioning model for designing information systems
Informacionnye tehnologii i vyčislitelnye sistemy, no. 3 (2023), pp. 127-136.

Voir la notice de l'article provenant de la source Math-Net.Ru

One of the common tasks faced by developers of information systems focused on working with data is the support of versioning and history of storing records. Versioning approaches that exist today are applicable to various application scenarios: online data processing, analytical reporting, distributed storage maintenance, etc. and do not depend directly on the used database. To select the optimal versioning model, it is necessary to determine the key requirements for the system in terms of versioning operations and evaluate the effectiveness of their implementation within each of the available mechanisms. This article provides an overview of these mechanisms, their characteristic differences, advantages and disadvantages, as well as examples of use. A method is proposed for comparative evaluation of these mechanisms on a test relational database using a series of operations on versions. This technique was used by the authors in the design and development of the integrated information system. Based on the initial requirements for the system, the characteristics of the models, and the obtained evaluation results, an analysis of the effectiveness of the studied mechanisms was carried out. The result of the analysis is the choice of the most optimal model in terms of the speed of versioning operations, data integrity, and flexibility in working with attributes.
Keywords: database, version control, versioning, Slowly Changing Dimension, SCD, Hibernate Envers, Aras Innovator, SQL, NoSQL, SciCMS. 
@article{ITVS_2023_3_a12,
     author = {B. A. Chernysh and A. V. Murygin},
     title = {Choosing a data versioning model for designing information systems},
     journal = {Informacionnye tehnologii i vy\v{c}islitelnye sistemy},
     pages = {127--136},
     publisher = {mathdoc},
     number = {3},
     year = {2023},
     language = {ru},
     url = {http://geodesic.mathdoc.fr/item/ITVS_2023_3_a12/}
}
TY  - JOUR
AU  - B. A. Chernysh
AU  - A. V. Murygin
TI  - Choosing a data versioning model for designing information systems
JO  - Informacionnye tehnologii i vyčislitelnye sistemy
PY  - 2023
SP  - 127
EP  - 136
IS  - 3
PB  - mathdoc
UR  - http://geodesic.mathdoc.fr/item/ITVS_2023_3_a12/
LA  - ru
ID  - ITVS_2023_3_a12
ER  - 
%0 Journal Article
%A B. A. Chernysh
%A A. V. Murygin
%T Choosing a data versioning model for designing information systems
%J Informacionnye tehnologii i vyčislitelnye sistemy
%D 2023
%P 127-136
%N 3
%I mathdoc
%U http://geodesic.mathdoc.fr/item/ITVS_2023_3_a12/
%G ru
%F ITVS_2023_3_a12
B. A. Chernysh; A. V. Murygin. Choosing a data versioning model for designing information systems. Informacionnye tehnologii i vyčislitelnye sistemy, no. 3 (2023), pp. 127-136. http://geodesic.mathdoc.fr/item/ITVS_2023_3_a12/