Database Versioning, a Transparent SQL Approach

Authors

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

Keywords:

DBMS, SQL, Versioning, Data Versioning

Abstract

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.

References

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,

http://www.ecsl.cs.sunysb.edu/tech 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, http://www.revistaie.ase.ro/content/64/08%20-%20Cioranu,%20Cioca,%20Cioca.pdf

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

Downloads

Published

2013-03-30

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 http://jmeds.eu/index.php/jmeds/article/view/Database_Versioning_a_Transparent_SQL_Approach

Issue

Vol. 5 No. 1 (2013): Advances in Data Processing

Section

Articles

License

Authors who publish with this journal agree to the following terms:


    1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.

    1. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.

    1. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).

    1. The author(s) is responsible for the correctness and legality of the paper content.

    1. Papers that are copyrighted or published will not be taken into consideration for publication in JMEDS It is the author(s) responsibility to ensure that the paper does not cause any copyright infringements and other problems.

    1. It is the responsibility of the author(s) to obtain all necessary copyright release permissions for the use of any copyrighted materials in the paper prior to the submission.

  1. The Author(s) retains the right to reuse any portion of the paper, in future works, including books, lectures and presentations in all media, with the condition that the publication by JMEDS is properly credited and referenced.
Creative Commons License
JMEDS articles by Journal of Mobile, Embedded and Distributed Systems (JMEDS) is licensed under a Creative Commons Attribution 4.0 International License.
Based on a work at http://jmeds.eu.
Permissions beyond the scope of this license may be available at http://jmeds.eu/index.php/jmeds/about/submissions#copyrightNotice.