WO2022012285A1 - Multi-source integrated multi-platform energy information management system - Google Patents

Abstract

A multi-source integrated multi-platform energy information management system, comprising, from a lower level to an upper lever, a basic facility layer, a data acquisition layer, a data storage layer, a basic support layer, a service application layer, a user interface layer, and a service object layer. The present system fully integrates various energy data by means of a plurality of acquisition manners, and establishes a basic energy database, breaking the obstacle of energy information sharing, promoting the sharing of energy information resources in the whole of society, and improving the comprehensive value of information resources; the present system uses ArcGIS SDE+Oracle as a database for storage, the speed of access to a large amount of data is fast, and the display of graphs in a map module is detailed and clear; and the system is expanded and designed to be displayed on a big screen end and a mobile end, achieving multi-platform display, and satisfying energy information requirements of various levels in the whole of society.

Description

A multi-source integrated multi-platform energy information management system

This application claims the priority of the Chinese patent application with the application number of 202010684072.8 and the title of the invention "a multi-source integrated multi-platform energy information management system", which was filed with the China Patent Office on July 16, 2020, the entire contents of which are by reference Incorporated in this application.

technical field

The invention relates to a platform management system, in particular to a multi-source integrated multi-platform energy information management system.

Background technique

In the current energy informatization construction, various energy-related units have developed some information systems and accumulated a lot of information resources in various industries. However, because these information resources usually mainly serve a single department of a specific industry, there is no large-scale information sharing between various systems, and the data association between various systems is not reflected, so that the comprehensive value of these information resources is also still unreliable. It has not been fully utilized, and the potential of information resources has not been fully released.

In addition, the existing energy information system has a narrow data level and a single service object. It cannot comprehensively sort out and manage various energy data at the provincial level, and cannot establish and improve the energy industry information statistics system, making these information systems impossible. At the same time, it meets the needs of the government, enterprises, and the public for energy information at different levels.

technical problem

The existing information resource systems do not realize information sharing on a large scale, so that the comprehensive value of these information resources has not been fully realized, and the potential of information resources has not been fully released. In addition, the existing energy information systems have not established and perfected the energy industry information statistics system, so that these information systems cannot simultaneously meet the needs of the government, enterprises, and the public for energy information at different levels.

technical solutions

The technical problem to be solved by the present invention is to overcome the deficiencies of the prior art, and to provide a multi-platform energy information management system with multi-source fusion, which solves the problem of non-sharing and intercommunication of energy information, and at the same time, satisfies the needs of energy information at all levels, and improves the daily use of energy information. The work efficiency and level of energy operation monitoring and management.

The technical scheme adopted by the present invention to solve the technical problem is: a multi-source fusion multi-platform energy information management system, including an infrastructure layer, a data acquisition layer, a data storage layer, a basic support layer, and a business application layer set from bottom to top , user interface layer and service object layer, wherein the modules of the infrastructure layer include application deployment servers, database servers, backup servers, storage devices, network devices and operating systems, and the modules of the data collection layer include data collection subsystems, batch import , data reporting and other system access, the modules of the data storage layer include an energy statistics monitoring database, an energy resource and project attribute database, an energy geospatial database, a multimedia resource library and a system configuration database, and the modules of the basic support layer include Data warehouse construction engine, data access engine, data visualization engine, energy knowledge management engine, intelligent analysis engine, business log engine, single sign-on engine, external interface and system configuration, the modules of the business application layer include energy statistics analysis subsystem , Energy Operation Monitoring Subsystem, Energy Information Release Subsystem, Energy Planning and Project Management Subsystem, Energy Knowledge Base Subsystem and Data Reporting and Collection Subsystem, the modules of the user interface layer include energy consultation sub-platform and mobile terminal platform , the modules of the service object layer include government departments, energy enterprises and public use terminals.

Further, the application deployment server adopts the Windows Server 2008 operating system, and the database server adopts Oracle and MySQL construction. The infrastructure layer is the basic guarantee for project construction.

Further, the data collection subsystem is used to build a reporting platform for users and suppliers to actively report data. The platform uses FineReport to implement report services, perform paging, column and group settings, and realize grid report production on the platform. The data acquisition layer is the basis for acquiring the data required by the system.

Further, the database is constructed by Oracle, using ArcGIS SDE as the storage system of the spatial database. The data storage layer is the foundation of business application construction.

