Abstract: when historical versions of data are concerned for a MIS (Management Information System) we naturally might resort to temporal database products. These bi-temporal products, however, are often extravagant and not easily mastered to most of MIS practitioners. Hence we present a plain DIY (do it yourself) solution, the Audit & Change Logs Mechanism-based approach--ACLM, to meet the uni-temporal requirement from restoring historical versions of data. With ACLM programmers can code SQL scripts on demand to trace and replay any snapshot of historical data version via RDBMS built-in functions, they need not to shift away from their usual way of coding stored procedures for data maintenance. Besides, the ACLM approach is compatible with mega-data change, and its additive overhead was instantiated imperceptible for throughputs of routine access with a typical scenario.

Haitao Yang, Fei Xu and Lating Xia, “A Diy Approach to Uni-Temporal Database Implementation” International Journal of Advanced Computer Science and Applications(IJACSA), 4(9), 2013. http://dx.doi.org/10.14569/IJACSA.2013.040919

@article{Yang2013,
title = {A Diy Approach to Uni-Temporal Database Implementation},
journal = {International Journal of Advanced Computer Science and Applications},
doi = {10.14569/IJACSA.2013.040919},
url = {http://dx.doi.org/10.14569/IJACSA.2013.040919},
year = {2013},
publisher = {The Science and Information Organization},
volume = {4},
number = {9},
author = {Haitao Yang and Fei Xu and Lating Xia}
}