Study on Object-Relational Mapping (ORM) Data Model Performance Effects in the Oil and Gas Industry

This paper discusses the performance of Object Relational Model data models in managing data for the oil and gas industry within Indonesia. The paper derives from a regulation made by the Indonesian government to standardize the format for data that falls under the category of upstream oil and gas affecting a total of 45 different data types. The paper aims to simulate ORM data models to identify their performance in managing rapidly growing data. The comparisons conducted within the paper are file space, data redundancy, and average operation time. The comparisons will be between normalized and non-normalized data models that are tested over 1000, 10,000, and 100,000 iterations of CRUD operations. A two-way ANOVA will analyze the mean differences between ORM models and database operations (Create, Read, Update, Delete) concerning average operation time. Results indicate that normalized data models perform better in average operation time compared to non-normalized models.