Usability and Performance Comparison: Implementation of Tibero and Oracle Databases in the Context of CAMS Software Development

Komang Yuli Santika; Dandy Pramana Hostiadi; Putu Desiana Wulaning Ayu

doi:10.23887/janapati.v13i3.82519

Authors

Komang Yuli Santika ITB STIKOM Bali
Dandy Pramana Hostiadi Institut Teknologi dan Bisnis STIKOM Bali
Putu Desiana Wulaning Ayu Institut Teknologi dan Bisnis STIKOM Bali

DOI:

https://doi.org/10.23887/janapati.v13i3.82519

Keywords:

Database, Tibero, Oracle, DBMS, Performance Testing

Abstract

In the world of software development, the role of database systems is very vital. Enterprise software, designed to handle the complex challenges of large organizations, requires reliable and efficient databases. Oracle, one of the top choices in the industry, stands out with its performance and flexibility. On the other hand, Tibero, a relational DBMS from TmaxSoft, offers the high performance, reliability and scalability required in business environments that require big data management. This research was conducted to analyze the technical side of the Oracle and Tibero databases in the context of the CAMS (Customer Asset Management System) application, with a focus on usability and performance aspects. This research uses the Performance Testing method to evaluate CPU, Memory, Storage resource usage and TPS (Transaction Per Second) of the two databases as well as the System Usability Scale (SUS) to measure user experience. The results provide information to software developers in selecting databases that suit business needs, while contributing to the development of the information technology industry

References

Ningsih, M., & Muzakir, A. (2021). Mengevaluasi User Interface Untuk Meningkatakan User Experience (Ux) Menggunakan Metode System Usability Scale (Sus). Bina Darma Conference on Computer Science, 365–374.

Laksana, F. F., & Suyoto, S. (2019). Pengukuran Kualitas Ux Website Menggunakan Sus. Computer Engineering, Science and Systems Journal, 4(2), 138. doi: 10.24114/cess.v4i2.12928.

Herdiana, G. A., Swarmardika, I. B. A., & Hartati, R. S. (2022). Pengukuran User Experience (Ux) Desain Aplikasi Trouble Ticket Menggunakan Metode Supergolden Ratio. SINTECH (Science Information Technology Journal), 5(1), 42–48. doi: 10.31598/sintechjournal.v5i1.1093.

Nopita, M., Purnamasari, S. D., & Yudiastuti, H. (2022). Evaluasi Usability Website SMA PGRI 2 Palembang Menggunakan System Usability Scale (SUS). Jurnal Mantik, 6(3), 3299–3307.

Maricar, M. A., & Pramana, D. (Year not provided). Usability Testing pada Sistem Peramalan Rentang Waktu Kerja Alumni ITB STIKOM Bali. Jurnal Eksplora Inform, 9(Issue not provided).

Praba, A. D., & Safitri, M. (2020). Studi Perbandingan Performasi Antara MySQL dan PostgreSQL.

Ilić, M., Kopanja, L., Zlatković, D., Trajković, M., & Ćurguz, D. (2021). Microsoft SQL Server and Oracle: Comparative Performance Analysis.

Otte, H. Compressing 3D Models Into Micro Meshes – A Usability Comparison Between Two Conversion Toolkits.

Xu, Y., Park, Y., Park, J. D., & Sun, B. (2023). Predicting Nurse Turnover for Highly Imbalanced Data Using the Synthetic Minority Over-Sampling Technique and Machine Learning Algorithms.

Fuertes, A. B., Pérez, M., & Meza, J. (2023). Nmorph Framework: An Innovative Approach to Transpiler-Based Multi-Language Software Development.

Costa, C., Faria, J. M., Guimarães, D., Matos, D., & Moreira, A. H. J. (2023). A Wearable Monitoring Device for COVID-19 Biometric Symptoms Detection.

Al‐Khiami, M. I., Jaeger, M., & Soleimani, S. M. (2023). Enhancing Concrete Structures Education: Impact of Virtual Reality on Motivation, Performance, and Usability for Undergraduate Engineering Students.

Naito, H., Matsumoto, M., & Nakano, M. (2023). Performance Analysis of Comparison Operations on Homomorphically Encrypted Sensitive Data.

Kent, R. D., Kent, J. F., & Rosenbek, J. C. (1987). Maximum Performance Tests of Speech Production. Journal of Speech and Hearing Disorders, 52, 367-387. doi: 10.1044/jshd.5204.367. University of Wisconsin–Madison and Veterans Administration Hospital, Madison WI.

Molyneaux, I. (2015). The Art of Application Performance Testing: From Strategy to Tools (2nd ed.). Sebastopol, CA: O'Reilly Media Inc.

Colley, D., & Stanier, C. (2017). Identifying New Directions in Database Performance Tuning. In Social Care Information Systems and Technologies, CENTERIS / ProjMAN / HCist 2017, 8-10 November 2017, Barcelona, Spain. Procedia Computer Science, 00, 000–000. Elsevier B.V

TmaxSoft, "Tibero SQL Reference Guide," 2017. [Online]. Available: https://technet.tmaxsoft.com/upload/download/online/tibero/pver-20170217-000001/sql-reference/index.html. [Accessed: Jul. 10, 2024].

Naito, H., Matsumoto, M., & Nakano, M. (2023). Performance Analysis of Comparison Operations on Homomorphically Encrypted Sensitive Data.

Tongkaw, S., & Tongkaw, A. (2019). A Comparison of Database Performance of MariaDB and MySQL with OLTP Workload. Songkhla Rajabhat University, Songkhla, Thailand

