DrillerGeoDB : Windows-based Database Program for Effective Management of Drilling Data in Oil and Gas Industry

doi:None

All Issue

2008 Vol.45, Issue 6 Preview Page Next Page

DrillerGeoDB : Windows-based Database Program for Effective Management of Drilling Data in Oil and Gas Industry 석유시추 자료의 효과적인 관리를 위한 윈도우 기반 데이터베이스 프로그램 DrillerGeoDB 개발: 서장원, 최요순, 박형동
JangWon Suh, Yosoon Choi and Hyeong-Dong Park

31 December 2008. pp. 707-718

PDF

Abstract

A new database program called DrillerGeoDB was developed to manage drilling data for the oil and gas industry. Many types of drilling reports and previous drilling database systems were reviewed to characterize the elements of drilling information, An effective design of relational database was suggested to organize the elements effectively. DrillerGeoDB provides well-organized graphic user interfaces for creating, editing, exporting, querying and visualizing the drilling data as well as for interchanging data with a spreadsheet such as MS-Excel.

Keywords

Drilling data

Database

Characterization

User interface

Window program

본 연구에서는 석유시추 자료의 효과적인 관리를 위해 활용할 수 있는 윈도우 기반의 데이터베이스 프로그램 DrillerGeoDB를 개발하였다. 국내외 석유시추 조사 보고서와 해외 선진 개발사례를 비교･분석하여 석유시추 데이터베이스에 포함될 정보요소들을 특성화하였으며, 프로젝트 일반, 지층, 시추/검층, 공정평가 등의 정보들을 유기적으로 연계할 수 있는 관계형 데이터베이스 구조를 제시하였다. DrillerGeoDB 프로그램은 사용자 편의의 인터페이스를 통해 석유시추 자료의 입출력과 검색, 그래프 작성, 보고서 출력 등의 기능을 제공하며, Excel 등의 스프레드시트 프로그램과 손쉽게 자료를 호환할 수 있는 장점이 있다. 본 연구에서 수행한 석유시추 자료의 정보요소 특성화와 시범 데이터베이스 프로그램의 개발 성과는 향후 국가 석유시추 데이터베이스 구축을 위한 기초연구 자료로서 활용될 수 있을 것이라 기대한다.

키워드

석유시추 자료

데이터베이스

특성화

사용자 인터페이스

윈도우 프로그램

References

대한광업진흥공사, 2004, 시추자료 표준화 및 메타데이터 DB 구축, p. 124.
한국건설기술연구원, 2001, 지반정보 DB 구축방안 및 발전방향, p. 99.
한국수자원공사, 2004, 국가지하수관측망 관리시스템 보고서, p. 411.
Bowie, R., 2003, “National Geological Records Center : A unique and important resource,” BGS Earthwise, Vol, 16, pp. 10-11.
BRGM, 2002, BRGM ANNUAL REPORT 2002, pp. 34-35.
British Geological Survey, 2008, “GeoRecords,” http://
shop.bgs.ac.uk/GeoRecords/local_help.cfm?ln=EN, Cited 08 September 2008.
Chang, Y. S. and Park, H. D., 2004, “Development of a web-based Geographic Information System for the management of borehole and geological data,” Computers & Geosciences, Vol. 30, No. 8, pp. 887-897.
Corless, S., 1991, “Implementation of a Drilling Database System,” Proceedings of SPE Asia-Pacific Conference, Perth, Australia, 4-7 November (Paper No. SPE 23016).
D’Agnese, F. and O’Brien, G., 2003, “Impact of geoinformatics on the emerging geoscience knowledge integration paradigm,” In: Rosenbaum, M. S., Turner, A. K. (eds) Characterisation of the Shallow Subsurface: Implications for Urban Infrastructure and Environmental Assessment. Springer, Dusseldorf, pp. 303-312.
Dunn, M. D. and Payne, M. L., 1986, “Design, Specification and Implementation of Drilling Operations Database Program,” Proceedings of SPE 61st Annual Technical Conference and Exhibition, Orleans, LA, U.S.A, October 5-8 (Paper No. SPE 15360).
Geoinfo 지반정보, 2008, http://www.geoinfo.or.kr, Cited 05 September 2008.
Geological Survey of France, 2008, http://www.brgm.fr/donneeNumerique/detail.jsp?theme=B.DSS&pageActive=0&cook=1219307893606, Cited 05 September 2008.
Hatch, D. G. and Miller, E. L., 1983, “Computer Well Database – An Engineer’s Tool,” Proceedings of SPE Middle East Oil Technical Conference, Manama, Bahrain, March 14-17 (Paper No. SPE 11445).
McCammon, K. C. and Mackinlay, W. M., 1993, “The Development and Implementation of a Drilling Database: A Case Study,” Proceedings of SPE Petroleum Computer Conference, New Orleans, U.S.A, July 11-14 (Paper No. SPE 26257).
Sedlak, P., 2000, “Sources of Digital Geological Data in the CZECH REPUBLIC,” Geographica, Vol. 36, No. 1, pp. 65-70.
Thomson, S. M., 2000, “Well Construction and Intervention Engineering Using a Relational Database,” Proceedings of SPE Asia-Pacific Oil and Gas Conference and Exhibition, Brisbane, Australia, October 16-18, Paper No. SPE 64391.
Vahaaho, I., 1998, “From Geotechnical Maps to Threedimensional Models,” Tunnelling and Underground Space Technology, Vol. 13, No. 1, pp. 51-56.

