A Comparative Study of Complex Query Performance on MySQL and Oracle Databases for the Oil and Gas Industry
Ellyz Yaory, Ida Bagus Kerthyayana Manuaba · 2024
Data has become an essential component in decision- making across various industries including the oil and gas sector. Before utilizing and generating data into insights, data storage and accessibility are necessary. Databases which are commonly used in the oil and gas sector are MySQL and Oracle databases due to the requirement for standardized and uniform data storage. The major challenge in this industry is implementing and executing complex queries efficiently because of the volume and data complexity involved. Hence, the purpose of this study is evaluating whether the execution of complex queries on MySQL and Oracle databases for the oil and gas scenario is efficient. To reach this goal, we utilized Docker to build up the database environment. Afterwards, dummy data was generated, and a complex SQL query was formulated based on the schema. Then, the testing scenarios, variables, and analysis methods were planned. In this study, MySQL database has a better execution time and CPU time performance compared to Oracle database for all the tested scenarios. T-test is one of the analysis methods used to find out whether the performance is significantly different, and after analyzing, there is a significant difference. The results imply that MySQL database is quicker in execution time and CPU time than Oracle database. The aim of this study is to highlight the importance of selecting a database in the oil and gas industry. MySQL has a faster execution time and CPU time performance compared to Oracle database.