CN114254906A - Power dispatching report query method - Google Patents
Power dispatching report query method Download PDFInfo
- Publication number
- CN114254906A CN114254906A CN202111537426.7A CN202111537426A CN114254906A CN 114254906 A CN114254906 A CN 114254906A CN 202111537426 A CN202111537426 A CN 202111537426A CN 114254906 A CN114254906 A CN 114254906A
- Authority
- CN
- China
- Prior art keywords
- telemetry
- data
- telemetering
- effective
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000005070 sampling Methods 0.000 claims description 13
- 238000005259 measurement Methods 0.000 description 4
- 230000008569 process Effects 0.000 description 3
- 238000012216 screening Methods 0.000 description 3
- 238000013500 data storage Methods 0.000 description 2
- 230000007547 defect Effects 0.000 description 2
- 230000014509 gene expression Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
-
- 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/242—Query formulation
-
- 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/29—Geographical information databases
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Tourism & Hospitality (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Health & Medical Sciences (AREA)
- Water Supply & Treatment (AREA)
- Development Economics (AREA)
- Public Health (AREA)
- Game Theory and Decision Science (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Educational Administration (AREA)
- Remote Sensing (AREA)
- Mathematical Physics (AREA)
- Primary Health Care (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Remote Monitoring And Control Of Power-Distribution Networks (AREA)
Abstract
The invention discloses a power dispatching report query method, which comprises the following steps: step 1: analyzing and translating the telemetering data uploaded by the transformer substation in advance, and correspondingly storing the attribute of the analyzed effective telemetering data and the telemetering ID number of the effective telemetering data together to form a telemetering analysis library; step 2: storing the analyzed effective telemetering data in a database, and associating the effective telemetering data with the telemetering ID; and step 3: and during query, acquiring a corresponding telemetry ID according to the attribute of the effective telemetry data in the telemetry analysis library, and searching the effective telemetry data associated with the telemetry ID in the database according to the telemetry ID. The invention has the advantages that: the stored telemetering data attributes are few and are all effective data, so that time delay caused by redundant data attributes during data query can be reduced, and the speed and accuracy of data query are improved.
Description
Technical Field
The invention relates to the field of power grid data query management, in particular to a power dispatching report query method.
Background
With the wide application of the dispatching automation system, the scale of the electric power telemetering data is rapidly increased, and the data requirements of each service part of the electric power company are more and more, so that how to quickly find out the data which meets the actual requirements of users from a large amount of electric power telemetering data is becoming a research hotspot.
The problems of more redundant data and more data redundancy attributes exist in current power data query, and therefore the data query response speed is low. The problem of more redundant data is mainly that a large number of data point numbers which are not cleared or stand-by data points exist in a dispatching automation system in time; the problem of multiple data redundancy attributes is mainly that each data is associated with a large number of attributes such as active, reactive, voltage and the like, but only two or three of the attributes are used in the process of inquiring a data packet actually, so that the data storage inquiry in the prior art cannot meet the requirement of quickly inquiring a power scheduling report.
Disclosure of Invention
The invention aims to overcome the defects of the prior art and provides a novel power scheduling report query method which is used for generating a special telemetering analysis library and realizing the quick search of telemetering data according to the database.
In order to achieve the purpose, the invention adopts the technical scheme that: a power dispatching report query method comprises the following steps:
step 1: analyzing and translating the telemetering data uploaded by the transformer substation in advance, and correspondingly storing the attribute of the analyzed effective telemetering data and the telemetering ID number of the effective telemetering data together to form a telemetering analysis library;
step 2: storing the analyzed effective telemetering data in a database, and associating the effective telemetering data with the telemetering ID;
and step 3: and during query, acquiring a corresponding telemetry ID according to the attribute of the effective telemetry data in the telemetry analysis library, and searching the effective telemetry data associated with the telemetry ID in the database according to the telemetry ID.
In step 1, effective telemetry is screened in a preposed telemetry sampling table of the power dispatching automation system by using a preposed telemetry point number, and then the name of the effective telemetry is analyzed and translated into the attribute of effective telemetry data and matched with the corresponding telemetry ID number.
Attributes of active telemetry include substation name, voltage class, equipment type, telemetry type.
In step 2, the telemetry ID of the valid telemetry data is stored with the database storage location association of the valid telemetry data to form a telemetry sample definition table.
And during query, querying the position of the valid telemetry data stored in the database in the telemetry sampling definition table according to the valid telemetry ID, and then querying and acquiring the corresponding valid telemetry data according to the storage position.
The invention has the advantages that: the stored telemetering data attributes are few and are all effective data, so that time delay caused by redundant data attributes during data query can be reduced, and the speed and accuracy of data query are improved; the query mode is used for performing query matching in a mode of attribute-ID-storage position, and the query is quick; the method is simple, convenient and quick to implement, and can quickly query effective telemetering data according to attribute information after data processing, matching and association are carried out on a database, a preposed telemetering definition table and a telemetering sampling definition table in the power dispatching system, so that the aim of quick query is fulfilled.
Drawings
The contents of the expressions in the various figures of the present specification and the labels in the figures are briefly described as follows:
FIG. 1 is a representation of a preamble telemetry definition table and telemetry sample definition of the present invention;
FIG. 2 is a flow chart of a data query method according to the present invention.
Detailed Description
The following description of preferred embodiments of the invention will be made in further detail with reference to the accompanying drawings.
The application mainly provides a new method for inquiring the data of the power dispatching report, and mainly relates to a method for inquiring and acquiring the remote measuring data of the power dispatching. This application mainly is solved the inquiry of power scheduling telemetering measurement data among the prior art too loaded down with trivial details and because the too slow defect of inquiry speed that causes of attribute, through providing dedicated database and specific attribute to the realization is fast obtains corresponding telemetering measurement data according to telemetering measurement attribute, and concrete scheme is as follows:
the query method of the electric power telemetry data comprises two parts: a telemetry analysis library and a database generation part; and a data query portion.
The telemetry resolution library and database generation part comprises:
the method comprises the steps of analyzing and translating telemetering data uploaded by a transformer substation in advance, screening effective telemetering from the telemetering data uploaded by the power dispatching automation system by utilizing a front telemetering point number, analyzing and translating the name of the effective telemetering into the attribute of the effective telemetering data, and matching the attribute with a corresponding telemetering ID number. Correspondingly storing the attribute of the analyzed effective telemetering data and the telemetering ID number of the effective telemetering data together to form a telemetering analysis library;
in the prior art, the query time is influenced by the fact that more attributes of uploaded telemetry data are directly queried by using the uploaded telemetry data, and meanwhile, a lot of invalid telemetry data exist in the telemetry data, so that the telemetry attributes set by the method are the telemetry data required by query, and the valid telemetry attributes comprise the names of the transformer stations, the voltage levels, the equipment types and the telemetry types. As the telemetering data can be uploaded to the power dispatching system, for the purpose of realizing the query of the application, the uploaded telemetering data is screened, and screening is carried out by using the preposed point number, as shown in fig. 2, the preposed telemetering definition table is read, whether the telemetering data is valid is judged by using the preposed point number, the valid telemetering data is reserved, otherwise, the telemetering data is discarded, and the specific judgment mode is that the preposed point number of the telemetering data is more than 1, the telemetering data is valid, otherwise, the telemetering data is discarded. The prefix point number is an attribute of the telemetry data that indicates the telemetry data is in the set of telemetry data, and is fixed. The pre-definition table is a table of a database, and comprises a plurality of attributes, wherein the four attributes are available, and the parsing is to extract the four attributes. And then analyzing the attribute corresponding to the telemetry name through a front telemetry definition table: the method comprises the steps of storing the telemetry ID and the attribute matching mode of the telemetry ID to form a telemetry analysis library, then storing effective telemetry data in a database, and correspondingly storing the stored position and the telemetry ID in a telemetry sampling definition table in a matching mode, thereby forming a telemetry sampling definition table with the telemetry ID corresponding to the telemetry data storage position.
Storing the analyzed effective telemetering data in a database, and associating the effective telemetering data with the telemetering ID; storing the telemetry ID of the valid telemetry data in association with a database storage location of the valid telemetry data forms a telemetry sample definition table. Because the storage position of the effective telemetering data is stored in the telemetering sampling definition table, the corresponding effective telemetering data can be quickly read according to the storage position.
During query, the power dispatching system provides a selectable data search function, a user can input search data according to actual query requirements, can input query attributes and other contents, obtains corresponding telemetering ID according to the attributes of the effective telemetering data in the telemetering analysis library, and then searches the effective telemetering data related to the telemetering ID in the database according to the telemetering ID. The method comprises the steps of adding a retrieval function in the power dispatching system, using a human-computer interaction interface including but not limited to a mouse, a touch screen, a mobile phone terminal and the like as an input end of retrieval data, wherein the supported retrieval data comprise the attribute of telemetry data, inquiring telemetry ID matched with the input attribute data in a telemetry analysis library through the input attribute data, inquiring a storage address of the telemetry data corresponding to the telemetry ID in a telemetry acquisition definition table, reading the telemetry data stored at the address in a database to obtain the data required to be retrieved and inquired, and downloading or exporting, displaying and the like the data. During query, the position of the valid telemetry data stored in the database is mainly queried in the telemetry sampling definition table according to the valid telemetry ID, and then the corresponding valid telemetry data is queried and obtained according to the storage position.
The invention discloses a novel power dispatching report query method. The power dispatching report query method comprises two processes of generating a telemetering analysis library and querying data.
The method comprises the steps of firstly screening effective telemetering in a preposed telemetering sampling table of a dispatching automation system by using a preposed point number, then resolving the name of the effective telemetering into a transformer substation, a voltage grade, an equipment type and a telemetering type, and storing the resolved telemetering characteristics and a telemetering ID number thereof to form a telemetering resolving library.
The query data of the power scheduling report query method comprises the steps of firstly providing selectable query conditions according to contents in a telemetering analysis library, then searching a telemetering ID number in the telemetering analysis library according to the selectable conditions, then searching a database storage position in a telemetering sampling definition table according to the telemetering ID number, and finally reading database data according to the searched storage position.
The method for inquiring the power dispatching report can greatly reduce redundant telemetering data inquiry, avoids inquiring invalid data attributes, further improves the inquiry speed and accuracy of data, and is convenient for power dispatching personnel to make reports.
When the electric power data is inquired, only a front telemetering definition table and a telemetering sampling definition table in a dispatching automation system are needed, the front telemetering definition table is responsible for explaining and translating data uploaded by a transformer substation, and a Chinese name in a data explanation channel table is uploaded by using a front point number. And the telemetry sample definition table is a table for recording the storage position of the telemetry data in a database. As shown in fig. 1, the two tables may be related by telemetry ID number to enable indexing of the data.
The invention firstly utilizes the preposed point number to screen out the effective telemetering data, and abandons the ineffective telemetering data, thereby greatly reducing the searching range of the data. And then, the Chinese name in the prepositive telemetering sampling definition table is analyzed, and the Chinese name is analyzed into four parts, namely a voltage grade, a transformer station name, an equipment name and a telemetering type, so that effective telemetering data attributes can be screened out, and data searching can be directly and rapidly realized. And finally, storing the analyzed telemetering characteristics and the telemetering ID number thereof to form a telemetering analysis library.
The telemetering analysis library provided by the invention contains effective data to be inquired and effective attributes of the data to be inquired. And using the four analyzed characteristics of the remote measurement as selectable query conditions. The power dispatcher can retrieve the valid data and the telemetry attributes thereof according to the provided query conditions.
And searching the ID number of the determined telemetry in a telemetry analysis library according to the determined telemetry characteristics, searching the storage position of the telemetry in the data in a telemetry sampling definition table according to the telemetry ID number, and inquiring and reading the data according to the storage position.
It is clear that the specific implementation of the invention is not restricted to the above-described embodiments, but that various insubstantial modifications of the inventive process concept and technical solutions are within the scope of protection of the invention.
Claims (5)
1. A power dispatching report query method is characterized in that: the method comprises the following steps:
step 1: analyzing and translating the telemetering data uploaded by the transformer substation in advance, and correspondingly storing the attribute of the analyzed effective telemetering data and the telemetering ID number of the effective telemetering data together to form a telemetering analysis library;
step 2: storing the analyzed effective telemetering data in a database, and associating the effective telemetering data with the telemetering ID;
and step 3: and during query, acquiring a corresponding telemetry ID according to the attribute of the effective telemetry data in the telemetry analysis library, and searching the effective telemetry data associated with the telemetry ID in the database according to the telemetry ID.
2. The power scheduling report query method according to claim 1, wherein: in step 1, effective telemetry is screened from telemetry data uploaded in the power dispatching automation system by using a front telemetry point number, and then the name of the effective telemetry is analyzed and translated into the attribute of the effective telemetry data and matched with the corresponding telemetry ID number.
3. The power scheduling report query method according to claim 2, wherein: attributes of active telemetry include substation name, voltage class, equipment type, telemetry type.
4. The power scheduling report query method according to claim 1, wherein: in step 2, the telemetry ID of the valid telemetry data is stored with the database storage location association of the valid telemetry data to form a telemetry sample definition table.
5. The power scheduling report query method of claim 4, wherein: and during query, querying the position of the valid telemetry data stored in the database in the telemetry sampling definition table according to the valid telemetry ID, and then querying and acquiring the corresponding valid telemetry data according to the storage position.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111537426.7A CN114254906A (en) | 2021-12-15 | 2021-12-15 | Power dispatching report query method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111537426.7A CN114254906A (en) | 2021-12-15 | 2021-12-15 | Power dispatching report query method |
Publications (1)
Publication Number | Publication Date |
---|---|
CN114254906A true CN114254906A (en) | 2022-03-29 |
Family
ID=80792518
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202111537426.7A Pending CN114254906A (en) | 2021-12-15 | 2021-12-15 | Power dispatching report query method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN114254906A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN117809657A (en) * | 2024-02-29 | 2024-04-02 | 国网山东省电力公司东营供电公司 | Self-answering intelligent auxiliary telephone robot |
-
2021
- 2021-12-15 CN CN202111537426.7A patent/CN114254906A/en active Pending
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN117809657A (en) * | 2024-02-29 | 2024-04-02 | 国网山东省电力公司东营供电公司 | Self-answering intelligent auxiliary telephone robot |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107330125B (en) | Mass unstructured distribution network data integration method based on knowledge graph technology | |
US9619512B2 (en) | Memory searching system and method, real-time searching system and method, and computer storage medium | |
CN106570105A (en) | Structured processing method for power equipment test report | |
CN107943831B (en) | HBase-based power grid historical data centralized storage method | |
CN104750825A (en) | Intelligent substation SCD document rapid analysis method | |
CN112667697A (en) | Method and device for acquiring real estate information by combining RPA and AI | |
CN114254906A (en) | Power dispatching report query method | |
CN104572978A (en) | User behavior counting method for power scheduling automatic system based on log | |
CN112395716B (en) | Power distribution network topological structure generation method based on multi-source heterogeneous production data | |
CN109189873A (en) | A kind of Meteorological Services big data monitoring analysis system platform | |
CN112445796B (en) | New energy station report generation method | |
CN107092607B (en) | Ticket storage method and device | |
CN111309709B (en) | Database building and searching method and device | |
CN114398862A (en) | Remote point table maintenance method based on terminal debugging device | |
CN111143296A (en) | Substation SCD file classification method and device, terminal and storage medium | |
JPH05334363A (en) | Data base retrieval system | |
CN114915639B (en) | Method, device, electronic equipment and medium for analyzing message of power dedicated scheduling channel | |
CN105302921A (en) | Map data storage method and system | |
CN114095800B (en) | Large-scale wireless local area network data acquisition and processing method based on multiple data sources | |
US20230056433A1 (en) | Data management device and program | |
CN111831695B (en) | Query system and method for line loss information of transformer area | |
KR102508179B1 (en) | IEC61850-based microgrid data analysis system and method | |
CN102591875A (en) | Data retrieval method and data retrieval device | |
CN114372037A (en) | Method for generating real-time database of data communication gateway | |
CN102750279A (en) | Classification association networked sharing method and system for electronic document |
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 |