PROSPECTS FOR MANAGING DATABASE RECORD VERSIONS

O. Tsyrul

Èlektron. model. 2026, 48(1):99-105

https://doi.org/10.15407/emodel.48.01.099

ABSTRACT

The relevance of researching database record versions is explained by the increase in the volume of information and the growing complexity of structured data. The effectiveness and limitations of several approaches to storing versioned data structures with complex relationships between objects in relational and non-relational databases have been researched and analyzed. Based on the comparison, the necessity of implementing versioning as a built-in tool for managing modern databases is demonstrated. An approach to implementing versioning is proposed, which uses the principles of flexible storage and management of the history of record changes.

KEYWORDS

database, versioning, resources, table.

REFERENCES

1. Cellary, W., Vidyasankar, K., & Vossen, G. (2021). Versioning in database management systems (Dagstuhl Seminar 9305). Schloss Dagstuhl-Leibniz-Zentrum für Informatik.
2. Bhardwaj, A., Bhattacherjee, S., Chavan, A., Deshpande, A., Elmore, A.J., Madden, S., & Parameswaran, A.G. (2014). DataHub: Collaborative data science & dataset version management at scale. arXiv. https://arxiv.org/abs/1409.0798
3. Strauch, C., Sites, U.L.S., & Kriha, W. (2011). NoSQL databases (Lecture Notes). Stuttgart Media University.
4. Mason, R.T. (2015). NoSQL databases and data modeling techniques for a document-oriented NoSQL database. Proceedings of the 2015 InSITE Conference, n. July, p. 259-268.
5. Worsley, J., & Drake, J.D. (2002). Practical PostgreSQL. O’Reilly Media.
6. Widom, J., & Ceri, S. (Eds.). (1995). Active database systems: Triggers and rules for advanced database processing. Morgan Kaufmann.
7. de Espona, L., & Pustulka, E. (2023). MongoDB data versioning performance: Local versus Atlas. In Proceedings of the EDBT/ICDT 2023 Workshops (Vol. 3, p. 3).
8. Bhattacherjee, S., Chavan, A., Huang, S., Deshpande, A., & Parameswaran, A. (2015). Principles of dataset versioning: Exploring the recreation/storage tradeoff. Proceedings of the VLDB Endowment, 8(12), 1346-1357. arXiv. https://arxiv.org/abs/1505.05211
9. Graefe, G. (2011). Modern B-tree techniques. Foundations and Trends® in Databases, 3(4), 203-402. https://doi.org/10.1561/1900000028
10. Pezoa, F., Reutter, J.L., Suarez, F., Ugarte, M., & Vrgoč, D. (2016). Foundations of JSON schema. In Proceedings of the 25th International World Wide Web Conference (WWW 2016) (pp. 263-273). https://doi.org/10.1145/2872427.2883029

Full text: PDF