Integrated Drilling Database Enables Automated Drilling Engineering Design

Abstract

Abstract As the rapid development of drilling techniques and data acquiring techniques, more and more drilling data are available. Storing, managing and effective using of these massive data are crucial to optimized drilling engineering design and strategic decision. This article is to research and design an integrated drilling database, and then further explore the innovative usage of the available drilling data. Based on the detail analysis of drilling database requirement, this article researched and designed drilling database by three phases: conceptual design, logical design and physical design. In the conceptual stage, the requirements of drilling design data, real-time drilling data and drilling construction data are extracted and analyzed, then E-R model is constructed. In the logical design stage, data tables and table relationship are designed and refined based on the E-R model. In the physical design stage, physical structure is selected for the logical data model to satisfy the application requirement. The designed drilling database is targeted data storage and management basis for drilling engineering design and craft software, real-time drilling software and drilling history management software; it conforms to drilling business process, contains comprehensive and detailed content and has high performance and refined data table structure. The construction of unified drilling database enables the efficient storage of mass drilling data and further data mining and analysis of drilling information. This work further researched the algorithms of automatic drilling engineering design, especially for automatic wellbore geometry design, based on the available data in the database. This article introduced a systematic method to design an integrated drilling database, which supports design data, real-time data and drilling management data. It also proposed an innovative way of drilling engineering design: automated drilling engineering design based on the data in the integrated drilling database and pre-installed rules.