Data Pipeline Engineering untuk LSTM Forecasting Seismisitas Melalui Integrasi Proses ETL Katalog Gempa Indonesia

Dewa Gde Agung Wisnu Anantha ; I Wayan Sudiarsa ; I Kadek Adi Erawan ; I Ketut Okta Suastika ; Gde Wardika Nugraha
Merkurius : Jurnal Riset Sistem Informasi dan Tekn... 📅 2026 Vol 4, No 1 🔗 DOI: 10.61132/merkurius.v4i1.1426
Abstract
Indonesia, as a country with the highest seismicity in the world, requires an accurate earthquake prediction system through the use of the BMKG earthquake catalogue. This research aims to implement ETL-based data pipeline engineering to process 92,887 earthquake catalog entries for the 2008-2023 period into ready-to-use daily time series for the LSTM seismicity forecasting model. The ETL process includes raw data extraction, cleaning of 97% missing values columns on focal mechanism parameters, datetime conversion, daily resampling producing 5,200 entries with earthquake count, total magnitude, and average magnitude features, as well as Min-Max Scaler normalization for LSTM compatibility. The dataset was processed using Google Colab with a stacked LSTM architecture of two layers of 50 and 25 units, dropout 0.2, Adam optimizer, and a sequence window of 30 days to predict the daily earthquake count. The model trained for 100 epochs shows the ability to capture stable seismic activity trends with a consistent decrease in MSE loss, although it shows deviations in extreme spikes due to aftershock sequences. The ETL pipeline proved crucial in ensuring temporal consistency, 100% data completeness, and relevant physics representation, resulting in a reproducible end-to-end framework for disaster mitigation.
Keywords
Data Pipeline; Earthquake Catalog; ETL; LSTM; Seismicity Forecasting
How to Cite

Dewa Gde Agung Wisnu Anantha, et al. (2026). Data Pipeline Engineering untuk LSTM Forecasting Seismisitas Melalui Integrasi Proses ETL Katalog Gempa Indonesia. Merkurius : Jurnal Riset Sistem Informasi dan Teknik Informatika, 4(1). https://doi.org/10.61132/merkurius.v4i1.1426

Dewa Gde Agung Wisnu Anantha; I Wayan Sudiarsa; I Kadek Adi Erawan; I Ketut Okta Suastika; Gde Wardika Nugraha, "Data Pipeline Engineering untuk LSTM Forecasting Seismisitas Melalui Integrasi Proses ETL Katalog Gempa Indonesia," Merkurius : Jurnal Riset Sistem Informasi dan Teknik Informatika, vol. 4, no. 1, 2026.

Dewa Gde Agung Wisnu Anantha; I Wayan Sudiarsa; I Kadek Adi Erawan; I Ketut Okta Suastika; Gde Wardika Nugraha. "Data Pipeline Engineering untuk LSTM Forecasting Seismisitas Melalui Integrasi Proses ETL Katalog Gempa Indonesia." Merkurius : Jurnal Riset Sistem Informasi dan Teknik Informatika, vol. 4, no. 1, 2026.

Dewa Gde Agung Wisnu Anantha; I Wayan Sudiarsa; I Kadek Adi Erawan; I Ketut Okta Suastika; Gde Wardika Nugraha. "Data Pipeline Engineering untuk LSTM Forecasting Seismisitas Melalui Integrasi Proses ETL Katalog Gempa Indonesia." Merkurius : Jurnal Riset Sistem Informasi dan Teknik Informatika 4, no. 1 (2026).

Dewa Gde Agung Wisnu Anantha, et al. (2026) 'Data Pipeline Engineering untuk LSTM Forecasting Seismisitas Melalui Integrasi Proses ETL Katalog Gempa Indonesia', Merkurius : Jurnal Riset Sistem Informasi dan Teknik Informatika, 4(1). doi: 10.61132/merkurius.v4i1.1426.

Dewa Gde Agung Wisnu Anantha; I Wayan Sudiarsa; I Kadek Adi Erawan; I Ketut Okta Suastika; Gde Wardika Nugraha. Data Pipeline Engineering untuk LSTM Forecasting Seismisitas Melalui Integrasi Proses ETL Katalog Gempa Indonesia. Merkurius : Jurnal Riset Sistem Informasi dan Teknik Informatika. 2026;4(1).

Artikel Terkait

Penerapan Pola dan Tren Penggunaan Instrumen Evaluasi Usability (SUS, UEQ, HE) pada Sistem Digital

Moh.Eri Ramadhan Ghifari; Fathoni Mahardika; Dani Indra Junaedi; Asep Saeppani

Analisis Kepuasan Pengguna Terhadap Layanan Wi-Fi Publik di Lingkungan Sekolah Tinggi Agama Katolik Negeri Pontianak

Indra Kristanto; Widiarina Widiarina; Bambang Junadi

Penentuan Rute Terpendek Pengiriman Barang pada PT AMSA menggunakan Algoritma Dijkstra

Millennanda Dwi Cahya; Bondan Dwi Hatmoko; Irwan Agus

Peran Sistem Informasi Manajemen dalam Pengelolaan Data Jamaah Umrah: Kajian Literatur Sistematis

Sabila Sabila; Dellia Dellia; Nadiya Nadiya; Latifa Latifa; Zainal Abidin

Analisis Sentimen Pengguna YouTube terhadap Game Mobile menggunakan Metode Naïve Bayes

Aura Rahayu Aksa Radiana; Fathoni Mahardika; Dani Indra Junaedi

Analisis Sentimen Pelanggan UMKM di Media Sosial Menggunakan Naive Bayes untuk Menilai Persepsi Kualitas Produk

Ayu Astuti Siregar; Al-Khowarizmi
Tren Sitasi Jurnal