Further, the naming logic of the data table in the Oracle database follows the following rules:

(1) Starting with b: It is a chart association table, which is used to save the association information between relevant fields in different tables;

(2) Beginning with c: It is a storage table for statistical operation indicators, which is used to store all operation-related data of the energy system; in addition to setting the Value field for numerical values, due to the large amount of data involved, the PARAM_ID field is also set for all operation data. Data indicator encoding, PARAMUNIT_ID indicates indicator unit encoding, SOURCE_ID indicates data source encoding, DATETIME_FLAG indicates time dimension encoding, RD_ID indicates running data flow direction encoding;

(3) Begin with f: It is the basic configuration table of the system, which is used to save the relevant information of the users in the system and the system module update;

(4) Beginning with l: a list of document classes and video classes;

(5) Beginning with Pro: is the project table, in which the middle field is Elec is the power project table; the middle field is NewEnergy is the new energy information table; the middle field is Oil is the oil and gas information table; the information of various energy projects in the province is stored in detail, Including related company project information, planning and construction progress information, high-definition satellite image data, digital ground model data DEM and geographic coordinate information.

Further, the basic support layer is the basis for constructing the operation of each professional application platform and its supporting system, and adopts the Web system development framework of the enterprise-level J2EE system based on JAVA JDK under the Java platform, and the platform adopts the system framework based on MVC, The front-end business application system adopts the EXT development framework; FineBI is used to draw charts on the front-end page display, realize multi-source data integration, data association and field escape of report data, and realize the configuration and analysis of ETL data collection tool flow, and use Echarts components at the same time Optimize the front-end dynamic window display; use ArcGIS Server to publish map and image data, use the 3D data engine NSC Globe to manage 3D data and publish 3D earth services, and use ArcGIS API for JavaScript development kits for 2D GIS on the office platform and large screen platform Function development, the mobile platform subsystem uses the ArcGIS API for Android development kit to develop 2D GIS functions on the mobile side.

Further, the business application layer centrally and intuitively reflects the application functions of the platform, and the home page of the energy statistics and analysis subsystem displays energy economy, energy production, total consumption and energy consumption information, and separates electricity, coal, petroleum, The change information of various types of energy production, consumption, transportation and inventory of gas and new energy is displayed in the form of bar chart/line chart/pie chart/map chart. Analysis and comparison.

Further, the energy statistics monitoring database, the energy resource and project attribute database and the system configuration database are constructed through Oracle, and the energy geospatial database is constructed through the ArcGIS SDE storage system.

beneficial effect

The invention comprehensively integrates various energy data through a variety of collection methods, establishes a basic energy database, breaks the barrier between energy information sharing, promotes the sharing of energy information resources in the whole society, and improves the comprehensive value of information resources; using ArcGIS As a database storage, SDE+Oracle can access a large amount of data quickly, and the charts in the map module are displayed in detail and clearly; the design and expansion system is displayed on the large screen and mobile terminals, realizing multi-platform display, which meets all levels of the whole society. energy information needs.

In addition to the objects, features and advantages described above, the present invention has other objects, features and advantages. The present invention will be described in further detail below with reference to the drawings.

Description of drawings

The accompanying drawings constituting a part of the present application are used to provide further understanding of the present invention, and the exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the attached image:

FIG. 1 is an overall frame diagram of an embodiment of the present invention.

Embodiments of the present invention

In order to facilitate understanding of the present invention, the present invention will be described more fully below, and preferred embodiments of the present invention will be given. However, the present invention may be embodied in many different forms and is not limited to the embodiments described herein. Rather, these embodiments are provided so that a thorough and complete understanding of the present disclosure is provided.

Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terms used herein in the description of the present invention are for the purpose of describing specific embodiments only, and are not intended to limit the present invention.

Referring to FIG. 1 , this embodiment includes seven different layers from bottom to top: infrastructure layer, data collection layer, data storage layer, basic support layer, business application layer, user interface layer, and service object layer.

Among them, the construction methods of each level are as follows:

(1) The infrastructure layer includes application deployment servers, database servers, backup servers, storage devices, network devices and operating systems;

The database server is the core server of the system. Oracle and MySQL are used to build the system database. The deployment server uses the Windows Server 2008 operating system. In addition, the network construction ensures the security and stability of port access between servers, and a special backup server is set up for the system. data is backed up.

