Partition Table in STARS: Concept and Evaluations

Database performance is one of the main components in supporting the sustainability of a system in this case is 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 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.