Published: 2025-10-01

Pengujian Perfoma UUID Sebagai Primary Key Pada Database PostgreSQL Dan MongoDB

DOI: 10.35870/jtik.v9i4.3878

Muhamad Kamal Shamlan, Sri Winarso Martyas Edi
  • Muhamad Kamal Shamlan: Universitas Kristen Satya Wacana , Indonesia
  • Sri Winarso Martyas Edi: Universitas Kristen Satya Wacana , Indonesia
Issue Cover

Downloads

Article Metrics
Share:

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

Peer Review Process

This article has undergone a double-blind peer review process to ensure quality and impartiality.

Indexing Information

Discover where this journal is indexed at our indexing page to understand its reach and credibility.

Open Science Badges

This journal supports transparency in research and encourages authors to meet criteria for Open Science Badges by sharing data, materials, or preregistered studies.

How to Cite

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
Article Information

This article has been peer-reviewed and published in the Jurnal JTIK (Jurnal Teknologi Informasi dan Komunikasi). The content is available under the terms of the Creative Commons Attribution 4.0 International License.

  • Issue: Vol. 9 No. 4 (2025)

  • Section: Computer & Communication Science

  • Published: %750 %e, %2025

AI Research Hub

This article is indexed and available through various AI-powered research tools and citation platforms. Our AI Research Hub ensures that scholarly work is discoverable, accessible, and easily integrated into the global research ecosystem. By leveraging artificial intelligence for indexing, recommendation, and citation analysis, we enhance the visibility and impact of published research.

Semantic Scholar Scite Dimensions Connected Papers
Scholarly Connection Platforms
Dimensions Dimensions Connected Papers Connected Papers Scite Scite Google Scholar Google Scholar Semantic Scholar Semantic Scholar Garuda Garuda Scilit Scilit Crossref Crossref BASE BASE Zenodo Zenodo Unpaywall Unpaywall OpenCitations OpenCitations
Author Biographies
Muhamad Kamal Shamlan
Google Scholar ResearchGate ORCID

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

Sri Winarso Martyas Edi
Google Scholar ResearchGate ORCID

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

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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • Cahyani, A. D., Basuki, A., & Nafisah, D. (2022). Pengolahan Basis Data Mongo DB. Media Nusa Creative (MNC Publishing).
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • Makris, A., Tserpes, K., Spiliopoulos, G., Zissis, D., & Anagnostopoulos, D. (2021). MongoDB Vs PostgreSQL: A comparative study on performance aspects. GeoInformatica, 25, 243-268.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • Mishra, N., Chakraborty, A., & Mukhopadhyay, D. (2022, August). Breaking Cross-world isolation on ARM TrustZone through EM Faults, Coredumps, and UUID Confusion.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • Ravshanovich, A. R. (2024). DATABASE STRUCTURE: POSTGRESQL DATABASE. PSIXOLOGIYA VA SOTSIOLOGIYA ILMIY JURNALI, 2(7), 50-55.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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).
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
  • 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.
    Google Scholar Scite Semantic Scholar Scilit Crossref Connected Papers
License & Copyright
Creative Commons License

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

Authors who publish with this journal agree to the following terms:

1. Copyright Retention and Open Access License

Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).

This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

2. Rights Granted Under CC BY 4.0

Under this license, readers are free to:

  • Share — copy and redistribute the material in any medium or format
  • Adapt — remix, transform, and build upon the material for any purpose, including commercial use
  • No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed

3. Attribution Requirements

All uses must include:

  • Proper citation of the original work
  • Link to the Creative Commons license
  • Indication if changes were made to the original work
  • No suggestion that the licensor endorses the user or their use

4. Additional Distribution Rights

Authors may:

  • Deposit the published version in institutional repositories
  • Share through academic social networks
  • Include in books, monographs, or other publications
  • Post on personal or institutional websites

Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.

5. Self-Archiving and Pre-Print Sharing

Authors are encouraged to:

  • Share pre-prints and post-prints online
  • Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
  • Engage in scholarly communication throughout the publication process

6. Open Access Commitment

This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.

Downloads

Similar Articles

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