Open access
Journal
SINTA 1
Design and implementation of the web (extract, transform, load) process in data warehouse application
IAES International Journal of Artificial Intelligence · Vol. 12 No. 2 (2023) · pp. 765–775
ISSN 2252-8938, 2089-4872
Published 2023-06-01
Publisher Institute of Advanced Engineering and Science
Language eng
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.
Collaboration network of the authors
14 authors ·
22 co-authorship links
· 16 across different organisations
Hover or tap a name to highlight its co-authors. Double-click to open the author's page.
University of Anbar Al-Qalam University University of Sulaimani University of Tehran University of Samarra Universiti Tenaga Nasional Affiliation unknown
Different organisations
Same organisation
Affiliation unknown
Thicker line = more joint articles · bigger circle = more articles
Show as table
Affiliations come from OpenAlex; journal OAI-PMH metadata carries none. Authors without an OpenAlex ID are matched by name, which can merge or split people.
Metadata source: OAI-PMH (metadata jurnal) http://ijai.iaescore.com/index.php/IJAI/oai, first harvested 8 Nov 2026, last seen 16 Nov 2026.
Original metadata (oai_dc)
<oai_dc:dc xmlns="http://www.openarchives.org/OAI/2.0/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.openarchives.org/OAI/2.0/oai_dc/ http://www.openarchives.org/OAI/2.0/oai_dc.xsd">
<dc:title xml:lang="en-US">Design and implementation of the web (extract, transform, load) process in data warehouse application</dc:title>
<dc:creator>Abd Al-Rahman, Seddiq Q.</dc:creator>
<dc:creator>Hasan, Ekram H.</dc:creator>
<dc:creator>Sagheer, Ali Makki</dc:creator>
<dc:subject xml:lang="en-US">Data Warehouse; Web ETL</dc:subject>
<dc:subject xml:lang="en-US">Data warehouse; Dirty data; Fact table; Interim table; Web (extract, transform, load)</dc:subject>
<dc:description xml:lang="en-US">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.</dc:description>
<dc:publisher xml:lang="en-US">Institute of Advanced Engineering and Science</dc:publisher>
<dc:contributor xml:lang="en-US"></dc:contributor>
<dc:date>2023-06-01</dc:date>
<dc:type>info:eu-repo/semantics/article</dc:type>
<dc:type>info:eu-repo/semantics/publishedVersion</dc:type>
<dc:type xml:lang="en-US"></dc:type>
<dc:format>application/pdf</dc:format>
<dc:identifier>https://ijai.iaescore.com/index.php/IJAI/article/view/21511</dc:identifier>
<dc:identifier>10.11591/ijai.v12.i2.pp765-775</dc:identifier>
<dc:source xml:lang="en-US">IAES International Journal of Artificial Intelligence (IJ-AI); Vol 12, No 2: June 2023; 765-775</dc:source>
<dc:source>2252-8938</dc:source>
<dc:source>2089-4872</dc:source>
<dc:source>10.11591/ijai.v12.i2</dc:source>
<dc:language>eng</dc:language>
<dc:relation>https://ijai.iaescore.com/index.php/IJAI/article/view/21511/13642</dc:relation>
<dc:rights xml:lang="en-US">Copyright (c) 2022 Institute of Advanced Engineering and Science</dc:rights>
<dc:rights xml:lang="en-US">http://creativecommons.org/licenses/by-sa/4.0</dc:rights>
</oai_dc:dc>
Citations and indexing
OpenAlex
Indexed
via DOI
8 citations
Crossref
Indexed
via DOI
5 citations
Counts as reported by each index on 13 Nov 2026; indexes count citations differently.
OpenAlex also lists this work in: crossref.
Cite this article
APA 7
Abd Al-Rahman, S. Q., Hasan, E. H., & Sagheer, A. M. (2023). Design and implementation of the web (extract, transform, load) process in data warehouse application. IAES International Journal of Artificial Intelligence, 12(2), 765–775. https://doi.org/10.11591/ijai.v12.i2.pp765-775
Copy
IEEE
S. Q. Abd Al-Rahman, E. H. Hasan, and A. M. Sagheer, “Design and implementation of the web (extract, transform, load) process in data warehouse application,” IAES International Journal of Artificial Intelligence, vol. 12, no. 2, pp. 765–775, 2023, doi: 10.11591/ijai.v12.i2.pp765-775.
Copy
Generated from the journal's metadata; check author names before use.