Melola Discovery

← Melola Discovery

Jurnal

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

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

DOI
10.15294/edukom.v13i1.41416
ISSN
2599-297X, 2252-6811
Terbit
2026-08-31
Penerbit
Universitas Negeri Semarang
Bahasa
eng

Abstrak

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.

Kata kunci

Jaringan kolaborasi para penulis

6 penulis · 9 tautan kepenulisan bersama

Arahkan kursor atau ketuk sebuah nama untuk menyorot rekan penulisnya. Klik dua kali untuk membuka halaman penulis.

  • State University of Semarang
  • Afiliasi tidak diketahui
  • Organisasi berbeda
  • Organisasi sama
  • Afiliasi tidak diketahui
  • Garis lebih tebal = lebih banyak artikel bersama · lingkaran lebih besar = lebih banyak artikel
Tampilkan sebagai tabel
Rekan penulisOrganisasiArtikel bersama
Anita LufiantiAfiliasi tidak diketahui1
Meity Mulya SusantiAfiliasi tidak diketahui1
RahmawatiAfiliasi tidak diketahui1

Afiliasi berasal dari OpenAlex; metadata OAI-PMH jurnal tidak memuatnya. Penulis tanpa ID OpenAlex dicocokkan berdasarkan nama, sehingga dua orang bisa tergabung atau satu orang bisa terpisah.

Sumber metadata: OAI-PMH (metadata jurnal) https://journal.unnes.ac.id/journals/edukom/oai, pertama di-harvest 5 Nov 2026, terakhir terlihat 8 Nov 2026.
Metadata asli (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>