SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
Concepts and applications of multilevel transactions and open nested transactions
Database transaction models for advanced applications
Evaluation of remote backup algorithms for transaction-processing systems
ACM Transactions on Database Systems (TODS)
Ensuring relaxed atomicity for flexible transactions in multidatabase systems
SIGMOD '94 Proceedings of the 1994 ACM SIGMOD international conference on Management of data
A critique of ANSI SQL isolation levels
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
Semantic ACID properties in multidatabases using remote procedure calls and update propagations
Software—Practice & Experience
Evaluation of the basic remote backup and replication methods for high availability databases
Software—Practice & Experience
Overview of multidatabase transaction management
The VLDB Journal — The International Journal on Very Large Data Bases
1-Safe Algorithms for Symmetric Site Configurations
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Improving Performance in Replicated Databases through Relaxed Coherency
VLDB '95 Proceedings of the 21th International Conference on Very Large Data Bases
Hi-index | 0.00 |
In a distributed ERP (Enterprise Resource Planning) system, the different local ERP systems are integrated in such a way that each local system can use the resources/stocks managed by the other local ERP systems. Businesses with branch offices may derive great benefits from such systems. In theory, such a system can be built by using a distributed DBMS (Data Base Management System). However, distributed DBMSs are not used in practice as e.g. performance and local autonomy are low. In distributed databases with relaxed ACID properties (Atomicity, Consistency, Isolation, and Durability), it is possible to optimize performance, local autonomy, and availability by using short duration locking. In such systems, data is not locked across locations, i.e. data is not locked across a dialog with a user, and replicated data must be updated asynchronously. In this paper, we will describe how it is possible to design a distributed ERP system by using databases with relaxed ACID properties. The techniques described are general in the sense that most package software run on separate computers may be integrated by using the same methods. The author has cooperated with one of the major ERP software companies in analyzing how the company can design such a distributed version of their ERP system.