loading page

Table Partition in STARS: Concept and Evaluations
  • Penidas Fiodinggo Tanaem ,
  • Andeka Rocky Tanaem ,
  • infraim oktofianus boymau
Penidas Fiodinggo Tanaem
Faculty of Information Technology
Author Profile
Andeka Rocky Tanaem
Author Profile
infraim oktofianus boymau
Author Profile

Abstract

Database performance is one of the main components in supporting the sustainability of a system in this case is Student’s Activity Record System (STARS). One way to improve the performance of the database is to use the concept of a partition table. Thus, in this study, the design and evaluation of the partition table will be carried out which will then be applied to the Satya Wacana Christian University (SWCU) STARS database. The results of this study indicate that partition tables have better performance than non-partitioned tables seen from several SQL syntaxes like update, delete, and select. Meanwhile, insert performs poorly for partitioned tables compared to non-partitioned tables.