USING DATA REPLICATION TECHNIQUES TO MAINTAIN DATA CONSISTENCY IN SUPPLY CHAIN APPLICATIONS

George Feuerlicht, Richard White, Glen MacLarty

2006

Abstract

Supply chain applications typically involve sharing of large amounts of information across a number of partner organizations. Examples of supply chain applications are common in manufacturing, healthcare and global trade. Such applications can involve a large number of partners in different locations with various levels of connectivity, ranging from high-speed Internet to unreliable and slow dial-up connections. Maintaining data consistency in supply chain applications is an essential requirement as the loss of data consistency results in poor quality and unreliable information. Current supply chain applications mostly rely on EDI (Electronic Data Interchange) or similar electronic messaging standards to ship data between partner organizations. In general, little attention is paid to ensuring that data remains consistent as it is propagated and updated along the supply chain. In this paper we first discuss the requirements for data consistency in supply chain applications and then briefly describe a data consistency management framework based on data replication. We use Freight Forwarding and Customs Brokerage (FFCB) applications examples to illustrate our discussion.

References

  1. Ball, M. O. Meng Ma, Louiqa Raschid, Zhengying Zhao, 2002, Supply Chain Infrastructures: System Integration and Information Sharing. SIGMOD Record 31(1): 61-66
  2. Buretta, M. Data Replication, Tools and Techniques for Managing Distributed Information, Wiley Computer Publishing, ISBN 0-471-15754-6, 1997
  3. Ceri S. and Pelagatti G., Distributed Databases: Principles & Systems, McGraw Hill, 1985.
  4. Elgarah, W., Falaleeva, N., Saunders, C. C., Ilie, V., Shim, J. T., and Courtney, J. F. 2005. Data exchange in interorganizational relationships: review through multiple conceptual lenses. SIGMIS Database 36, 1 (Feb. 2005), pages 8-29. http://doi.acm.org/10.1145/1047070.1047073
  5. Feuerlicht, G. (2004) Maintaining Data Consistency in Complex Replication Environments, Industry Link Seeding Project, University of Technology, Sydney, Eagle Datamation International (EDI), 2003-2004.
  6. Hirsch, R., Coratella, A., Felder, M., & Rodriguez, E. (2001) A Framework for Analyzing Mobile Transaction Models. Journal of Database Management, Vol. 12, No. 3, pp. 36-47.
  7. Jain, S., Choong, N. F., and Lee, W. 2002. Manufacturing supply chain applications: Modeling computer assembly operations for supply chain integration. In Proceedings of the 34th Conference on Winter Simulation: Exploring New Frontiers (San Diego, California, December 08 - 11, 2002). Winter Simulation Conference. Winter Simulation Conference, 1165-1173. Year of Publication: 2002, ISBN:0-7803-7615-3
  8. Johnston, D. B. 2003, The Next Generation in Application Architecture: Occasionally Connected Computing [Online]. Available: http://crm.ittoolbox.com/documents/document.asp?i=3 260 [Accessed 23rd July 2004].
  9. Liu, P. and Hsieh, Y. , 2005. A study based on the value system for the interaction of the multi-tiered supply chain under the trend of e-business. In Proceedings of the 7th international Conference on Electronic Commerce (Xi'an, China, August 15 - 17, 2005). ICEC 7805, vol. 113. ACM Press, New York, NY, 385- 392. http://doi.acm.org/10.1145/1089551.1089623
  10. Madria, S. K., Bhargava, B. K. "A Transaction Model to Improve Data Availability in Mobile Computing", Distributed and Parallel Databases, 10(2): 127-160, 2001.
  11. Noble, Brian D. Mobile Data Access, PhD Thesis, School of Computer Science, Carnegie Mellon University, Pittsburgh, PA 15213, May 11, 1998, CMU-CS-98- 118
  12. Pitoura, E. & Bhargava, B. 1999, 'Data Consistency in Intermittently Connected Distributed Systems', IEEE Transactions on Knowledge and Data Engineering, vol. 11, no. 6, pp. 896-915.
  13. Sandberg, R., Goldberg, D., Kleiman, S., Walsh, D., Lyon, B. Design and Implementation of the Sun Network Filesystem. Summer Usenix Conference Proceedings. 1985.
  14. Satyanarayanan, M., Kistler, J., Mummert, L., Ebling, M., Kumar, P., Lu, Q. Experience with disconnected operation in a mobile environment. In Proceedings of USENIX Symposium on Mobile LocationIndependent Computing (Cambridge, Massachusetts, August 1993)
  15. Steen, V., Tanenbaum, S. Distributed Systems: Principles and Paradigms, Prentice Hall; January 15, 2002, ISBN: 0130888931
  16. Terry, D. B. M. M. Theimer, K. Petersen, A. J. Demers, M. J. Spreitzer, and C. H. Hauser, (1995) "Managing update conflicts in Bayou, a weakly connected replicated storage system," in Proceedings of the 15th Symposium on Operating Systems Principles, Copper Mountain Resort, Colorado, December 1995, ACM, number 22, pp. 172--183.
  17. Urbano, R. 2003, Oracle Database Advanced Replication, 10g Release 1 (10.1), Oracle Corporation, Redwood City, CA.
  18. Woodward, L. B., 2003, Annual Report 2002 - 03, Australian Customs Service, Canberra.
  19. Xiao Qin and Hong Jiang, Data Grid: Supporting DataIntensive applications in Wide-Area Networks, Technical Report No. TR-03-05-01, May 2003, University of Nebraska-Lincoln, NE 68588-0115
Download


Paper Citation


in Harvard Style

Feuerlicht G., White R. and MacLarty G. (2006). USING DATA REPLICATION TECHNIQUES TO MAINTAIN DATA CONSISTENCY IN SUPPLY CHAIN APPLICATIONS . In Proceedings of the International Conference on e-Business - Volume 1: ICE-B, (ICETE 2006) ISBN 978-972-8865-62-7, pages 209-214. DOI: 10.5220/0001429102090214


in Bibtex Style

@conference{ice-b06,
author={George Feuerlicht and Richard White and Glen MacLarty},
title={USING DATA REPLICATION TECHNIQUES TO MAINTAIN DATA CONSISTENCY IN SUPPLY CHAIN APPLICATIONS},
booktitle={Proceedings of the International Conference on e-Business - Volume 1: ICE-B, (ICETE 2006)},
year={2006},
pages={209-214},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001429102090214},
isbn={978-972-8865-62-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the International Conference on e-Business - Volume 1: ICE-B, (ICETE 2006)
TI - USING DATA REPLICATION TECHNIQUES TO MAINTAIN DATA CONSISTENCY IN SUPPLY CHAIN APPLICATIONS
SN - 978-972-8865-62-7
AU - Feuerlicht G.
AU - White R.
AU - MacLarty G.
PY - 2006
SP - 209
EP - 214
DO - 10.5220/0001429102090214