Electronic Commerce: Using Distributed ERP-systems with Approximated ACID Properties

Lars Frank

    Research output: Chapter in Book/Report/Conference proceedingArticle in proceedingsResearch

    Abstract

    The article compares and evaluates the properties of some of the most important replication designs with the properties of the no-replication design. The table designs will, for example, be compared with respect to their availability, performance, implementation problems, failure/disaster recovery and ACID properties (Atomicity, Consistency, Isolation and Durability). By using the evaluation, it is possible to design distributed databases/multidatabases that for each table use the most inexpensive table design, fulfilling the needs of application. Most of the replication designs that may be used to optimize performance and availability have only approximated or semantic ACID properties, i.e. from an application point of view, the system functions as if all the traditional ACID properties were implemented. But in reality, the designers have used countermeasures against the problems that occur when only local ACID properties are used in the execution of global transactions. We have cooperated with one of the major ERP (enterprise resource planning) software companies in designing a distributed version of the ERP system with local autonomous databases in the different sales and/or store locations. An e-commerce server can be viewed as a sales location with or without its own store. Therefore, an e-commerce system can be viewed as a special case of a distributed ERP system, and if the e-commerce server should fail, any of the other sales locations may function as a hot backup.
    Original languageEnglish
    Title of host publicationProceedings of the 34th Annual Hawaii International Conference on System Sciences, HICSS 2001
    EditorsRalph H. Sprague Jr.
    Number of pages7
    Place of PublicationLos Alamitos, CA
    PublisherIEEE
    Publication date2001
    ISBN (Print)0769509819
    DOIs
    Publication statusPublished - 2001
    EventThe 34th Hawaii International Conference on System Sciences. HICSS 2001 - Island of Maui, Hawaii, United States
    Duration: 3 Jan 20016 Jan 2001
    Conference number: 34

    Conference

    ConferenceThe 34th Hawaii International Conference on System Sciences. HICSS 2001
    Number34
    Country/TerritoryUnited States
    CityIsland of Maui, Hawaii
    Period03/01/200106/01/2001
    SeriesProceedings of the Annual Hawaii International Conference on System Sciences
    ISSN1060-3425

    Keywords

    • E-commerce
    • ERP
    • Replication methods
    • Database availability
    • High performance
    • Multidatabases
    • Approximated ACID properties

    Cite this