Integration of Heterogeneous Distributed Database Based on E-Commerce System

Vinit Nimkar , Kazi FakirMohammed, Sushopti Gawde

Abstract

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.