Tabel Partisi Pada STARS: Konsep Dan Evaluasi (Studi Kasus STARS UKSW)
Abstract
Database performance is one of the main components in supporting the sustainability of a system, in this case, STARS. In the system context, data will usually be collected into a database. Tied to the data collection process, this really affects the performance of a system as a whole, in this case when executing a query to get a return of the execution results, because the performance of the database itself will be affected by the amount of data available. One way to improve the performance of the database is to use the partition table concept. Thus, in this research a design and evaluation of the partition table will be carried out which will then be applied to the SWCU STARS database. This research focuses more on the use of vertical partitions and list partitions by utilizing PostgreSQL version 14. The stages used in this study. These stages include data collection, partition design, technical partition, testing and implementation. The results of this study indicate that partition tables have better performance than non-partition tables. Judging from some of the sql syntax, namely update, delete and select, while insert has poor performance for partition tables compared to non-partition tables
Keywords
Full Text:
References
A. Viloria, G. C. Acuña, D. J. A. Franco, H. Hernández-Palma, J. P. Fuentes, and E. P. Rambal, “Integration of data mining techniques to postgresQL database manager system,” Procedia Comput Sci, vol. 155, no. 2018, pp. 575–580, 2019, doi: 10.1016/j.procs.2019.08.080.
K. S. Maabreh, “Optimizing Database Query Performance Using Table Partitioning Techniques,” ACIT 2018 - 19th International Arab Conference on Information Technology, pp. 1–4, 2019, doi: 10.1109/ACIT.2018.8672584.
N. Tabassam and R. Obermaisser, “Minimizing the Make Span of Diagnostic Multi-Query Graphs Using Query Aware Partitioning in Embedded Real-Time Systems,” Proceedings - 2018 International Conference on Promising Electronic Technologies, ICPET 2018, no. 2, pp. 1–7, 2018, doi: 10.1109/ICPET.2018.00007.
P. Swathi, “A STUDY ON SQL-RDBMS CONCEPTS AND DATABASE NORMALIZATION.” [Online]. Available: https://ssrn.com/abstract=4282707
A. Dwi Praba and M. Safitri, “STUDI PERBANDINGAN PERFORMANSI ANTARA MYSQL DAN POSTGRESQL,” vol. VIII, no. 2, [Online]. Available: https://www.adminer.org/.
M. Hassan and S. K. Bansal, “Data Partitioning Scheme for Efficient Distributed RDF Querying Using Apache Spark,” Proceedings - 13th IEEE International Conference on Semantic Computing, ICSC 2019, pp. 24–31, 2019, doi: 10.1109/ICOSC.2019.8665614.
M. Hassan and S. K. Bansal, “S3QLRDF: Property Table Partitioning Scheme for Distributed SPARQL Querying of large-scale RDF data,” Proceedings - 2020 IEEE International Conference on Smart Data Services, SMDS 2020, pp. 133–140, 2020, doi: 10.1109/SMDS49396.2020.00023.
V. Salgova and K. Matiasko, “Reducing Data Access Time using Table Partitioning Techniques,” ICETA 2020 - 18th IEEE International Conference on Emerging eLearning Technologies and Applications, Proceedings, pp. 564–569, 2020, doi: 10.1109/ICETA51985.2020.9379231.
P. F. Tanaem, A. F. Wijaya, A. D. Manuputty, and G. N. Huwae, “Penerapan RESTFul Web Service Pada Disain Arsitektur Sistem Informasi Pada Perguruan Tinggi (Studi Kasus: STARS UKSW),” JASIEK (Jurnal Aplikasi Sains, Informasi, Elektronika dan Komputer), vol. 2(1), no. 1, pp. 11–20, 2020.
H. Yin, S. Yang, H. Zhao, and Z. Chen, “Partial query optimization techniques for partitioned tables,” Proceedings - 2012 9th International Conference on Fuzzy Systems and Knowledge Discovery, FSKD 2012, no. Fskd, pp. 792–797, 2012, doi: 10.1109/FSKD.2012.6234270.
L. Qu et al., “Are current benchmarks adequate to evaluate distributed transactional databases?,” BenchCouncil Transactions on Benchmarks, Standards and Evaluations, vol. 2, no. 1, p. 100031, 2022, doi: 10.1016/j.tbench.2022.100031.
F. C. Daeng Bani, Suharjito, Diana, and A. S. Girsang, “Implementation of Database Massively Parallel Processing System to Build Scalability on Process Data Warehouse,” Procedia Comput Sci, vol. 135, pp. 68–79, 2018, doi: 10.1016/j.procs.2018.08.151.
Postgresql, “Table Partitioning,” Postgresql, 2022. https://www.postgresql.org/docs/current/ddl-partitioning.html (accessed Sep. 16, 2022).
D. Vashi, H. B. Bhadka, K. Patel, and S. Garg, “An Efficient Hybrid Approach of Attribute Based Encryption for Privacy Preserving Through Horizontally Partitioned Data,” Procedia Comput Sci, vol. 167, no. 2019, pp. 2437–2444, 2020, doi: 10.1016/j.procs.2020.03.296.
A. Dahal and S. R. Joshi, “A Clustering Based Vertical Fragmentation and Allocation of a Distributed Database,” in 2019 Artificial Intelligence for Transforming Business and Society (AITB), Nov. 2019, vol. 1, pp. 1–5. doi: 10.1109/AITB48515.2019.8947444.
M. Abhishek Nair, A. Dewangan, and A. Geetha Mary, “Efficient Retrieval of Data from Cloud Databases using Hash Partitioned Buckets,” 2019 Innovations in Power and Advanced Computing Technologies, i-PACT 2019, pp. 1–7, 2019, doi: 10.1109/i-PACT44901.2019.8960047.
A. JMeter, “Apache JMeter,” Apache JMeter, 2022. https://jmeter.apache.org/ (accessed Oct. 02, 2022).
DOI: https://doi.org/10.30591/jpit.v8i2.4753
Refbacks
- There are currently no refbacks.
This work is licensed under a Creative Commons Attribution 4.0 International License.
JPIT INDEXED BY
 |  |  |  |
 |  |  |  |
 |  | ||
This work is licensed under a Creative Commons Attribution 4.0 International License.
