Main Content
Lembaga Kita Journal Portal

Abstract


The selection of a primary key is crucial in database management, as it impacts database performance and scalability. This study aims to evaluate one of the trending types of primary keys among developers — UUID. The evaluation is conducted on two different databases, PostgreSQL and MongoDB, using auto-increment and MongoDB’s ObjectId as comparisons. The testing involves importing data from a CSV file and processing it in parallel to assess the efficiency of each primary key in handling data insertion. The results show that auto-increment has advantages in terms of speed and smaller storage size compared to UUID, especially in MongoDB. In PostgreSQL, the speed difference is not as significant, but auto-increment remains more efficient in storage usage. This study provides valuable insights for developers in selecting the appropriate primary key based on system performance requirements.

Keywords

UUID PostgreSQL MongoDB

How to Cite

Citation Format
Muhamad Kamal Shamlan, & Edi, S. W. M. (2025). Pengujian Perfoma UUID Sebagai Primary Key Pada Database PostgreSQL Dan MongoDB. Jurnal JTIK (Jurnal Teknologi Informasi Dan Komunikasi), 9(4), 1322-1334. https://doi.org/10.35870/jtik.v9i4.3878

References

17 References
  • Bhaswara, F. A., Sarno, R., & Sunaryono, D. (2017). Perbandingan Kemampuan Database NoSQL dan SQL dalam Kasus ERP Retail. Jurnal Teknik ITS, 6(2), A511-A514. https://doi.org/10.12962/j23373539.v6i2.24031.
  • Cahyani, A. D., Basuki, A., & Nafisah, D. (2022). Pengolahan Basis Data Mongo DB. Media Nusa Creative (MNC Publishing).
  • Cui, X., & Chen, W. (2021). Performance comparison test of HBase and Cassandra based on YCSB. In 2021 IEEE/ACIS 19th International Conference on Computer and Information Science (ICIS), 70–77. https://doi.org/10.1109/ICIS51600.2021.9516864.
  • Keighobad, A., & Demirel, F. B. (2021). Software Platform for Design and Management of Real-time Data from Microneedle-based Wearable Sensors: A front-end (iOS) and a server-side (Node. js) implementation for an IoT system.
  • Makris, A., Tserpes, K., Spiliopoulos, G., Zissis, D., & Anagnostopoulos, D. (2021). MongoDB Vs PostgreSQL: A comparative study on performance aspects. GeoInformatica, 25, 243-268.
  • Mishra, N., Chakraborty, A., & Mukhopadhyay, D. (2022, August). Breaking Cross-world isolation on ARM TrustZone through EM Faults, Coredumps, and UUID Confusion.
  • Nokeri, T. C. (2021). Python Web Frameworks and Apps. In Web App Development and Real-Time Web Analytics with Python: Develop and Integrate Machine Learning Algorithms into Web Apps (pp. 79-85). Berkeley, CA: Apress.
  • Pebrianto, J. (2022). Perbandingan Kecepatan Baca Dan Tulis Data Pada Mysql Menggunakan Primary Key Auto Increment Dengan Universally Unique Identifier (UUID). Media Jurnal Informatika, 14(2), 86-96. https://doi.org/10.35194/mji.v14i2.2681.
  • Prastowo, A. A., Purwadi, A., Murtono, T., Upe, A., Rusli, M., Hos, J., Moita, S., Wicaksono, G., Wan Khairuldin, W. M. K. F., & Sono, M. G. (2021). Application of decision support system using composite performance index algorithm. Journal of Physics: Conference Series, 1933(1), 012018. https://doi.org/10.1088/1742-6596/1933/1/012018.
  • Ravshanovich, A. R. (2024). DATABASE STRUCTURE: POSTGRESQL DATABASE. PSIXOLOGIYA VA SOTSIOLOGIYA ILMIY JURNALI, 2(7), 50-55.
  • Rumandan, R. J. (2022). Implementasi Composite Performance Index (CPI) Pada Sistem Pendukung Keputusan Pemilihan Mitra Pengiriman Barang. KLIK: Kajian Ilmiah Informatika Dan Komputer, 3(1), 17-25.
  • Salunke, S. V., & Ouda, A. (2024). A Performance Benchmark for the PostgreSQL and MySQL Databases. Future Internet, 16(10), 382. https://doi.org/10.3390/fi16100382.
  • Satria, B., Sidauruk, A., Wardhana, R., Al Akbar, A., & Ihsan, M. A. (2022). Penerapan composite performance index (CPI) sebagai metode pada sistem pendukung keputusan seleksi penerima beasiswa. The Indonesian Journal of Computer Science, 11(2). https://doi.org/10.33022/ijcs.v11i2.3056.
  • Silalahi, M. (2018). Perbandingan performansi database mongodb dan mysql dalam aplikasi file multimedia berbasis web. Computer Based Information System Journal, 6(1), 63-63. https://doi.org/10.33884/cbis.v6i1.574.
  • Timisela, H. (2024). PERBANDINGAN KINERJA JENIS-JENIS BASIS DATA NOSQL DALAM MANAJEMEN DATA BIOMEDIK= PERFORMANCE COMPARISON OF NOSQL DATABASE TYPES IN BIOMEDICAL DATA MANAGEMENT (Doctoral dissertation, Universitas Hasanuddin).
  • Triebel, D., Reichert, W., Bosert, S., Feulner, M., Okach, D. O., Slimani, A., & Rambold, G. (2018). A generic workflow for effective sampling of environmental vouchers with UUID assignment and image processing. Database, 2018. https://doi.org/10.1093/database/bax096.
  • Zhou, X., Chai, C., Li, G., & Sun, J. (2022). Database meets artificial intelligence: A survey. IEEE Transactions on Knowledge and Data Engineering, 34(3), 1096–1116. https://doi.org/10.1109/TKDE.2020.2994641.

Author Biographies

Muhamad Kamal Shamlan, Satya Wacana Christian University

Teknik Informatika, Fakultas Teknologi Informasi, Universitas Kristen Satya Wacana.

Sri Winarso Martyas Edi, Satya Wacana Christian University

Teknik Informatika, Fakultas Teknologi Informasi, Universitas Kristen Satya Wacana.

License

Copyright (c) 2025 Muhamad Kamal Shamlan, Sri Winarso Martyas Edi

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

This is an open-access journal distributed under the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits unrestricted use, distribution, reproduction, and adaptation in any medium (even commercially), provided appropriate credit is given to the original author(s), a link to the license is provided, and any changes made are indicated. Authors retain copyright without restrictions and grant the journal the right of first publication as well as non-exclusive publishing rights for archiving, indexing, and scholarly dissemination.

Downloads

OJS UsageStats Plugin
Download data is not yet available.

Similar Articles

You may also start an advanced similarity search for this article.

Most read articles by the same author(s)

Contrimetric

Recommended Articles