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 language | English |
---|---|
Title of host publication | Proceedings of the 34th Annual Hawaii International Conference on System Sciences, HICSS 2001 |
Editors | Ralph H. Sprague Jr. |
Number of pages | 7 |
Place of Publication | Los Alamitos, CA |
Publisher | IEEE |
Publication date | 2001 |
ISBN (Print) | 0769509819 |
DOIs | |
Publication status | Published - 2001 |
Event | The 34th Hawaii International Conference on System Sciences. HICSS 2001 - Island of Maui, Hawaii, United States Duration: 3 Jan 2001 → 6 Jan 2001 Conference number: 34 |
Conference
Conference | The 34th Hawaii International Conference on System Sciences. HICSS 2001 |
---|---|
Number | 34 |
Country/Territory | United States |
City | Island of Maui, Hawaii |
Period | 03/01/2001 → 06/01/2001 |
Series | Proceedings of the Annual Hawaii International Conference on System Sciences |
---|---|
ISSN | 1060-3425 |
Keywords
- E-commerce
- ERP
- Replication methods
- Database availability
- High performance
- Multidatabases
- Approximated ACID properties