Roy, A.M.; Bhaduri, J. (2021). A Deep Learning Enabled Multi-Class Plant Disease Detection Model Based on Computer Vision. AI, 2, 413–428.

Roy, A.M. (2022). An efficient multi-scale CNN model with intrinsic feature integration for motor imagery EEG subject classification in brain-machine interfaces. Biomed. Signal Process. Control., 74, 103496.

Singh, A., Raj, K., Kumar, T., Verma, S., Roy, A.M. (2023). Deep Learning-Based Cost-Effective and Responsive Robot for Autism Treatment. Drones, 7, 81.

Kumar, M.S. (2018). Comparison of NoSQL Database and Traditional Database-An emphatic analysis. JOIV Int. J. Inform. Vis., 2, 51–55.

Kolev, B., Bondiombouy, C., Valduriez, P., Jiménez-Peris, R., Pau, R., Pereira, J. (2016). The cloudmdsql multistore system. In Proceedings of the 2016 International Conference on Management of Data, San Francisco, CA, USA, 26 June–1 July 2016; pp. 2113–2116.

Zhou, L., Fu, A., Yu, S., Su, M., Kuag, B. (2018). Data integrity verification of the outsourced big data in the cloud environment: A survey. J. Netw. Comput. Appl., 122, 1–15.

Sahatqija, K., Ajdari, J., Zenuni, X., Raufi, B., Ismaili, F. (2018). Comparison between relational and NoSQL Databases. In Proceedings of the 2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO), Opatija, Croatia, 21–25 May 2018; pp. 216–221.

Alias, N., Suhari, N.N., Saipol, H.F., Dahawi, A.A., Saidi, M.M., Hamlan, H.A., Teh, C.R. (2016). Parallel computing of numerical schemes and big data analytic for solving real life applications. Jurnal Teknologi, 78.

Chang, M.-L.E., Chua, H.N. (2018). SQL and NoSQL Database Comparison. In Proceedings of the Future of Information and Communication Conference, Vienna, Austria, 4–6 December 2018; pp. 294–310.

Frizzo-Barker, J., Chow-White, P.A., Mozafari, M., Ha, D. (2016). An empirical study of the rise of big data in business scholarship. Int. J. Inf. Manag., 36, 403–413.

Alomari, E., Barnawi, A., Sakr, S. (2015). Cdport: A framework of data portability in cloud platforms. In Proceedings of the 16th International Conference on Information Integration and Web-based Applications & Services, Singapore, 28–30 November 2014; pp. 126–133.

Vanelli, B., da Silva, M.P., Manerichi, G., Pinto, A.S.R., Dantas, M.A.R., Ferrandin, M., Boava, A. (2017). Internet of Things Data Storage Infrastructure in the Cloud Using NoSQL Databases. IEEE Lat. Am. Trans., 15, 737–743.

Ansari, H. (2022). Performance Comparison of Two Database Management Systems MySQL vs. MongoDB; Umeå University: Umeå, Sweden.

Santoso, J. (2018). Usability User Interface Dan User Experience Media Pembelajaran Kamus Kolok Bengkala Berbasis Android. Journal of Educational Technology, 15(2), 123-130

Hendra, & Andriyani, W. (2020). Studi Komparasi Menyimpan dan Menampilkan Data Histori antara Database Terstruktur MariaDB dan Database tidak Terstruktur InfluxDB. Journal of Data Management, 33(2), 150-160

Sandhiyasa, I. M. S., Yanti, C. P., & Hendrawati, T. (2021). Implementation and Evaluation of Accounting Information Systems in Manufacturing Company Using System Usability Scale. Indonesian Journal of Accounting, 19(3), 45-55

Permatasari, D. I., Ardani, M., Ma’ulfa, A. Y., Ilhami, N., Pratama, S. G., Astuti, S. R. D., & Naufalita, N. W. (2020). Pengujian Aplikasi Menggunakan Metode Load Testing dengan Apache Jmeter pada Sistem Informasi Pertanian. Journal of Agricultural Informatics, 14(1), 67-76

Juniawan, F. P., Laurentinus, & Sylfania, D. Y. (2021). Evaluasi Usability Sistem Pelaporan Publikasi Penelitian Dosen Berbasis Android. Journal of Mobile Computing, 29(4), 89-98.

D. Madhani, E. Darwiyanto, dan A. Gandhi, "Performance Testing Menggunakan Metode Load Testing dan Stress Testing pada Sistem Core Banking PT. XYZ," e-Proceeding of Engineering, vol. 10, no. 6, pp. 5431, Desember 2023.

Permatasari D I, Ardani M, & Ma’ulfa A Y. (2020). Pengujian Aplikasi Menggunakan Metode Load Testing dengan Apache Jmeter pada Sistem Informasi Pertanian. JUSTIN (Jurnal Sistem dan Teknologi Informasi), 8(1), 135-139.

Diastama I G N P D D, Sukarsa I M, Wirdiani N K A. (2021). Pengembangan Test Script untuk Load Testing Web dengan metode Software Testing Life Cycle. JITTER. 2(1).

Chou C Y, Fang Y B, Wang S T, & Kuo F A. (2020). Smoke and Stress Tests for Travel Service Applications via LoadRunner. LNISA, 11894, 366-373.

Fansha D A, Setyawan M Y H, & Fauzan M N.(2021). Load Test pada Microservice yang menerapkan CQRS dan Event Sourcing. Jurnal Buana Informatika, 12(2), 126-134.