(2) The data acquisition layer module includes data acquisition subsystem, batch import, data reporting and other system access;

First of all, the present invention designs a data collection subsystem to build a reporting platform for users and suppliers to actively report data; the platform uses FineReport to realize report service, perform paging, column and group settings, and realize the production of various and complex grid reports on the platform ;

In order to connect the data interfaces of other information systems, Web Service is used to publish application services, and at the same time, communication protocols between different systems are configured for different data transmission methods for dedicated line connection.

Set up web crawlers to regularly capture data from the Internet, mainly to perform page analysis on web pages published by Internet-related websites to determine the required data, and then collect and store the data;

The system collects energy data from a wide range of types and sources, including electricity, coal, oil, natural gas, new energy, etc.; the energy business chain includes energy production data, supply data, circulation data, consumption data, inventory data, etc.; data Types include operational data, project data, multimedia data, geographic information, etc.; data sources include energy authorities, key energy companies, other institutions, and the Internet. Time dimensions include year, month, quarter, and day.

(3) The data storage layer includes energy statistics monitoring database, energy resource and project attribute database, energy geospatial database, multimedia resource database and system configuration database;

Use Oracle to build the system database, specifically, the energy statistics monitoring database, the energy resource and project attribute database and the system configuration database are built through Oracle; ArcGIS SDE is used as the storage system of the spatial database, that is, the energy geospatial database is built through the ArcGIS SDE storage system; this The invention uses a disk array as the storage device for online real-time running data, temporary work data and recent historical data, mainly storing spatial data and attribute relation data; using an offline disk library as an offline storage device to store the history that is relatively long from the current time data and larger file data;

The naming logic of data tables in Oracle database (referring to energy statistics monitoring database, energy resource and project attribute database and system configuration database) follows the following rules:

Beginning with b: It is a chart association table, which is used to save the association information between relevant fields in different tables;

Beginning with c: it is a storage table for statistical operation indicators, which is used to store all operation-related operation data of the energy system; in addition to setting the Value field for numerical values, the present invention also sets the PARAM_ID field for all operation data because of the large amount of data involved. Data indicator encoding, PARAMUNIT_ID indicates indicator unit encoding, SOURCE_ID indicates data source encoding, DATETIME_FLAG indicates time dimension encoding, RD_ID indicates running data flow direction encoding;

Beginning with f: It is the basic configuration table of the system, which is used to save relevant information such as users in this system and system module updates;

Beginning with l: a list of document classes and video classes;

Beginning with Pro: is the project information table, in which the middle field is Elec, which is the power project information table; the middle field is NewEnergy, which is the new energy information table; the middle field is Oil, which is the oil and gas information table; the information of various energy projects in the province is stored in detail, including Related company project information, planning and construction progress information, high-definition satellite image data, digital ground model data (DEM) and geographic coordinate information.

For vector spatial data, the ArcGIS Server spatial data engine is used to establish the corresponding seamless dataset and spatial grid index for the vector data layer in the Oracle database, and the corresponding seamless dataset is also constructed for the indexed vector graph data. Establish the corresponding spatial grid index; for the image data, it is divided into continuous and seamless data blocks, each data block has the same image features and spatial reference, and the ArcGIS Server spatial data engine is used to construct the corresponding data blocks in the Oracle database. raster datasets, and establish a pyramid image index for each raster dataset to form an internal spatial index system for image data blocks.

(4) The basic support layer is the basis for building various professional application platforms and their supporting systems. Its modules include data warehouse construction engine, data access engine, data visualization engine, energy knowledge management engine, intelligent analysis engine, business log engine, single Click on the login engine, external interface and system configuration;

The basic support layer is the basis for constructing various professional application platforms and their supporting systems. This system adopts the enterprise-level Web system development framework based on JAVA JDK's J2EE system under the Java platform, the platform procurement service application system is based on the MVC system framework, and the front-end business application system adopts the EXT development framework;

Use FineBI to draw charts on the front-end page display, realize BI analysis such as multi-source data integration, data association and field escape of report data, realize the configuration and analysis of ETL data collection tool flow, and use Echarts component to display the front-end dynamic window achieve optimization;

