Melola Discovery

← Melola Discovery

Open access Jurnal SINTA 2

Maintaining Query Performance through Table Rebuilding & Archiving

IJCCS (Indonesian Journal of Computing and Cybernetics Systems) · Vol. 18 No. 1 (2024) · pp. 73–82

DOI
10.22146/ijccs.90062
ISSN
2460-7258, 1978-1520
Published
2024-01-31
Publisher
IndoCEISS in colaboration with Universitas Gadjah Mada, Indonesia.
Language
eng
License
creativecommons.org/licenses/by-sa/4.0

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

Collaboration network of the authors

8 authors · 9 co-authorship links · 3 across different organisations

Hover or tap a name to highlight its co-authors. Double-click to open the author's page.

  • Universitas Teknologi Digital Indonesia
  • Yogyakarta State University
  • Jenderal Soedirman University
  • Affiliation unknown
  • Different organisations
  • Same organisation
  • Affiliation unknown
  • Thicker line = more joint articles · bigger circle = more articles
Show as table
Co-authorOrganisationJoint articles
Saryanto SaryantoAffiliation unknown1
Suryanto SuryantoJenderal Soedirman University1
Adi KusjaniUniversitas Teknologi Digital Indonesia1
Domy KristomoUniversitas Teknologi Digital Indonesia1
Dadan RosanaYogyakarta State University1
Jumadi JumadiYogyakarta State University1

Affiliations come from OpenAlex; journal OAI-PMH metadata carries none. Authors without an OpenAlex ID are matched by name, which can merge or split people.

Metadata source: OAI-PMH (metadata jurnal) https://journal.ugm.ac.id/ijccs/oai, first harvested 26 Okt 2026, last seen 26 Okt 2026.
Original metadata (oai_dc) 
<oai_dc:dc xmlns="http://www.openarchives.org/OAI/2.0/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.openarchives.org/OAI/2.0/oai_dc/  http://www.openarchives.org/OAI/2.0/oai_dc.xsd">
	<dc:title xml:lang="en-US">Maintaining Query Performance through  Table Rebuilding &amp; Archiving</dc:title>
	<dc:creator>Andriyani, Widyastuti</dc:creator>
	<dc:creator>Pujianto, Pujianto</dc:creator>
	<dc:subject xml:lang="en-US"></dc:subject>
	<dc:subject xml:lang="en-US">Elevated transactions and challenges, table reconstruction, data archiving</dc:subject>
	<dc:description xml:lang="en-US">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</dc:description>
	<dc:publisher xml:lang="en-US">IndoCEISS in colaboration with Universitas Gadjah Mada, Indonesia.</dc:publisher>
	<dc:contributor xml:lang="en-US"></dc:contributor>
	<dc:date>2024-01-31</dc:date>
	<dc:type>info:eu-repo/semantics/article</dc:type>
	<dc:type>info:eu-repo/semantics/publishedVersion</dc:type>
	<dc:type xml:lang="en-US"></dc:type>
	<dc:format>application/pdf</dc:format>
	<dc:identifier>https://journal.ugm.ac.id/ijccs/article/view/90062</dc:identifier>
	<dc:identifier>10.22146/ijccs.90062</dc:identifier>
	<dc:source xml:lang="en-US">IJCCS (Indonesian Journal of Computing and Cybernetics Systems); Vol 18, No 1 (2024): January; 73-82</dc:source>
	<dc:source>2460-7258</dc:source>
	<dc:source>1978-1520</dc:source>
	<dc:language>eng</dc:language>
	<dc:relation>https://journal.ugm.ac.id/ijccs/article/view/90062/38505</dc:relation>
	<dc:rights xml:lang="en-US">Copyright (c) 2024 IJCCS (Indonesian Journal of Computing and Cybernetics Systems)</dc:rights>
	<dc:rights xml:lang="en-US">http://creativecommons.org/licenses/by-sa/4.0</dc:rights>
</oai_dc:dc>