Article Per Year (5 Year)
p-Index From 2020 - 2025
0.408
P-Index
This Author published in this journals
All Journal Sistemasi: Jurnal Sistem Informasi Jurnal Pendidikan dan Teknologi Indonesia
Dijerja, Gahara
Unknown Affiliation
Computer Science & IT Education Electrical & Electronics Engineering Engineering

Published : 2 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 2 Documents
Search

 1 
Analisis Perbandingan Response Time View dan Materialized View pada Database Oracle dalam Treasury Big Data DJPb Kemenkeu Dijerja, Gahara; Soepriadi, Raden; Samidi, Samidi
Jurnal Pendidikan dan Teknologi Indonesia Vol 5 No 2 (2025): JPTI - Februari 2025
Publisher : CV Infinite Corporation

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.52436/1.jpti.671

Abstract

Pengelolaan data dalam volume besar, seperti pada sistem Treasury Direktorat Jenderal Perbendaharaan (DJPb) Kementerian Keuangan, memerlukan teknik optimasi yang efektif untuk memastikan kinerja sistem yang optimal. Penelitian ini bertujuan membandingkan waktu respons antara penggunaan View dan Materialized View pada database Oracle dalam konteks Big Data DJPb. Berdasarkan eksperimen yang dilakukan, Materialized View memberikan peningkatan signifikan dalam kecepatan query, terutama untuk query yang kompleks dan berulang. Walaupun membutuhkan biaya penyimpanan tambahan dan pemeliharaan yang lebih tinggi, teknik ini terbukti lebih efisien dalam mendukung kebutuhan akses data yang cepat dan sering. Penelitian ini memberikan rekomendasi praktis untuk meningkatkan efisiensi pengelolaan Treasury Big Data dalam sistem keuangan negara, terutama dalam memilih teknik optimasi basis data yang sesuai. Implementasi Materialized View diharapkan dapat membantu DJPb mencapai tujuan efisiensi dan akurasi dalam pengambilan keputusan berbasis data.
Performance Improvement of Periodic Reports with Materialized Views on Oracle Database System Soepriadi, Raden; Dijerja, Gahara; Samidi, Samidi
Sistemasi: Jurnal Sistem Informasi Vol 14, No 2 (2025): Sistemasi: Jurnal Sistem Informasi
Publisher : Program Studi Sistem Informasi Fakultas Teknik dan Ilmu Komputer

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.32520/stmsi.v14i2.4910

Abstract

Periodic reports in Management Information Systems (MIS) play a crucial role in organizational decision-making. However, rapid data growth can degrade query performance. This study aims to enhance the performance of periodic reports in the State Revenue Collection Module (SIM MPN) of the Ministry of Finance by utilizing Materialized Views (MVs) in the Oracle database system. A dataset comprising 294,503,898 rows from 2021 to 2023 was used as a sample. An analysis was conducted on eight types of periodic report queries that traditionally relied on standard views. These queries were then converted into MVs to reduce execution time. Testing was performed by comparing execution times between views and MVs across 24 queries executed in two different environments. The results showed that the average execution time using views was 2,047,417 ms, whereas with MVs, execution times were reduced to 41 ms in the first test, 17 ms in the second, and 12 ms in the third. These findings confirm that MVs significantly improve the performance of periodic reports by accelerating query execution. The practical implication of this study is the recommendation to implement MVs in systems with large data volumes to optimize report access speed. Future research can focus on optimizing MV refresh times and further analyzing factors affecting execution time under various usage scenarios.
Co-Authors Samidi Samidi Samidi Samidi, Samidi Soepriadi, Raden