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.


Primary Copy Transaction Model Local Autonomy Site Failure Branch Office 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Frank, L., Zahle, T.: Semantic ACID Properties in Multidatabases Using Remote Procedure Calls and Update Propagations. Software - Practice & Experience 28, 77–98 (1998)CrossRefGoogle Scholar
  2. 2.
    Garcia-Molina, H., Polyzois, C.: Issues in disaster recovery. IEEE Compcon, pp. 573–577. IEEE, New York (1990)Google Scholar
  3. 3.
    Polyzois, C., Garcia-Molina, H.: Evaluation of Remote Backup Algorithms for Transaction-Processing Systems. ACM TODS 19(3), 423–449 (1994)CrossRefGoogle Scholar
  4. 4.
    Gallersdörfer, R., Nicola, M.: Improving Performance in Replicated Databases through Relaxed Coherency. In: Proc. 21st VLDB Conf., pp. 445–455 (1995)Google Scholar
  5. 5.
    Humborstad, R., Sabaratnam, M., Hvasshovd, S., Torbjornsen, O.: 1-Safe algorithms for symmetric site configurations. In: Proc. 23rd VLDB Conf., pp. 316–325 (1997)Google Scholar
  6. 6.
    Frank, L.: Evaluation of the Basic Remote Backup and Replication Methods for High Availability Databases. Software - Practice & Experience 29(15), 1339–1353 (1999)CrossRefGoogle Scholar
  7. 7.
    Frank, L., Kofod, U.: Atomicity Implementation in E-Commerce Systems. In: Proc. of the Second International Conference on Electronic Commerce, ICEB 2002, Taipei, pp. 381–383 (2002)Google Scholar
  8. 8.
    Garcia-Molina, H., Salem, K.: Sagas. In: ACM SIGMOD Conf., pp. 249–259 (1987)Google Scholar
  9. 9.
    Mehrotra, S., Rastogi, R., Korth, H., Silberschatz, A.: A transaction model for multi-database systems. In: Proc. International Conference on Distributed Computing Systems, pp. 56–63 (1992)Google Scholar
  10. 10.
    Weikum, G., Schek, H.: Concepts and Applications of Multilevel Transactions and Open Nested Transactions. In: Elmagarmid, A. (ed.) Database Transaction Models for Advanced Applications, pp. 515–553. Morgan Kaufmann, San Francisco (1992)Google Scholar
  11. 11.
    Zhang, A., Nodine, M., Bhargava, B., Bukhres, O.: Ensuring Relaxed Atomicity for Flexible Transactions in Multidatabase Systems. In: Proc. ACM SIGMOD Conf., pp. 67–78 (1994)Google Scholar
  12. 12.
    Frank, L.: Replication Methods and Their Properties. In: Rivero, L.C., Doorn, J.H., Ferraggine, V.E. (eds.) Encyclopedia of Database Technologies and Applications. Idea Group Inc. (2005)Google Scholar
  13. 13.
    Frank, L.: Architecture for Integration of Distributed ERP Systems and E-commerce Systems. Industrial Management and Data Systems (IMDS) 104(5), 418–429 (2004)CrossRefGoogle Scholar
  14. 14.
    Gray, J., Reuter, A.: Transaction Processing. Morgan Kaufman, San Francisco (1993)zbMATHGoogle Scholar
  15. 15.
    Berenson, H., Bernstein, P., Gray, J., Melton, J., O’Neil, E., O’Neil, P.: A Critique of ANSI SQL Isolation Levels. In: Proc. ACM SIGMOD Conf., pp. 1–10 (1995)Google Scholar
  16. 16.
    Breibart, Y., Garcia-Molina, H., Silberschatz, A.: Overview of Multidatabase Transaction Management. VLDB Journal 2, 181–239 (1992)CrossRefGoogle Scholar
  17. 17.
    Frank, L.: Databases with Relaxed ACID Properties, a doctoral thesis submitted for the Dr. Merc. degree, Copenhagen Business School. The thesis will probably be accepted and published in (2006)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Lars Frank
    • 1
  1. 1.Department of InformaticsCopenhagen Business SchoolFrederiksbergDenmark

Personalised recommendations