A systematic approach to efficiently managing the effects of retroactive updates of time-varying data in multiversion XML databases. (2018)

• Record Type: Journal Article
• Authors: Hamrouni, Hind; Brahmia, Zouhaier; Bouaziz, Rafik
• Is Part Of: International journal of intelligent information and database systems. Volume 11:Number 1(2018)
• Page Start: 1
• Page End: 26
• Publication Date: 2018
• Subjects: XML database -- temporal database -- schema versioning -- retroactive update -- inconsistency period -- data inconsistency -- data dependency -- transaction log; Database management -- Computer programs -- Periodicals; Information retrieval -- Computer programs -- Periodicals; Information storage and retrieval systems -- Computer programs -- Periodicals; Artificial intelligence -- Periodicals; Expert systems (Computer science) -- Periodicals; Intelligent agents (Computer software) -- Periodicals; 006.33
• Languages: English
• ISSNs: 1751-5858

Abstract

A retroactive update is an update that changes a past data. It is a common operation in both conventional and temporal databases. However, in temporal databases, a retroactive update is challenging since it could lead to data inconsistencies if the retroactively updated data were used for creating other data (like social contributions and taxes which are calculated based on the salaries of the employees). Such data inconsistencies must be repaired in order to preserve the database consistency. In this paper, we extend our previous approach on detecting and repairing automatically data inconsistencies that result from retroactive updates of multiversion temporal XML databases. The extension consists in: 1) providing an enhanced version of the architecture of our approach and explaining the process of handling a retroactive update; 2) showing how to extract data dependencies and how to use them in order to repair detected inconsistencies; 3) proposing a new log structure ensuring a complete and useful history of the executed transactions; 4) presenting a tool, named Retro-Update-Manager, that we have developed to prove technically our approach.