Designing a conceptual model for geochemical geodatabase of oil wells: A case study of Gachsaran Oilfield


Department of Remote Sensing and GIS, Faculty of Earth Sciences, Shahid Chamran University of Ahvaz, Ahvaz, Iran


Due to the necessity of identification and need assessment phase in the creation and the development of Geodatabase and Geographic Information System (GIS), designing a concept model is being introduced as its first phase of the study. Conceptual data modeling using ERD (Entity-Relationship Diagram) method, by defining entities, attributes, and the relationship between spatial and non-spatial entities. In this study, using the ERD method, a spatial database structure is designed for geochemical data of oil wells. Petroleum geochemical data is used for oilfield exploration, management, production, and development. In an oilfield, the most basic spatial entity is the wells. Other spatial entities in this study are field boundaries, sectors, and formations. Non-spatial entities were defined in separate tables, including oil samples and parameters derived from the geochemical analysis of samples in the Gachsaran oilfield. The ER diagram was designed using SAP Power Designer Software by establishing a 1 to N relationship between the well and all entities as well as determining the primary key and foreign key for each relationship. 11 entities were identified to create the data model.The result of applying the conceptual model before creating the Geodatabase is the logical structure of the database; also, spatial data modeling ensures the success of creating and developing a Geodatabase and WebGIS. As a result, the designed conceptual model simplifies the creation of a spatial database for display, processing, query and analysis of geochemical data of oil wells.


Alizadeh, B., Maroufi, K., Fajrak, M., 2017. Hydrocarbon reserves of Gachsaran oilfield, SW Iran: Geochemical characteristics and origin. Marine and Petroleum Geology 92, 308-318.
Bagui, S., Earp, R., 2012. Database Design Using Entity-Relationship Diagrams, Second Edition, CRC Press, Taylor & Francis Group, p. 362.
Bordenave, M.L., Hegre, J.A., 2005. The Influence of Tectonics on the Entrapment of oil in the Dezful Embayment, Zagros Fold Belt, Iran. Journal of Petroleum Geology 28, 339-368.
Chen, P.P., 1976. The entity-relationship model-toward a unified view of data. ACM Transactions on Database Systems 1(1), 9–37.
Faraji Sabokbar, H., Mansourian, A., Reza Ali, M., Aghanezhad Ahmadchali, M.R., 2013. Presenting a conceptual model for managing the local data infrastructure of the municipality. Case study: Babol Municipality. Human Geographical Research 48, 44-23.
Farshi, M., Moussavi-Harami, R., Mahboubi, A., Khanehbad, M., 2019. Reservoir rock typing using integrating geological and petrophysical properties for the Asmari Formation in the Gachsaran oilfield, Zagros basin. Journal of Petroleum Science and Engineering 176, 161-171.
Forouzandeh Dehkordi, H., 2013. Database Management, 1nd ed, Iran Textbook Publishing Company, Tehran.
Fozoun Bal, M., 2004. Application of Geographic Information Systems in Oil, Gas and Petrochemical Industries, Scientific-Promotional Monthly of Oil Exploration and Production, No. 15.
Griffiths, P.R., De Haseth, J. A., 2007. Fourier transform infrared spectrometry, 2nd ed. John Wiley & Sons, p. 542.
Han, T., Rukhlov, A., Riddell, J., Ferbey, T., 2019. A skeleton data model for geochemical database at the British Columbia geological survey, British Columbia Ministry of Energy. Mines and Petroleum Resources, pp. 125-135.
Hartcher, M., Shearin, J., 1996. Developing a Corporate Wide Network for GIS, pp. 8-12.
Hunt, M.J., 1996. Petroleum geochemistry and geology, 2nd ed. WH Freeman and company, New York, p. 764.
MacDonald, A., 2001. Building a Geodatabase, GIS by ESRI, USA, p. 490.
Makris, A., Tserpes, K., Spiliopoulos, G., Anagnostopoulos, D., 2019. Performance evaluation of MongoDB and PostgreSQL for Spatio-temporal data. In Proceedings of the 2nd International Workshop on Big Mobility Data Analytics, Lisbon, Portugal, 26–29.
Maroufi, K., 2017. Investigation of Reservoirs Fluid Properties and Continuity in Gachsaran and Mansourabad Oilfields Using Integration of Reservoir Geochemistry and Engineering Approaches, Ph.D. thesis, Shahid Chamran University of Ahvaz.
Mohamed. J, M.A., Jaafar, A.F., Ismail, M.H.D., Othman, M.A., 2017. Fourier Transform Infrared (FTIR) Spectroscopy, Rahman University Technology Malaysia, Johor Bahru, Johor, Malaysia, Elsevier Inc, Chapter 1, pp. 3-29.
Motiei, H., 1993. Stratigraphy of Zagros. Geological Survey of Iran Publication, 536 p (in Persian).
Nouri, R., Memariani, M., Kamali, M., 2008. A Study of Oil Systems in Gachsaran Square, Proceedings of the 12th Conference of the Iranian Geological Society, Ahvaz - National Oil Company of the South, 1-7.
Peter, K. E., Fowler, M. G., 2002. Application of Petroleum geochemistry to exploration and reservoir management. Organic Geochemistry 33, 5-36.
Rangzan, K., Karimian, R., Kabolizadeh, M., 2019. Using Google Earth to detection oil wells and pipelines: A case study of Gachsaran oilfield, computer, Information Technology and Applications of artificial intelligence, Ahvaz, Khuzestan Industry, Mining and Trade Organization, p. 1-9.
Rouhani Rankouhi, M. T., 1993. Introduction of Database, Jelveh, 1st edition, p. 520.
Seddighi, N., 2016. ERD diagram and conceptual model of WebGIS system database of New Cities Development Company, 3rd International Conference on Science and Engineering, Istanbul - Turkey.
Sherman, R., 2015. Business Intelligence Guidebook, Data Integration to Analytics, Elsevier Inc, p. 173-195.
Shukla, D., Shivnani, C., Shah, D., 2016. Comparing oracle spatial and Postgres PostGIS. IJCSE, p. 95–100.
Sveen, A.F., 2019. Efficient storage of heterogeneous geospatial data in spatial databases. Journal of Big Data, pp. 102.
Teorey, T., Lightdtone, S., Nadeau, T., 2011. Database Modeling & Design, 5th edition, Morgan Kaufmann Publishers, Elsevier, USA, pp. 335.
van Graas, G.W., 1990. Biomarkers maturity parameters for high maturities: calibration of the working range up to oil/condensate threshold. Organic Geochemistry 16, 1025-1032.
Walpes, D.W., 1985. Geochemistry in Petroleum exploration. 1nd ed, IHRDC Press, Boston, MA, p. 232.
Young Park, Ch., Blackmond Laskey, K., 2019. A Mapping between Multi-Entity Bayesian Network and Relational Model. Applied Sciences 9(9), pp.26.