A DIY APPROACH TO UNI-TEMPORAL DATABASE IMPLEMENTATION
Journal Title: International Journal of Advanced Computer Science & Applications - Year 2013, Vol 4, Issue 9
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.
Authors and Affiliations
Haitao Yang, Fei Xu, Lating Xia
Keywords
Related Articles
- EP ID EP120556
- DOI 10.14569/IJACSA.2013.040919
- Views 75
- Downloads 0
eHealth WBAN: Energy-Efficient and Priority-Based Enhanced IEEE802.15.6 CSMA/CA MAC Protocol
This paper provided a general study of Wireless Body Area Network (WBAN) in health monitoring system as well as the study of the application of wearable and implanted Bio-Medical-Sensors (BMS) which are used to monitor t...
Let’s Code: A Kid-friendly Interactive Application Designed to Teach Arabic-speaking Children Text-based Programming
Programming is the cornerstone for the development of all of the technologies we encounter in our daily lives. It also plays an important role in enhancing creativity, problem-solving, and logical thinking. Due to the im...
Evaluating the Applicability of a Social Content Management Framework: A Case Analysis
Social media platform plays an important role in engaging customers. The social content resulting from social media interactions between the organisations and the customers need a proper management. Therefore, in this wo...
Maneuverability of an Inverted Pendulum Vehicle According to the Handle Operation Methods
This study investigated what handle operation and turning gain is comfortable for people using an inverted pendulum vehicle that is changeable the handle operation. Experimental conditions were three conditions. First is...
An Intelligent Bio-Inspired Algorithm for the Faculty Scheduling Problem
All universities have faculty members who need to be assigned to teach courses. Those members have various specialties, preferences and different levels of experience. The manual assignment of courses is a very tedious a...