Integration of Heterogeneous Distributed Database Based on E-Commerce System
Vinit Nimkar , Kazi FakirMohammed, Sushopti Gawde
The rapid expansion of internet systems, ease of availability and so on reduction in operating costs, and spread of internet access have created colossal of electronic data. The disseminate nature of our internet system and databases, however, has resulted in a hodgepodge of diverse, heterogeneous, database implementations, making access to and gathering and combining of data across databases very difficult. The diacritic technologies used to make the integration are familiar. But our objective here it is the inaugural description of these technologies are presented together in well-organized to give a synopsis of how it is probable to collaborate different internet systems with purport relaxed ACID properties. The ACID (Atomicity, Consistency, Isolation and Durability) properties of a database are properties used (Data Base Management System) to make database recovery easier and make it possible in a multi user environment to give concurrent transactions a consistent chronological view of the data in the database. Therefore, the ACID properties are important. However in case of heterogeneous databases and there integration, the ACID properties may slow down the performance and the response time of the system. In many situations, the performance and the response time will be unacceptable if the ACID properties are implied on the heterogeneous databases. Hence in many real time application or business standards slow response and performance is not acceptable and needs to be optimized. Consequently, we will in this paper use relaxed ACID properties across different database. The objective of designing relaxed ACID properties across different database are to give the users a perspective that the data that may be inconsistent across various database but in practice functions as if the traditional ACID properties were implemented so that users can be assured about the data they are using. In this paper, we will collaborate the ERP systems of the customers of an e-commerce website with the e-commerce system of the suppliers as an example. Despite the fact, the integration architecture or the conceptual design model proposed in this paper may for example also be used for collaborating airline systems, hospitality system, educational systems etc.
 Breibart, Y., Garcia-Molina, H. and Silberschatz, A., 1992, “Overview of Multidatabase Transaction Management”, VLDB Journal, 2, pp 181-239.
 Berenson, H., Bernstein, P., Gray, J., Melton, J., O’Neil, E. and O’Neil, P., 1995, “A Critique of ANSI SQL Isolation Levels”, Proc ACM SIGMOD Conf., pp. 1-10.
Frank, L, 2010, Design of Distributed Integrated Heterogeneous or Mobile Databases, LAP LAMBERT Academic Publishing AG & Co. KG, Germany, ISBN 978-3-8383-4426-3, pp 1-157.
Frank, L. and Zahle, T, 1998, “Semantic ACID Properties in Multidatabases Using Remote Procedure Calls and Update Propagations”, Software - Practice & Experience, Vol.28, pp77-98.
Gray, J. and Reuter, A., 1993, “Transaction Processing”, Morgan Kaufman, 1993.
Garcia-Molina, H. and Salem, K., 1987, “Sagas”, ACM SIGMOD Conf, pp 249-259.
Mehrotra, S., Rastogi, R., Korth, H., and Silberschatz, A., 1992, “A transaction model for multi-database systems”, Proc International Conference on Distributed Computing Systems, pp 56-63.
Weikum, G. and Schek, H., 1992, “Concepts and Applications of Multilevel Transactions and Open Nested Transactions”, A. Elmagarmid (ed.): Database Transaction Models for Advanced Applications, Morgan Kaufmann, pp 515-553.
Zhang, A., Nodine, M., Bhargava, B. and Bukhres, O., 1994, “Ensuring Relaxed Atomicity for Flexible Transactions in Multidatabase Systems”, Proc ACM SIGMOD Conf, pp 67-78.
[Vinit Nimkar , Kazi FakirMohammed, Sushopti Gawde (2015), Integration of Heterogeneous Distributed Database Based on E-Commerce System , International Journal of Innovative Research in Computer Science & Technology (IJIRCST), Vol-3, Issue-1, Page No-27-30], (ISSN 2347 - 5552). www.ijircst.org
Information Technology, Pillai’s Institute of Information Technology, Mumbai, India, Mob No: 9773294378