CN109960705B - Multi-source data access and display method for power grid automation system - Google Patents
Multi-source data access and display method for power grid automation system Download PDFInfo
- Publication number
- CN109960705B CN109960705B CN201910031018.0A CN201910031018A CN109960705B CN 109960705 B CN109960705 B CN 109960705B CN 201910031018 A CN201910031018 A CN 201910031018A CN 109960705 B CN109960705 B CN 109960705B
- Authority
- CN
- China
- Prior art keywords
- source
- measurement
- data
- automation system
- power grid
- 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.)
- Active
Links
Images
Classifications
-
- 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—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
Abstract
The invention relates to a multi-source data access and display method for a power grid automation system, wherein the multi-source data integrity of the power grid automation system is modeled; the method comprises the steps that multisource data of a power grid automation system are accessed into a data processing service, and the data processing service adds multisource information to measured data through a loaded data source coding table and measured multisource source table information; publishing multi-source data in a power grid automation system; displaying default sources of multi-source data; switching multi-source data to display; and displaying the multi-source data binding source. The invention solves the problems that multi-source data from different departments and different field service systems can not be processed by point multi-source and station multi-source in the prior art, and the defects that the multi-source data only stores the optimal value, does not store all source data and can not ensure the integrity of the multi-source data in the prior art; the human-computer interface is more flexible in displaying multi-source data.
Description
Technical Field
The invention belongs to the technical field of power grid automation management, and particularly relates to a multi-source data access and display method for a power grid automation system.
Background
In recent years, with the scale of the power grid model being continuously enlarged, data limited to the power system cannot meet the development requirement, such as new energy related data, such as meteorological data, water conservancy data and weather forecast data, are continuously connected to the power grid automation system. With the expansion of data models and the difference of data sources, the same data may come from different acquisition terminals and different field service systems. When the interface is displayed, the requirement of viewing data from different data sources also exists.
A multi-source processing method in a traditional power grid automation system mainly has a multi-source and station multi-source mode. The point multi-source and station multi-source are mainly characterized in that a communication channel is divided into multiple source links in the aspect of data access, optimal data are stored through quality code comparison, and the optimal data are displayed on a human-computer interface. Therefore, the point multi-source and station multi-source mode cannot meet the requirements of system development in the aspects of data access and man-machine display.
Disclosure of Invention
In order to solve the technical problems, the invention provides a multi-source data access and display method for a power grid automation system, which solves the problems of integrity of multi-source data, access of the multi-source data, switching display and binding display of the multi-source data. The technical scheme adopted by the invention is as follows:
the multi-source data access and display method of the power grid automation system comprises the following steps:
step 1, modeling the integrity of multi-source data of a power grid automation system, and respectively setting: a data source coding table, a measurement multi-source table and a measurement table; inputting source information of multi-source data into a data source coding table; creating a record of the measuring information with multiple sources in a measuring multi-source table, and filling a multi-source number value and a set source serial number; then, creating multi-source measurement to the measurement table one by one according to the record data in the measurement multi-source table;
step 2, multi-source data of the power grid automation system are accessed into a data processing service, and the data processing service adds the multi-source information into measurement data through a loaded data source coding table and measurement multi-source table information;
and 3, releasing multi-source data in the power grid automation system, wherein the data releasing service firstly receives the measured data value sent by the data processing service, and directly updates the value into the measurement table through the updating interface. After the updating is finished, releasing data, reading all data from the measuring table, loading the data into a service, and then providing a data acquisition function to the outside in a subscription mode;
step 4, displaying the default source of the multi-source data, reading the set source serial number by a human-computer interface through loading a measurement multi-source table to form a measurement ID, and loading the measurement of the source;
step 5, multi-source data are switched to be displayed, a man-machine interface forms a measurement ID through reading multi-source codes selected by a menu, and the measurement of the source is loaded;
and 6, displaying the bound source of the multi-source data, reading configuration information of each person by a human-computer interface to obtain bound multi-source codes, forming a measurement ID, and loading the measurement of the source.
The invention has the beneficial effects that:
1) the invention completely realizes a complete solution scheme of multi-source data access from modeling, different data sources and multi-source information storage in the power grid automation system, is more perfect in data integrity compared with a method for multi-source and station multi-source in the traditional power grid automation system, and solves the problems that the multi-source and station multi-source in the prior art can not process multi-source data from different departments and different field business systems, and the defects that the multi-source data in the prior art only stores optimal values, does not store all source data and can not ensure the integrity of the multi-source data.
2) The human-computer interface is more flexible in displaying multi-source data. According to the method, different multi-source data can be displayed according to the requirements of users. In the aspect of switching and displaying multi-source data, measurement data from different sources can be conveniently and quickly switched according to data source codes in the human-computer display process. In the aspect of multi-source data binding display, personnel information and multi-source sources are bound, data and information of different sources are displayed for different login personnel, the display requirement of the multi-source data is met, and the defects that the requirement for human-computer switching multi-source display is not supported and the requirement for binding and displaying specific sources of different types of personnel in the prior art are overcome.
Drawings
FIG. 1 is a block flow diagram of multi-source data access and presentation of an embodiment of the present invention;
FIG. 2 is a schematic diagram of the composition of measurement IDs in the measurement table.
Detailed Description
Embodiments of the present invention will be described in detail below with reference to the accompanying drawings.
Fig. 1 is a block diagram illustrating a multi-source data accessing and displaying process according to an embodiment of the present invention. The multi-source data access and display method of the power grid automation system comprises the following steps:
step 1, modeling the integrity of multi-source data of a power grid automation system, and respectively setting: data source code table, measurement multi-source table, and measurement table. Inputting source information of multi-source data into a data source coding table; creating a record of the measuring information with multiple sources in a measuring multi-source table, and filling a multi-source number value and a set source serial number; and then, creating multi-source measurement into the measurement table one by one according to the record data in the measurement multi-source table.
In order to more clearly and intuitively reflect the implementation method of the present invention, the following examples respectively illustrate the setting methods of the data source coding table, the measurement multi-source table, and the measurement table.
(1) And setting a data source coding table.
As shown in table 1 below, the data source encoding table includes the following three fields: the source Code, the source Name and the source description Desc are listed through the table, and meanwhile, a source Code field is added to a later table 3 measuring table to indicate the measured data source information.
TABLE 1 data Source coding Table
(2) Setting a measurement multi-source table.
As shown in Table 2 below, the metrology multi-source table includes the following fields: main measurement ID-Meas _ ID, measurement type MeasType, multisource number MultiSourceNum, set source number MultiSouSetOrder, multisource 1 source code MultiSouCode1, … …, multisource 512 source code MultiSouCode 512. The measurement multi-source table is used for dynamically creating multi-source measurement information into the following table 3 measurement table, and the quantity of the created multi-source measurement is confirmed by the number of the multiple sources, so that the multi-source measurement and the main measurement are in the measurement table, and the human-computer interface can subscribe all the measurement information at the same time.
TABLE 2 Measure Multi-Source Table
(3) And setting a measuring table.
As shown in table 3 below, the measurement table includes four fields: measurement ID, measurement Name, measurement Time, and measurement Data. The index measurement ID in the measurement table is a 64-bit unsigned integer. Fig. 2 is a schematic diagram showing the composition of the measurement ID in the measurement table. The measurement ID is composed of a 16-bit data type + 16-bit number + 8-bit area number + 24-bit serial number. The data type represents the type of measurement (such as breaker type measurement, type value 407, knife switch type measurement, type value 408), the number represents a data type attribute number, the area number represents the area number of the measurement source, and the serial number represents the number from 0. When the multi-source measurement is established in the measurement multi-source table, the number bit field in the main measurement ID is assigned to the source code, and then the corresponding multiple measurement IDs can be dynamically generated. The measurement name is formed by splicing a main measurement name and a multi-source name to form the measurement name.
TABLE 3 measuring table
In the above three tables, short indicates a signed short integer data type in the C/C + +/Java language.
string represents a string type in the C + +/Java language. The length is variable.
unsigned long represents the unsigned long shaping data type in the C/C + +/Java language.
int denotes signed integer data types in the C/C + +/Java language.
float represents a signed floating point data type in the C/C + +/Java language.
The PK Primary Key is called a Primary Key. The primary key is represented in the database and is the only primary attribute column of a table. The same meaning here indicates the primary key attribute column of a table.
And 2, accessing the multi-source data of the power grid automation system to a data processing service. And aiming at each multi-source data, the data are respectively accessed through corresponding preposed acquisition program modules.
For example, the multi-source data of the power station is accessed through the front-end acquisition program module 1, the multi-source data of the water conservancy bureau is accessed through the front-end acquisition program module 2, the multi-source data of the meteorological bureau is accessed through the front-end acquisition program module 3, the multi-source data of the weather forecast is accessed through the front-end acquisition program module 4, and the multi-source data of other sources are accessed simultaneously. The data processing service mainly has the functions of receiving the measurement data sent by different prepositive collection, adding the multi-source information into the measurement data through the loaded data source coding table and the measurement multi-source table information, and directly sending the measurement data to the data issuing service for issuing and using after the attachment is completed.
And step 3, releasing the multi-source data in the power grid automation system. The multi-source data measurement and the common measurement are both placed in the data distribution service and provide data to the outside. The data issuing service firstly receives the measured data value sent by the data processing service, and directly updates the value into the measurement table through the updating interface. After the updating is completed, the data is published, all the data is read from the measurement table (table 3) and loaded into the service, and then a data acquisition function is provided for the outside in a subscription mode.
And 4, displaying the default source of the multi-source data. The man-machine interface reads the set source serial number by loading the measurement multi-source table to form a measurement ID and loads the measurement of the source.
And 5, switching multi-source data to display. The man-machine interface reads the multi-source codes selected by the menu to form a measurement ID, and loads the measurement of the source. The specific method comprises the following steps:
when the human-computer interface displays the multi-source measurement data, the data of the measurement multi-source table (table 2) is loaded firstly, and the prior display is carried out according to the current 'set source serial number' in the measurement multi-source table. If a source of a measurement default display needs to be modified, only the field value of the "set source number" in the measurement multi-source table needs to be filled into the corresponding source number.
When multi-source measurement is switched, a switching menu is provided according to the number of the multi-source codes provided by the data source code table (table 1), when an operator switches to a designated source, the human-computer interface generates a corresponding multi-source measurement ID according to a multi-source measurement code creation rule, and after the ID is generated, the human-computer interface subscribes corresponding data in the measurement table (table 3) and provides the data for the human-computer interface to display multi-sources.
When different types of personnel bind and display specific source requirements, the personnel types and the multi-source codes can be bound and stored in a configuration file, when the different types of personnel log in a human-computer interface, a human-computer can obtain the source codes which are preferentially displayed according to the configuration file, and then the source codes are analyzed into specific measurement source serial numbers according to a measurement multi-source list, so that the requirements of the different types of personnel for binding and displaying the specific sources are realized.
And 6, displaying the multi-source data binding source. The human-computer interface obtains the bound multi-source codes by reading the configuration information of each person to form a measurement ID, and the measurement of the source is loaded.
Claims (5)
1. The multi-source data access and display method of the power grid automation system is characterized by comprising the following steps:
step 1, modeling the integrity of multi-source data of a power grid automation system, and respectively setting: a data source coding table, a measurement multi-source table and a measurement table; inputting source information of multi-source data into a data source coding table; creating a record of the measuring information with multiple sources in a measuring multi-source table, and filling a multi-source number value and a set source serial number; then, creating multi-source measurement to the measurement table one by one according to the record data in the measurement multi-source table;
step 2, multi-source data of the power grid automation system are accessed into a data processing service, and the data processing service adds the multi-source information into measurement data through a loaded data source coding table and measurement multi-source table information;
step 3, publishing multi-source data in the power grid automation system, wherein the data publishing service firstly receives a measured data value sent by the data processing service, directly updates the value into a measurement table through an updating interface, publishes the data after the updating is finished, reads all data from the measurement table and loads the data into the service, and then provides a data acquisition function to the outside through a subscription mode;
step 4, displaying the default source of the multi-source data, reading the set source serial number by a human-computer interface through loading a measurement multi-source table to form a measurement ID, and loading the measurement of the source;
step 5, multi-source data are switched to be displayed, a man-machine interface forms a measurement ID through reading multi-source codes selected by a menu, and the measurement of the source is loaded;
step 6, displaying the bound source of the multi-source data, wherein the human-computer interface obtains the bound multi-source codes by reading the configuration information of each person to form a measurement ID, and loading the measurement of the source;
the specific steps of the multi-source data switching multi-source display in the step 5 are as follows:
when the human-computer interface displays the multi-source measurement data, loading the measurement multi-source list data, preferentially displaying according to the currently set source serial number in the measurement multi-source list, and if a certain measurement default display source needs to be modified, only filling the set source serial number field value in the measurement multi-source list into the corresponding source serial number;
when multi-source measurement is switched, a switching menu is provided according to the number of multi-source codes provided by the data source code table, when an operator switches to a specified source, the man-machine interface generates a corresponding multi-source measurement ID according to a multi-source measurement code creation rule, and after the ID is generated, the man-machine interface subscribes corresponding data in the measurement table and provides the data for the man-machine interface to display multi-sources;
when different types of personnel are required to bind and display specific sources, the personnel types and the multi-source codes can be bound and stored in a configuration file, when the different types of personnel log in a human-computer interface, a human-computer can obtain the source codes which are preferentially displayed according to the configuration file, and the source codes are analyzed into specific measurement source serial numbers according to a measurement multi-source list, so that the specific sources can be bound and displayed by the different types of personnel.
2. The grid automation system multi-source data access and display method according to claim 1, wherein the data source code table of step 1 includes three fields: the source code, the source name and the source description are used for listing all data sources which can be accessed by the power grid automation system and the source codes thereof;
the measurement multisource source table includes the following fields: the method comprises the following steps of main measurement, measurement types, multi-source numbers, set source serial numbers, multi-source 1 source codes, … … and multi-source 512 source codes, wherein a measurement multi-source table is used for dynamically creating multi-source measurement information into a measurement table, and the quantity of the created multi-source measurement is confirmed by the multi-source numbers;
the measurement table includes four fields: measurement ID, measurement name, measurement time and measurement value.
3. The grid automation system multi-source data access and display method as claimed in claim 2, wherein the measurement ID is a 64-bit unsigned integer composed of a 16-bit data type + 16-bit number + 8-bit area number + 24-bit serial number, the data type represents a measurement type, the number represents a data type attribute number, the area number represents a measurement source area number, and the serial number represents a number starting from 0.
4. The grid automation system multi-source data access and display method as claimed in claim 3, wherein when a multi-source measurement is created from a measurement multi-source table, a number bit field in a main measurement ID is assigned to a source code to dynamically generate a plurality of corresponding measurement IDs, and measurement names are formed by splicing a main measurement name and multi-source names to form measurement names.
5. The power grid automation system multi-source data accessing and displaying method according to claim 4, wherein the specific method for accessing the power grid automation system multi-source data to the data processing service in the step 2 is as follows: and aiming at each multi-source data, the data are respectively accessed through corresponding preposed acquisition program modules.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910031018.0A CN109960705B (en) | 2019-01-14 | 2019-01-14 | Multi-source data access and display method for power grid automation system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910031018.0A CN109960705B (en) | 2019-01-14 | 2019-01-14 | Multi-source data access and display method for power grid automation system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109960705A CN109960705A (en) | 2019-07-02 |
| CN109960705B true CN109960705B (en) | 2021-01-26 |
Family
ID=67023497
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910031018.0A Active CN109960705B (en) | 2019-01-14 | 2019-01-14 | Multi-source data access and display method for power grid automation system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109960705B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111177268B (en) * | 2019-12-30 | 2023-07-07 | 积成电子股份有限公司 | Implementation method of custom real-time library of power monitoring system |
| CN112182073A (en) * | 2020-09-27 | 2021-01-05 | 珠海许继芝电网自动化有限公司 | Electric power measurement data display method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107066482A (en) * | 2016-12-21 | 2017-08-18 | 晶赞广告（上海）有限公司 | Multi-source data monitoring method, device and terminal |
| CN107066499A (en) * | 2016-12-30 | 2017-08-18 | 江苏瑞中数据股份有限公司 | The data query method of multi-source data management and visualization system is stored towards isomery |
| CN107463709A (en) * | 2017-08-21 | 2017-12-12 | 北京奇艺世纪科技有限公司 | A kind of ETL processing method and processing devices based on multi-data source |
| CN108021670A (en) * | 2017-12-06 | 2018-05-11 | 中国南方航空股份有限公司 | Multi-source heterogeneous data fusion system and method |
| CN108363746A (en) * | 2018-01-26 | 2018-08-03 | 福建星瑞格软件有限公司 | A kind of unified SQL query system for supporting multi-source heterogeneous data |
| CN108804613A (en) * | 2018-05-30 | 2018-11-13 | 国网山东省电力公司经济技术研究院 | A kind of Various database real time fusion system and its fusion method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10037331B2 (en) * | 2015-01-30 | 2018-07-31 | Splunk Inc. | Source type management |
-
2019
- 2019-01-14 CN CN201910031018.0A patent/CN109960705B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107066482A (en) * | 2016-12-21 | 2017-08-18 | 晶赞广告（上海）有限公司 | Multi-source data monitoring method, device and terminal |
| CN107066499A (en) * | 2016-12-30 | 2017-08-18 | 江苏瑞中数据股份有限公司 | The data query method of multi-source data management and visualization system is stored towards isomery |
| CN107463709A (en) * | 2017-08-21 | 2017-12-12 | 北京奇艺世纪科技有限公司 | A kind of ETL processing method and processing devices based on multi-data source |
| CN108021670A (en) * | 2017-12-06 | 2018-05-11 | 中国南方航空股份有限公司 | Multi-source heterogeneous data fusion system and method |
| CN108363746A (en) * | 2018-01-26 | 2018-08-03 | 福建星瑞格软件有限公司 | A kind of unified SQL query system for supporting multi-source heterogeneous data |
| CN108804613A (en) * | 2018-05-30 | 2018-11-13 | 国网山东省电力公司经济技术研究院 | A kind of Various database real time fusion system and its fusion method |
Non-Patent Citations (1)
| Title |
|---|
| 基于多源数据的空气质量分析及可视化;陈晨;《中国优秀硕士学位论文全文数据库 工程科技Ⅰ辑》;20180915(第9期);B027-333 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109960705A (en) | 2019-07-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101988961B (en) | Geographic location data collecting system | |
| CN107729003A (en) | Automatic generation method, device and the electronic equipment of code | |
| CN106708480A (en) | Management platform realization method and apparatus | |
| CN109960705B (en) | Multi-source data access and display method for power grid automation system | |
| CN112132327A (en) | Multi-source data fusion-oriented intelligent planning system for power distribution network | |
| CN111260413A (en) | Vector graph-based rapid calculation method for construction cost of power main network engineering | |
| CN110543303A (en) | Visual business platform | |
| CN116680648A (en) | Service fusion data generation method and system for digital twin city | |
| CN111506997A (en) | Power engineering quantity calculation method based on BIM | |
| CN111597596B (en) | Automatic construction drawing method and device based on signal system | |
| CN105305619A (en) | Method and device for three-remote configuration based on distribution automation | |
| CN110096687A (en) | Substation equipment summary of materials production method based on Three-dimensional Design Software | |
| CN111984673A (en) | Fuzzy retrieval method and device for tree structure of power grid electric energy metering system | |
| CN112148672A (en) | Rapid reservoir building method and system for land survey | |
| CN101635711B (en) | Programmable character communication method | |
| CN104317879B (en) | A kind of telemetry real-time exhibition method based on real-time data base | |
| CN111814292B (en) | BIM technology-based automatic drawing method for electrical panel cabinet | |
| CN112685863A (en) | Simulation system for cable laying of transformer substation | |
| CN108647320B (en) | GIS-based power distribution automation master station system | |
| CN111626639A (en) | Power grid equipment state and data management system | |
| CN110737980A (en) | Electrical design system and electrical design method | |
| CN110457663A (en) | Display control method, system and the terminal device of branch's subitem inventory page | |
| CN103632233A (en) | Electrical logging specialty practical management system for power enterprises | |
| JP2010182215A (en) | Time series map data management system, terminal device, time series map data management method, and time series map data management program | |
| CN102209278A (en) | Program code generation method, tightly combined with program production and based on new media business |
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 | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Chang Xinzheng Inventor after: Yan Zhonghua Inventor after: Zhang Shuai Inventor after: Zhang Tao Inventor after: Liu Xinhui Inventor after: Kong Dedi Inventor before: Chang Xinzheng Inventor before: Zhang Shuai Inventor before: Zhang Tao Inventor before: Liu Xinhui Inventor before: Kong Dedi |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20230113 Address after: 211106 No.19, Suyuan Avenue, Jiangning Economic and Technological Development Zone, Nanjing City, Jiangsu Province Patentee after: JICHENG SOFTWARE CO.,LTD. Address before: No.1677 Kehang Road, Jinan, Shandong 250100 Patentee before: INTEGRATED ELECTRONIC SYSTEMS LAB Co.,Ltd. |