Deferred repair of inconsistencies resulting from retroactive updates of temporal XML currency data

• Published in: International journal of Web information systems Vol. 13; no. 4; pp. 485 - 519
• Main Authors: Hamrouni, Hind, Grandi, Fabio, Brahmia, Zouhaier
• Format: Journal Article
• Language: English
• Published: Bingley Emerald Group Publishing Limited 06.11.2017
• Subjects: Data base management systems; Data structures; Employees; Enterprise resource planning; Extensible Markup Language; Repair
• ISSN: 1744-0084; 1744-0092
• DOI: 10.1108/IJWIS-02-2017-0009

PurposeA temporal XML database could become an inconsistent model of the represented reality after a retroactive update. Such an inconsistency state must be repaired by performing corrective actions (e.g. payment of arrears after a retroactive salary increase) either immediately (i.e. at inconsistency detection time) or in a deferred manner, at one or several chosen repair times according to application requirements. The purpose of this work is to deal with deferred and multi-step repair of detected data inconsistencies.Design/methodology/approachA general approach for deferred and stepwise repair of inconsistencies that result from retroactive updates of currency data (e.g. the salary of an employee) in a valid-time or bitemporal XML database is proposed. The approach separates the inconsistency repairs from the inconsistency detection phase and deals with the execution of corrective actions, which also take into account enterprise's business rules that define some relationships between data.FindingsAlgorithms, methods and support data structures for deferred and multi-step inconsistency repair of currency data are presented. The feasibility of the approach has been shown through the development and testing of a system prototype, named Deferred-Repair Manager.Originality/valueThe proposed approach implements a new general and flexible strategy for repairing detected inconsistencies in a deferred manner and possibly in multiple steps, according to varying user's requirements and to specifications which are customary in the real world.