Use ArcGIS Server to publish map and image data, use the 3D data engine NSC Globe to manage 3D data and publish 3D earth services, use ArcGIS API for JavaScript development kits for office platforms and large-screen platforms to develop 2D GIS functions, and use ArcGIS for mobile platform subsystems. API for Android development kit for mobile 2D GIS function development.

(5) The business application layer centrally and intuitively reflects the various application functions of the platform, including the energy statistical analysis subsystem, energy operation monitoring subsystem, energy information release subsystem, energy planning and project management subsystem, energy knowledge base subsystem and Data reporting and collection subsystem;

The invention designs business application subsystems such as energy statistical analysis, energy operation monitoring, energy planning and project management, energy knowledge base, and energy information release for the office platform. And expanded and designed a large-screen comprehensive display platform and a mobile handheld energy APP platform. The system provides a large number of basic views of business data logic tables in the database, and specially designs separate views for the business segments of different subsystems;

The home page of the energy statistical analysis subsystem displays the energy economy, energy production, total consumption and energy consumption information, and separately displays the change information of electricity, coal, oil, gas, new energy and other types of energy production, consumption, transportation, inventory, etc. , which are mainly displayed in the form of bar charts, line charts, pie charts, map charts, etc. The statistical dimension of the data report results by this subsystem is mainly analyzed and compared on an annual basis;

The energy operation monitoring subsystem focuses on energy core business activities and core business resources, and through sorting out the data indicator system, realizes all-round and all-weather monitoring of the consumption, import and export, inventory and energy supply and demand events of electricity, coal, oil and natural gas. Monitoring, including statistical display of monthly, daily and real-time data.

The energy planning and project management subsystem performs two-dimensional map display through ArcGIS Server, which mainly realizes the display and maintenance of energy projects, energy resources and basic geographic information on the map; energy projects include power projects, coal projects, oil projects, natural gas projects, Renewable energy projects and annual key projects; energy resources include coal resources, water resources, wind resources, photovoltaic resources, biomass resources, garbage resources, shale gas resources, geothermal resources and uranium resources;

The energy knowledge subsystem centrally manages various energy knowledge and document libraries, and performs centralized encryption and block storage of various domestic and foreign energy related laws and regulations, energy policies, notices and announcements, work trends, etc., while ensuring information security, Establish convenient information sharing and publishing channels for system users at all levels; a wide variety and large number of documents and other types of documents in the system are stored on the server in the form of files, and the UUID and documents are mapped in the database through document names. search accordingly;

In addition to the office platform, the large-screen comprehensive display platform is specially designed for use as a publicity platform. The data charts in the two subsystems of statistical analysis and operation monitoring are optimized and refined through Echarts components and ArcGIS Server for display; APP Handheld Energy The platform uses ArcGIS API for Android to display the annual, monthly, and daily energy operation information of electricity, coal, and oil and gas on the mobile terminal in a graphical manner, which is generally divided into annual statistics, monthly statistics, and daily monitoring.

(6) The user interface layer is the service object-oriented application equipment interface, including the energy consultation sub-platform and the mobile terminal platform;

The present invention sets up multiple platforms for display, including an office platform, a large-screen publicity platform, and a mobile terminal platform; users can access each application subsystem through office computers, notebook computers, large-screen splicing screens, and mobile terminal equipment.

(7) The service object layer is the final user of the system, including government departments, energy companies and the public.

This embodiment comprehensively integrates various energy data through multiple collection methods, establishes a basic energy database, breaks the barriers between energy information sharing, promotes the sharing of energy information resources in the whole society, and improves the comprehensive value of information resources ;Using ArcGIS SDE+Oracle as the database storage, the access speed of a large amount of data is fast, and the charts in the map module are displayed in detail and clearly; the design and expansion system is displayed on the large screen and mobile terminal, realizing multi-platform display, which meets the requirements of all Energy information needs at all levels of society.

The above descriptions are only preferred embodiments of the present invention, and are not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and changes. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included within the protection scope of the present invention.

Claims (8)

