DATA PROCESSING AND ANALYSIS
INTELLIGENCE SYSTEMS AND TECHNOLOGIES
MATHEMATICAL MODELING
MANAGEMENT AND DECISION MAKING
SOFTWARE ENGINEERING
B. A. Chernysh, A. V. Murygin Choosing a Data Versioning Model for Designing Information Systems
B. A. Chernysh, A. V. Murygin Choosing a Data Versioning Model for Designing Information Systems
Abstract. 

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.

PP. 127-136.

DOI 10.14357/20718632230313
 
References

1. Kimball R., Ross M. The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, Third Eition. Indianapolis: John Wiley & Sons, Inc., 2013.
2. Berger A.B., Microsoft SQL Server 2005 Analysis Services. OLAP i mnogomerniy analiz dannykh [OLAP and multidimensional data analysis]. St/ Petersburg: BHVPeterburg, 2007.
3. Bauer C., King G., Gregory G. Java Persistence with Hibernate. Second Edition, Manning Publications Co., 2016.
4. Malakhov Y.A., Mikhalchenko S.S. Analiz sovremennykh resheniy v oblasti web-prilizheniy [Analysis of modern solutions in the field of web application development] // Sbornik nauchnykh statey Vserossiyskoy conferentsii «Avtomatizaciya i modelirovanie v proektirovanii i upravlenii» [Collection of scientific articles of the All-Russian conference "Automation and modeling in design and management"]. Bryansk, 2022.
5. Content Versioning. Available at: https://market.strapi.io/plugins/@notum-cz-strapi-plugincontent-versioning (accessed: March 12,.2023).
6. Yungpeng L., Utpal R., Seung-Jun S., Y. Tina L. A "Smart Component" Data Model in PLM // 2015 IEEE International Conference on Big Data. Santa Clara, 2015.
7. Chernysh B.A., Murygin A.V. Dinamicheskaya schema GraphQL v realizatsii integrirovannoy informatsionnoy sistemy [GraphQL Dynamic Schema in Integrated Information System Implementation] // Programmnye produkty i sistemy [Software and systems], № 4 (35), pp. 561-566, 2022.
8. Bazrov B.M., Kheifetz M.L., Hurevich V.L., Popok N.N. Assessment of production manufacturability of the design in the product life cycle // Proceedings of the National academy of sciences of Belarus. Phisico-technical series, vol. 65, № 4, pp. 422-432, 2020.
9. Damirbek K.G., Zhakypova E.A.. Obespecheniye tselostnosti informatsii информации v avtomatizirovannyh informatsionnyh sistemah [Ensuring the integrity of information in automated information systems] // Sovremennye problemy mekhaniki [Modern problems of mechanics], pp. 66-41, 2018.
10. Rainardi V. Building a Data Warehouse With Examples in SQL Server. New York: Apress, 2008.
11. Loyola R.C., Sepulveda A.U., Hernandez M.W. Optimization slowly changing dimensions of a data warehouse using object-relational // International Conference of the Chilean Computer Science Society (SCCC), 2015.
12. Adriana J., Holanda M. NoSQL: SQL to NoSQL Databases // Advances in Intelligent Systems and Computing, vol. 746, pp. 938-948, 2018.

 

2024 / 03
2024 / 02
2024 / 01
2023 / 04

© ФИЦ ИУ РАН 2008-2018. Создание сайта "РосИнтернет технологии".