{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,28]],"date-time":"2025-10-28T03:15:41Z","timestamp":1761621341980,"version":"3.41.2"},"reference-count":39,"publisher":"Emerald","issue":"4","license":[{"start":{"date-parts":[[2017,11,6]],"date-time":"2017-11-06T00:00:00Z","timestamp":1509926400000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.emerald.com\/insight\/site-policies"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["IJWIS"],"published-print":{"date-parts":[[2017,11,6]]},"abstract":"<jats:sec>\n<jats:title content-type=\"abstract-subheading\">Purpose<\/jats:title>\n<jats:p>A 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.<\/jats:p>\n<\/jats:sec>\n<jats:sec>\n<jats:title content-type=\"abstract-subheading\">Design\/methodology\/approach<\/jats:title>\n<jats:p>A 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\u2019s business rules that define some relationships between data.<\/jats:p>\n<\/jats:sec>\n<jats:sec>\n<jats:title content-type=\"abstract-subheading\">Findings<\/jats:title>\n<jats:p>Algorithms, 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.<\/jats:p>\n<\/jats:sec>\n<jats:sec>\n<jats:title content-type=\"abstract-subheading\">Originality\/value<\/jats:title>\n<jats:p>The 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\u2019s requirements and to specifications which are customary in the real world.<\/jats:p>\n<\/jats:sec>","DOI":"10.1108\/ijwis-02-2017-0009","type":"journal-article","created":{"date-parts":[[2017,10,3]],"date-time":"2017-10-03T19:12:43Z","timestamp":1507057963000},"page":"485-519","source":"Crossref","is-referenced-by-count":1,"title":["Deferred repair of inconsistencies resulting from retroactive updates of temporal XML currency data"],"prefix":"10.1108","volume":"13","author":[{"given":"Hind","family":"Hamrouni","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Fabio","family":"Grandi","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zouhaier","family":"Brahmia","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"140","reference":[{"key":"key2020120423504360200_ref002","unstructured":"Altova (2017), \u201cXMLSpy XML editor\u201d, available at: www.altova.com\/xmlspy.html (accessed 10 June 2017)."},{"year":"2009","key":"key2020120423504360200_ref003","article-title":"Data manipulation in multi-temporal XML databases supporting schema versioning"},{"issue":"2","key":"key2020120423504360200_ref004","doi-asserted-by":"crossref","first-page":"20","DOI":"10.4018\/ijitwe.2014040102","article-title":"Schema change operations for full support of schema versioning in the \u03c4XSchema framework","volume":"9","year":"2014","journal-title":"International Journal of Information Technology and Web Engineering"},{"key":"key2020120423504360200_ref005","first-page":"7651","article-title":"Schema versioning","volume-title":"Encyclopedia of Information Science and Technology","year":"2015","edition":"3rd ed."},{"year":"2016","key":"key2020120423504360200_ref006","article-title":"A tool-supported approach for managing time-varying XML data in multi-temporal XML repositories under temporal schema versioning"},{"first-page":"140","article-title":"tauXUF: a temporal extension of the XQuery update facility language for the tauXSchema framework","year":"2016","key":"key2020120423504360200_ref007"},{"first-page":"194","article-title":"On temporal grouping","year":"1995","key":"key2020120423504360200_ref008"},{"issue":"2","key":"key2020120423504360200_ref009","doi-asserted-by":"crossref","first-page":"171","DOI":"10.1145\/249978.249980","article-title":"On the semantics of \u2018now\u2019 in databases","volume":"22","year":"1997","journal-title":"ACM Transactions on Database Systems"},{"first-page":"348","article-title":"A tale of two schemas: creating a temporal XML schema from a snapshot schema with tXSchema","year":"2004","key":"key2020120423504360200_ref010"},{"first-page":"122","article-title":"Temporal conditions with retroactive and proactive updates","year":"1995","key":"key2020120423504360200_ref011"},{"key":"key2020120423504360200_ref012","doi-asserted-by":"crossref","first-page":"3032","DOI":"10.1007\/978-0-387-39940-9_411","article-title":"Temporal XML","volume-title":"Encyclopedia of Database Systems","year":"2009"},{"key":"key2020120423504360200_ref013","unstructured":"EMC (2011), \u201cEMC xDB 10.2.0 manual\u201d, available at: https:\/\/developer-content.emc.com\/docs\/documentum\/xdb\/manual\/#_1 (accessed 10 June 2017)."},{"first-page":"126","article-title":"Retroactive and proactive database processing","year":"1994","key":"key2020120423504360200_ref014"},{"volume-title":"Temporal Databases: Research and Practice","year":"1998","key":"key2020120423504360200_ref015"},{"issue":"1","key":"key2020120423504360200_ref016","doi-asserted-by":"crossref","first-page":"21","DOI":"10.1109\/69.667083","article-title":"A multiagent update process in a database with temporal data dependencies and schema versioning","volume":"10","year":"1998","journal-title":"IEEE Transactions on Knowledge and Data Engineering"},{"key":"key2020120423504360200_ref017","first-page":"1914","article-title":"Temporal databases","volume-title":"Encyclopedia of Information Science and Technology","year":"2015","edition":"3rd ed."},{"first-page":"135","article-title":"An efficient approach for detecting and repairing data inconsistencies resulting from retroactive updates in multi-temporal and multi-version XML databases","year":"2014","key":"key2020120423504360200_ref018"},{"issue":"2","key":"key2020120423504360200_ref019","doi-asserted-by":"crossref","first-page":"141","DOI":"10.1561\/1900000002","article-title":"Architecture of a database system","volume":"1","year":"2007","journal-title":"Foundations and Trends\u00ae in Databases"},{"key":"key2020120423504360200_ref020","unstructured":"IRS (2013), Reporting Back Pay and Special Wage Payments to the Social Security Administration, Publication 957, available at: www.irs.gov\/publications\/p957\/index.html (accessed 10 June 2017)."},{"key":"key2020120423504360200_ref021","unstructured":"IRS (2015), \u201cApplication of retroactive increase in excludable transit benefits\u201d, Internal Revenue Bullettin 2015-4, Notice 2015-2, available at: www.irs.gov\/irb\/2015-4_IRB\/ar06.html (accessed 10 June 2017)."},{"key":"key2020120423504360200_ref022","first-page":"2957","article-title":"Temporal database","volume-title":"Encyclopedia of Database Systems","year":"2009"},{"key":"key2020120423504360200_ref023","first-page":"367","article-title":"The consensus glossary of temporal database concepts \u2013 February 1998 version","volume-title":"Temporal Databases: Research and Practice, LNCS 1399","year":"1998"},{"issue":"3","key":"key2020120423504360200_ref024","doi-asserted-by":"crossref","first-page":"34","DOI":"10.1145\/2380776.2380786","article-title":"Temporal features in SQL:2011","volume":"41","year":"2012","journal-title":"ACM SIGMOD Record"},{"first-page":"92","article-title":"A comparison of different forms of temporal Data management","year":"2015","key":"key2020120423504360200_ref025"},{"edition":"4th ed.","volume-title":"Concepts in Enterprise Resource Planning","year":"2013","key":"key2020120423504360200_ref026"},{"key":"key2020120423504360200_ref027","unstructured":"Nguyen, T.M. (2013), \u201cUnderstanding retroactive accounting\u201d, available at: http:\/\/scn.sap.com\/docs\/DOC-35341 (accessed 10 June 2017)."},{"key":"key2020120423504360200_ref028","unstructured":"Oracle (2016), \u201cUnderstanding retro pay processing\u201d, Online Documentation of Oracle\u2019s PeopleSoft Human Capital Management 9.2, available at: http:\/\/docs.oracle.com\/cd\/E79521_01\/hcm92pbr11\/eng\/hcm\/hpay\/concept_UnderstandingRetroPayProcessing-3e3c34.html?pli=ul_d209e402_hpay (accessed 10 June 2017)."},{"key":"key2020120423504360200_ref029","unstructured":"Oracle (2017), \u201cTemporal validity support\u201d, Oracle Database Online Documentation 12c Release 1 (12.1), available at: https:\/\/docs.oracle.com\/database\/121\/ADFNS\/adfns_design.htm#ADFNS967 (accessed 10 June 2017)."},{"first-page":"136","article-title":"Modern temporal data models: strengths and weaknesses","year":"2015","key":"key2020120423504360200_ref030"},{"first-page":"13","article-title":"Temporal data in relational database systems: a comparison","year":"2016","key":"key2020120423504360200_ref031"},{"key":"key2020120423504360200_ref032","unstructured":"SAP (2017), \u201cSAP human capital management\u201d, available at: http:\/\/go.sap.com\/product\/hcm.html (accessed 10 June 2017)."},{"key":"key2020120423504360200_ref033","unstructured":"Saracco, C.M., Nicola, M. and Gandhi, L. (2012), \u201cA matter of time: temporal data management in DB2 10\u201d, available at: www.ibm.com\/developerworks\/data\/library\/techarticle\/dm-1204db2temporaldata\/ (accessed 10 June 2017)."},{"issue":"4","key":"key2020120423504360200_ref034","article-title":"Keep track \u2013 new features in teradata 13.10 enhance support of temporal data","volume":"10","year":"2010","journal-title":"Teradata Magazine"},{"issue":"2","key":"key2020120423504360200_ref035","doi-asserted-by":"crossref","first-page":"223","DOI":"10.1016\/j.datak.2007.09.003","article-title":"Validating quicksand: schema versioning in \u03c4XSchema","volume":"65","year":"2008","journal-title":"Data & Knowledge Engineering"},{"volume-title":"The TSQL2 Temporal Query Language","year":"1995","key":"key2020120423504360200_ref001"},{"key":"key2020120423504360200_ref036","unstructured":"SQL Server (2016), \u201cTemporal tables\u201d, available at: https:\/\/msdn.microsoft.com\/en-us\/library\/dn935015.aspx (accessed 10 June 2017)."},{"volume-title":"Temporal Databases: Theory, Design and Implementation","year":"1993","key":"key2020120423504360200_ref037"},{"key":"key2020120423504360200_ref038","unstructured":"W3C (2011), XQuery Update Facility 1.0, W3C Candidate Recommendation, available at: www.w3.org\/TR\/2011\/REC-xquery-update-10-20110317\/ (accessed 10 June 2017)."},{"key":"key2020120423504360200_ref039","unstructured":"W3C (2015), XQuery Update Facility 3.0, W3C Last Call Working Draft, available at: www.w3.org\/TR\/2015\/WD-xquery-update-30-20150219\/ (accessed 10 June 2017)."}],"container-title":["International Journal of Web Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.emerald.com\/insight\/content\/doi\/10.1108\/IJWIS-02-2017-0009\/full\/xml","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/www.emerald.com\/insight\/content\/doi\/10.1108\/IJWIS-02-2017-0009\/full\/html","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,7,24]],"date-time":"2025-07-24T22:23:43Z","timestamp":1753395823000},"score":1,"resource":{"primary":{"URL":"http:\/\/www.emerald.com\/ijwis\/article\/13\/4\/485-519\/166617"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017,11,6]]},"references-count":39,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2017,11,6]]}},"alternative-id":["10.1108\/IJWIS-02-2017-0009"],"URL":"https:\/\/doi.org\/10.1108\/ijwis-02-2017-0009","relation":{},"ISSN":["1744-0084"],"issn-type":[{"type":"print","value":"1744-0084"}],"subject":[],"published":{"date-parts":[[2017,11,6]]}}}