1. A multi-source integrated multi-platform energy information management system, characterized in that it includes an infrastructure layer, a data collection layer, a data storage layer, a basic support layer, a business application layer, a user interface layer and a service object layer set from bottom to top , wherein the modules of the infrastructure layer include application deployment servers, database servers, backup servers, storage devices, network devices and operating systems, and the modules of the data collection layer include data collection subsystems, batch import, data reporting and other system access , the modules of the data storage layer include an energy statistics monitoring database, an energy resource and project attribute database, an energy geospatial database, a multimedia resource library and a system configuration database, and the modules of the basic support layer include a data warehouse construction engine, a data access engine , data visualization engine, energy knowledge management engine, intelligent analysis engine, business log engine, single sign-on engine, external interface and system configuration, the modules of the business application layer include energy statistical analysis subsystem, energy operation monitoring subsystem, energy Information release subsystem, energy planning and project management subsystem, energy knowledge base subsystem and data reporting and collection subsystem, the modules of the user interface layer include an energy consultation sub-platform and a mobile terminal platform, and the modules of the service object layer Including government departments, energy companies and the public use terminals.
2. The multi-platform energy information management system of multi-source fusion according to claim 1, is characterized in that: described application deployment server adopts Windows Server 2008 operating system, and database server adopts Oracle and MySQL construction.
3. The multi-platform energy information management system of multi-source fusion according to claim 1 or 2, wherein the data acquisition subsystem is used to build a reporting platform for users and suppliers to actively report data, and the platform adopts FineReport to realize the report Service, perform paging, column and group settings, and realize grid report production on the platform.
4. The multi-platform energy information management system of multi-source fusion according to claim 1 or 2, is characterized in that: described database is constructed by Oracle, and uses ArcGIS SDE as the storage system of spatial database.
5. The multi-platform energy information management system of multi-source fusion according to claim 4 is characterized in that: the naming logic of the data table in the Oracle database follows the following rules:

   (1) Starting with b: It is a chart association table, which is used to save the association information between relevant fields in different tables;

   (2) Beginning with c: It is a storage table for statistical operation indicators, which is used to save all operation-related operation data of the energy system; in addition to setting the Value field for numerical values, the PARAM_ID field is also set for all operation data to indicate the data index code, PARAMUNIT_ID indicates Indicator unit code, SOURCE_ID represents the data source code, DATETIME_FLAG represents the time dimension code, RD_ID represents the running data flow direction code;

   (3) Begin with f: It is the basic configuration table of the system, which is used to save the relevant information of the users in the system and the system module update;

   (4) Beginning with l: a list of document classes and video classes;

   (5) Beginning with Pro: is the project table, in which the middle field is Elec is the power project information table; the middle field is NewEnergy is the new energy information table; the middle field is Oil is the oil and gas information table; the information of various energy projects is stored in detail, including Related company project information, planning and construction progress information, high-definition satellite image data, digital ground model data DEM and geographic coordinate information.
6. The multi-platform energy information management system of multi-source fusion according to claim 1 or 2, characterized in that: the basic support layer adopts an enterprise-level Web system development framework based on the J2EE system of JAVA JDK under the Java platform, and the platform The service application system is based on the MVC system framework, and the front-end business application system adopts the EXT development framework; FineBI is used to draw charts on the front-end page display to realize multi-source data integration, data association and field escape of report data, and realize ETL data collection tools Stream configuration and analysis, and use the Echarts component to optimize the front-end dynamic window display; use ArcGIS Server to publish map and image data, use the 3D data engine NSC Globe to manage 3D data and publish 3D earth services, office platforms and large screen platforms use The ArcGIS API for JavaScript development kit is used to develop 2D GIS functions, and the mobile platform subsystem uses the ArcGIS API for Android development kit to develop 2D GIS functions on the mobile side.
7. The multi-platform energy information management system of multi-source fusion according to claim 1 or 2, characterized in that: the business application layer centrally and intuitively reflects various application functions of the platform, and the energy statistics and analysis subsystem home page displays energy Economy, energy production, total consumption and energy consumption information, and separately display the change information of various energy production, consumption, transportation and inventory of electricity, coal, oil, gas, and new energy through bar chart/line chart/pie It is displayed in the form of a graph/map chart, and the subsystem analyzes and compares the statistical dimensions of the data report results on an annual basis.
8. The multi-platform energy information management system of multi-source fusion according to claim 1 or 2, is characterized in that: energy statistics monitoring database, energy resource and project attribute database and system configuration database are constructed by Oracle, and energy geospatial database is constructed by ArcGIS SDE Storage system construction.

Images