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.

数据库性能是支撑系统可持续性的核心要素之一，本研究中的目标系统为STARS。提升数据库性能的方法之一是采用分区表（partition table）的概念。因此，本研究将开展分区表的设计与评估工作，并将其应用于SWCU STARS数据库。研究结果表明，从若干SQL语法（SQL syntaxes）的执行情况来看，分区表的性能优于非分区表，例如update、delete和select操作。与此同时，相较于非分区表，分区表在insert操作上的性能表现较差。