RDBMS Scoring Analysis: Billing System Efficiency Solution (Case Study at PT. XYZ)

Jaswadi Jaswadi, Bambang Purnomosidi Dwi Putranto, Sri Redjeki

Sari


Penggunaan Oracle exadata pada sistem billing di PT. XYZ membutuhkan biaya ATS (Annual Technical Support) dan ACS (Advanced Customer Service) yang besar sehingga dibutuhkan pencarian software database RDBMS yang sesuai untuk penyimpanan dan pengolahan data dalam proses generate billing di PT. XYZ. Oleh karena itu pada penelitian dilakukan analisis penentuan pemilihan database RDBMS (Relational Database Management System). Metode yang digunakan adalah metode scoring untuk membandingkan 3 database RDMS (Oracle non-exadata, EDB Postgres, dan 11DB Postgres) berdasarkan 5 kriteria yang meliputi penyiapan infrastruktur, migrasi data, tingkat akurasi hitung billing, durasi hitung billing, dan waktu pengerjaan. Hasil penelitian menunjukkan bahwa score database Oracle memiliki nilai paling tinggi di antara database yang lain yaitu sebesar 95, kemudian disusul oleh EDB Postgres dan 11DB Postgres dengan score secara berurutan yaitu sebesar 84 dan 57. Berdasarkan hal tersebut, maka dapat disimpulkan bahwa Oracle non-exadata memiliki performance yang paling tinggi di antara database yang lain. 

Teks Lengkap:

PDF

Referensi


O. Sunar Verma, I. Chaudhary, M. Javed khan, A. Kumar Chaudhary, and A. Professor, “A Comparative Study of Relational Database Management System and Object Oriented Database Management System,†International Journal of Creative Research Thoughts (IJCRT), vol. 9, no. 4, pp. 3493–3497, 2021, [Online]. Available: www.ijcrt.org

S. Maria and Y. A. Putri, “Perancangan Sistem Informasi Tes Penerimaan Siswa Baru Berbasis Komputer di Ponpes Darel Hikmah Berbasis Web,†Jurnal Intra Tech, vol. 5, no. 1, 2021.

N. G. Boyar, “A Case Study of RDBMS and OODBMS: Importance in Business,†International Journal od Research in Engineering, Science and Management, vol. 5, no. 11, pp. 1–6, 2022, [Online]. Available: https://www.ijresm.com

Md. SajjatulIslam and Md. Zainal Abedin, “Impacts of Data Mining on Relational Database Management System Centric Business Environments,†Int J Comput Appl, vol. 75, no. 3, pp. 21–27, Aug. 2013, doi: 10.5120/13091-0371.

J. I. Maanari, R. Sengkey, H. F. Wowor, and Y. D. Y. Rindengan, “Perancangan Basis Data Perusahaan Distribusi dengan Menggunakan Oracle,†e-journal Teknik Elektro dan Komputer, pp. 1–11, 2013.

B. Siswanto, “Oracle DBMS Scheduler Package for Data Integrity Test on Web-Based Application,†Journal of Telecommunication, Electronic and Computer Engineering (JTEC), vol. 12, no. 4, pp. 1–4, 2020, [Online]. Available: www.oracle.com

Bank Indonesia, “Pengumuman Pelelangan,†2020.

Bank Indonesia, “Pengumuman Tender,†2024. [Online]. Available: https://eprocurement.bi.go.id.

R. Kleweka, W. Truskowski, and M. Skublewska-Paszkowska, “Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases perfor-mance, including virtualization Porównanie wydajności baz danych MySQL, MSSQL, PostgreSQL oraz Oracle z uwzględnieniem wirtualizacji,†Journal Computer Sciences Institute (JCSI), vol. 16, pp. 279–284, 2020.

A. Dwi Praba and M. Safitri, “Studi Perbandingan Performansi Antara MySQL dan PostgreSQL,†Jurnal Khatulistiwa Informatika, vol. VIII, no. 2, pp. 88–93, 2020, [Online]. Available: https://www.adminer.org/.

R. Wodyk and M. Skublewska-Paszkowska, “Performance comparison of relational databases SQL Server, MySQL and PostgreSQL using a web application and the Laravel framework Porównanie wydajności relacyjnych baz danych SQL Server, MySQL oraz PostgreSQL z zastosowaniem aplikacji webowej i frameworku Laravel,†Journal Computer Sciences Institute (JCSI), vol. 17, pp. 358–364, 2020.

B. M. Klimek and M. Skublewska-Paszkowska, “Comparison of the performance of relational databases PostgreSQL and MySQL for desktop application Porównanie wydajności relacyjnych baz danych PostgreSQL oraz MySQL dla aplikacji desktopowej,†Journal Computer Sciences Institute (JCSI), vol. 18, pp. 61–66, 2021.

