p-Index From 2020 - 2025
6.072
P-Index
Claim Missing Document
Check
Articles

Found 1 Documents
Search
Journal : ILKOM Jurnal Ilmiah

Development ETL (Extract, Transform and Load) Module in Indonesian Agricultural Commodities OLAP System Aditia Yudhistira; Imas Sukaesih Sitanggang; Hari Agung Adrianto
ILKOM Jurnal Ilmiah Vol 15, No 2 (2023)
Publisher : Prodi Teknik Informatika FIK Universitas Muslim Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33096/ilkom.v15i2.1758.335-343

Abstract

The SOLAP system for Indonesian Agricultural Commodities is a successful development based on previous studies. Agricultural commodity data are managed in a data warehouse with a galactic schema, which has 7 fact tables, namely cut flower horticulture, ornamental plant horticulture, horticulture, food crops, plantation, livestock population, and livestock production, as well as 3 dimensional tables, namely location, time, and commodity. The results of SOLAP operations on the system can be visualized in the form of crosstabs, graphs and maps. The system uses a web platform so that it can be accessed by the public. However, the SOLAP system cannot update data in real time. This study aims to develop a data warehouse for Indonesian Agricultural Commodities SOLAP in real time by creating a scraping system. This study has succeeded in developing a data warehouse in real time on the indonesian agricultural commodity SOLAP system by creating a real time scraping system that is applied to the SOLAP server and has succeeded in making the ETL process run in real time on the SOLAP server and optimizing polygon-based spatial data visualization using the Douglas-Peucker. This study has also carried out functional testing of OLAP features and functions on the Indonesian Agricultural Commodity SOLAP system using the black box testing method. The results of this study provide accurate and real-time data on the SOLAP of Indonesian Agricultural Commodities, with the results of SOLAP feature testing achieving 100 percent pass and the data conformity test results of OLAP function as expected. In addition, the results of this study make it possible to automatically update the data according to a predetermined schedule to provide real-time information.
Co-Authors -, Rachmawati Abdul Rahman Saleh Abdul Wakhid Aditia Yudhistira Agus Buono Agus Mulyana Agus Purwito Ahmad Khusaeri Albar, Israr Alusyanti Primawati Anak Agung Istri Sri Wiadnyani Andi Nurkholis Andita Wahyuningtyas Anna Qahhariana Annisa Annisa Annisa Annisa Annisa Awal, Elsa Elvira Aziz Kustiyo Baba Barus Badollahi Mustafa Boedi Tjahjono Bramdito, Vandam Caesariadi Despry Nur Annisa Ahmad, Despry Nur Annisa DEWI APRI ASTUTI Dhani Sulistiyo Wibowo Dini Hayati Dwi Purwantoro Sasongko Eddy Prasetyo Nugroho Efendi, Zuliar Erliza Hambali Fakhri Sukma Afina Febriyanti Bifakhlina Firman Ardiansyah Hardhienata, Medria Kusuma Dewi Hari Agung Adrianto Hasibuan, Lailan Sahrina Hefni Effendi Hendra Rahmawan Hendra Rahmawan Herawan, Yoga Heru Sukoco HUSNUL KHOTIMAH I Nengah Surati Jaya Ikhsan kurniawan Irman Hermadi Ivan Maulana Putra Khairani Krisnanto, Ferdian Kurnianto, Andi Lailan Syaufina Lilis Syarifah Luki Abdullah Medria Kusuma Dewi Hardhienata Miftah Farid Mohammad, Farid mufti, abdul Muhammad Abrar Istiadi Muhammad Asyhar Agmalaro Muhammad Murtadha Ramadhan Nalar Istiqomah Nia Kurniati Peggy Antonette Soplantila Prasetyo Nugroho, Eddy Pudji Muljono Purwanti , Endang Yuni Purwanti, Endang Yuni Putra, Fiqhri Mulianda Raden Fityan Hakim Raharja, Aditya Cipta Ramadhan, Jeri Rd. Zainal Frihadian Ridwan Raafi'udin Rina Trisminingsih Risa Intan Komaraasih Rizki, Yoze Safrudin, Muhammad Safrul Sakti, Harry Hardian Santoso, Angga Bayu Satyawan, Verda Emmelinda Shelvie Nidya Neyman Sobir Sobir Sonita Veronica Br Barus Sonita Veronica Br Barus Sony Hartono Wijaya Suci Indrawati Irwan Sulistyo Basuki Suradiradja, Kahfi Heryandi Suria Darma Tarigan Surjono Hadi Sutjahjo Syarifah Aini Taihuttu, Helda Yunita Taufik Djatna Taufik Hidayat Tenda, Edwin Tiurma Lumban Gaol Toto Haryanto Trisminingsih, Rina Unik, Mitra Wa Ode Rahma Agus Udaya Manarfa Wattimena, Emanuella M C Wisnu Ananta Kusuma Wulandari WULANDARI Yenni Puspitasari Yoanda, Sely