APPLICATION OF MULTI-TIER DATA WAREHOUSE IN OIL AND GAS DRILLING IMFORMATION MANAGEMENT

Oil and gas drilling is a system engineering cooperating with multidisciplinary professional technologies, and it features dispersed working locations, huge information volume and complex data. Data Warehouse (DW) is a good solution for drilling information management and application, and can provide the decision makers of petroleum enterprises with effective technical support. However, DW construction demands vast capital, human resource and time, while it can’t accomplish information processing of different levels in short-term. Therefore, a model of multi-tier data warehouse is adopted to develop a Drilling Information Comprehensive Management and Application System based on current technology of data warehouse. The structure model of the system is presented in this paper and its validity is proved by using an example. Thus the efficiency of system development is improved and lots of cost and time is saved, and at the same time, the needs of information processing in different levels are also accomplished.