IAES International Journal of Artificial Intelligence (IJ-AI)
Vol 12, No 2: June 2023

Design and implementation of the web (extract, transform, load) process in data warehouse application

Seddiq Q. Abd Al-Rahman (University of Anbar)
Ekram H. Hasan (University of Anbar)
Ali Makki Sagheer (University of Anbar)



Article Info

Publish Date
01 Jun 2023

Abstract

Recently, due to an increase size and complexity of data in addition to the management issues, data storage is required a great deal of attention to employ it in realistic applications, so the requirement for designing and implementing a data warehouse system has become an urgent necessity, ETL represents a vital side of data warehouse architecture. This paper, designed data warehouse application contains a web ETL process that divides its work between the input device and server. This system proposed to solve the problem lack of partition of the work between the input device and server. The proposed and designed system can be used and applied in many branches and disciplines for its high performance in adding data, analyzing data using a web server and building queries. The analysis of the results has been proven that a faster time is achieved in cleaning data and transferring it between the remote parts of the system connected to the Internet. Where ETL without Missing for any data took 0.00582 seconds.

Copyrights © 2023






Journal Info

Abbrev

IJAI

Publisher

Subject

Computer Science & IT Engineering

Description

IAES International Journal of Artificial Intelligence (IJ-AI) publishes articles in the field of artificial intelligence (AI). The scope covers all artificial intelligence area and its application in the following topics: neural networks; fuzzy logic; simulated biological evolution algorithms (like ...