Maintaining Query Performance through Table Rebuilding & Archiving
Widyastuti Andriyani(1*), Pujianto Pujianto(2)
(1) Universitas Teknologi Digital Indonesia
(2) Department of Information Technology, Indonesian Digital Technology University, Yogyakarta
(*) Corresponding Author
Abstract
Despite the system previously utilizing optimal query configurations and database settings, the transaction table in the database, which is undergoing significant numerical increases and notable queries and updates on each line, has seen a drop in query speeds simultaneous with data growth. This situation arises due to an increase in disk space in the database tablespace, which results from block fragmentation. At times, database engines do not detect this problem, thereby overlooking it in the database recommendation engine. Lacking an understanding of the fundamental issue, database engineers need analysis and strategies to maintain the query speed of the transaction table in the relational database
Keywords
Full Text:
PDFReferences
Oracle, “Overview of SQL,” oracle.com, 2022. [2] S. J. Kamatkar, A. Kamble, A. Viloria, L. Hernández-Fernandez, and E. García Cali, “Database performance tuning and query optimization,” Lect. Notes Comput. Sci. (including Subser. Lect. Notes Artif. Intell. Lect. Notes Bioinformatics), vol. 10943 LNCS, pp. 3–11, 2018, doi: 10.1007/978-3-319-93803-5_1. [3] D. Iskandar, M. Fachruroji, W. A. Septyo, and A. K. A, “Database Tuning in Hospital Applications Using Table Indexing and Query Optimization,” vol. 6, pp. 1960–1967, 2022. [4] B. Ding, S. Chaudhuri, and V. Narasayya, “Bitvector-aware Query Optimization for Decision Support Queries,” Proc. ACM SIGMOD Int. Conf. Manag. Data, pp. 2011–2026, 2020, doi: 10.1145/3318464.3389769. [5] S. Srivastava and R. Misra, “Archiving ERP data to enhance operational effectiveness: The case of Dolphin,” Int. J. Inf. Technol. Manag., vol. 16, no. 2, pp. 162–172, 2017, doi: 10.1504/IJITM.2017.083866. [6] C. Shallahamer, “All About Oracle Database Fragmentation,” White Pap. OraPub, Inc. Lake Oswego, USA, 2000. [7] Microsoft, “Konsep: fragmentasi indeks dan kepadatan halaman,” docs.microsoft.com, 2022. [8] Hariprasath Rajaram, “Reorganization Table,” oracledbwr.com, 2022. [9] Y. Liu, R. Kumar, A. Tripathi, A. Sharma, and M. Rana, “The Application of Internet of Things and Oracle Database in the Research of Intelligent Data Management System,” Inform., vol. 46, no. 3, pp. 403–410, 2022, doi: 10.31449/inf.v46i3.4019. [10] P. Dix, “InfluxData (InfluxDB) | Time Series Database Monitoring & Analytics,” InfluxData, Inc., vol. 12, no. 2, pp. 168–174, 2017, [Online]. Available: https://www.influxdata.com
DOI: https://doi.org/10.22146/ijccs.90062
Article Metrics
Abstract views : 1185 | views : 535Refbacks
- There are currently no refbacks.
Copyright (c) 2024 IJCCS (Indonesian Journal of Computing and Cybernetics Systems)
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
View My Stats1