Information

Publisher :The Korean Society of Mineral and Energy Resources Engineers
Publisher(Ko) :한국자원공학회
Journal Title :Journal of the Korean Society for Geosystem Engineering
Journal Title(Ko) :한국지구시스템공학회지
Volume : 45
No :6
Pages :707-718

[1] 대한광업진흥공사, 2004, 시추자료 표준화 및 메타데이터 DB 구축, p. 124.

[2] 한국건설기술연구원, 2001, 지반정보 DB 구축방안 및 발전방향, p. 99.

[3] 한국수자원공사, 2004, 국가지하수관측망 관리시스템 보고서, p. 411.

[4] Bowie, R., 2003, “National Geological Records Center : A unique and important resource,” BGS Earthwise, Vol, 16, pp. 10-11.

[5] BRGM, 2002, BRGM ANNUAL REPORT 2002, pp. 34-35.

[6] British Geological Survey, 2008, “GeoRecords,” http://

[7] shop.bgs.ac.uk/GeoRecords/local_help.cfm?ln=EN, Cited 08 September 2008.

[8] Chang, Y. S. and Park, H. D., 2004, “Development of a web-based Geographic Information System for the management of borehole and geological data,” Computers & Geosciences, Vol. 30, No. 8, pp. 887-897.

[9] Corless, S., 1991, “Implementation of a Drilling Database System,” Proceedings of SPE Asia-Pacific Conference, Perth, Australia, 4-7 November (Paper No. SPE 23016).

[10] D’Agnese, F. and O’Brien, G., 2003, “Impact of geoinformatics on the emerging geoscience knowledge integration paradigm,” In: Rosenbaum, M. S., Turner, A. K. (eds) Characterisation of the Shallow Subsurface: Implications for Urban Infrastructure and Environmental Assessment. Springer, Dusseldorf, pp. 303-312.

[11] Dunn, M. D. and Payne, M. L., 1986, “Design, Specification and Implementation of Drilling Operations Database Program,” Proceedings of SPE 61st Annual Technical Conference and Exhibition, Orleans, LA, U.S.A, October 5-8 (Paper No. SPE 15360).

[12] Geoinfo 지반정보, 2008, http://www.geoinfo.or.kr, Cited 05 September 2008.

[13] Geological Survey of France, 2008, http://www.brgm.fr/donneeNumerique/detail.jsp?theme=B.DSS&pageActive=0&cook=1219307893606, Cited 05 September 2008.

[14] Hatch, D. G. and Miller, E. L., 1983, “Computer Well Database – An Engineer’s Tool,” Proceedings of SPE Middle East Oil Technical Conference, Manama, Bahrain, March 14-17 (Paper No. SPE 11445).

[15] McCammon, K. C. and Mackinlay, W. M., 1993, “The Development and Implementation of a Drilling Database: A Case Study,” Proceedings of SPE Petroleum Computer Conference, New Orleans, U.S.A, July 11-14 (Paper No. SPE 26257).

[16] Sedlak, P., 2000, “Sources of Digital Geological Data in the CZECH REPUBLIC,” Geographica, Vol. 36, No. 1, pp. 65-70.

[17] Thomson, S. M., 2000, “Well Construction and Intervention Engineering Using a Relational Database,” Proceedings of SPE Asia-Pacific Oil and Gas Conference and Exhibition, Brisbane, Australia, October 16-18, Paper No. SPE 64391.

[18] Vahaaho, I., 1998, “From Geotechnical Maps to Threedimensional Models,” Tunnelling and Underground Space Technology, Vol. 13, No. 1, pp. 51-56.

Journal of the Korean Society of Mineral and Energy Resources Engineers 한국자원공학회지 ISSN:2288-0291(Print) 2288-2790(Online)

All Issue