A multiagent update process in a database with temporal data dependencies and schema versioning

Gal, Avigdor; Etzion, Opher

doi:10.1109/69.667083

Cited by 16 publications

(5 citation statements)

References 37 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The data dependencies occur in databases when some data are calculated in function of others (Gal and Etzion, 1998). For example, since a social contribution is calculated in function of a salary (socialContribution = salary * 0.1), there is a dependency between the socialContribution, called the dependent and the salary, called the dependee (Gal and Etzion, 1998).…”

Section: Data Dependency Extractionmentioning

confidence: 99%

See 1 more Smart Citation

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

Hamrouni

Brahmia

Bouaziz

2018

IJIIDS

View full text Add to dashboard Cite

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.Reference to this paper should be made as follows: Hamrouni, H., Brahmia, Z. and Bouaziz, R. (2018) 'A systematic approach to efficiently managing the effects of retroactive updates of time-varying data in multiversion XML databases', Int.

show abstract

Section: Data Dependency Extractionmentioning

confidence: 99%

“…The issue of identifying dependencies between data has been studied in few works, like (Gal and Etzion, 1998). However, there is no work on extracting data dependencies from XML updates.…”

Section: Data Dependency Extractionmentioning

confidence: 99%

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

Hamrouni

Brahmia

Bouaziz

2018

IJIIDS

View full text Add to dashboard Cite

show abstract

“…In some cases, late payment interests could also be due. Notice also that some data, which we will call primary data, are used as a baseline for computing, according to some established business rule, other data, which we will call derived data (Gal and Etzion, 1998). For example, social contributions and payroll taxes are derived data with respect to employees’ salaries considered as primary data.…”

Section: Deferred Repair Of Inconsistencies In Temporal Xml Currency Datamentioning

confidence: 99%

“…Repairing database integrity after a retroactive update relies on both data semantics and data dependencies (Gal and Etzion, 1998). Indeed, some data require on-time repair (Hamrouni et al , 2014), whereas others require deferred repair.…”

Section: Introductionmentioning

confidence: 99%

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

Hamrouni

Grandi

Brahmia

2017

IJWIS

View full text Add to dashboard Cite

Purpose 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. Design/methodology/approach 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’s business rules that define some relationships between data. Findings 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. Originality/value 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’s requirements and to specifications which are customary in the real world.

show abstract

“…A typical design in such frameworks assumes the infrequent changes of metadata with respect to data modifications (e.g. [3]) and often leads to a rigid selection of data structures and programs that are heavily dependent on a specific metadata structure. Hence, in order to provide swift maintenance of Web related information services, the following two requirements should be fulfilled: Domain model independence: A flexible data structure provides the capability of modifying the domain model structure without modifying the internals of the browsing and querying tools.…”

Section: Model Maintenancementioning

confidence: 99%

Information Services for the Web: Building and Maintaining Domain Models

Gal

Kerr²,

Mylopoulos

1999

Int. J. Coop. Info. Syst.

View full text Add to dashboard Cite

The World Wide Web serves as a leading vehicle for information dissemination by offering information services, such as product information, group interactions, or sales transactions. Three major factors affect the performance and reliability of information services for the Web, namely the distribution of information which has resulted from the globalization of information systems, the heterogeneity of information sources, and the sources' instability caused by autonomous evolution. This paper focuses on integrating existing information sources, available via the Web, in the delivery of information services. The primary objective of the paper is to provide mechanisms for structuring and maintaining domain models for Web applications. These mechanisms are based on conceptual modeling techniques, where concepts are being defined and refined within a metadata repository through the use of instantiation, specialization and attribution. Also, active databases techniques are exploited to provide robust mechanisms for maintaining a consistent domain model in a rapidly evolving environment, such as the Web. Therefore, the main contribution of the paper lies in the provision of an architecture for semi-automatic generation and maintenance of user-oriented, semantic-based domain models that describe distributed heterogeneous information sources.

show abstract

A multiagent update process in a database with temporal data dependencies and schema versioning

Cited by 16 publications

References 37 publications

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

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

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

Information Services for the Web: Building and Maintaining Domain Models

Contact Info

Product

Resources

About