A Diy Approach to Uni-Temporal Database Implementation

Haitao Yang, Fei Xu, Lating Xia
2013 International Journal of Advanced Computer Science and Applications  
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
more » ... de 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 meta-data change, and its additive overhead was instantiated imperceptible for throughputs of routine access with a typical scenario. 123 | P a g e www.ijacsa.thesai.org government MIS projects with requirements of uni-temporal database applications.
doi:10.14569/ijacsa.2013.040919 fatcat:i4j3s4it25aq5gunr6hxyke3ry