M. Choina and M. Skublewska-Paszkowska, “Performance analysis of relational databases MySQL, PostgreSQL and Oracle using Doctrine libraries Analiza wydajności relacyjnych baz danych MySQL, PostgreSQL oraz Oracle z zastosowaniem bibliotek Doctrine,†Journal Computer Sciences Institute, vol. 24, pp. 250–257, 2022.

A. Akhtar, “Popularity Ranking of Database Management Systems,†arXiv preprint arXiv:2301.00847, Jan. 2023, [Online]. Available: http://arxiv.org/abs/2301.00847

N. Kumar Miryala, “Evolving Trends in Open-Source RDBMS: Performance, Scalability and Security Insights,†International Journal of Science and Research (IJSR), vol. 13, no. 2, pp. 494–500, Feb. 2024, doi: 10.21275/sr24126224648.

Ms. Jailani, F. Jeka, and U. Negeri Sulthan Thaha Saifuddin Jambi, “Populasi dan Sampling (Kuantitatif), Serta Pemilihan Informan Kunci (Kualitatif) dalam Pendekatan Praktis,†Jurnal Pendidikan Tambusai, vol. 7, no. 3, pp. 26320–26332, 2023.

M. Sholikhan, S. Y. J. Prasetyo, and K. D. Hartomo, “Sholikhan 2019 - Pemanfaatan WebGISuntuk Pemetaan Wilayah Rawan Longsor Kabupaten Boyolali dengan Me,†Jurnal Teknik Informatika dan Sistem Informasi, vol. 5, no. 1, pp. 131–143, 2019.

M. Savchenko, L. Atzori, N. Papakyprianou, M. Piszczek, and A. Wiebalck, “Preparing for a new Data Center: Automated Management of a 10’000 node bare-metal fleet in CERN IT,†EPJ Web Conf, vol. 295, p. 07038, 2024, doi: 10.1051/epjconf/202429507038.

S. Chinta, “Harnessing Oracle Cloud Infrastructure for Scalable AI Solutions: A Study on Performance and Cost Efficincy,†TIJER, vol. 8, no. 11, pp. a29–a43, 2021, [Online]. Available: https://www.researchgate.net/publication/387271119

A. M. Potdar, D. G. Narayan, S. Kengond, and M. M. Mulla, “Performance Evaluation of Docker Container and Virtual Machine,†Procedia Comput Sci, vol. 171, pp. 1419–1428, 2020, doi: 10.1016/j.procs.2020.04.152.

M. Elamparithi, “Data Migration between Heterogeneous Relational Databases-Oracle, MySQL, PostgreSQL and Microsoft SQL Server,†J Algebr Stat, vol. 13, no. 3, pp. 637–653, 2022, [Online]. Available: https://publishoa.com

I. Hermawan, S. Sudirman, D. Perencanaan, J. Tol, and H. Karya, “Digitalisasi Industri Konstruksi dengan Integrasi BIM dan 3D Machine Control untuk Meningkatkan Performa Pelaksanaan Konstruksi,†Jurnal Teknik Sipil, vol. 19, no. 2, pp. 185–203, 2023, doi: 10.28932/jts.v1xix.x.

The DNSstuff Tech Team, "EnterpriseDB vs. PostgreSQL," 2 December 2024. [Online]. Available: https://www.dnsstuff.com/enterprisedb-vs-postgresql. [Accessed 21 January 2024].

geeksforgeeks, "Perbedaan Antara EnterpriseDB dan PostgreSQL," 24 September 2024. [Online]. Available: https://www.geeksforgeeks.org/enterprisedb-vs-postgresql/. [Accessed 31 January 2025].

M. Marden and C. W. Olofson, “EXECUTIVE SUMMARY The Economic and Business Advantages of EDB Postgres Database Solutions,†2016. [Online]. Available: www.idc.com

I. E. Tope, P. Zavarsky, R. Ruhl, and D. Lindskog, “Performance evaluation of oracle VM server virtualization software 64 bit Linux environment,†in Proceedings - 2011 3rd International Workshop on Security Measurements and Metrics, Metrisec 2011, IEEE Computer Society, 2011, pp. 51–57. doi: 10.1109/Metrisec.2011.16




DOI: http://dx.doi.org/10.30811/jaise.v5i1.6372

Refbacks

  • Saat ini tidak ada refbacks.


Indexing :

Creative Commons License
Journal of Artificial Intelligence and Software Engineering (JAISE) licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.