Melola Discovery

← Melola Discovery

Akses terbuka Jurnal 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) · hlm. 765–775

DOI
10.11591/ijai.v12.i2.pp765-775
ISSN
2252-8938, 2089-4872
Terbit
2023-06-01
Penerbit
Institute of Advanced Engineering and Science
Bahasa
eng
Lisensi
creativecommons.org/licenses/by-sa/4.0

Abstrak

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.

Kata kunci

Jaringan kolaborasi para penulis

14 penulis · 22 tautan kepenulisan bersama · 16 lintas organisasi

Arahkan kursor atau ketuk sebuah nama untuk menyorot rekan penulisnya. Klik dua kali untuk membuka halaman penulis.

  • University of Anbar
  • Al-Qalam University
  • University of Sulaimani
  • University of Tehran
  • University of Samarra
  • Universiti Tenaga Nasional
  • Afiliasi tidak diketahui
  • Organisasi berbeda
  • Organisasi sama
  • Afiliasi tidak diketahui
  • Garis lebih tebal = lebih banyak artikel bersama · lingkaran lebih besar = lebih banyak artikel
Tampilkan sebagai tabel
Rekan penulisOrganisasiArtikel bersama
Hadi VeisiUniversity of Tehran2
Sameeh Abdulghafour JassimAfiliasi tidak diketahui2
Hadeel Mohammed TaherUniversity of Anbar1
Shihab A. Shawkat‎‎University of Samarra1
Ismail Taha AhmedUniversity of Anbar1
Norziana JamilUniversiti Tenaga Nasional1
Baraa Tareq HammadUniversity of Anbar1
Dalia Mohammad ToufiqUniversity of Sulaimani1
Srwa Hasan AbdullaUniversity of Sulaimani1
Farah Maath JasemUniversity of Anbar1
Abdullah M. AwadAl-Qalam University1

Afiliasi berasal dari OpenAlex; metadata OAI-PMH jurnal tidak memuatnya. Penulis tanpa ID OpenAlex dicocokkan berdasarkan nama, sehingga dua orang bisa tergabung atau satu orang bisa terpisah.

Sumber metadata: OAI-PMH (metadata jurnal) http://ijai.iaescore.com/index.php/IJAI/oai, pertama di-harvest 8 Nov 2026, terakhir terlihat 16 Nov 2026.
Metadata asli (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>