Article Per Year (5 Year)
p-Index From 2020 - 2025
0.23
P-Index
This Author published in this journals
All Journal Jurnal Teknik Informatika (JUTIF)
Rachman, M Harviandi
Unknown Affiliation
Computer Science & IT

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

Found 1 Documents
Search

 1 
COMPARISON OF INDEX, PARTITION, AND MATERIALIZED VIEW METHODS ON THE ORACLE DATABASE STUDY ON CENTRAL GOVERNMENT FINANCIAL REPORTS (LKPP) Rachman, M Harviandi; Samidi, Samidi; Aprianto, Eko
Jurnal Teknik Informatika (Jutif) Vol. 5 No. 4 (2024): JUTIF Volume 5, Number 4, August 2024
Publisher : Informatika, Universitas Jenderal Soedirman

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

Abstract

The Indonesian Central Government Financial Report (LKPP) is a financial document prepared to increase transparency and accountability in the implementation of the State Revenue and Expenditure Budget (APBN). It is prepared within a tight schedule, hence changes made by each entity must be updated promptly. Therefore, this research focuses on the optimal table design for presenting financial reports. Query optimization is a major concern in database design, with the use of indexing concepts to increase data search speed. Table partitioning is also a strategy to consider, namely dividing a table into parts that form separate data ranges. The use of a Materialized View (MV) is another alternative, providing increased performance with the space-for-time trade-off principle. Experiments were carried out by comparing the response time of applying index, partition, and materialized views to produce financial report data. Experimental results indicate that materialized views can provide significant advantages when faced with large volumetric data. The decision to choose a materialized view can be considered contextually, depending on the specific needs and characteristics of the data encountered in a database system.
Co-Authors Eko Aprianto Samidi Samidi, Samidi