Melola Discovery

← Melola Discovery

Journal

Designing Summary Tables to Optimize Performance in Relational Databases: An Empirical Approach

Edu Komputika Journal · Vol. 13 No. 1 (2026) · pp. 34–44

DOI
10.15294/edukom.v13i1.41416
ISSN
2599-297X, 2252-6811
Published
2026-08-31
Publisher
Universitas Negeri Semarang
Language
eng

Abstract

The performance of transactional applications involving databases will decline over time due to the increasing amount of stored data and the continuously rising volume of transactions. This research proposes a summary table design method that integrates table partitioning techniques and data aggregation to improve query efficiency without sacrificing the consistency and accuracy of the stored data. We tested this method using 30,275 transaction records on Google Cloud infrastructure and MySQL Server 8.0, demonstrating a data processing speed increase of up to 92.36% compared to conventional table designs. The research results show that this method not only accelerates data processing but also simplifies data management in relational database management systems (RDBMS). This method is relevant for transactional database applications with high transaction loads, such as the financial and e-commerce sectors. By combining the physical table design architecture and efficient query processing, this research contributes to the development of more scalable, reliable, and suitable database designs for high workload scenarios.

Keywords

Collaboration network of the authors

40 authors · 102 co-authorship links · 7 across different organisations · showing the 40 most connected

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

  • Indonesia University of Education
  • Islamic University of Indonesia
  • Lampung University
  • Siliwangi University
  • Universitas Halu Oleo
  • Affiliation unknown
  • Different organisations
  • Same organisation
  • Affiliation unknown
  • Thicker line = more joint articles · bigger circle = more articles
Show as table
Co-authorOrganisationJoint articles
Rahmat RizalSiliwangi University1
Dadi RusdianaIndonesia University of Education1
Parsaoran SiahaanIndonesia University of Education1
Ismail IsmailIndonesia University of Education1
Anna PermanasariIndonesia University of Education1
I Ketut SuardikaUniversitas Halu Oleo1
La Ode Ali BasriAffiliation unknown1
Safira KhoirunnisaIslamic University of Indonesia1
. RahmawatiAffiliation unknown1
Anita LufiantiAffiliation unknown1
Meity Mulya SusantiAffiliation unknown1
Muhammad AnsoriAffiliation unknown1
Anisa DwiyantiAffiliation unknown1
Khofifah Qurratu’AiniAffiliation unknown1
Bulan Zumi FauziahAffiliation unknown1
Alza FebrianaAffiliation unknown1
Allya Candra TarishaAffiliation unknown1
Suwito Eko PramonoAffiliation unknown1
Tjaturahono Budi SanjotoAffiliation unknown1
Hani NuraisahAffiliation unknown1
Andi SuhandiIndonesia University of Education1
Wahyuni HandayaniAffiliation unknown1
P SinagaAffiliation unknown1
Idris IdrisAffiliation unknown1
Masrukhin MasrukhinAffiliation unknown1
Suryo WiyonoAffiliation unknown1
Efi Toding TondokAffiliation unknown1
I Made SudianaAffiliation unknown1
Atit KantiAffiliation unknown1
Toga Pangihotan NapitupuluAffiliation unknown1
I Nyoman SumertaAffiliation unknown1
I Wayan DistrikLampung University1
Chandra ErtikantoLampung University1
Sarip HidayatAffiliation unknown1
Suwari AkhmaddhianAffiliation unknown1
Toto SupartonoAffiliation unknown1
Dikha AnugrahAffiliation unknown1

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.unnes.ac.id/journals/edukom/oai, first harvested 5 Nov 2026, last seen 8 Nov 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">Designing Summary Tables to Optimize Performance in Relational Databases: An Empirical Approach</dc:title>
	<dc:creator xml:lang="en">Widodo, Edi</dc:creator>
	<dc:creator xml:lang="en">Kartika Imam Santoso</dc:creator>
	<dc:creator xml:lang="en">Wawan Setiawan</dc:creator>
	<dc:subject xml:lang="en">Database Performance</dc:subject>
	<dc:subject xml:lang="en">RDBMS</dc:subject>
	<dc:subject xml:lang="en">Table Partitioning</dc:subject>
	<dc:description xml:lang="en">The performance of transactional applications involving databases will decline over time due to the increasing amount of stored data and the continuously rising volume of transactions. This research proposes a summary table design method that integrates table partitioning techniques and data aggregation to improve query efficiency without sacrificing the consistency and accuracy of the stored data. We tested this method using 30,275 transaction records on Google Cloud infrastructure and MySQL Server 8.0, demonstrating a data processing speed increase of up to 92.36% compared to conventional table designs. The research results show that this method not only accelerates data processing but also simplifies data management in relational database management systems (RDBMS). This method is relevant for transactional database applications with high transaction loads, such as the financial and e-commerce sectors. By combining the physical table design architecture and efficient query processing, this research contributes to the development of more scalable, reliable, and suitable database designs for high workload scenarios.</dc:description>
	<dc:publisher xml:lang="en">Universitas Negeri Semarang</dc:publisher>
	<dc:date>2026-08-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">Peer-reviewed Article</dc:type>
	<dc:format>application/pdf</dc:format>
	<dc:identifier>https://journal.unnes.ac.id/journals/edukom/article/view/41416</dc:identifier>
	<dc:identifier>10.15294/edukom.v13i1.41416</dc:identifier>
	<dc:source xml:lang="en">Edu Komputika Journal; Vol. 13 No. 1 (2026): Edu Komputika Journal; 34-44</dc:source>
	<dc:source>2599-297X</dc:source>
	<dc:source>2252-6811</dc:source>
	<dc:source>10.15294/edukom.v13i1</dc:source>
	<dc:language>eng</dc:language>
	<dc:relation>https://journal.unnes.ac.id/journals/edukom/article/view/41416/11353</dc:relation>
	<dc:rights xml:lang="en">Copyright (c) 2026 Edu Komputika Journal</dc:rights>
</oai_dc:dc>