CN103984755A - Multidimensional model based oil and gas resource data key system implementation method and system - Google Patents
Multidimensional model based oil and gas resource data key system implementation method and system Download PDFInfo
- Publication number
- CN103984755A CN103984755A CN201410232574.1A CN201410232574A CN103984755A CN 103984755 A CN103984755 A CN 103984755A CN 201410232574 A CN201410232574 A CN 201410232574A CN 103984755 A CN103984755 A CN 103984755A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- database
- hydrocarbon resources
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 34
- 238000004458 analytical method Methods 0.000 claims abstract description 31
- 238000007726 management method Methods 0.000 claims abstract description 24
- 238000013499 data model Methods 0.000 claims abstract description 19
- 230000000007 visual effect Effects 0.000 claims abstract description 13
- 238000012545 processing Methods 0.000 claims abstract description 10
- 239000000284 extract Substances 0.000 claims description 11
- 230000008569 process Effects 0.000 claims description 10
- 238000013523 data management Methods 0.000 claims description 9
- 238000013461 design Methods 0.000 claims description 6
- 238000011068 loading method Methods 0.000 claims description 6
- 238000013075 data extraction Methods 0.000 claims description 5
- 238000012795 verification Methods 0.000 claims description 5
- 238000006243 chemical reaction Methods 0.000 claims description 4
- 239000004215 Carbon black (E152) Substances 0.000 claims 20
- 229930195733 hydrocarbon Natural products 0.000 claims 20
- 150000002430 hydrocarbons Chemical class 0.000 claims 20
- 230000015572 biosynthetic process Effects 0.000 claims 2
- 238000004040 coloring Methods 0.000 claims 1
- 238000011369 optimal treatment Methods 0.000 claims 1
- 238000012546 transfer Methods 0.000 claims 1
- 238000004519 manufacturing process Methods 0.000 abstract description 12
- 230000008676 import Effects 0.000 abstract description 5
- 238000005065 mining Methods 0.000 abstract description 4
- 238000007418 data mining Methods 0.000 abstract 1
- 239000007789 gas Substances 0.000 description 76
- 230000006870 function Effects 0.000 description 16
- 238000011161 development Methods 0.000 description 10
- 238000012800 visualization Methods 0.000 description 6
- 230000002354 daily effect Effects 0.000 description 5
- 229910052500 inorganic mineral Inorganic materials 0.000 description 5
- 239000011707 mineral Substances 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 4
- 238000005259 measurement Methods 0.000 description 4
- VNWKTOKETHGBQD-UHFFFAOYSA-N methane Chemical compound C VNWKTOKETHGBQD-UHFFFAOYSA-N 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 230000010354 integration Effects 0.000 description 3
- 238000003860 storage Methods 0.000 description 3
- 230000009466 transformation Effects 0.000 description 3
- 238000004140 cleaning Methods 0.000 description 2
- 238000011156 evaluation Methods 0.000 description 2
- 239000003345 natural gas Substances 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000013501 data transformation Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000010921 in-depth analysis Methods 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 230000001131 transforming effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/02—Agriculture; Fishing; Forestry; Mining
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Mining & Mineral Resources (AREA)
- Life Sciences & Earth Sciences (AREA)
- Economics (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- General Business, Economics & Management (AREA)
- Marine Sciences & Fisheries (AREA)
- Animal Husbandry (AREA)
- Agronomy & Crop Science (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
本发明公开一种基于多维度模型的油气资源数据要览系统实现方法及系统,该系统通过对油气资源的源数据进行整理、清理、归类及系统化,基于ETL架构进行清洗、转换和集成,然后加载到数据仓库或集市中形成核心数据库;再通过建立多维度数据模型,提高数据的处理效率并进行数据挖掘;该方法可灵活组合数据的不同纬度,实现对油价、产量、储量、资源量、进出口、矿权等核心数据的定制分析,支持报表、图表、文本、地图的集成管理和可视化展示,系统的界面和功能模块基于配置方案,具有灵活配置、可扩展、易于使用等特点,丰富了数据的展示形式,提高了检索效率。
The invention discloses a method and system for realizing an overview system of oil and gas resource data based on a multi-dimensional model. The system cleans, converts and integrates source data of oil and gas resources based on an ETL framework by sorting, clearing, categorizing and systematizing , and then loaded into the data warehouse or bazaar to form a core database; and then by establishing a multi-dimensional data model, data processing efficiency is improved and data mining is performed; this method can flexibly combine different latitudes of data to realize oil price, production, reserves, Customized analysis of core data such as resource volume, import and export, and mining rights, supports integrated management and visual display of reports, charts, texts, and maps. The interface and functional modules of the system are based on configuration schemes, with flexible configuration, scalability, and ease of use. It enriches the display form of data and improves the retrieval efficiency.
Description
技术领域technical field
本发明属于数据库(Database)、数据仓库(Data Warehouse)和计算机制图技术领域,涉及一种基于多维度模型的油气资源数据要览系统实现方法及油气资源数据要览系统。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
油气资源是重要的能源矿产和战略性资源,油气资源战略调查评价、规划、管理、保护和合理利用等各个环节,都涉及到海量数据资料的采集、处理、管理与决策,迫切需要利用现代信息技术,以实现油气资源信息的采集、传输、存储、处理和服务的数字化、网络化、可视化和智能化。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.
油气数据以其海量性而著称,既有空间位置数据,又有实体属性数据,如何利用数据库中存储的庞大数据,挖掘更深层次的信息以辅助决策,将油气信息要素以更丰富的可视化手段来表现,提高油气要素检索的效率,是当前面临的重大课题。现有的利用数据库技术检索信息方法,检索效率不高,展示数据形式单一。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 the database to mine deeper information to assist decision-making, and to visualize oil and gas information elements with richer visualization means Improving the efficiency of oil and gas element retrieval is a major issue at present. The existing method of using database technology to retrieve information has low retrieval efficiency and a single form of display data.
发明内容Contents of the invention
为解决现有技术对油气资源数据管理、检索与表现效率低下的问题,本发明提供一种基于多维度模型的油气资源数据要览系统实现方法及系统,该系统通过对油气资源的源数据进行整理、清理、归类及系统化,并将分布异构的数据源中的数据基于ETL(数据提取、转换、加载)架构抽取到临时中间层进行清洗、转换和集成,然后加载到数据仓库或数据集市中,形成核心业务数据库;建立多维度数据模型,将数据库中存储的庞大数据经过处理以挖掘其更深层次的信息;该系统突破现有的表格、菜单查询的框架,利用人类对图形信息的喜爱,依据用户需求,通过人工动态配置生成油气资源数据的展示界面和功能模块,达到以更丰富的可视化手段来表现油气信息要素,以及对油气资源数据的定制分析,提高油气要素检索的效率。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.
本发明中的多维度模型或多维度数据模型是将数据以数据立方体的形式,按照度量、维度、层次结构和多维数据集为组织结构,围绕主题为中心来组织数据,该主题用事实表来表示,事实用数值来度量。本发明采用面向对象数据库设计,通过数据仓库技术及软件集成方法,实现核心数据库的建立、多维度数据模型的建立、数据报表的制作和油气资源数据的定制分析和可视化展示,从而进行油气资源数据的高效检索、油气资源数据的丰富展示和深层次分析。The multi-dimensional model or multi-dimensional data model in the present invention is to organize data in the form of data cubes according to measurement, dimension, hierarchical structure and multi-dimensional data sets, and organize data around a theme. The theme is represented by a fact table. Indicates that facts are measured numerically. The present invention adopts object-oriented database design, through data warehouse technology and software integration method, realizes the establishment of core database, the establishment of multi-dimensional data model, the production of data reports and the customized analysis and visual display of oil and gas resource data, so as to carry out oil and gas resource data Efficient retrieval, rich display and in-depth analysis of oil and gas resource data.
本发明的技术方案为:Technical scheme of the present invention is:
基于多维度模型的油气资源数据要览系统实现方法,该方法通过对油气资源的源数据进行处理后形成油气资源核心数据库和通过建立多维度数据模型对核心业务数据进行定制分析、检索和可视化展示,包括如下步骤:The implementation method of the oil and gas resource data overview system based on the multi-dimensional model. This method forms the core database of oil and gas resources after processing the source data of oil and gas resources, and conducts customized analysis, retrieval and visual display of the core business data by establishing a multi-dimensional data model. , including the following steps:
S1:通过对油气资源的源数据进行处理,形成油气资源的核心数据库;S1: Form the core database of oil and gas resources by processing the source data of oil and gas resources;
S2:将核心数据库转为数据仓库,通过建立多维度数据模型,形成油气资源的专题维度数据库;所述专题维度数据库包括由事实表和维度表组成的多维数据集;S2: Convert the core database into a data warehouse, and form a thematic dimension database of oil and gas resources by establishing a multidimensional data model; the thematic dimension database includes a multidimensional data set composed of a fact table and a dimension table;
S3:通过数据库报表服务SSRS(SQL Server Reporting Services)对专题维度数据库中的多维数据集进行处理生成多种形式的报表,形成报表数据库;S3: Through the database report service SSRS (SQL Server Reporting Services), the cube in the thematic dimension database is processed to generate various forms of reports to form a report database;
S4:通过提取报表数据库中的信息生成报表模板,形成报表模板要素配置信息XML文件;S4: Generate a report template by extracting the information in the report database, and form an XML file of report template element configuration information;
S5:通过参数配置方式配置客户端的界面形式和功能菜单模块,生成客户端配置信息XML文件;S5: configure the interface form and function menu module of the client through the parameter configuration mode, and generate the client configuration information XML file;
S6:将报表模板要素配置信息XML文件和客户端配置信息XML文件进行最优化处理,根据用户权限提取该用户能访问的功能,由此实现对油气资源数据的查询检索、定制分析或以可视化的多种报表形式来展示。S6: Optimize the report template element configuration information XML file and the client configuration information XML file, and extract the functions that the user can access according to the user's authority, thereby realizing the query and retrieval of oil and gas resource data, custom analysis, or visualization A variety of report forms to display.
上述基于多维度模型的油气资源数据要览系统实现方法中,步骤S1对油气资源的源数据进行处理具体包括如下过程:In the implementation method of the above-mentioned multi-dimensional model-based oil and gas resource data overview system, the processing of source data of oil and gas resources in step S1 specifically includes the following process:
S11:对用户需求进行综合、归纳与抽象,通过面向对象数据库设计,建立油气资源数据模型,并对其进行优化;S11: Synthesize, summarize and abstract user needs, establish and optimize oil and gas resource data models through object-oriented database design;
S12:对油气资源的源数据进行整理、清理、归类和系统化;S12: Arranging, clearing, classifying and systematizing the source data of oil and gas resources;
S13:对在步骤S12整理后的数据通过ETL工具进行数据提取和整合转换,形成油气资源的核心数据库。S13: Perform data extraction, integration and transformation on the data sorted in step S12 through ETL tools to form a core database of oil and gas resources.
上述基于多维度模型的油气资源数据要览系统实现方法在步骤S2中的多维度数据模型是将数据以数据立方体的形式,围绕数据的主题,按照度量、维度和层次结构来组织数据形成多维数据集;数据的主题用事实表来表示,事实用数值来度量,通过星型架构来表示多维数据集中的事实和维度的关系。The multi-dimensional data model in step S2 of the above-mentioned oil and gas resource data summary system implementation method based on the multi-dimensional model is to organize the data in the form of data cubes, around the theme of the data, and organize the data according to the measurement, dimension and hierarchical structure to form multi-dimensional data Set; the subject of the data is represented by the fact table, the fact is measured by the value, and the relationship between the fact and the dimension in the cube is represented by the star schema.
进一步地,步骤S3是根据业务需求,通过对专题维度数据库中多维数据集的维度和事实进行组合,生成多种形式的报表,形成的报表数据库上传到服务器;报表为图表、表格和地图中的一种或多种。Further, step S3 is to generate various forms of reports by combining the dimensions and facts of the multidimensional datasets in the thematic dimension database according to business requirements, and upload the formed report database to the server; the reports are charts, tables and maps. one or more.
步骤S4中的报表模板要素配置信息XML文件的内容至少包括报表模板基本结构信息、报表参数信息、报表对象信息、报表符号信息和报表颜色信息;报表模板基本结构包括页眉、页脚、主体和数据四个区域;报表参数包括时间参数、资源类型和报表类型;报表对象包括文本框、线条、矩形和图像。The content of the report template element configuration information XML file in step S4 includes at least the basic structure information of the report template, report parameter information, report object information, report symbol information and report color information; the basic structure of the report template includes header, footer, body and There are four data areas; report parameters include time parameters, resource types and report types; report objects include text boxes, lines, rectangles and images.
步骤S5中客户端的界面形式分为专题、模块和业务三个层次,每个专题包括多个模块,每个模块包括多个业务;客户端的功能菜单模块包括工具栏和导航条。In step S5, the interface form of the client is divided into three levels: topics, modules and services, each topic includes multiple modules, and each module includes multiple services; the function menu module of the client includes a tool bar and a navigation bar.
进一步地,步骤S6具体是用户通过基于角色的权限验证后获得用户角色的权限,通过客户端配置信息XML文件提取该用户对应权限所能访问的系统功能,使之显示在主界面中,主界面包括工具条、导航条和数据图表展示区,由此实现用户对油气资源数据的查询检索、定制分析或以可视化的多种报表形式来展示。Further, in step S6, the user obtains the authority of the user role after passing the role-based authority verification, extracts the system functions that the user can access through the client configuration information XML file, and displays them on the main interface. Including tool bar, navigation bar and data chart display area, so as to realize the user's query and retrieval of oil and gas resource data, customized analysis or display in the form of various visual reports.
基于多维度模型的油气资源数据要览系统,其基础数据支撑包括核心数据库、模板库、配置数据库和用户属性数据库,该系统包括数据管理模块、系统配置模块、权限管理模块、分析展示模块和报表输出模块,其中:数据管理模块用于实现对维度数据的更新,从而达到报表数据源更新的目的;系统配置模块用于系统管理员对系统界面和功能模块的配置,其配置结果文件作为分析展示模块的基础;权限管理模块用于实现管理员对系统普通用户的权限分配和统一管理,使得普通用户登录系统以后,根据权限读取不同的配置结果文件,分析展示具有权限的专题报表;分析展示模块用于对核心业务数据的定制分析和可视化展示;报表输出模块用于进行项目报告生成、数据表格导出和数据图表导出。Oil and gas resource data overview system based on multi-dimensional model, its basic data support includes core database, template library, configuration database and user attribute database, the system includes data management module, system configuration module, authority management module, analysis and display module and reports The output module, among which: the data management module is used to update the dimension data, so as to achieve the purpose of updating the report data source; the system configuration module is used for the system administrator to configure the system interface and function modules, and the configuration result file is used as an analysis display The basis of the module; the authority management module is used to realize the administrator's authority distribution and unified management of ordinary users of the system, so that after ordinary users log in to the system, they can read different configuration result files according to their authority, and analyze and display special reports with authority; analysis and display The module is used for customized analysis and visual display of core business data; the report output module is used for project report generation, data table export and data chart export.
本发明的有益效果为:The beneficial effects of the present invention are:
本发明提供的基于多维度模型的油气资源数据要览系统实现方法及系统,通过对油气资源海量数据提取、转换、加载,将数据仓库技术和数据库报表服务运用到对海量数据的加工,提高了对数据的处理效率,挖掘出更深次的信息,该方法可灵活组合数据的不同纬度,实现对油价、产量、储量、资源量、进出口、矿权等核心数据的定制分析,支持报表、图表、文本、地图的集成管理和可视化展示,使管理和查看变得直观、简单和轻松;系统的界面和功能模块基于配置方案,具有灵活配置、可扩展、易于使用等特点,丰富了数据的展示形式,提高了检索效率。The realization method and system of the oil and gas resource data overview system based on the multi-dimensional model provided by the present invention, through the extraction, conversion and loading of massive data of oil and gas resources, the data warehouse technology and database report service are applied to the processing of massive data, which improves the For data processing efficiency, dig deeper information. This method can flexibly combine different latitudes of data, realize customized analysis of core data such as oil price, production, reserves, resources, import and export, mining rights, etc., and support reports and charts The integrated management and visual display of , text, and maps make management and viewing intuitive, simple, and easy; the interface and functional modules of the system are based on configuration schemes, and have the characteristics of flexible configuration, scalability, and ease of use, which enrich the display of data form, which improves retrieval efficiency.
附图说明Description of drawings
图1为本发明实施例基于多维度模型的油气资源数据要览系统的实现方法的流程图。Fig. 1 is a flowchart of an implementation method of an oil and gas resource data overview system based on a multi-dimensional model according to an embodiment of the present invention.
图2为本发明实施例中生成的每日油价维度模型包含的事实和维度的关系示意图。FIG. 2 is a schematic diagram of the relationship between facts and dimensions contained in the daily oil price dimensional model generated in the embodiment of the present invention.
图3为本发明实施例基于多维度模型的油气资源数据要览系统结构图。Fig. 3 is a structural diagram of an overview system of oil and gas resource data based on a multi-dimensional model according to an embodiment of the present invention.
图4为本发明实施例基于多维度模型的油气资源数据要览系统主界面截图。Fig. 4 is a screenshot of the main interface of the oil and gas resource data overview system based on the multi-dimensional model according to the embodiment of the present invention.
图5为本发明实施例基于多维度模型的油气资源数据要览系统报表展示输出截图。Fig. 5 is a screenshot of the report display output of the oil and gas resource data overview system based on the multi-dimensional model according to the embodiment of the present invention.
具体实施方式Detailed ways
下面结合附图和具体实施例,对本发明进一步详细描述,但不以任何方式限制本发明的范围。The present invention will be described in further detail below in conjunction with the accompanying drawings and specific embodiments, but the scope of the present invention will not be limited in any way.
本发明的一个具体实施例采用c#开发构建基于多维度模型的油气资源数据要览系统,通过该系统实现对全国范围内的油气资源量、储量、产量、勘探开发、油气贸易、矿权六大专题的数据进行定制分析,系统可支持报表、图表、文本、地图的集成展示。A specific embodiment of the present invention uses c# to develop and build an oil and gas resource data overview system based on a multi-dimensional model, through which the six major oil and gas resources, reserves, production, exploration and development, oil and gas trade, and mining rights across the country are realized. Thematic data can be customized and analyzed, and the system can support the integrated display of reports, charts, texts, and maps.
图1是本发明实施例基于多维度模型的油气资源数据要览系统的实现方法的流程图。基于多维度模型的油气资源数据要览系统的实现方法包括如下步骤:Fig. 1 is a flowchart of an implementation method of an oil and gas resource data overview system based on a multi-dimensional model according to an embodiment of the present invention. The realization method of the oil and gas resources data overview system based on the multi-dimensional model includes the following steps:
S1:建立核心数据库,包括油气专业数据库和属性数据库;S1: Establish core databases, including oil and gas professional databases and attribute databases;
S2:将核心数据库转为数据仓库,建立多维度数据模型,保存到油气维度数据库中;S2: Convert the core database into a data warehouse, establish a multi-dimensional data model, and save it in the oil and gas dimension database;
S3:通过数据库报表服务SSRS(SQL Server Reporting Services)对多维度数据模型进行处理,提取模型里的维度表和事实表,根据业务需求制作不同的报表(图表、表格、地图),将报表上传到报表服务器数据库;S3: Process the multi-dimensional data model through the database report service SSRS (SQL Server Reporting Services), extract the dimension tables and fact tables in the model, make different reports (charts, tables, maps) according to business needs, and upload the reports to report server database;
S4:提取报表制作的参数、类型、所需内容等信息,建立报表模型,生成报表模板要素配置信息XML文件;S4: Extract the parameters, types, required content and other information of report making, establish a report model, and generate an XML file of report template element configuration information;
S5:通过参数配置方式,配置客户端前台界面形式以及功能模块,将配置结果保存到XML文件中;S5: Configure the front-end interface form and function modules of the client through the parameter configuration method, and save the configuration results in the XML file;
S6:将报表模板要素配置信息XML文件、客户端前台界面形式和功能模块的配置结果信息XML文件进行最优化处理,用户通过基于角色的权限验证后,登录进入系统,系统根据当前用户的可访问哪些功能的权限而提取具体的功能,并显示在主界面中,实现以丰富的可视化形式展示油气资源数据,同时用户可以根据自己的需求对报表调整,通过报表模板实现对报表的定制。S6: Optimize the report template element configuration information XML file, the client front-end interface form and the configuration result information XML file of the function module. After the user passes the role-based authority verification, log in to the system, and the system can access according to the current user Which functions are authorized to extract specific functions and display them in the main interface to display oil and gas resource data in a rich and visual form. At the same time, users can adjust the report according to their own needs and realize the customization of the report through the report template.
上述基于多维度模型的油气资源数据要览系统中,进一步地,步骤S1建立的核心数据库具体包括如下步骤:In the above-mentioned oil and gas resource data overview system based on the multi-dimensional model, further, the core database established in step S1 specifically includes the following steps:
S11:依据业务要求,建立核心数据库:S11: According to business requirements, establish a core database:
首先了解与分析用户需求,对用户需求进行综合、归纳与抽象,形成一个独立于具体的DBMS的概念模型;将概念结构转换为某个DBMS所支持的数据模型,并对其进行优化;为逻辑数据模型选取一个最适合应用环境的物理结构(包括存储结构和存储方法);运用DBMS提供的数据库语言(SQL),根据逻辑设计和物理设计的结果建立数据库,编制与调试应用程序,组织数据入库。First understand and analyze user needs, synthesize, summarize and abstract user needs to form a conceptual model independent of the specific DBMS; convert the conceptual structure into a data model supported by a certain DBMS, and optimize it; for the logic The data model selects a physical structure (including storage structure and storage method) that is most suitable for the application environment; uses the database language (SQL) provided by the DBMS to establish a database according to the results of logical design and physical design, compiles and debugs application programs, and organizes data into library.
S12:对收集到的油气专业数据先整理、清理、归类、系统化;S12: Organize, clean up, classify and systematize the collected oil and gas professional data;
S13:对整理后的数据进行整合转换,该过程包括数据提取、数据转换、数据清理、数据加载,建立数据仓库模型,将数据加载到整体数据仓库中,再由整体数据仓库使用数据复制、发布工具,依据需求将数据复制及发布到部门性质数据仓库;S13: Integrating and transforming the sorted data, the process includes data extraction, data conversion, data cleaning, data loading, building a data warehouse model, loading data into the overall data warehouse, and then the overall data warehouse uses data copying and publishing Tools, copy and publish data to departmental data warehouses according to requirements;
S14:在数据集中,依据业务要求,提取事实数据和维度数据,建立维度表和事实表,通过维度表和事实表构建星型架构,通过星型架构来保存数据集中的度量和维度的关系;S14: In the data set, extract fact data and dimension data according to business requirements, establish dimension tables and fact tables, construct a star schema through the dimension table and fact table, and use the star schema to save the relationship between measurements and dimensions in the data set;
步骤S2中要建立多维度数据模型,涉及到创建多维数据集结构、建立和部署多维数据集以及统一维度模型。The establishment of a multidimensional data model in step S2 involves creating a multidimensional data set structure, establishing and deploying a multidimensional data set, and unifying the dimensional model.
在本实施例中构建多维度模型,通过多维度模型简化本系统对数据的处理能力和定制分析能力,具体包括如下步骤:In this embodiment, a multi-dimensional model is constructed to simplify the system's ability to process data and customize analysis capabilities through the multi-dimensional model, specifically including the following steps:
S21:构建分析应用程序的第一步是在Business Intelligence Development Studio中创建一个新的Analysis Services项目,创建空项目之后,应当创建一个“数据源”并将其与源数据库建立连接;S21: The first step in building an analysis application is to create a new Analysis Services project in Business Intelligence Development Studio. After creating an empty project, a "data source" should be created and connected to the source database;
S22:定义数据视图,利用数据视图把来自各种不同数据源的表和字段组合在一起,筛选掉数据库中那些不必要的数据项,给表和字段赋予一些用户友好型的名字和描述,并在表和字段结构上进行虚拟附加(virtual addition);S22: Define data views, use data views to combine tables and fields from various data sources, filter out unnecessary data items in the database, give tables and fields some user-friendly names and descriptions, and Virtual addition to table and field structures;
S23:接着通过数据视图的内容创建一个新的多维数据集,依次定义好所需的AnalysisServices数据库、维度、度量、层次、属性和多维数据集;S23: Then create a new cube through the content of the data view, and define the required AnalysisServices database, dimension, measure, hierarchy, attribute and cube in sequence;
S24:预览和测试多维数据集和维度,通过Business Intelligence Development Studio的菜单选择“部署”,在指定的目标服务器上构建和部署项目。S24: Preview and test the cube and dimension, select "Deploy" through the menu of Business Intelligence Development Studio, build and deploy the project on the specified target server.
在本实施例中,核心库中的数据的重要事实包括资源量、储量、产量、勘探开发、油气贸易、矿权等实体,依据油气田、资源类型和时间维度构成更大粒度维度,分别是盆地、省区和公司,将事实数据和维度数据按专题存储到维度数据库中。例如,图2为本实施例中生成的每日油价维度模型,根据每日油价核心库来构建每日油价的维度模型,每日油价的维度模型包含一个事实和两个维度,一个事实为各地区油价,两个维度分别为日期和油价评估地区。In this embodiment, the important facts of the data in the core database include entities such as resources, reserves, production, exploration and development, oil and gas trade, and mineral rights, which form a larger granularity dimension based on oil and gas fields, resource types, and time dimensions, respectively. Basin , provinces and companies, and store fact data and dimension data in the dimension database according to themes. For example, Figure 2 is the daily oil price dimensional model generated in this embodiment. The daily oil price dimensional model is constructed according to the daily oil price core library. The daily oil price dimensional model includes a fact and two dimensions, and one fact is each Regional oil prices, the two dimensions are date and oil price evaluation region.
通过数据库报表服务SSRS(SQL Server Reporting Services)对多维数据模型进行处理,组合不同维度和事实,根据业务需求制作各专题报表(图表、表格、地图),将专题报表上传到报表服务器数据库。Process the multidimensional data model through the database report service SSRS (SQL Server Reporting Services), combine different dimensions and facts, make various special reports (charts, tables, maps) according to business needs, and upload the special reports to the report server database.
步骤S3中通过数据库报表服务SSRS(SQL Server Reporting Services)对多维度数据模型进行处理,提取多维度模型里的维度表和事实表,根据业务需求制作不同的报表(图表、表格、地图),将报表上传到报表服务器数据库,具体包括如下步骤:In step S3, the multi-dimensional data model is processed through the database report service SSRS (SQL Server Reporting Services), the dimension table and the fact table in the multi-dimensional model are extracted, and different reports (charts, tables, maps) are produced according to business requirements, and the The report is uploaded to the report server database, specifically including the following steps:
S31:通过SQL Server Business Intelligence Development Studio,进入报表开发环境,新建一个项目,将项目保存在自定义目录路径下的文件夹;S31: Enter the report development environment through SQL Server Business Intelligence Development Studio, create a new project, and save the project in a folder under the custom directory path;
S32:开发报表,首先要建立读取报表数据所需的连接信息,即设置共享数据源,设置数据源名称、选择连接类型,指定连接服务器位置、验证模式以及数据库;S32: To develop a report, firstly establish the connection information required to read the report data, that is, set the shared data source, set the data source name, select the connection type, specify the connection server location, verification mode and database;
S33:设置共享数据集,选定特定数据源,新建数据集,数据集内容包括业务报表所需的维度表和事实表,选择相关的维度和度量字段。S33: Set up a shared data set, select a specific data source, create a new data set, the content of the data set includes dimension tables and fact tables required for business reports, and select related dimensions and measurement fields.
S34:在特定的数据源和数据集下,依据业务要求,设置报表参数,制作符合要求的报表(图表、表格、地图),可按需求导出不同格式(Word、PDF等)的报表。S34: Under the specific data source and data set, set report parameters according to business requirements, make reports (charts, tables, maps) that meet the requirements, and export reports in different formats (Word, PDF, etc.) as required.
步骤S4通过建立报表模型,生成报表模板要素配置信息XML文件,方便数据变换后,快速更新报表和定制新的报表,具体包括如下步骤:Step S4 generates a report template element configuration information XML file by establishing a report model, which is convenient for quickly updating reports and customizing new reports after data transformation, specifically including the following steps:
S41:建立报表模型,首先要建立包含数据表实体、一般数据字段、汇总数据字段与数据表实体间的关系的架构,接着先导入数据源,再新增数据源视图,数据源视图是数据的中继数据集合,可以将它视为一个虚拟的数据仓库,用以维护所有数据表的数据结构以及字段逻辑。S41: To build a report model, first establish a structure including the relationship between data table entities, general data fields, summary data fields and data table entities, then import the data source first, and then add a data source view, which is the data source view The relay data collection can be regarded as a virtual data warehouse to maintain the data structure and field logic of all data tables.
S42:设置报表模板的基本结构,包括页眉、页脚、主体、数据等四个主要区域,选定报表对象,包括文本框、线条、矩形和图像,设置共享数据源和共享数据集。S42: Set the basic structure of the report template, including four main areas such as header, footer, body, and data, select report objects, including text boxes, lines, rectangles, and images, and set shared data sources and shared data sets.
S43:依据维度模型数据确定报表参数并提取,报表参数包括时间参数、资源类型、报表类型等,提取报表符号库和颜色库,最后生成报表模板要素配置信息XML文件。S43: Determine and extract report parameters according to the dimensional model data. Report parameters include time parameters, resource types, report types, etc., extract report symbol library and color library, and finally generate report template element configuration information XML files.
步骤S5通过本发明的客户端进行人工手动配置油气资源数据报表展示形式,配置客户端主界面功能菜单展示油气资源数据的专题和模块,具体包括如下步骤:Step S5 manually configures the presentation form of the oil and gas resource data report through the client of the present invention, and configures the main interface function menu of the client to display the topics and modules of the oil and gas resource data, specifically including the following steps:
S51:依据业务要求和数据逻辑,开发系统配置界面,配置客户端功能菜单,包括工具栏和导航条的配置。S51: According to the business requirements and data logic, develop the system configuration interface, configure the client function menu, including the configuration of the toolbar and navigation bar.
S52:该配置界面按照层次逻辑结构,分为专题、模块、业务,人工通过配置界面手动添加专题,专题下多个模块,模块下多个业务,将配置信息保存到XML文件中。S52: The configuration interface is divided into topics, modules, and services according to the hierarchical logical structure. Manually add topics through the configuration interface, multiple modules under the topic, and multiple services under the module, and save the configuration information in the XML file.
步骤S6是以丰富的形式展示油气资源数据并可对其检索和定制分析,具体包括如下步骤:Step S6 is to display oil and gas resource data in a rich form and to retrieve and customize analysis, specifically including the following steps:
S61:本发明通过读取报表模板要素配置信息XML文件、前台展示逻辑形式的配置结果信息XML文件,用户通过基于角色的权限验证后,登录进入系统,系统根据当前用户的可访问哪些功能的权限通过配置的结果信息XML文件而提取具体的功能,显示在主界面中。S61: The present invention reads the report template element configuration information XML file, and the foreground displays the configuration result information XML file in logical form. After the user passes the role-based authority verification, he logs into the system, and the system can access which functions according to the authority of the current user. The specific functions are extracted through the configured result information XML file and displayed in the main interface.
S62:用户通过读取系统界面和功能模块的XML文件信息,进入到油气资源数据要览系统主界面,其主界面包括工具条、导航条以及数据图表展示区,用户在此系统可以实现数据的查询和检索,油气数据的定制分析,数据报表的定制和输出。S62: The user enters the main interface of the oil and gas resource data overview system by reading the XML file information of the system interface and functional modules. The main interface includes a tool bar, a navigation bar, and a data chart display area. Query and retrieval, customized analysis of oil and gas data, customization and output of data reports.
在本发明的一个具体实施例中,通过上述方法构建基于多维度模型的油气资源数据要览系统。图3为本发明实施例基于多维度模型的油气资源数据要览系统结构图,该系统以核心业务数据库、配置数据库、用户属性库和模板库为数据支撑,包括数据管理模块、配置管理模块、权限管理模块、分析展示模块和报表输出模块,其中,数据管理模块用于进行数据的导入和导出、维度数据的更新和数据的检索;配置管理模块用于进行专题配置、模块配置、内容配置、业务配置和配置文件的上传和下载;权限管理模块用于进行用户信息管理、用户权限分配和登录日志管理;分析展示模块用于进行不同维度数据的定制分析和核心数据的可视化展示;报表输出模块用于进行项目报告生成、数据表格导出和数据图表导出。分析和展示的数据不是直接对数据库里存储的核心业务数据处理,而是通过提取核心数据库里的维度表和事实表建立多维数据集构建维度模型,通过数据库报表服务对维度模型处理定制满足业务需求的各专题数据报表,分析展示模块通过系统配置模块的XML文件,提取满足条件的数据报表,通过参数定制和报表内部参数自主选择达到对各专题数据的定制分析和可视化展示,展示结果可通过多种输出方式输出报表和结果。In a specific embodiment of the present invention, a multi-dimensional model-based oil and gas resource data overview system is constructed through the above method. Fig. 3 is a structure diagram of an overview system of oil and gas resource data based on a multi-dimensional model according to an embodiment of the present invention. The system uses a core business database, a configuration database, a user attribute database and a template database as data supports, and includes a data management module, a configuration management module, Authority management module, analysis display module and report output module, among which, data management module is used for data import and export, dimension data update and data retrieval; configuration management module is used for topic configuration, module configuration, content configuration, Upload and download of business configuration and configuration files; authority management module is used for user information management, user authority assignment and login log management; analysis and display module is used for customized analysis of different dimensions of data and visual display of core data; report output module Used for project report generation, data table export and data chart export. The data analyzed and displayed is not directly processed on the core business data stored in the database, but by extracting the dimension table and fact table in the core database to build a multi-dimensional data set to build a dimensional model, and to customize the dimensional model processing through the database report service to meet business needs The analysis and display module extracts data reports that meet the conditions through the XML file of the system configuration module, and achieves customized analysis and visual display of each topic data through parameter customization and independent selection of report internal parameters. The display results can be displayed through multiple There are two output methods to output reports and results.
上述系统的界面和功能菜单基于可配置方案,具有灵活配置、易扩展、易使用的特点,系统的界面包括系统数据管理界面、配置管理界面、用户权限管理界面和系统主界面,图4为系统主界面截图,其中:The interface and function menu of the above system are based on a configurable scheme, which has the characteristics of flexible configuration, easy expansion, and easy use. The system interface includes the system data management interface, configuration management interface, user rights management interface and system main interface. Figure 4 shows the system Screenshot of the main interface, in which:
数据管理界面用于由系统管理员检索查看各专题数据表、导入和导出数据,管理员依据每天需要更新的数据信息,进行专题数据更新,到达更新报表数据源的目的。The data management interface is used for the system administrator to retrieve and view each topic data table, import and export data, and the administrator updates the topic data according to the data information that needs to be updated every day, so as to achieve the purpose of updating the report data source.
系统配置管理界面由系统管理员配置客户端功能菜单,包括工具栏和导航条,本实施例中,该配置界面按照层次逻辑结构,分为专题、模块、内容、业务,具体为油气资源的资源量、储量、产量、勘探开发、油气贸易、矿权六个专题信息以及每个专题下的模块信息、内容信息和业务信息,在资源量专题下配置包括全国、省区和盆地三个模块,分别在每个模块下配置包括多个内容信息以及业务信息;上述配置信息保存为XML配置文件,保存到配置库。The system configuration management interface is configured by the system administrator to configure the function menu of the client, including the toolbar and the navigation bar. In this embodiment, the configuration interface is divided into topics, modules, content, and services according to the hierarchical logical structure, specifically the resources of oil and gas resources. Six thematic information on volume, reserves, production, exploration and development, oil and gas trade, and mineral rights, and module information, content information, and business information under each topic. Under the resource volume topic, configure three modules including national, provincial, and basin. The configuration under each module includes multiple content information and business information; the above configuration information is saved as an XML configuration file and saved to the configuration library.
用户权限管理界面用于由系统管理员对该系统的用户信息进行统一管理,可按用户身份、所属部门、职务等维度进行查询检索用户详细信息,并对普通户用进行权限分配,不同权限能读取的配置库里的XML文件不同,能查看不同的专题数据信息。The user authority management interface is used by the system administrator to manage the user information of the system in a unified manner. It can query and retrieve user detailed information according to the dimensions of user identity, department, and position, and assign authority to ordinary users. Different authority functions The XML files in the read configuration library are different, and different thematic data information can be viewed.
系统主界面用于显示用户所具有的权限对应所能查看的专题数据信息,使得用户可以查看和检索专题数据,并依据报表模板对数据报表定制分析,导出报表数据和可视化等。The main interface of the system is used to display the thematic data information that users have corresponding to the permissions they can view, so that users can view and retrieve thematic data, and customize and analyze data reports according to report templates, export report data and visualize them, etc.
通过上述系统可实现对全国内油气资源量、储量、产量、勘探开发、油气贸易、矿权6大专题的数据进行定制分析,支持报表、图表、文本、地图的集成展示,图5为本发明实施例基于多维度模型的油气资源数据要览系统报表展示输出截图。可按照如下步骤对油气资源数据进行查询检索、定制分析和可视化展示操作:Through the above-mentioned system, it is possible to carry out customized analysis on the data of the six major topics of oil and gas resources, reserves, production, exploration and development, oil and gas trade, and mineral rights in the country, and support the integrated display of reports, charts, texts, and maps. Figure 5 shows the present invention Embodiments The multi-dimensional model-based oil and gas resource data summary system report display output screenshots. The oil and gas resource data can be queried and retrieved, customized analysis and visualized according to the following steps:
第一步:准备数据,使用油气中心各专题数据库和油气动态信息作为主要数据源;Step 1: Prepare data, using various thematic databases of the oil and gas center and oil and gas dynamic information as the main data source;
第二步:规范油气资源各专题数据库中的数据,设计油气资源核心业务数据库,开发ETL系统,实现数据抽取、数据转换、数据加载等过程,采用数据库SQL语句提取重要事实数据包括资源量、储量、产量、勘探开发、油气贸易、矿权等,依据油气田、资源类型和时间维度构成更大粒度维度,分别是盆地、省区、公司。Step 2: Standardize the data in the various special databases of oil and gas resources, design the core business database of oil and gas resources, develop the ETL system, realize data extraction, data conversion, data loading and other processes, and use database SQL statements to extract important factual data including resource volume and reserves , production, exploration and development, oil and gas trade, mining rights, etc., constitute a larger granularity dimension based on oil and gas fields, resource types, and time dimensions, which are basins, provinces, and companies.
第三步:通过建立多维度模型,组合不同维度定制满足业务需求的专题报表以及报表模板,将报表上传到服务器。Step 3: By establishing a multi-dimensional model, combining different dimensions to customize special reports and report templates that meet business needs, and upload the reports to the server.
第四步,系统管理员登入系统进入数据管理配置界面,可对专题数据进行更新,从而到达更新报表数据源的目的。In the fourth step, the system administrator logs in to the system and enters the data management configuration interface, where the thematic data can be updated, so as to achieve the purpose of updating the report data source.
第五步:管理员登录系统进入系统配置界面,配置资源量、储量、产量、勘探开发、油气贸易、矿权6个专题信息以及每个专题下的模块信息、内容和业务报表信息,如添加储量专题,在该专题下添加全国、省区、盆地、石油公司四个模块,分别在每个模块下添加内容信息和业务报表信息,如在全国模块下添加历年全国油气储量、全国各盆地油气储量、全国各省区油气储量、全国各石油公司油气储量四个内容,分别在每个内容下添加业务报表信息,如在历年全国油气储量内容下添加历年全国盆地储量(图表)、历年全国盆地储量(表格)两张定制好的报表信息,最后将XML配置文件保存到配置库里。Step 5: The administrator logs in to the system to enter the system configuration interface, and configures 6 thematic information of resources, reserves, production, exploration and development, oil and gas trade, and mineral rights, as well as module information, content and business report information under each topic, such as adding For the topic of reserves, add four modules of national, provincial, basin, and oil companies under this topic, and add content information and business report information under each module. Reserves, oil and gas reserves of all provinces and regions in the country, and oil and gas reserves of various oil companies in the country, add business report information under each content, such as adding national basin reserves in previous years (charts) and national basin reserves in previous years under the content of national oil and gas reserves in previous years (Form) Two customized report information, and finally save the XML configuration file to the configuration library.
第六步:管理员登录系统进入用户权限管理界面对该系统的用户信息进行统一管理,可添加、修改、删除用户信息,可按用户身份、所属部门、职务等维度进行查询检索用户详细信息,对普通户用进行权限分配,通过用户视图和专题视图管理和修改普通用户权限,确定每一个用户所能查看的专题信息。Step 6: The administrator logs in to the system and enters the user rights management interface to manage the user information of the system in a unified manner. User information can be added, modified, and deleted, and user detailed information can be queried and retrieved according to user identity, department, job title, etc. Assign rights to ordinary users, manage and modify ordinary user rights through user view and topic view, and determine the topic information that each user can view.
第七步:普通用户登录系统,系统会根据该用户所具有的权限读取保存在配置库里的XML文件,筛选出能看到的专题数据信息,进入到系统界面,系统工具条上显示所能查看的专题名称,普通户用点击所要查看的专题,专题导航模块出现该专题下相对应的模块名称,在专题导航模块用户可能够做到对年度、资源类型(石油、天然气)、信息查看类型(图表、表格、地图)的自主选择定制参数查看具体信息,系统保存用户退出系统时最后定制的参数,当用户再次登录系统时参数初始化为上次登录定制好的参数,用户可双击专题导航模块的模块名称,系统根据逻辑关系以及XML文件里对应信息,读取到相应的专题业务报表,显示在数据报表展示模块,在该模块中可以切换不同内容下的业务报表信息,通过报表内部参数的选择定制,可展示历年某公司石油情况,展示的形式有柱状图、饼图、表格、地图等,同时可切换不同形式查看。如定制分析和展示产量专题下盆地模块的历年盆地油气产量,通过内部参数的定制分析,以柱状图形式展示2010年塔里木盆地当年天然气产量排名前10位的油田。用户可根据模板库里的报表模板对数据报表进行修改,定制符合自己要求的报表,定制分析和展示的结果可按多种格式输出,输出结果可生成项目报告,可将数据表格导出、可将地图信息导出。Step 7: A common user logs in to the system, the system will read the XML file stored in the configuration library according to the user's authority, filter out the thematic data information that can be seen, enter the system interface, and the system tool bar will display all The name of the topic that can be viewed. Ordinary users click on the topic they want to view, and the corresponding module name under the topic will appear in the topic navigation module. In the topic navigation module, users may be able to view the year, resource type (oil, natural gas), and information. Types (charts, tables, maps) can be independently selected to customize parameters to view specific information. The system saves the last customized parameters when the user logs out of the system. When the user logs in to the system again, the parameters are initialized to the parameters customized for the last login. Users can double-click the topic navigation The module name of the module. According to the logical relationship and the corresponding information in the XML file, the system reads the corresponding special business report and displays it in the data report display module. In this module, the business report information under different contents can be switched, through the internal parameters of the report It can display the oil situation of a certain company over the years. The displayed forms include bar charts, pie charts, tables, maps, etc. At the same time, different forms can be switched for viewing. For example, the customized analysis and display of the oil and gas production of the basin in the basin module under the production topic over the years, through the customized analysis of internal parameters, the top 10 oilfields with natural gas production in the Tarim Basin in 2010 are displayed in the form of a column chart. Users can modify the data reports according to the report templates in the template library, and customize reports that meet their own requirements. The results of customized analysis and display can be output in various formats. The output results can generate project reports, and the data tables can be exported. Map information export.
将上述方法及所构建的系统应用到全国或全球油气资源数据按专题定制分析和可视化展示,提高了数据的检索效率,丰富了数据的可视化形式,增强油气要素的管理与可视化效果、提高油气行业服务的质量。Applying the above method and the constructed system to the national or global oil and gas resource data customized analysis and visual display according to the topic, which improves the efficiency of data retrieval, enriches the visualization form of data, enhances the management and visualization effect of oil and gas elements, and improves the oil and gas industry. the quality of the service.
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410232574.1A CN103984755A (en) | 2014-05-28 | 2014-05-28 | Multidimensional model based oil and gas resource data key system implementation method and system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410232574.1A CN103984755A (en) | 2014-05-28 | 2014-05-28 | Multidimensional model based oil and gas resource data key system implementation method and system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN103984755A true CN103984755A (en) | 2014-08-13 |
Family
ID=51276728
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410232574.1A Pending CN103984755A (en) | 2014-05-28 | 2014-05-28 | Multidimensional model based oil and gas resource data key system implementation method and system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN103984755A (en) |
Cited By (44)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104299102A (en) * | 2014-10-31 | 2015-01-21 | 国电南瑞科技股份有限公司 | Multidimensional data model modeling method of power grid regulation and control integration system |
CN104462343A (en) * | 2014-12-08 | 2015-03-25 | 北京庆世昌明科技有限公司 | Big data alignment collision system |
CN104504094A (en) * | 2014-12-26 | 2015-04-08 | 中国石油集团工程设计有限责任公司北京分公司 | Various data source integrated management method for oil and gas field |
CN104572074A (en) * | 2014-12-08 | 2015-04-29 | 北京辰闰丰青信息技术有限公司 | Big-data-based graphic presentation customizing system |
CN104615725A (en) * | 2015-02-09 | 2015-05-13 | 武汉众联信息技术股份有限公司 | Web-based online self-defined reporting method |
CN105843936A (en) * | 2016-03-31 | 2016-08-10 | 乐视控股(北京)有限公司 | Service data report form method and system |
CN106021624A (en) * | 2016-07-21 | 2016-10-12 | 中国农业银行股份有限公司 | ETL (extract-transform-load) model generation method and device |
CN106126513A (en) * | 2016-05-03 | 2016-11-16 | 成都市公安局 | Super dimension space-time depicting method |
CN106293712A (en) * | 2016-08-01 | 2017-01-04 | 浪潮(苏州)金融技术服务有限公司 | A kind of implementation method of form processing cube model |
CN106503202A (en) * | 2016-10-26 | 2017-03-15 | 广州市勤思网络科技有限公司 | The Dynamic Configuration that a kind of data drawing list linkage shows |
CN106790504A (en) * | 2016-12-16 | 2017-05-31 | 北京北科亿力科技有限公司 | A kind of metallurgical big data service platform |
CN106897277A (en) * | 2015-12-17 | 2017-06-27 | 成都飞机工业(集团)有限责任公司 | A kind of production and operation data visualization implementation method based on data mining |
CN106897285A (en) * | 2015-12-17 | 2017-06-27 | 北京宸瑞国新科技有限公司 | Data Elements extract analysis system and Data Elements extract analysis method |
CN106934023A (en) * | 2017-03-13 | 2017-07-07 | 山东浪潮云服务信息科技有限公司 | A kind of data managing method and device |
CN107194280A (en) * | 2017-05-25 | 2017-09-22 | 北京小度信息科技有限公司 | Method for establishing model and device |
CN107239539A (en) * | 2017-06-02 | 2017-10-10 | 山东浪潮商用系统有限公司 | A kind of user-defined m odel method based on relevant database |
CN107330045A (en) * | 2017-06-28 | 2017-11-07 | 携程旅游网络技术(上海)有限公司 | The big data visual analysis method and system of plane ticket booking platform |
CN107734068A (en) * | 2017-11-17 | 2018-02-23 | 贵州爱唐文化网络科技有限公司 | Big data display systems and method based on high in the clouds storage layout |
CN107832313A (en) * | 2017-05-15 | 2018-03-23 | 中国石油化工股份有限公司 | Oil professional software conversion method of data format |
CN107908784A (en) * | 2017-12-08 | 2018-04-13 | 北京蓝尊科技有限公司 | A kind of Resource management dynamic management approach and its system based on big data |
CN107943913A (en) * | 2017-11-20 | 2018-04-20 | 深圳市启明星电子商务有限公司 | A kind of data sheet analysis system |
CN108009798A (en) * | 2017-12-18 | 2018-05-08 | 广东电网有限责任公司电力调度控制中心 | A kind of project various dimensions support Knowledge Management System |
CN108052542A (en) * | 2017-11-22 | 2018-05-18 | 链家网(北京)科技有限公司 | A kind of analysis method of the multidimensional data of the data based on presto |
CN108415917A (en) * | 2017-03-13 | 2018-08-17 | 平安科技(深圳)有限公司 | A kind of generation method of Visual Report Forms and the generating means of Visual Report Forms |
CN108573354A (en) * | 2018-04-28 | 2018-09-25 | 武汉轻工大学 | Grain processing loss data analysis system and method |
CN109300023A (en) * | 2018-08-30 | 2019-02-01 | 广东源恒软件科技有限公司 | A kind of method and system that increment tax on land value big data is extracted and applied |
CN109408549A (en) * | 2018-11-02 | 2019-03-01 | 大连瀚闻资讯有限公司 | Import and export trade big data visualization analysis system |
CN109710686A (en) * | 2018-12-27 | 2019-05-03 | 杭州火树科技有限公司 | The analysis system of visualization building chart |
CN110162676A (en) * | 2019-05-21 | 2019-08-23 | 山东浪潮通软信息科技有限公司 | A kind of component that can carry out hierarchical navigation browsing to business datum according to dynamic multidimensional degree |
CN110275920A (en) * | 2019-06-27 | 2019-09-24 | 中国石油集团东方地球物理勘探有限责任公司 | Data query method, apparatus, electronic equipment and computer readable storage medium |
CN110442639A (en) * | 2019-07-31 | 2019-11-12 | 山东浪潮商用系统有限公司 | The big data of a kind of point of Subject Manager shows method and system |
CN110457368A (en) * | 2019-07-26 | 2019-11-15 | 广州市广百物流有限公司 | A kind of method for visualizing of supply chain, system and storage medium |
CN111078782A (en) * | 2018-10-19 | 2020-04-28 | 上海宝信软件股份有限公司 | Industrial big data visualization system and method |
CN111159986A (en) * | 2019-12-17 | 2020-05-15 | 国家电网有限公司大数据中心 | Method and system for executing intelligent task constructed based on data resource catalog |
CN111259069A (en) * | 2019-10-29 | 2020-06-09 | 浙江浙大中控信息技术有限公司 | Data visualization implementation method based on configuration |
CN111353288A (en) * | 2020-03-03 | 2020-06-30 | 畅捷通信息技术股份有限公司 | Report processing method, system, device and computer readable storage medium |
CN111831534A (en) * | 2019-04-15 | 2020-10-27 | 西安京迅递供应链科技有限公司 | Method and device for verifying accuracy of datagram table |
CN111966761A (en) * | 2020-08-20 | 2020-11-20 | 合肥智圣新创信息技术有限公司 | Multi-dimensional model data visualization customization platform and method based on DataV |
CN112231388A (en) * | 2020-10-14 | 2021-01-15 | 宁夏回族自治区教育信息化管理中心 | Dynamic chart construction method for diversified index analysis |
CN112307041A (en) * | 2020-10-29 | 2021-02-02 | 山东浪潮通软信息科技有限公司 | Index dimension modeling method and device and computer readable medium |
CN112488800A (en) * | 2020-12-15 | 2021-03-12 | 北京易兴元石化科技有限公司 | Network-based petroleum operation data processing method and device and storage medium |
CN114625648A (en) * | 2022-03-14 | 2022-06-14 | 广域铭岛数字科技有限公司 | DevOps-based quality analysis method, system, equipment and medium |
CN115905418A (en) * | 2022-03-25 | 2023-04-04 | 西安热工研究院有限公司 | Method and system for analyzing airport route data by using data warehouse technology |
CN119180267A (en) * | 2024-08-26 | 2024-12-24 | 航粤智能电气股份有限公司 | Intelligent analysis and display method for enterprise energy data |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101075304A (en) * | 2006-05-18 | 2007-11-21 | 河北全通通信有限公司 | Method for constructing decision supporting system of telecommunication industry based on database |
US20100299304A1 (en) * | 2000-07-19 | 2010-11-25 | Vasudevan Software Inc. | Multimedia inspection database system (midas) for dynamic run-time data evaluation |
CN103092610A (en) * | 2012-12-31 | 2013-05-08 | 武汉中地数码科技有限公司 | Configuration method of telecommunications exterior line resource one-stop type inquiring process based on hand-held terminal |
-
2014
- 2014-05-28 CN CN201410232574.1A patent/CN103984755A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20100299304A1 (en) * | 2000-07-19 | 2010-11-25 | Vasudevan Software Inc. | Multimedia inspection database system (midas) for dynamic run-time data evaluation |
CN101075304A (en) * | 2006-05-18 | 2007-11-21 | 河北全通通信有限公司 | Method for constructing decision supporting system of telecommunication industry based on database |
CN103092610A (en) * | 2012-12-31 | 2013-05-08 | 武汉中地数码科技有限公司 | Configuration method of telecommunications exterior line resource one-stop type inquiring process based on hand-held terminal |
Non-Patent Citations (1)
Title |
---|
刘其飞: "基于商务智能的油气生产报表的研究", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (57)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104299102A (en) * | 2014-10-31 | 2015-01-21 | 国电南瑞科技股份有限公司 | Multidimensional data model modeling method of power grid regulation and control integration system |
CN104462343B (en) * | 2014-12-08 | 2018-12-25 | 北京庆世昌明科技有限公司 | A kind of big data comparison collision system |
CN104462343A (en) * | 2014-12-08 | 2015-03-25 | 北京庆世昌明科技有限公司 | Big data alignment collision system |
CN104572074A (en) * | 2014-12-08 | 2015-04-29 | 北京辰闰丰青信息技术有限公司 | Big-data-based graphic presentation customizing system |
CN104504094A (en) * | 2014-12-26 | 2015-04-08 | 中国石油集团工程设计有限责任公司北京分公司 | Various data source integrated management method for oil and gas field |
CN104504094B (en) * | 2014-12-26 | 2018-03-30 | 中国石油集团工程设计有限责任公司北京分公司 | A kind of multiple data sources integrated management method and data management system for oil gas field |
CN104615725A (en) * | 2015-02-09 | 2015-05-13 | 武汉众联信息技术股份有限公司 | Web-based online self-defined reporting method |
CN104615725B (en) * | 2015-02-09 | 2018-03-16 | 武汉众廉科技有限公司 | A kind of online self-defined report implementation method based on Web |
CN106897277A (en) * | 2015-12-17 | 2017-06-27 | 成都飞机工业(集团)有限责任公司 | A kind of production and operation data visualization implementation method based on data mining |
CN106897285A (en) * | 2015-12-17 | 2017-06-27 | 北京宸瑞国新科技有限公司 | Data Elements extract analysis system and Data Elements extract analysis method |
CN106897285B (en) * | 2015-12-17 | 2020-04-07 | 北京宸瑞国新科技有限公司 | Data element extraction and analysis system and data element extraction and analysis method |
CN105843936A (en) * | 2016-03-31 | 2016-08-10 | 乐视控股(北京)有限公司 | Service data report form method and system |
CN106126513A (en) * | 2016-05-03 | 2016-11-16 | 成都市公安局 | Super dimension space-time depicting method |
CN106021624A (en) * | 2016-07-21 | 2016-10-12 | 中国农业银行股份有限公司 | ETL (extract-transform-load) model generation method and device |
CN106021624B (en) * | 2016-07-21 | 2019-07-09 | 中国农业银行股份有限公司 | A kind of ETL model generating method and device |
CN106293712A (en) * | 2016-08-01 | 2017-01-04 | 浪潮(苏州)金融技术服务有限公司 | A kind of implementation method of form processing cube model |
CN106503202A (en) * | 2016-10-26 | 2017-03-15 | 广州市勤思网络科技有限公司 | The Dynamic Configuration that a kind of data drawing list linkage shows |
CN106790504A (en) * | 2016-12-16 | 2017-05-31 | 北京北科亿力科技有限公司 | A kind of metallurgical big data service platform |
CN106934023A (en) * | 2017-03-13 | 2017-07-07 | 山东浪潮云服务信息科技有限公司 | A kind of data managing method and device |
CN108415917B (en) * | 2017-03-13 | 2021-01-15 | 平安科技(深圳)有限公司 | Visual report generation method and visual report generation device |
CN108415917A (en) * | 2017-03-13 | 2018-08-17 | 平安科技(深圳)有限公司 | A kind of generation method of Visual Report Forms and the generating means of Visual Report Forms |
CN107832313A (en) * | 2017-05-15 | 2018-03-23 | 中国石油化工股份有限公司 | Oil professional software conversion method of data format |
CN107194280A (en) * | 2017-05-25 | 2017-09-22 | 北京小度信息科技有限公司 | Method for establishing model and device |
CN107239539A (en) * | 2017-06-02 | 2017-10-10 | 山东浪潮商用系统有限公司 | A kind of user-defined m odel method based on relevant database |
CN107330045A (en) * | 2017-06-28 | 2017-11-07 | 携程旅游网络技术(上海)有限公司 | The big data visual analysis method and system of plane ticket booking platform |
CN107734068A (en) * | 2017-11-17 | 2018-02-23 | 贵州爱唐文化网络科技有限公司 | Big data display systems and method based on high in the clouds storage layout |
CN107943913A (en) * | 2017-11-20 | 2018-04-20 | 深圳市启明星电子商务有限公司 | A kind of data sheet analysis system |
CN108052542A (en) * | 2017-11-22 | 2018-05-18 | 链家网(北京)科技有限公司 | A kind of analysis method of the multidimensional data of the data based on presto |
CN108052542B (en) * | 2017-11-22 | 2021-06-08 | 贝壳找房(北京)科技有限公司 | Multidimensional data analysis method based on presto data |
CN107908784A (en) * | 2017-12-08 | 2018-04-13 | 北京蓝尊科技有限公司 | A kind of Resource management dynamic management approach and its system based on big data |
CN108009798A (en) * | 2017-12-18 | 2018-05-08 | 广东电网有限责任公司电力调度控制中心 | A kind of project various dimensions support Knowledge Management System |
CN108573354A (en) * | 2018-04-28 | 2018-09-25 | 武汉轻工大学 | Grain processing loss data analysis system and method |
CN109300023A (en) * | 2018-08-30 | 2019-02-01 | 广东源恒软件科技有限公司 | A kind of method and system that increment tax on land value big data is extracted and applied |
CN111078782A (en) * | 2018-10-19 | 2020-04-28 | 上海宝信软件股份有限公司 | Industrial big data visualization system and method |
CN111078782B (en) * | 2018-10-19 | 2023-04-28 | 上海宝信软件股份有限公司 | Industrial big data visualization system and method |
CN109408549A (en) * | 2018-11-02 | 2019-03-01 | 大连瀚闻资讯有限公司 | Import and export trade big data visualization analysis system |
CN109710686A (en) * | 2018-12-27 | 2019-05-03 | 杭州火树科技有限公司 | The analysis system of visualization building chart |
CN111831534A (en) * | 2019-04-15 | 2020-10-27 | 西安京迅递供应链科技有限公司 | Method and device for verifying accuracy of datagram table |
CN110162676A (en) * | 2019-05-21 | 2019-08-23 | 山东浪潮通软信息科技有限公司 | A kind of component that can carry out hierarchical navigation browsing to business datum according to dynamic multidimensional degree |
CN110275920A (en) * | 2019-06-27 | 2019-09-24 | 中国石油集团东方地球物理勘探有限责任公司 | Data query method, apparatus, electronic equipment and computer readable storage medium |
CN110275920B (en) * | 2019-06-27 | 2021-08-03 | 中国石油集团东方地球物理勘探有限责任公司 | Data query method and device, electronic equipment and computer readable storage medium |
CN110457368A (en) * | 2019-07-26 | 2019-11-15 | 广州市广百物流有限公司 | A kind of method for visualizing of supply chain, system and storage medium |
CN110457368B (en) * | 2019-07-26 | 2023-07-21 | 广州市广百物流有限公司 | Visualization method, system and storage medium for supply chain |
CN110442639A (en) * | 2019-07-31 | 2019-11-12 | 山东浪潮商用系统有限公司 | The big data of a kind of point of Subject Manager shows method and system |
CN111259069A (en) * | 2019-10-29 | 2020-06-09 | 浙江浙大中控信息技术有限公司 | Data visualization implementation method based on configuration |
CN111259069B (en) * | 2019-10-29 | 2023-05-19 | 浙江中控信息产业股份有限公司 | Configuration-based data visualization implementation method |
CN111159986A (en) * | 2019-12-17 | 2020-05-15 | 国家电网有限公司大数据中心 | Method and system for executing intelligent task constructed based on data resource catalog |
CN111353288A (en) * | 2020-03-03 | 2020-06-30 | 畅捷通信息技术股份有限公司 | Report processing method, system, device and computer readable storage medium |
CN111353288B (en) * | 2020-03-03 | 2024-03-29 | 畅捷通信息技术股份有限公司 | Report processing method, system, device and computer readable storage medium |
CN111966761A (en) * | 2020-08-20 | 2020-11-20 | 合肥智圣新创信息技术有限公司 | Multi-dimensional model data visualization customization platform and method based on DataV |
CN112231388A (en) * | 2020-10-14 | 2021-01-15 | 宁夏回族自治区教育信息化管理中心 | Dynamic chart construction method for diversified index analysis |
CN112307041A (en) * | 2020-10-29 | 2021-02-02 | 山东浪潮通软信息科技有限公司 | Index dimension modeling method and device and computer readable medium |
CN112488800A (en) * | 2020-12-15 | 2021-03-12 | 北京易兴元石化科技有限公司 | Network-based petroleum operation data processing method and device and storage medium |
CN112488800B (en) * | 2020-12-15 | 2024-01-23 | 北京易兴元石化科技有限公司 | Petroleum operation data processing method, device and storage medium based on network |
CN114625648A (en) * | 2022-03-14 | 2022-06-14 | 广域铭岛数字科技有限公司 | DevOps-based quality analysis method, system, equipment and medium |
CN115905418A (en) * | 2022-03-25 | 2023-04-04 | 西安热工研究院有限公司 | Method and system for analyzing airport route data by using data warehouse technology |
CN119180267A (en) * | 2024-08-26 | 2024-12-24 | 航粤智能电气股份有限公司 | Intelligent analysis and display method for enterprise energy data |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103984755A (en) | Multidimensional model based oil and gas resource data key system implementation method and system | |
US10579678B2 (en) | Dynamic hierarchy generation based on graph data | |
Deelman et al. | Grid-based metadata services | |
Li et al. | A spatiotemporal indexing approach for efficient processing of big array-based climate data with MapReduce | |
CN100573528C (en) | Digital museum gridding and building method thereof | |
US8949291B2 (en) | Automatic conversion of multidimentional schema entities | |
CN104462227A (en) | Automatic construction method of graphic knowledge genealogy | |
CN104008161A (en) | Data configuration based oil and gas resource data integration method and integration platform | |
Lehmann et al. | Managing geospatial linked data in the GeoKnow project | |
Varga et al. | QB2OLAP: enabling OLAP on statistical linked open data | |
CN113326345A (en) | Knowledge graph analysis and application method, platform and equipment based on dynamic ontology | |
US20130232158A1 (en) | Data subscription | |
JP4604168B1 (en) | File management apparatus, method thereof, and program | |
US20110258007A1 (en) | Data subscription | |
Wariyapola et al. | Ontology and metadata creation for the poseidon distributed coastal zone management system | |
Liakos et al. | A distributed infrastructure for earth-science big data retrieval | |
Gahegan et al. | A semantic web map mediation service: interactive redesign and sharing of map legends | |
Fiore et al. | A graph data model-based micro-provenance approach for multi-level provenance exploration in end-to-end climate workflows | |
Le Goff et al. | Interoperability of the ArSol (Archives du Sol) Database based on the CIDOC-CRM Ontology | |
CN114428777A (en) | Database expansion method and system | |
CN114490568A (en) | Cross-domain database integration and migration method and system | |
Pattuelli | Graphing Out Communities and Cultures in the Archives. Methods and Tools | |
Usachev et al. | Research of Correlation Dependencies in Russian Household Data Using Data Mining Methods | |
KR101743229B1 (en) | System for planning document databse based in collection diagram and apparatus used in it | |
Kalyanam et al. | Idata: A community geospatial data sharing environment to support data-driven science |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140813 |
|
WD01 | Invention patent application deemed withdrawn after publication |