Performance Improvement of Periodic Reports with Materialized Views on Oracle Database System
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...
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | Indonesian |
| Published: |
Islamic University of Indragiri
2025-03-01
|
| Series: | Sistemasi: Jurnal Sistem Informasi |
| Subjects: | |
| Online Access: | https://sistemasi.ftik.unisi.ac.id/index.php/stmsi/article/view/4910 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1849770221683867648 |
|---|---|
| author | Raden Soepriadi Gahara Dijerja Samidi Samidi |
| author_facet | Raden Soepriadi Gahara Dijerja Samidi Samidi |
| author_sort | Raden Soepriadi |
| collection | DOAJ |
| description | 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. |
| format | Article |
| id | doaj-art-0e237a662a3f48b9bf6bf5de490f0c4c |
| institution | DOAJ |
| issn | 2302-8149 2540-9719 |
| language | Indonesian |
| publishDate | 2025-03-01 |
| publisher | Islamic University of Indragiri |
| record_format | Article |
| series | Sistemasi: Jurnal Sistem Informasi |
| spelling | doaj-art-0e237a662a3f48b9bf6bf5de490f0c4c2025-08-20T03:03:06ZindIslamic University of IndragiriSistemasi: Jurnal Sistem Informasi2302-81492540-97192025-03-0114257058610.32520/stmsi.v14i2.49101024Performance Improvement of Periodic Reports with Materialized Views on Oracle Database SystemRaden Soepriadi0Gahara Dijerja1Samidi Samidi2Universitas Budi LuhurUniversitas Budi LuhurUniversitas Budi LuhurPeriodic 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.https://sistemasi.ftik.unisi.ac.id/index.php/stmsi/article/view/4910execution time, materialized views, oracle database, periodic reports, management information system |
| spellingShingle | Raden Soepriadi Gahara Dijerja Samidi Samidi Performance Improvement of Periodic Reports with Materialized Views on Oracle Database System Sistemasi: Jurnal Sistem Informasi execution time, materialized views, oracle database, periodic reports, management information system |
| title | Performance Improvement of Periodic Reports with Materialized Views on Oracle Database System |
| title_full | Performance Improvement of Periodic Reports with Materialized Views on Oracle Database System |
| title_fullStr | Performance Improvement of Periodic Reports with Materialized Views on Oracle Database System |
| title_full_unstemmed | Performance Improvement of Periodic Reports with Materialized Views on Oracle Database System |
| title_short | Performance Improvement of Periodic Reports with Materialized Views on Oracle Database System |
| title_sort | performance improvement of periodic reports with materialized views on oracle database system |
| topic | execution time, materialized views, oracle database, periodic reports, management information system |
| url | https://sistemasi.ftik.unisi.ac.id/index.php/stmsi/article/view/4910 |
| work_keys_str_mv | AT radensoepriadi performanceimprovementofperiodicreportswithmaterializedviewsonoracledatabasesystem AT gaharadijerja performanceimprovementofperiodicreportswithmaterializedviewsonoracledatabasesystem AT samidisamidi performanceimprovementofperiodicreportswithmaterializedviewsonoracledatabasesystem |