Managing Consistency Anomalies in Distributed Integrated Databases with Relaxed ACID Properties

    Research output: Chapter in Book/Report/Conference proceedingArticle in proceedingsResearchpeer-review

    Abstract

    In central databases the consistency of data is normally implemented by using the ACID (Atomicity, Consistency, Isolation and Durability) properties of a DBMS (Data Base Management System). This is not possible if distributed and/or mobile databases are involved and the availability of data also has to be optimized. Therefore, we will in this paper use so called relaxed ACID properties across different locations. The objective of designing relaxed ACID properties across different database locations is that the users can trust the data they use even if the distributed database temporarily is inconsistent. It is also important that disconnected locations can operate in a meaningful way in socalled disconnected mode.
    A database is DBMS consistent if its data complies with the consistency rules of the DBMS's metadata. If the database is DBMS consistent both when a transaction starts and when it has been committed and completed, the execution has the consistency property.
    The above definition of the consistency property is not useful in distributed databases with relaxed ACID properties because such a database is almost always inconsistent.
    In the following, we will use the concept Consistency anomalies for the inconsistencies caused by the missing consistency property in distributed integrated databases with relaxed ACID properties.
    In this paper, we will describe countermeasures against the consistency anomalies to make it possible to reduce or prevent the consequences of the missing distributed consistency property. We will also illustrate how to use the countermeasures against the consistency anomalies in ERP systems integrated with heterogeneous E-commerce systems and the databases of mobile salesman ERP modules.
    The methods described in this paper may be used in so called CAP optimization where Availability and Partition-tolerance are optimized on the expense of Consistency
    Original languageEnglish
    Title of host publicationProceedings of the 8th International Conference on Ubiquitous Information Management and Communication
    EditorsDongsoo S. Kim, Sang-Wook Kim
    Number of pages7
    Place of PublicationNew York
    PublisherAssociation for Computing Machinery
    Publication date2014
    Article number30
    ISBN (Print)9781450326445
    DOIs
    Publication statusPublished - 2014
    EventThe 8th International Conference on Ubiquitous Information Management and Communication - Siem Reap, Cambodia
    Duration: 9 Jan 201411 Jan 2014
    Conference number: 8
    http://www.imcom.org/

    Conference

    ConferenceThe 8th International Conference on Ubiquitous Information Management and Communication
    Number8
    CountryCambodia
    CitySiem Reap
    Period09/01/201411/01/2014
    Other(ICUIMC)
    Internet address

    Cite this

    Frank, L., & Ulslev Pedersen, R. (2014). Managing Consistency Anomalies in Distributed Integrated Databases with Relaxed ACID Properties. In D. S. Kim, & S-W. Kim (Eds.), Proceedings of the 8th International Conference on Ubiquitous Information Management and Communication [30] Association for Computing Machinery. https://doi.org/10.1145/2557977.2557982