Living with database conflicts: A temporal branching technique

Roy Gelbard, Israel Spiegler

Research output: Contribution to journalArticlepeer-review

Abstract

Heterogeneous as well as distributed databases make data conflicts inevitable. Both tolerate the entry of conflicting values in data objects, e.g., the value "female" may be entered by one user whereas another may put "male" in the same data object. Such inconsistencies in databases are common and are resolved routinely by built in structured mechanisms. Unresolved conflicts are typically quarantined till they can be resolved. But, there are situations for which there are no structured mechanisms to resolve conflicts while having to maintain application flow. Moreover, there are situations, i.e., medical or financial environments, in which conflicts must be stored so that their effects be analyzed for decision making. The current research proposes a model and a technique for living with database conflicts. The technique, named Temporal Branching, integrates and extends temporal oriented databases, temporal versioning, and log-file approaches and offers a solution and flexible structure readily accessible to retrieval and audits by standard DBMS software. A case study in health care delivery system is given to illustrate the problem and proposed solution.

Original languageEnglish
Pages (from-to)251-265
Number of pages15
JournalDistributed and Parallel Databases
Volume17
Issue number3
DOIs
StatePublished - Mar 2005

Keywords

  • Check point
  • Conflict resolution
  • Data integrity
  • Distributed database
  • Rollback and recovery
  • Temporal oriented databases
  • Temporal versioning

Fingerprint

Dive into the research topics of 'Living with database conflicts: A temporal branching technique'. Together they form a unique fingerprint.

Cite this