Database Versioning, a Transparent SQL Approach


  • Cosmin Cioranu Executive Unit for Higher Education, Research, Development and Innovation Funding
  • Marius Cioca “Lucian Blaga” University of Sibiu


DBMS, SQL, Versioning, Data Versioning


In today’s times every piece of software no matter the complexity, produces data, redundant or otherwise, that needs or should be stored in a permanent storage. The simplest way is a file system, but where the need of complexity and flexibility is required, most system designers prefer to use some kind of Database Management System (DBMS). Even with such a management system, on large amounts of data, combined with information updates, it raises the need to retrieve and track the history of modifications of a  specific information alongside the dependencies that makes it coherent. Considering the above the natural solution is to have a database revision or versioning system in which the existing algorithms will still perform without or little modifications and the cost of implementation of such a solution is minimal.


Florin Gheorghe Filip, Designing and Building Modern Information Systems; A Series of Decisions to Be Made, Computer Science Journal of Moldova, vol.19, no.2(56), 2011

Enrico Franconi, Fabio Grandi and Federica Mandreoli, A Semantic Approach for Schema Evolution and Versioning in Object-Oriented Databases, Computational Logic - CL 2000, Lecture Notes in Computer Science Volume 1861, 2000, pp 1048-1062

Ninging Zhu, Data versioning systems. Technical report, Stony Brook University, reports.html

Craig A.N. Soules, Garth R. Goodson, John D. Strunk, Gregory R. Ganger, Metadata Efficiency in Versioning File Systems, Proceedings of FAST ’03: 2nd USENIX Conference on File and Storage Technologies, San Francisco, CA, USA March 31–April 2, 2003

Edward Sciore, Versioning and Configuration Management in an Object-Oriented Data Model, VLDB JournaL3, 77-106 (1994)

Michail D. Flouris, Clotho: Transparent Data Versioning at the Block I/O Level, Twelfth NASA Goddard Conference on Mass Storage Systems and Technologies in cooperation with Twenty-First IEEE Conference on Mass Storage Systems and Technologies, p315-p329

Ana-Maria Suduc, Mihai Bizoi, Florin Gheorghe Filip, Usability in Scientic Databases, Computer Science Journal of Moldova, vol.20, no.2(59), 2012

Cosmin CIORANU, Marius CIOCA, Lucian-Ionel CIOCA, Improving Image Processing Systems by Using Software Simulated LRU Cache Algorithms,,%20Cioca,%20Cioca.pdf

Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko, High Performance MySQL, Third Edition, ISBN: 978-1-449-31428-6, 2012




How to Cite

Cioranu, C., & Cioca, M. (2013). Database Versioning, a Transparent SQL Approach. Journal of Mobile, Embedded and Distributed Systems, 5(1), 1-5. Retrieved from