Research of Data-Warehouse-Based OLAP Drilling Analysis System

Abstract

To fulfill the requirements of complex analyzing of drilling analysis system, aim at the inability of analysis power which exists in traditional information system by database technology, a data-warehouse-based OLAP system has been analyzed and studied within this paper. In accordance with the characteristics of users (which are wild spread at international level) of drilling system, a system of B/S structure-based OLAP has been applied. According to some real examples, a multi-dimensional model of data warehouse OLAP structure-based drilling analysis system has been designed. With this model of multi-dimensional drilling analysis system, data multi-analysis can be processed via OLAP, and various complex analysis functionalities for multi-dimensional data set of drilling system could be implemented.