Architecture for Distributed ERP Systems
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.
KeywordsPrimary Copy Transaction Model Local Autonomy Site Failure Branch Office
Unable to display preview. Download preview PDF.
- 2.Garcia-Molina, H., Polyzois, C.: Issues in disaster recovery. IEEE Compcon, pp. 573–577. IEEE, New York (1990)Google Scholar
- 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.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
- 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.Garcia-Molina, H., Salem, K.: Sagas. In: ACM SIGMOD Conf., pp. 249–259 (1987)Google Scholar
- 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.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.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.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
- 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
- 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