Study On The Multidimensional Analysis Of Drilling Materials Information Based On Big Data

Oil drilling process needs to use a variety of species and types of drilling materials.The traditional drilling materials management information systems are mainly for the management of transaction information used for drilling materials.They lack of the decision support and analysis for drilling material usage information,and not fully utilize and exert the large amounts of data information which is accumulated in information construction.The paper adopts the theory and method of big data to study of the multidimensional analysis method of drilling material information based on big data,in order to further improve efficiency of management of drilling enterprise.Firstly,the system structure of drilling material information management system based on big data is constructed in the thesis.We use the theories and methods of big data and combine with the Hadoop technology and distributed storage to construct thearchitecture of drilling material information management system based on Hadoop and a solution of multidimensional analysis.Secondly,the design and implementation of data warehouse based on Hive is proposed in the thesis.The design of the subject and the fact table and dimension table of the data warehouse can be used to construct the corresponding multidimensional data mode and realize the design of the data warehouse.The process of data extraction,conversion and organization in data warehouse is designed with the technology of Hive and the data transfer between HDFS and tradition relational database is realized by Sqoop.Thirdly,the thesis studies put forward the multidimensional analysis method of drilling material based on Hadoop.There are some general operations which are used to analyze the multidimensional data such as slicing,cut,drill,rotation and so on;The thesis achieves multidimensional analysis based on MapReduce to help enterprise policy makers' working analysis data from different angles.Using the theory and method of big data to process drilling material information data can give full play to the advantage of low cost and high efficiency.The thesis have developed a drilling material multidimensional analysis prototype system based on big data,which provides the auxiliary support for the problems such as widely distribution,large amount of data,difficult to integrate and timely analysis.