Cloud computing based ETL technique using Warehouse Intermediate Agents

The decentralized and distributed business management increases the need to trade information between different parties. The aim of this research is to provide a technique that enables data integration using ETL technique in a cloud computing environment to be offered as a service. This enables scalability and cost saving. The technique developed is based on Warehouse Intermediate Agents (WIA) to consider the security and the privacy of data stored and transmitted. WIA also provides a generic extraction technique that can get data from heterogeneous data sources. It allows the broadcasting and multi-mapping of the detected changes in data and ensures reliable loading of the transformed data into the destination. Using a set of interacting WIA´s, we can build a distributed cloud data warehouse based on data extracted and stored at each agent.