CN111831695B - Query system and method for line loss information of transformer area - Google Patents
Query system and method for line loss information of transformer area Download PDFInfo
- Publication number
- CN111831695B CN111831695B CN202010661587.6A CN202010661587A CN111831695B CN 111831695 B CN111831695 B CN 111831695B CN 202010661587 A CN202010661587 A CN 202010661587A CN 111831695 B CN111831695 B CN 111831695B
- Authority
- CN
- China
- Prior art keywords
- data
- area
- line loss
- data table
- unit
- 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
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/2455—Query execution
- G06F16/24552—Database cache management
-
- 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/2471—Distributed queries
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
-
- 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
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Abstract
The invention provides a system and a method for inquiring line loss information of a station area. The system comprises a database, an information acquisition module, a first cache module, a processing module, a second cache module and a query module, wherein the database stores a plurality of area line loss tables, and the line loss tables record a plurality of area data; the information acquisition module can traverse the database to extract the data of the platform area and integrate the extracted data into a first data table; the first cache module can store a first data table; the processing module can analyze and process the data of the platform area and obtain a second data table; the second buffer module can store a second data table; the query module can query and/or count the data of the area in the second data table. The method comprises the step of inquiring the line loss information by adopting the system. The beneficial effects of the invention can include: can save artifical labour, labour saving and time saving, efficient, easy and simple to handle can improve the treatment efficiency of line loss, is favorable to carrying out line loss investigation and treatment on line.
Description
Technical Field
The invention relates to the field of power distribution, in particular to a system and a method for inquiring line loss information of a transformer area.
Background
The line loss data of the power company is usually exported in a line loss table area data workbook in a manual mode, then the substandard table areas are searched, replaced, ordered and screened, the names of the input power supply stations are inserted, and then the names are copied and pasted into another table for statistics and summarization. When line loss information of a plurality of power supply stations is to be queried, the above steps must be repeated, which is cumbersome and time-consuming.
Disclosure of Invention
The present invention is directed to solving one or more of the problems of the prior art, including the shortcomings of the prior art. For example, one of the purposes of the present invention is to improve the line loss control efficiency.
In order to achieve the above objective, the present invention provides a system for querying line loss information of a station area.
The query system can comprise a database, an information acquisition module, a first cache module, a processing module, a second cache module and a query module, wherein the database stores a plurality of area line loss tables, the line loss tables record a plurality of area data, and each area data comprises an area name, input time, output time, input electric quantity and output electric quantity; the information acquisition module can traverse the database to extract the data of the areas in the line loss tables and integrate the extracted data into a first data table; the first cache module is capable of storing a first data table; the processing module can analyze and process the data of the area in the first data table and obtain a second data table, and comprises at least one of a judging unit, an analyzing unit and a matter adding unit, wherein the judging unit can judge whether repeated data of the area exist in the first data table, and if the repeated data exist, redundant data are deleted; the analysis unit can analyze the area data in the first data table and mark the area data as standard or substandard according to the analysis result; the item adding unit can add new data into each piece of area data of the first data table, wherein the new data comprises at least one of a power supply station, a high-voltage line and a manager; the second cache module is capable of storing a second data table; the query module is capable of querying and/or counting the zone data in the second data table.
Further, the cell data may further include an electrical power difference and/or an actual line loss, for example, both an electrical power difference and an actual line loss.
Further, the step of the analysis unit being capable of analyzing the data of the area in the first data table and marking the data of the area as up to standard or not up to standard according to the analysis result includes: the analysis unit can obtain actual line loss according to the input current and the output electric quantity of the platform region data in the first data table, judge whether the actual line loss is in a standard range, mark the platform region data as reaching the standard under the condition that the actual line loss is in the standard range, otherwise, mark the platform region data as not reaching the standard.
The invention further provides a system for inquiring the line loss information of the station area.
The query system can comprise a database, an information acquisition module, a first cache module, a processing module, a second cache module and a query module, wherein the database stores a plurality of table area line loss tables, the line loss tables record a plurality of table area data, and each table area data comprises a table area name, input time, output time, input electric quantity, output electric quantity and actual line loss; the information acquisition module can traverse the database to extract the data of the areas in the line loss tables and integrate the extracted data into a first data table; the first cache module is capable of storing a first data table; the processing module can analyze and process the data of the area in the first data table and obtain a second data table, and comprises at least one of a judging unit, an analyzing unit and a matter adding unit, wherein the judging unit can judge whether repeated data of the area exist in the first data table, and if the repeated data exist, redundant data are deleted; the analysis unit can compare the actual line loss in each region data of the first data table with the standard range, and mark the region data as standard or not standard according to the comparison result; the item adding unit can add new data into each piece of area data of the first data table, wherein the new data comprises at least one of a power supply station, a high-voltage line and a manager; the second cache module is capable of storing a second data table; the query module is capable of querying and/or counting the zone data in the second data table.
According to one or more exemplary embodiments of the invention, the information acquisition module is capable of traversing the database using dir functions.
According to one or more exemplary embodiments of the present invention, the query module may include an input unit capable of inputting a query condition including at least one of a power supply station, a zone name, a status, and a manager, a query unit, and an output unit; the query unit can screen out the data of the platform area meeting the query condition from the second data table; the output unit can output and display the zone data meeting the conditions.
According to one or more exemplary embodiments of the invention, the new data may further include a query time.
According to one or more exemplary embodiments of the invention, the new data may also include a user table number.
According to one or more exemplary embodiments of the present invention, the standard range may be: 0 to 10%.
According to one or more exemplary embodiments of the present invention, the analysis unit is further capable of marking rebound data in the zone data marked as substandard.
The invention also provides a system for inquiring the line loss information of the platform region, and the inquiring method can comprise the step of inquiring the line loss by adopting the system for inquiring the line loss information of the platform region.
Compared with the prior art, the invention has the beneficial effects that: can save artifical labour, labour saving and time saving, efficient, easy and simple to handle can improve the treatment efficiency of line loss, is favorable to carrying out line loss investigation and treatment on line.
Detailed Description
Hereinafter, the query system and the query method of the present invention for the line loss information of the transformer area will be described in detail with reference to exemplary embodiments.
The invention provides a system for inquiring line loss information of a station area.
In an exemplary embodiment of the present invention, a query system for the line loss information of a station area may include: the system comprises a database, an information acquisition module, a first cache module, a processing module, a second cache module and a query module.
The database stores a plurality of area line loss tables, for example, more than 2. The line loss table of the transformer area can be a historical line loss table of an electricity collection information system, the line loss table can be recorded with transformer area information, the line loss table can be recorded with a plurality of transformer area data, and each transformer area data comprises a transformer area name, input time, output time, input electric quantity, output electric quantity and the like.
The information acquisition module can traverse the database, extract the area data in the line loss tables at the same time, and integrate the area data into a data table, wherein the data table can be a first data table. Wherein the information acquisition module may traverse the database using dir functions.
The first cache module is capable of storing a first data table.
The processing module can analyze the data of the area in the first data table and obtain a second data table, and the second data table comprises at least one of a distinguishing unit, an analyzing unit and a matter adding unit, preferably can comprise the distinguishing unit, the analyzing unit and the matter adding unit. The judging unit can judge whether the first data table has repeated data of the platform area, if so, the redundant data is deleted, namely only one group of data is reserved, and then other repeated data is deleted. The analysis unit is capable of analyzing the zone data in the first data table and classifying the zone data into one of up-to-standard and down-to-standard according to the analysis result. The event adding unit can add new data to each of the zone data of the first data table, the new data including at least one of a power supply station, a high-voltage line, and a manager, and of course, the present invention is not limited thereto and may include data required by other staff.
The second cache module is capable of storing a second data table.
The query module is capable of querying and/or counting the zone data in the second data table.
In this embodiment, the zone data may further include a power difference, that is, a difference between the input power and the output power, for example, when the input power is 904kWh and the output power is 860.764kWh, the power difference is 43.236kWh.
Further, the zone data may also include actual line loss.
In the present embodiment, the line loss table may be Excel, word, TXT or the like, as just one example.
In this embodiment, further, the data of the transformer area may further include a theoretical line loss value, so as to be compared with an actual line loss. As an illustration, the theoretical line loss may be 5%. The theoretical line loss value can be a set value in a line loss table of the electricity acquisition information system.
In this embodiment, the order in which the discriminating unit, the analyzing unit, and the event adding unit operate is not particularly required. For example, the analysis unit may process the land data processed by the determination unit, and the event adding unit may perform a data adding operation on the data processed by the analysis unit.
In this embodiment, when the area data in the first data table includes the input electric quantity and the output electric quantity and does not include the actual line loss, the analysis unit may obtain the actual line loss according to the input current and the output electric quantity of the area data in the first data table, determine whether the actual line loss is within a standard range, and mark the area data as reaching the standard if the actual line loss is within the standard range, otherwise, mark the area data as not reaching the standard.
Wherein, the standard range can be 0-10%, further more than 0 and less than 10%.
In this embodiment, the analysis unit can further mark rebound data in the area data marked as substandard.
Specifically, the database stores the line loss tables of the previous month and the current month, and the analysis unit can also mark the data of the district which does not reach the standard in the current month and reaches the standard in the previous month as rebound data.
In this embodiment, the processing unit further includes a correction unit capable of modifying the land data in the first data table. The correction unit can have account number and password authority login functions.
In this embodiment, the new data may further include a power supply station, a high-voltage line, and a manager, so as to clearly know the management area and personnel of each station, and to clearly know the station information data of each power supply station of the power supply company. Further, the new data may also include the number of subscriber tables. The high voltage line name may include the 10KV line of each power supply station.
The query module in this embodiment may include an input unit, a query unit, and an output unit. The input unit is capable of inputting a query condition; the query unit can screen the data of the platform region meeting the query condition from the second data table, and further, can also carry out statistics on the screened data, wherein the statistics can be carried out by using a countif function; the output unit can output and display the table area data meeting the conditions, and further can output and display the statistical result.
The query condition includes at least one of a power supply station, a station name, a status, and a manager, and further may further include a status (i.e., up-to-standard or not-to-standard) of station data.
In this embodiment, the query system may further have a login window, which may have a user name and password login.
In this embodiment, after the query system performs data query and/or statistics, both the first and second buffer modules can clear the stored data table, so as to facilitate the next query and statistics.
In another exemplary embodiment of the present invention, the query system for the area line loss information may be largely the same as that of the previous exemplary embodiment.
The difference is that:
(1) each of the zone data must include line loss data.
(2) The analysis unit can compare the actual line loss in each region data of the first data table with the standard range, and mark the region data as reaching or not reaching the standard according to the comparison result.
The invention also provides a system for inquiring the line loss information of the platform region, and the inquiring method can comprise the step of inquiring the line loss by adopting the system for inquiring the line loss information of the platform region.
In summary, the advantages of the system and method for querying the line loss information of the platform area according to the present invention may include at least one of the following:
(1) The query system is simple and convenient, convenient to query and high in speed, and can avoid confusion of data in the manual query process.
(2) The invention can save a great deal of manual labor and improve the line loss management efficiency.
Claims (4)
1. The system for inquiring the line loss information of the platform region is characterized by comprising a database, an information acquisition module, a first cache module, a processing module, a second cache module and an inquiring module, wherein,
the database stores a plurality of area line loss tables, the line loss tables record a plurality of area data, and each area data comprises an area name, an input time, an output time, an input electric quantity and an output electric quantity; the station area data also comprises an electric quantity difference and/or an actual line loss;
the information acquisition module can traverse the database to extract the area data in the line loss tables and integrate the extracted data into a first data table, and the information acquisition module can traverse the database by using a dir function;
the first cache module is capable of storing a first data table;
the processing module can analyze and process the data of the area in the first data table and obtain a second data table, and comprises at least one of a judging unit, an analyzing unit and a matter adding unit, wherein the judging unit can judge whether repeated data of the area exist in the first data table, and if the repeated data exist, redundant data are deleted; the analysis unit can analyze the area data in the first data table, mark the area data as standard-reaching or standard-failing according to the analysis result, and can mark rebound data in the area data marked as standard-failing; the item adding unit can add new data into each piece of area data of the first data table, wherein the new data comprises at least one of a power supply station, a high-voltage line and a manager;
the step that the analysis unit can analyze the platform area data in the first data table and mark the platform area data as standard or substandard according to the analysis result comprises the following steps:
the analysis unit can obtain actual line loss according to the input current and the output electric quantity of the data of the platform area in the first data table, judge whether the actual line loss is in a standard range, and mark the data of the platform area as reaching the standard under the condition that the actual line loss is in the standard range, otherwise, mark the data of the platform area as not reaching the standard;
the processing module further comprises a correction unit, the correction unit can modify the data of the platform area in the first data table, and the correction unit has account number and password authority login functions;
the second cache module is capable of storing a second data table;
the query module can query and/or count the data of the platform area in the second data table;
after the query system performs data query and/or statistics, the first and second cache modules can clear the stored data table;
the inquiry module comprises an input unit, an inquiry unit and an output unit, wherein,
the input unit can input query conditions, wherein the query conditions comprise at least one of a power supply station, a platform area name, a state and a manager;
the query unit can screen out the data of the platform area meeting the query condition from the second data table;
the output unit can output and display the platform area data meeting the query conditions.
2. The system for querying for the line loss information of a platform according to claim 1, wherein the new data further comprises a query time.
3. The system for querying the line loss information of the transformer area according to claim 1, wherein the standard range is: 0 to 10%.
4. The method for inquiring the line loss information of the transformer area is characterized by comprising the step of inquiring the line loss by adopting the system for inquiring the line loss information of the transformer area according to claim 1 or 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010661587.6A CN111831695B (en) | 2020-07-10 | 2020-07-10 | Query system and method for line loss information of transformer area |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010661587.6A CN111831695B (en) | 2020-07-10 | 2020-07-10 | Query system and method for line loss information of transformer area |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111831695A CN111831695A (en) | 2020-10-27 |
| CN111831695B true CN111831695B (en) | 2023-09-08 |
Family
ID=72901178
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010661587.6A Active CN111831695B (en) | 2020-07-10 | 2020-07-10 | Query system and method for line loss information of transformer area |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111831695B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103955519A (en) * | 2014-05-08 | 2014-07-30 | 国网上海市电力公司 | Account inquiring and recording system and inquiring and recording method thereof |
| CN104182546A (en) * | 2014-09-09 | 2014-12-03 | 北京国双科技有限公司 | Method and device for querying data in databases |
| CN108038121A (en) * | 2017-11-03 | 2018-05-15 | 福建网龙计算机网络信息技术有限公司 | A kind of caching method and terminal |
| CN109711703A (en) * | 2018-12-20 | 2019-05-03 | 国网北京市电力公司 | The line loss querying method and system of power distribution network |
| CN110806518A (en) * | 2019-10-21 | 2020-02-18 | 国网四川省电力公司成都供电公司 | Transformer area line loss abnormal motion analysis module and operation method thereof |
| CN110855012A (en) * | 2019-12-19 | 2020-02-28 | 国网河北省电力有限公司武安市供电分公司 | Real-time line loss intelligent analysis system for transformer area |
-
2020
- 2020-07-10 CN CN202010661587.6A patent/CN111831695B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103955519A (en) * | 2014-05-08 | 2014-07-30 | 国网上海市电力公司 | Account inquiring and recording system and inquiring and recording method thereof |
| CN104182546A (en) * | 2014-09-09 | 2014-12-03 | 北京国双科技有限公司 | Method and device for querying data in databases |
| CN108038121A (en) * | 2017-11-03 | 2018-05-15 | 福建网龙计算机网络信息技术有限公司 | A kind of caching method and terminal |
| CN109711703A (en) * | 2018-12-20 | 2019-05-03 | 国网北京市电力公司 | The line loss querying method and system of power distribution network |
| CN110806518A (en) * | 2019-10-21 | 2020-02-18 | 国网四川省电力公司成都供电公司 | Transformer area line loss abnormal motion analysis module and operation method thereof |
| CN110855012A (en) * | 2019-12-19 | 2020-02-28 | 国网河北省电力有限公司武安市供电分公司 | Real-time line loss intelligent analysis system for transformer area |
Non-Patent Citations (1)
| Title |
|---|
| 杨勇胜 ; 钱卫杰 ; 刘军 ; .利用EXCEL图表分析多台区线损.湖州师范学院学报.2016,38(第08期),第89-92页. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111831695A (en) | 2020-10-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110795921B (en) | Automatic generation and verification method for monitoring information of intelligent substation equipment | |
| CN111212104B (en) | Automatic meter searching method for electricity meter acquisition terminal | |
| CN106815373A (en) | Big data methods of exhibiting and system are rushed to repair in distribution based on BI analyses | |
| CN107169880A (en) | Platform is monitored in power grid user electricity consumption on-line | |
| CN110046391A (en) | Transforming plant primary wiring diagram automatic generation method based on monitoring information table | |
| CN105046604A (en) | Patent information management system | |
| CN104538957A (en) | Power grid model self-adaptive processing method for counting low-frequency low-voltage load shedding capacity | |
| CN104599068A (en) | Method for positioning user fault through comprehensive analysis of repair request information | |
| CN111831695B (en) | Query system and method for line loss information of transformer area | |
| CN111984656B (en) | Method and system for checking basic data key parameters of intelligent substation automation equipment | |
| CN109272249A (en) | A kind of platform area line loss defect elimination method based on platform area identifier | |
| CN112148897A (en) | Automatic retrieval and classification method and system for fault information of power system | |
| CN114611869B (en) | Low-voltage station area station household identification method | |
| CN111049157B (en) | Distribution network transformer reactive compensation condition analysis method | |
| CN109165753A (en) | A kind of substation's defect management method based on mobile platform | |
| CN111698711B (en) | Analysis method and analysis system for intelligent diagnosis of public network wireless communication channel faults | |
| CN112347089B (en) | Method for checking power supply reliability data quality of multiple systems | |
| CN110298585B (en) | Hierarchical automatic auditing method for monitoring information of substation equipment | |
| CN114003774A (en) | A big data information collection system of electric power for wisdom city | |
| CN114254906A (en) | Power dispatching report query method | |
| CN206863741U (en) | Monitoring information table auditing system | |
| Ya’An | Application of artificial intelligence in computer network technology in the era of big data | |
| CN110598805A (en) | Method and system for identifying monitoring information of power system | |
| CN109947867A (en) | Electric Power Network Planning data fusion method based on function support dimension | |
| CN113886469B (en) | Multi-source data-based automatic mining method and system for power distribution network engineering effect abnormity |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |