Abstract
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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Frank, L., Zahle, T.: Semantic ACID Properties in Multidatabases Using Remote Procedure Calls and Update Propagations. Software - Practice & Experience 28, 77–98 (1998)
Garcia-Molina, H., Polyzois, C.: Issues in disaster recovery. IEEE Compcon, pp. 573–577. IEEE, New York (1990)
Polyzois, C., Garcia-Molina, H.: Evaluation of Remote Backup Algorithms for Transaction-Processing Systems. ACM TODS 19(3), 423–449 (1994)
Gallersdörfer, R., Nicola, M.: Improving Performance in Replicated Databases through Relaxed Coherency. In: Proc. 21st VLDB Conf., pp. 445–455 (1995)
Humborstad, R., Sabaratnam, M., Hvasshovd, S., Torbjornsen, O.: 1-Safe algorithms for symmetric site configurations. In: Proc. 23rd VLDB Conf., pp. 316–325 (1997)
Frank, L.: Evaluation of the Basic Remote Backup and Replication Methods for High Availability Databases. Software - Practice & Experience 29(15), 1339–1353 (1999)
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)
Garcia-Molina, H., Salem, K.: Sagas. In: ACM SIGMOD Conf., pp. 249–259 (1987)
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)
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)
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)
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)
Frank, L.: Architecture for Integration of Distributed ERP Systems and E-commerce Systems. Industrial Management and Data Systems (IMDS) 104(5), 418–429 (2004)
Gray, J., Reuter, A.: Transaction Processing. Morgan Kaufman, San Francisco (1993)
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)
Breibart, Y., Garcia-Molina, H., Silberschatz, A.: Overview of Multidatabase Transaction Management. VLDB Journal 2, 181–239 (1992)
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)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Frank, L. (2006). Architecture for Distributed ERP Systems. In: Draheim, D., Weber, G. (eds) Trends in Enterprise Application Architecture. TEAA 2005. Lecture Notes in Computer Science, vol 3888. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11681885_7
Download citation
DOI: https://doi.org/10.1007/11681885_7
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-32734-9
Online ISBN: 978-3-540-32735-6
eBook Packages: Computer ScienceComputer Science (R0)