Multidimensional model based oil and gas resource data key system implementation method and system

Abstract

The invention discloses a multidimensional model based oil and gas resource data key system implementation method and system. According to the multidimensional model based oil and gas resource data key system implementation system, sorting, cleaning, classification and systematization are performed on source data of oil and gas resources, cleaning, transformation and integration are performed based on an ETL (Extract-Transform-Load) framework, the source data are loaded into a data warehouse or a market to form a core database, and the data processing efficiency is improved and data mining is performed through establishment of a multidimensional model. According to the multidimensional model based oil and gas resource data key system implementation method, different latitudes of the data can be flexibly combined, the custom analysis on core data such as the oil price, the yield, reserves, the quantity of the resources, import and export and the mining right is achieved, integrated management and visual display of statements, graphics, texts and maps are supported, interfaces and function modules of the system are based on a configuration scheme, and accordingly the configuration is flexible, the extension can be performed, the use is easy, the display form of the data is enriched, and the retrieval efficiency is improved.

Description

technical field [0001] The invention belongs to the technical field of databases, data warehouses and computer graphics, and relates to a method for realizing an oil and gas resource data overview system based on a multidimensional model and an oil and gas resource data overview system. Background technique [0002] Oil and gas resources are important energy minerals and strategic resources. The strategic investigation and evaluation, planning, management, protection and rational utilization of oil and gas resources all involve the collection, processing, management and decision-making of massive data. It is urgent to use modern information technology to realize the digitization, networking, visualization and intelligence of the collection, transmission, storage, processing and service of oil and gas resource information. [0003] Oil and gas data is famous for its massiveness, including both spatial location data and entity attribute data. How to use the huge data stored in...

AI Technical Summary

Problems solved by technology

[0004] In order to solve the problem of low efficiency in the management, retrieval and presentation of oil and gas resources data in the prior art, the present invention provides a method and system for realizing an overview system of oil and gas resources data based on a multi-dimensional model. Sort, clean, classify and systematize, and extract the data from distributed heterogeneous data sources to the temporary middle layer based on the ETL (data extraction, transformation, loading) architecture for cleaning, transformation and integration, and then load it into the data warehouse or In the data mart, a core business database is formed; a multi-dimensional data model is established to process the huge data stored in the database to mine deeper information; the system breaks through the existing form and menu query framework, and uses human Information favorite, according to user needs, through artificial dynamic configuration to generate oil and gas resource data display interface and functional modules, to achieve richer visualization means to represent oil and gas information elements, as well as customized analysis of oil and gas resource data, to improve the search efficiency of oil and gas elements efficiency

Images