Maintaining Query Performance through Table Rebuilding & Archiving

https://doi.org/10.22146/ijccs.90062

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


Elevated transactions and challenges, table reconstruction, data archiving

Full Text:

PDF


References

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 : 1412 | views : 636

Refbacks

  • There are currently no refbacks.




Copyright (c) 2024 IJCCS (Indonesian Journal of Computing and Cybernetics Systems)

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.



Copyright of :
IJCCS (Indonesian Journal of Computing and Cybernetics Systems)
ISSN 1978-1520 (print); ISSN 2460-7258 (online)
is a scientific journal the results of Computing
and Cybernetics Systems
A publication of IndoCEISS.
Gedung S1 Ruang 416 FMIPA UGM, Sekip Utara, Yogyakarta 55281
Fax: +62274 555133
email:ijccs.mipa@ugm.ac.id | http://jurnal.ugm.ac.id/ijccs



View My Stats1
View My Stats2