Maintaining Query Performance through Table Rebuilding & Archiving
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 sit...
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Universitas Gadjah Mada
2024-01-01
|
| Series: | IJCCS (Indonesian Journal of Computing and Cybernetics Systems) |
| Subjects: | |
| Online Access: | https://jurnal.ugm.ac.id/ijccs/article/view/90062 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1850193294918680576 |
|---|---|
| author | Widyastuti Andriyani Pujianto Pujianto |
| author_facet | Widyastuti Andriyani Pujianto Pujianto |
| author_sort | Widyastuti Andriyani |
| collection | DOAJ |
| description | 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 |
| format | Article |
| id | doaj-art-6463cd72af5845a79c73397b3f424284 |
| institution | OA Journals |
| issn | 1978-1520 2460-7258 |
| language | English |
| publishDate | 2024-01-01 |
| publisher | Universitas Gadjah Mada |
| record_format | Article |
| series | IJCCS (Indonesian Journal of Computing and Cybernetics Systems) |
| spelling | doaj-art-6463cd72af5845a79c73397b3f4242842025-08-20T02:14:19ZengUniversitas Gadjah MadaIJCCS (Indonesian Journal of Computing and Cybernetics Systems)1978-15202460-72582024-01-01181738210.22146/ijccs.9006235289Maintaining Query Performance through Table Rebuilding & ArchivingWidyastuti Andriyani0Pujianto Pujianto1Universitas Teknologi Digital IndonesiaDepartment of Information Technology, Indonesian Digital Technology University, YogyakartaDespite 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 databasehttps://jurnal.ugm.ac.id/ijccs/article/view/90062elevated transactions and challenges, table reconstruction, data archiving |
| spellingShingle | Widyastuti Andriyani Pujianto Pujianto Maintaining Query Performance through Table Rebuilding & Archiving IJCCS (Indonesian Journal of Computing and Cybernetics Systems) elevated transactions and challenges, table reconstruction, data archiving |
| title | Maintaining Query Performance through Table Rebuilding & Archiving |
| title_full | Maintaining Query Performance through Table Rebuilding & Archiving |
| title_fullStr | Maintaining Query Performance through Table Rebuilding & Archiving |
| title_full_unstemmed | Maintaining Query Performance through Table Rebuilding & Archiving |
| title_short | Maintaining Query Performance through Table Rebuilding & Archiving |
| title_sort | maintaining query performance through table rebuilding archiving |
| topic | elevated transactions and challenges, table reconstruction, data archiving |
| url | https://jurnal.ugm.ac.id/ijccs/article/view/90062 |
| work_keys_str_mv | AT widyastutiandriyani maintainingqueryperformancethroughtablerebuildingarchiving AT pujiantopujianto maintainingqueryperformancethroughtablerebuildingarchiving |