CN114036206A - Multi-energy information management system based on time sequence database - Google Patents
Multi-energy information management system based on time sequence database Download PDFInfo
- Publication number
- CN114036206A CN114036206A CN202111292270.0A CN202111292270A CN114036206A CN 114036206 A CN114036206 A CN 114036206A CN 202111292270 A CN202111292270 A CN 202111292270A CN 114036206 A CN114036206 A CN 114036206A
- Authority
- CN
- China
- Prior art keywords
- data
- energy
- acquisition
- node
- subsystem
- 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
- 238000005265 energy consumption Methods 0.000 claims abstract description 53
- 230000008520 organization Effects 0.000 claims abstract description 35
- 238000007726 management method Methods 0.000 claims abstract description 21
- 238000013500 data storage Methods 0.000 claims abstract description 12
- 238000004458 analytical method Methods 0.000 claims abstract description 9
- 238000004364 calculation method Methods 0.000 claims description 12
- 238000007619 statistical method Methods 0.000 claims description 11
- 230000002159 abnormal effect Effects 0.000 claims description 10
- VNWKTOKETHGBQD-UHFFFAOYSA-N methane Chemical compound C VNWKTOKETHGBQD-UHFFFAOYSA-N 0.000 claims description 10
- 238000012544 monitoring process Methods 0.000 claims description 10
- 238000011161 development Methods 0.000 claims description 9
- 238000009826 distribution Methods 0.000 claims description 8
- 238000004519 manufacturing process Methods 0.000 claims description 6
- 238000000034 method Methods 0.000 claims description 6
- 230000001502 supplementing effect Effects 0.000 claims description 6
- 239000003345 natural gas Substances 0.000 claims description 5
- 238000000547 structure data Methods 0.000 claims description 5
- 238000006243 chemical reaction Methods 0.000 claims description 4
- 239000007789 gas Substances 0.000 claims description 4
- 230000008569 process Effects 0.000 claims description 4
- 238000005516 engineering process Methods 0.000 claims description 3
- 238000012797 qualification Methods 0.000 claims description 3
- 238000003860 storage Methods 0.000 claims description 3
- 230000005856 abnormality Effects 0.000 claims description 2
- 239000013589 supplement Substances 0.000 claims description 2
- 238000013461 design Methods 0.000 abstract description 3
- 230000000295 complement effect Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 230000005611 electricity Effects 0.000 description 3
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 238000001514 detection method Methods 0.000 description 2
- 230000003203 everyday effect Effects 0.000 description 2
- 238000005065 mining Methods 0.000 description 2
- 239000003570 air Substances 0.000 description 1
- 239000003034 coal gas Substances 0.000 description 1
- 230000002354 daily effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- -1 electricity Substances 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2474—Sequence data queries, e.g. querying versioned data
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24568—Data stream processing; Continuous queries
-
- 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/06—Energy or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Economics (AREA)
- Probability & Statistics with Applications (AREA)
- Human Resources & Organizations (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Fuzzy Systems (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
A multi-energy information management system based on a time sequence database is characterized in that: the system comprises an infrastructure layer, a data acquisition layer, a data storage layer, a business application layer, a user interface layer and a service object layer which are arranged from bottom to top; the energy information management system adopts a flexible data acquisition mode to acquire different types of energy information in enterprises, designs various energy flow hierarchical structures and energy accounting organization hierarchical structures in a tree structure mode through unified modeling, associates the energy flow structures with acquired data, calculates the node energy consumption in the energy flow structures in a formula mode, provides a configurable report system, can configure various flexible and changeable energy reports, and meets the energy information statistics and analysis requirements of various organizations.
Description
Technical Field
The invention belongs to the technical field of energy information management, and particularly relates to a multi-energy and multi-energy information management system based on a time sequence database.
Background
The existing energy management system mainly reads specific types of energy through customized development and analysis, the report mode of the traditional energy management system is fixed, unified modeling and analysis on multiple different energy types in an enterprise are lacked, the report output mode is not flexible enough, and energy management system users cannot flexibly define various energy statistical reports in a self-defined mode, so that the energy information management system does not have great flexibility and adaptability, and the cost for constructing and implementing the energy information management system by each demand unit is increased.
Disclosure of Invention
The invention aims to solve the problems of the existing energy management system, and provides a multi-energy and multi-variety energy information management system based on a time sequence database.
The invention provides a multi-energy information management system based on a time sequence database, which is used for solving the technical problem and is characterized in that: comprises an infrastructure layer, a data acquisition layer, a data storage layer, a business application layer, a user interface layer and a service object layer which are arranged from bottom to top, the infrastructure layer comprises an application deployment server, a data acquisition server, a database server, a storage device, a network device and an operating system, the data acquisition layer comprises a data configuration subsystem, a data acquisition subsystem and a manual data input module, the data storage layer comprises energy collection data, energy statistical data, energy flow structure data and energy consumption organization data, the service application layer comprises an energy statistic analysis subsystem, an energy operation monitoring subsystem, an energy information issuing subsystem and a data reporting subsystem, the user interface layer comprises a web end and a mobile end of the energy information management system, and the service object layer comprises a power energy production department and a power energy use department.
Further, the application deployment Server and the data acquisition Server adopt a Windows Server2008 operating system, the time sequence database adopts a fidelity historian, and the database Server adopts Oracle.
Further, the data configuration subsystem can configure data acquisition tasks of different energy types, required acquisition point locations, energy types corresponding to the point locations, Historian tags, energy consumption multiplying power, upper and lower limits and energy units, and decimal point bit configuration items, wherein the configurable content of the data acquisition tasks comprises acquisition names, Historian data sources and acquisition periods, and the acquisition periods comprise seconds, minutes, hours, class, days, half months, quarters, half years and years.
Furthermore, the data configuration subsystem can configure energy flow direction distribution structures with different energy types according to a tree structure mode, or configure energy consumption use organization hierarchy structures of different organizations and departments in the tree structure mode, each node on the tree structure can refer to one or more specific energy meter data, four operations are performed on the multiple meter data in a formula calculation mode, and an operation result is used as the energy data of the node, or the four operations are performed by referring to nodes of other energy flow structures or other energy consumption organization structures.
Further, the data acquisition subsystem can periodically read data from a Historian database according to configured data acquisition tasks and acquisition point positions, write the data into an energy source database, enter an acquisition supplementing queue after failed acquisition, periodically start an acquisition supplementing program to supplement the acquisition tasks in the acquisition supplementing queue, periodically start an abnormality checking program to check whether the acquired energy data contain abnormal data, wherein the abnormal data contain four conditions of acquisition data being empty, excessive acquisition data, negative acquisition data and 0 acquisition data, and mark and process the abnormal data.
Further, the data storage layer comprises energy collection data, energy statistics data, energy flow structure data and energy consumption organization data, related data are stored in an Oracle database, and the naming of the table of the Oracle database follows the following rules:
(a) storing data of the configuration class by using a table at the beginning of JC _ for storing configured acquisition tasks, acquisition point data, energy flow structures, organizational structures and energy consumption calculation formulas;
(b) storing the collected data, the energy consumption calculation result data and the statistical result data of various reports in a table at the head of SC _ A;
(c) the table beginning with XT _ stores system user information and user right information data.
Furthermore, the manual data input module can input energy consumption data in a manual mode, and the manual data input module inputs instrument data which cannot be acquired through automatic acquisition tasks and energy statistics related signature data, production data, plan indexes and assessment index data.
The method comprises the steps that a data configuration client of a user interface layer is developed by adopting a WinForm development technology under a Net platform, energy monitoring, energy statistical analysis and an energy report subsystem system are developed by adopting a Net Aspx.Net development framework, Echarts graphical display controls are used for displaying energy flow distribution, statistical analysis, energy prediction, energy trend display and the like of energy, GridView and DataGrid controls of Aspx.net are used for displaying statistical reports of energy data and energy consumption data, a mobile terminal adopts a React development H5 website, and a user accesses the H5 website through a mobile terminal browser to view the energy data and the statistical data.
Furthermore, the service application layer integrates multiple application functions of the system, the energy statistical analysis subsystem displays the data of the acquisition point position reading meter and the energy consumption data of various types, performs trend analysis on the reading and the energy consumption, corrects the energy data, can display the flow direction and distribution of energy of different types according to the energy flow structure, and displays the energy use condition of each organization according to the organization structure.
Furthermore, the energy operation monitoring subsystem can monitor the energy quality, the energy quality data comprises voltage, current, vacuum pressure, air pressure, steam pressure, natural gas and the like, the energy quality data can be analyzed and judged through the system, the qualification rate and the disqualification rate of the daily morning, noon, evening shift, first-second-third-month shift and first-second-third-month shift are counted, and the use efficiency and the conversion efficiency of energy are reflected by calculating the air-pressure electric-gas ratio, the boiler steam-gas ratio and the power factor index data of each day, each shift and each month.
Furthermore, the data report subsystem can customize various types of statistical reports in a configurable mode, the output format of the report is Excel, Excel cell display data can be configured through a configuration file, association is established between the configuration file and nodes in the energy flow structure and the energy consumption organization structure, and node data in the energy flow structure or the energy consumption organization structure are automatically read and written into the Excel cells when the report is generated.
The configuration of the cells follows the following rules:
ITEM cell content description node label, cell column (A, B, C, D, etc.), cell row (1, 2, 3, etc.), and so on
And (3) node marking:
the node data statistics mode of naming the nodes in the energy flow structure or the energy consumption organization structure by letters or underlines, point numbers and the like follows the following rules:
(1) MONTH1, which indicates reading the data of the MONTH1 of the current year of the node, and the MONTH can be followed by any MONTH number, which indicates reading the data of the MONTH specified by the current year of the node;
(2) season1, which is used for reading the data of the 1 st quarter of the current year of the node, and can be followed by any number of quarters, which is used for reading the data of the specified quarter of the current year of the node;
(3) LastYearMonth 1: data representing the last 1 month of the year of reading the node; LastYearMonth may be followed by any month number indicating that the data of the month specified in the last year of the node is read;
(4) EndOfThisMonth: representing reading all month statistics of the node from this year to the current month;
(5) LastMonth: indicating reading the data of the last month of the node;
(6) THISEYEAR: representing the data of the node read in the whole year of the current year;
(7) LastYear represents the data read for the node for the last year and the whole year.
Advantageous effects
The invention provides a multi-energy and multi-variety energy information management system based on a time sequence database, which adopts a flexible data acquisition mode to acquire different kinds of energy information in enterprises, designs various energy flow hierarchical structures and energy accounting organization hierarchical structures in a tree structure mode through unified modeling, associates the energy flow structures with acquired data, calculates node energy consumption in the energy flow structures in a formula mode, provides a configurable report system, can configure various flexible and variable energy reports, and meets the energy information statistics and analysis requirements of various organizations.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings used in the description of the embodiments will be briefly introduced below.
FIG. 1 is a diagram illustrating an overall architecture of an energy management system according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a Historian data acquisition process in an embodiment of the present invention;
FIG. 3 is a schematic diagram of an Excel report configuration in an embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples.
Referring to fig. 1, the present embodiment includes an infrastructure layer, a data acquisition layer, a data storage layer, a business application layer, a user interface layer, and a service object layer, which are arranged from bottom to top.
The construction method of each layer is as follows:
(1) the infrastructure layer comprises an application deployment server, a data acquisition server, a database server, a storage device, a network device and an operating system; the system comprises a time sequence database, an application Server, a data acquisition Server, a data Server and a data acquisition Server, wherein the time sequence database adopts Proficy Historian, the database Server adopts Oracle, the database Server is a core Server of the system, the application Server and the data acquisition Server adopt Windows Server2008 operation systems, the Server where the Historian is located and the Server where the data acquisition application is located are connected with the two servers in the same network segment or in a network cable direct connection mode as far as possible, so that the network is not interrupted, the data acquisition can be carried out smoothly, in order to ensure the safety of data, a special backup system is adopted to backup the Oracle database every day, and backup files are respectively stored on a local backup file Server and a special backup file Server;
(2) the data acquisition layer comprises a data configuration subsystem, a data acquisition subsystem and a manual data input module;
after energy data are read by various meters or sensors such as an electric meter, a water meter and an air pressure flow meter in an energy network or a pipeline, the energy data are sent to a Historian database through an OPC protocol, and the energy data are marked in the Historian database through tags. The Historian database is a time sequence database commonly used in the industry, can store collected data on instrument equipment, has the defects of low access speed and no cluster and distributed functions, and is a closed database which cannot create more tables on the database to support more advanced applications. Therefore, data in Historian needs to be put into a common relational database such as Oracle after being collected, a new table is created in the database by utilizing the advantages of the Oracle database, and association of multiple dimensions is established with energy data so as to form effective support for a business application layer.
The energy management system aims to collect energy data from a Historian time sequence database and store the energy data into an Oracle database, and meanwhile, different collection periods can be set aiming at different energy types and energy types, energy quality types such as temperature, humidity, voltage, current, air pressure instantaneous flow and steam flow are collected according to minute levels, energy consumption type electricity consumption, water consumption, steam usage, natural gas usage and the like are collected according to hour levels, and new collection tasks and collection point positions can be flexibly added according to energy management requirements. The energy management system data configuration subsystem is used for configuring acquisition tasks and acquisition point locations, the data acquisition tasks comprise acquisition task names, acquisition intervals and acquired Historian server addresses, a plurality of different acquisition tasks can be configured according to different database sources, the acquisition tasks run in a background mode in an independent thread mode, each data acquisition task can comprise a plurality of data acquisition point locations, and each data acquisition node configuration item comprises configuration items such as energy types, corresponding Historian labels, acquisition periods, acquisition multiplying powers, energy units, data upper and lower limits and default decimal point numbers.
Referring to fig. 2, a schematic diagram of a Historian data acquisition process is shown, and a data acquisition subsystem acquires data of multiple energy sources from the Historian according to configured acquisition tasks, wherein the energy sources include water, electricity, coal gas, natural gas, air pressure, vacuum, steam and the like. NET WCF provides basic Historian data acquisition service, the data acquisition service is used for receiving acquisition requests, service request interface parameters comprise acquisition labels, acquisition time points and the quantity required to be acquired each time, and the acquisition service returns data to a service requester after reading the data. The other module is used for sending an acquisition service request, running in a Window service mode, adopting a Net Timer timing mechanism to start an acquisition task at regular time, sending a data acquisition service request through a NET WCF protocol, wherein request parameters comprise data acquisition point location information and an acquisition time range, and storing data into an Oracle database after receiving the acquired data. And the acquisition tasks which cannot be completed enter the complementary acquisition queue, and in order to prevent the data in the complementary acquisition queue from being lost, the data in the complementary acquisition queue is persisted into an Oracle database. And starting the complementary mining program at regular time to acquire the acquisition tasks in the complementary mining queue, and removing the acquired acquisition tasks from the complementary mining queue. And starting a data abnormity judgment service at regular time to judge whether the acquired data contains abnormal data, wherein the abnormal data comprises 0 acquired, the acquired data is empty, a negative number is acquired, the acquired data is abnormally large, and the abnormal data is marked.
The manual data input module is used for inputting energy data and related data of the energy system, which are input in a manual mode. The manual data input module is a program with a B/S structure, and a user can manually input data by means of a browser. The manual data input module can input instrument data which cannot be acquired through an automatic acquisition task, and signature data, production data, plan indexes and assessment index data which are related to energy statistics.
The system can create various tree-shaped energy flow structures and energy consumption organization structures through flexible configuration and is used for counting and checking the flow direction and distribution of energy sources, each node in the tree-shaped structures can refer to one or more acquisition points and can also refer to nodes in other tree-shaped structures, each reference object is named according to the sequence in the manner of A, B, C, D and the like, the reference objects are used as basic elements to perform four-way operation, and the energy value of each node is calculated. The data configuration subsystem is a B/S structure client application program developed by C #, can configure energy flow structures and organizational structures in any forms as required, commands nodes in a tree structure, and naming rules are character strings consisting of letters, numbers, characters and the like, and the nodes can be quoted by a report system and used for generating data in a report. After the energy flow structure, the energy consumption organization structure and the acquisition point location are associated, statistics and analysis related to various energy sources and report calculation can be carried out on a business application layer and a user interface layer.
(3) The data storage layer comprises a database of an Oracle construction system, and data in the database comprise energy collection data, energy statistics data, energy flow structure data and energy consumption organization data. The energy collection data and the energy consumption statistical data are mainly used for storing collected energy data and energy consumption data, the energy flow structure database stores an energy flow direction hierarchical structure represented by a treelized structure and an energy consumption calculation formula of each node, the energy consumption organization data stores organization energy consumption data represented by the treelized structure and an energy consumption calculation formula of each organization node, and the Oracle database table naming follows the following naming rules:
(a) and storing data of the configuration class by using a table at the beginning of JC _ for storing configured acquisition tasks, acquisition point data, energy flow structures, organizational structures and energy consumption calculation formulas. JC _ SIMUTAB data acquisition point location information table, JC _ DGATHERTASK data acquisition task table, JC _ DGATHERPOINT data task specific point location table, JC _ ENERGY ENERGY flow structure and ENERGY consumption organization structure table and JC _ TAG ENERGY flow structure and ENERGY consumption organization structure label table.
(b) And storing the collected data, the energy consumption calculation result data and the statistical result data of various reports by using the table at the head of the SC _ table. SC _ ENERGY, data acquisition data storage table, SC _ BAOBIBAO data storage table for advanced operation of data with labels in ENERGY flow structure and ENERGY consumption organization structure.
(c) The table beginning with XT _ stores system user information and user right information data. XT _ USER information table.
(4) The service application layer centralizes and visually embodies various application functions of the platform, and comprises an energy statistical analysis subsystem, an energy operation detection subsystem, an energy information release subsystem and a data report subsystem;
the energy statistical analysis subsystem comprises a meter reading number capable of checking the collection point location, an energy consumption value calculated in a collection period, a reading trend chart and an energy consumption trend chart, abnormal collection point location query and missed collection point location query. Energy use conditions are counted and analyzed in a table and graphical mode according to the configured energy flow structure and energy consumption organization structure, energy use values, same ratio values and ring ratio values are calculated according to different periods, independent calculation can be carried out according to working days and non-working days, and the energy use conditions are predicted.
The energy operation monitoring subsystem can monitor the energy quality, the energy quality data comprises voltage, current, vacuum pressure, air pressure, steam pressure and natural gas data, the energy operation detection system judges whether the data per minute is qualified or not according to one point per minute on the energy quality data, the data exceeding the upper limit and the lower limit are judged to be unqualified, and the total qualification rate and the disqualification rate of the morning, noon, evening and shift, the first and second shifts, the morning, evening and the second and third shifts every day are counted. And monitoring the use efficiency and the conversion efficiency of energy sources by calculating the air-to-pressure-electric ratio, the boiler steam-to-gas ratio and the power factor index data of each day, each shift and each month.
The data report subsystem counts and analyzes the use condition of the energy according to an accounting organization structure, an energy flow structure and the like, and outputs various types of reports, including reports of energy unit consumption, main economic and technical indexes, industrial enterprise electricity consumption, workshop energy consumption indexes and the like. The report output system is a configurable system, the output format is Excel, as shown in fig. 3, Excel cell data can be configured through a configuration file, a relationship among Excel cells, a power flow structure and an energy consumption organization structure is established in a configuration mode, node data in the power flow structure or the energy consumption organization structure is automatically read and written into the Excel cells when a report is generated, and the cell configuration follows the following rule:
ITEM cell content description node label, cell column (A, B, C, D, etc.), cell row (1, 2, 3, etc.), and so on
And (3) node marking:
naming the nodes in the energy flow structure or energy consumption organization structure by letters or underlines, dot numbers and the like
The node data statistical mode follows the following rules:
MONTH1, which represents reading the data of the MONTH1 of the year of the node, and is followed by any MONTH number, which represents reading the data of the MONTH specified by the node in the year
Season1 shows reading the data of the node in the 1 st quarter of the year, and Season can be followed by any number of quarters, showing reading the data of the node in the designated quarter of the year
LastYearMonth 1: data for reading the month1 of the last year of the node is shown, and the LastYearMonth is followed by any month number for reading the data of the month specified by the last year of the node
EndOfThisMonth: representing the reading of all month statistics of the node from this year to the current month
LastMonth: data representing last month of reading the node
THISEYEAR: representing the data of reading the node all year round this year
LastYear means to read the data of the node for the whole year
(5) The user interface layer is an application equipment interface facing to a service object and comprises a data configuration client, an energy monitoring subsystem, an energy statistical analysis subsystem, a web end of an energy report subsystem and a mobile end; the user can access each application subsystem through an office computer, a notebook computer, a large screen splicing screen, mobile terminal equipment and the like. The method comprises the steps that a data configuration client side is developed by adopting a WinForm development technology under a Net platform, an energy monitoring and energy statistical analysis subsystem system and an energy report subsystem system are developed by adopting a Net Aspx.Net development framework, Echarts graphical display control is used for displaying energy flow distribution, statistical analysis, energy prediction, energy trend display and the like of energy, and GridView and DataGrid controls of Aspx.net are used for displaying statistical reports of energy data and energy consumption data. The mobile terminal adopts a React to develop an H5 website, and a user can visit the H5 website through a mobile terminal browser to view energy data and statistical data.
(6) The service object layer is a user to which the system is finally oriented, and comprises users of a power energy production department, users of a power energy use department and the like.
According to the embodiment, through flexible design, data storage, data display and report display can be carried out from data acquisition, and custom configuration can be carried out in a configuration mode, so that multiple energy sources can be configured and acquired in a unified mode, various energy flow structures and organization structures can be flexibly configured, and the use condition of the energy sources can be displayed through different visual angles.
Various modifications and variations of the present invention may be made by those skilled in the art, and they are still within the scope of the present patent invention provided they are within the scope of the claims and their equivalents.
What is not described in detail in the specification is prior art that is well known to those skilled in the art.
Claims (12)
1. A multi-energy information management system based on a time sequence database is characterized in that: comprises an infrastructure layer, a data acquisition layer, a data storage layer, a business application layer, a user interface layer and a service object layer which are arranged from bottom to top, the infrastructure layer comprises an application deployment server, a data acquisition server, a database server, a storage device, a network device and an operating system, the data acquisition layer comprises a data configuration subsystem, a data acquisition subsystem and a manual data input module, the data storage layer comprises energy collection data, energy statistical data, energy flow structure data and energy consumption organization data, the service application layer comprises an energy statistic analysis subsystem, an energy operation monitoring subsystem, an energy information issuing subsystem and a data reporting subsystem, the user interface layer comprises a web end and a mobile end of the energy information management system, and the service object layer comprises a power energy production department and a power energy use department.
2. The system according to claim 1, wherein the system comprises: the application deployment Server and the data acquisition Server adopt a Windows Server2008 operating system, the time sequence database adopts a workflow historian, and the database Server adopts Oracle.
3. The system according to claim 1, wherein the system comprises: the data configuration subsystem can configure data acquisition tasks of different energy types, required acquisition point positions, energy types corresponding to the point positions, Historian labels, energy consumption multiplying power, upper and lower limits and energy units, and reserve decimal point digit configuration items, wherein the configurable content of the data acquisition tasks comprises acquisition names, Historian data sources and acquisition periods, and the acquisition periods comprise seconds, minutes, hours, shifts, days, half months, quarters, half years and years.
4. The system according to claim 1, wherein the system comprises: the data configuration subsystem can configure energy flow direction distribution structures with different energy types according to a tree structure mode, or configure energy consumption use organization hierarchy structures of different organizations and departments in the tree structure mode, each node on the tree structure can refer to one or more specific energy meter data, four-way operation is carried out on the multiple meter data in a formula calculation mode, and an operation result is used as the energy data of the node, or four-way operation is carried out by referring to nodes of other energy flow structures or other energy consumption organization structures.
5. The system according to claim 1, wherein the system comprises: the data acquisition subsystem can periodically read data from a Historian database according to configured data acquisition tasks and acquisition point positions, write the data into an energy source database, enter acquisition failure tasks into an acquisition supplementing queue, periodically start an acquisition supplementing program to supplement the acquisition tasks in the acquisition supplementing queue, periodically start an abnormality checking program to check whether the acquired energy data contain abnormal data, wherein the abnormal data contain four conditions of acquisition data being empty, excessive acquisition data, negative acquisition data and 0 acquisition data, and mark and process the abnormal data.
6. The system according to claim 1, wherein the system comprises: the data storage layer comprises energy collection data, energy statistical data, energy flow structure data and energy consumption organization data, related data are stored in an Oracle database, and the naming of the table of the Oracle database follows the following rules:
(a) storing data of the configuration class by using a table at the beginning of JC _ for storing configured acquisition tasks, acquisition point data, energy flow structures, organizational structures and energy consumption calculation formulas;
(b) storing the collected data, the energy consumption calculation result data and the statistical result data of various reports in a table at the head of SC _ A;
(c) the table beginning with XT _ stores system user information and user right information data.
7. The system according to claim 1, wherein the system comprises: the manual data input module can input energy consumption data in a manual mode, and the manual data input module inputs instrument data which cannot be acquired through an automatic acquisition task and energy statistics related signature data, production data, plan indexes and assessment index data.
8. The system according to claim 1, wherein the system comprises: the data configuration client of the user interface layer is developed by adopting a WinForm development technology under a Net platform, energy monitoring, energy statistical analysis and an energy report subsystem system are developed by adopting a Net Aspx.Net development framework, Echarts graphical display controls are used for displaying energy flow distribution, statistical analysis, energy prediction, energy trend display and the like of energy, GridView and DataGrid controls of Aspx.net are used for displaying statistical reports of energy data and energy consumption data, a mobile terminal adopts a React development H5 website, and a user accesses the H5 website through a mobile terminal browser to view the energy data and the statistical data.
9. The system according to claim 1, wherein the system comprises: the service application layer integrates multiple application functions of the system, the energy statistical analysis subsystem displays the data of the acquisition point position reading meter and the energy consumption data of various energy types, performs trend analysis on the reading and the energy consumption, corrects the energy data, can display the flow direction and distribution of energy of different energy types according to the energy flow structure, and displays the energy use condition of each organization according to the organization structure.
10. The system according to claim 1, wherein the system comprises: the energy operation monitoring subsystem can monitor the energy quality, the energy quality data comprises voltage, current, vacuum pressure, air pressure, steam pressure, natural gas and the like, the energy quality data can be analyzed and judged through the system, the qualification rate and the rejection rate of the daily morning, noon, evening shift, first-second-third-fourth-fifth-shift, monthly morning, noon, evening shift and first-second-third-shift are counted, and the use efficiency and the conversion efficiency of the reaction energy are reflected by calculating the air-pressure electric ratio, the boiler steam-gas ratio and the power factor index data of each day, each shift and each month.
11. The system according to claim 1, wherein the system comprises: the data report subsystem can customize various types of statistical reports in a configurable mode, the output format of the report is Excel, Excel cell display data can be configured through a configuration file, association is established between the configuration file and nodes in an energy flow structure and an energy consumption organization structure, and node data in the energy flow structure or the energy consumption organization structure are automatically read and written into the Excel cell when the report is generated.
12. The system according to claim 11, wherein the system comprises: the configuration of the cells follows the following rules:
ITEM cell content description node label, cell column (A, B, C, D, etc.), cell row (1, 2, 3, etc.), and so on
And (3) node marking:
the node data statistics mode of naming the nodes in the energy flow structure or the energy consumption organization structure by letters or underlines, point numbers and the like follows the following rules:
(1) MONTH1, which indicates reading the data of the MONTH1 of the current year of the node, and the MONTH can be followed by any MONTH number, which indicates reading the data of the MONTH specified by the current year of the node;
(2) season1, which is used for reading the data of the 1 st quarter of the current year of the node, and can be followed by any number of quarters, which is used for reading the data of the specified quarter of the current year of the node;
(3) LastYearMonth 1: data representing the last 1 month of the year of reading the node; LastYearMonth may be followed by any month number indicating that the data of the month specified in the last year of the node is read;
(4) EndOfThisMonth: representing reading all month statistics of the node from this year to the current month;
(5) LastMonth: indicating reading the data of the last month of the node;
(6) THISEYEAR: representing the data of the node read in the whole year of the current year;
(7) LastYear represents the data read for the node for the last year and the whole year.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111292270.0A CN114036206A (en) | 2021-11-03 | 2021-11-03 | Multi-energy information management system based on time sequence database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111292270.0A CN114036206A (en) | 2021-11-03 | 2021-11-03 | Multi-energy information management system based on time sequence database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114036206A true CN114036206A (en) | 2022-02-11 |
Family
ID=80136106
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111292270.0A Pending CN114036206A (en) | 2021-11-03 | 2021-11-03 | Multi-energy information management system based on time sequence database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114036206A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116109096A (en) * | 2023-02-15 | 2023-05-12 | 广州智慧能源服务有限公司 | Intelligent energy data acquisition system and method based on Internet of things |
| CN117132246A (en) * | 2023-10-27 | 2023-11-28 | 安联奇智(安徽)科技有限公司 | Energy consumption statistical system, method, equipment and medium of flexible production line |
| CN117763484A (en) * | 2024-02-21 | 2024-03-26 | 新奥数能科技有限公司 | Energy use abnormality diagnosis method and device based on enterprise energy use space |
-
2021
- 2021-11-03 CN CN202111292270.0A patent/CN114036206A/en active Pending
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116109096A (en) * | 2023-02-15 | 2023-05-12 | 广州智慧能源服务有限公司 | Intelligent energy data acquisition system and method based on Internet of things |
| CN116109096B (en) * | 2023-02-15 | 2023-08-15 | 广州智慧能源服务有限公司 | Intelligent energy data acquisition system and method based on Internet of things |
| CN117132246A (en) * | 2023-10-27 | 2023-11-28 | 安联奇智(安徽)科技有限公司 | Energy consumption statistical system, method, equipment and medium of flexible production line |
| CN117132246B (en) * | 2023-10-27 | 2024-02-06 | 安联奇智(安徽)科技有限公司 | Energy consumption statistical system, method, equipment and medium of flexible production line |
| CN117763484A (en) * | 2024-02-21 | 2024-03-26 | 新奥数能科技有限公司 | Energy use abnormality diagnosis method and device based on enterprise energy use space |
| CN117763484B (en) * | 2024-02-21 | 2024-05-14 | 新奥数能科技有限公司 | Energy use abnormality diagnosis method and device based on enterprise energy use space |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114036206A (en) | Multi-energy information management system based on time sequence database | |
| WO2021135177A1 (en) | Construction method and apparatus for energy data warehouse system | |
| CN111291076B (en) | Abnormal water use monitoring alarm system based on big data and construction method thereof | |
| US20150073608A1 (en) | System and method for managing and monitoring renewable energy power generation | |
| CN103745322A (en) | Province-city secondary system integrated comprehensive monitoring and process management system in power dispatching and implementation method for system | |
| CN104777813A (en) | Comprehensive meteorological observation operation monitoring system and monitoring method thereof | |
| CN104850934A (en) | Meteorological device maintenance and repair management system | |
| CN104898618A (en) | Grain and oil processing production line energy management system and management method | |
| US11063998B2 (en) | System and method for energy management information system reliability assurance | |
| CN112037083B (en) | Power plant production data reporting system | |
| CN109359900A (en) | A kind of inspection management platform | |
| CN108470218A (en) | Public utility operation management system | |
| CN115017214B (en) | Hydropower station auxiliary equipment operation state analysis early warning method, device and storage medium | |
| CN115392742A (en) | Energy consumption integrated management system | |
| CN109784614A (en) | Thermal power plant produces mobile management system | |
| CN108460541A (en) | Harbour intelligence maintenance system and method | |
| CN102592175A (en) | Power system line loss management analysis method and system | |
| CN112700082A (en) | Substation gateway metering big data analysis and online monitoring system and method | |
| CN117495266A (en) | Intelligent digital comprehensive energy production operation management decision-making system and method | |
| CN110660461B (en) | Cross-platform medical data information uploading system based on artificial intelligence | |
| CN116821101A (en) | Data integration platform construction system and method based on lithium battery industry | |
| CN114049036A (en) | Data computing platform, method, device and storage medium | |
| CN106447241A (en) | Power generation production and operation control platform | |
| CN111625616A (en) | Enterprise-level data management system capable of realizing mass storage | |
| Drożdż et al. | The use of IT systems in the power industry on the example of the Polish Electricity Distribution System Operator |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |