A Multi-Agent Framework for Data Extraction,Transformation and Loading in Data Warehouse

Abstract

The rapid growth in size of data sets poses chal-lenge to extract and analyze information in timely manner for better prediction and decision making. Data warehouse is the solution for strategic decision making. Data warehouse serves as a repository to store historical and current data. Extraction, Transformation and Loading (ETL) process gather data from different sources and integrate it into data warehouse. This paper proposes a multi-agent framework that enhance the efficiency of ETL process. Agents perform specific task assigned to them. The identification of errors at different stages of ETL process become easy. This was difficult and time consuming in traditional ETL process. Multi-agent framework identify data sources, extract, integrate, transform, and load data into data warehouse. A monitoring agent remains active during this process and generate alerts if there is issue at any stage.

Authors and Affiliations

Ramzan Talib, Muhammad Kashif Hanif, Fakeeha Fatima, Shaeela Ayesha

Keywords

Related Articles

Abnormalities Detection in Digital Mammography Using Template Matching

Breast cancer affects 1 in 8 women in the United States. Early detection and diagnosis is key to recovery. Computer-Aided Detection (CAD) of breast cancer helps decrease morbidity and mortality rates. In this study we ap...

The Role of Camera Convergence in Stereoscopic Video See-through Augmented Reality Displays

In the realm of wearable augmented reality (AR) systems, stereoscopic video see-through displays raise issues related to the user’s perception of the three-dimensional space. This paper seeks to put forward few considera...

Analysis of Coauthorship Network in Political Science using Centrality Measures

In recent era, networks of data are growing massively and forming a shape of complex structure. Data scientists try to analyze different complex networks and utilize these networks to understand the complex structure of...

Secure Deletion of Data from SSD

The deletion of data from storage is an important component on data security. The deletion of entire disc or special files is well-known on hard drives, but this is quite different on SSDs, because they have a different...

Digital Certificate Exchange of Agricultural Products using SOAP Web Services

Developing countries have continued to experience a number of challenges in managing import and export certificate for various goods. In this paper, we are proposing a model for digital certificate exchange in an effort...

Download PDF file
  • EP ID EP397053
  • DOI 10.14569/IJACSA.2016.071146
  • Views 130
  • Downloads 0

How To Cite

Ramzan Talib, Muhammad Kashif Hanif, Fakeeha Fatima, Shaeela Ayesha (2016). A Multi-Agent Framework for Data Extraction,Transformation and Loading in Data Warehouse. International Journal of Advanced Computer Science & Applications, 7(11), 351-354. https://europub.co.uk/articles/-A-397053