Temporal Branching as a Conflict Management Technique
The current research attempts to model a technique for managing conflicts within an integrated database. An integrated database being a database whose schema is an integration of several external database schemas, independent of each other. The independence of the systems allows conflicting values to be entered into the same data objects.
For example, one system may hold the value of female for a specific data object where as another may hold male. The conflict is only discovered when the data objects are brought to the integrated database, and then there is need to resolve the conflict.
A technique to manage conflicts is developed based on version management, used in temporal databases, and the log-file approach used in more conventional technologies. The model combines temporal database tools with distributed database management tools. Thus it obtains greater flexibility than existing replication and log-file techniques and is more economic in record volume than the temporal approach.
KeywordsData Object Blood Type Electronic Patient Record Audit Trail Data Schema
Unable to display preview. Download preview PDF.
- 1.Ahamad, M., Ammar, M.H. and Cheung, S.Y., “Replicated Data Management in Distributed Systems”. In: Readings in Distributed Computing Systems, Thomas L. Casavant and Mukesh Singhal (Eds.), IEEE Computer Society Press, 1994.Google Scholar
- 2.Anastassopoulos, P. and Dollimore, J., “A Unified Approach to Distributed Concurrency Control”. In: Readings in Distributed Computing Systems, Thomas L. Casavant and Mukesh Singhal (Eds.), IEEE Computer Society Press, 1994.Google Scholar
- 5.FDA, “21 CFR Part 11. Electronic Records; Electronic Signatures; Final Rule”, Federal Register, Vol. 62, NO. 52, 1997, pp. 13430–13466.Google Scholar
- 7.ICH, “ICH topic 6—Guideline for Good Clinical Practice”, The European Agency for the Evaluation of Medical Products (EUDRA), 1996.Google Scholar
- 8.Jensen, Christian S. and Dyreson, Curtis E. (Eds.), “The Consensus Glossary of Temporal Database Concepts — February 1998 Version”, Temporal Databases — Research and Practice, Lecture Notes in Computer Science 1388, Springer-Verlag, Berlin, 1998, pp. 368–405.Google Scholar
- 9.Lepay, David A., “Guidance for Industry. Computerized Systems Used in Clinical Trials”, (draft), Federal Register, Vol. 62, 33094, 1997.Google Scholar
- 10.Lu Jiang, Barclay, P. and Kennedy, J., “On temporal versioning in temporal databases”, Informationssystem-Architekturen, Vol. 3, Iss. 1, Sept 1996, pp. 38–40.Google Scholar
- 11.Oracle, “Introduction to Oracle7 Advanced Replication”, White Paper, http://www.oracle.com, October 1996.
- 13.Shiftan, Y., “Managing Table Databases Incorporating the Time Dimension”, (Hebrew), Computers, Sept. 1990, Israel.Google Scholar
- 15.Tansel, Clifford, Gadia, Jajodia, Segev and Snodgrass, Temporal Databases: Theory, Design, and Implementation, Benjamin/Cummings, USA, 1993.Google Scholar
- 16.Timothy P. Loomis, “Audit History and Time-Slice Archiving an Object DBMS for Laboratory Databases”, HP Journal, Article 10, August 1997.Google Scholar
- 17.Yu Wu, Sushil Jajodia and Sean Wang, X., “Temporal Database Bibliography Update”, Temporal Databases — Research and Practice, Lecture Notes in Computer Science 1388, Springer-Verlag, Berlin, 1998, pp. 368–405.Google Scholar