CN111831695A - System and method for inquiring transformer area line loss information - Google Patents
System and method for inquiring transformer area line loss information Download PDFInfo
- Publication number
- CN111831695A CN111831695A CN202010661587.6A CN202010661587A CN111831695A CN 111831695 A CN111831695 A CN 111831695A CN 202010661587 A CN202010661587 A CN 202010661587A CN 111831695 A CN111831695 A CN 111831695A
- Authority
- CN
- China
- Prior art keywords
- data
- line loss
- data table
- query
- module
- 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.)
- Granted
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 transformer area line loss information. 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 transformer area line loss tables, and a plurality of transformer area data are recorded in the line loss tables; the information acquisition module can traverse the database to extract the data of the transformer area and integrate the extracted data in 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 transformer area and obtain a second data table; the second cache module can store a second data table; the query module can query and/or count the region data 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, it is efficient, easy and simple to handle, can improve the treatment effeciency of line loss, be favorable to developing the line loss investigation on line and administer.
Description
Technical Field
The invention relates to the field of power distribution, in particular to a system and a method for inquiring transformer area line loss information.
Background
The method comprises the steps of generally, manually exporting a data workbook of a station area of a loss table in a station area line loss data query of a power company, searching, replacing, sorting and screening out unqualified station areas, inserting a name of an input power supply station, copying, pasting into another table, and counting and summarizing. When the line loss information of a plurality of power supply stations is required to be inquired, the steps are required to be repeated, and the operation is tedious and time-consuming.
Disclosure of Invention
In view of the deficiencies in the prior art, it is an object of the present invention to address one or more of the problems in the prior art as set forth above. For example, one of the objects of the present invention is to improve the line loss management efficiency.
In order to achieve the above object, an aspect of the present invention provides a system for querying line loss information of a distribution room.
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 transformer area line loss tables, the line loss tables record a plurality of transformer area data, and each transformer area data comprises a transformer area name, input time, output time, input electric quantity and output electric quantity; the information acquisition module can traverse a database to extract the station area data in the line loss tables 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 station area data in the first data table to obtain a second data table, and comprises at least one of a judging unit, an analyzing unit and an item adding unit, wherein the judging unit can judge whether the first data table has repeated station area data, and if so, redundant data are deleted; the analysis unit can analyze the platform area data in the first data table and mark the platform area data as up-to-standard or not up-to-standard according to an analysis result; the item adding unit can add new data into each station 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 can store a second data table; the query module can query and/or count the station area data in the second data table.
Further, the station area data may further include the difference in the electric quantity and/or the actual line loss, for example, both the difference in the electric quantity and the actual line loss.
Further, the step of analyzing the platform area data in the first data table by the analysis unit and marking the platform area data 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 station area data in the first data table, judge whether the actual line loss is in a standard range, mark the station area data as up to standard under the condition that the actual line loss is in the standard range, and otherwise mark the station area data as not up to standard.
The invention also provides a system for inquiring the line loss information of the transformer 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 transformer area line loss tables, the line loss tables record 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 actual line loss; the information acquisition module can traverse a database to extract the station area data in the line loss tables 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 station area data in the first data table to obtain a second data table, and comprises at least one of a judging unit, an analyzing unit and an item adding unit, wherein the judging unit can judge whether the first data table has repeated station area data, and if so, redundant data are deleted; the analysis unit can compare the actual line loss in each area data of the first data table with the standard range, and mark the area data as up-to-standard or not up-to-standard according to the comparison result; the item adding unit can add new data into each station 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 can store a second data table; the query module can query and/or count the station area 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 a dir function.
According to one or more exemplary embodiments of the present invention, the query module may include an input unit, a query unit, and an output unit, wherein the input unit may input a query condition, the query condition including at least one of a power supply station, a station area name, a status, and a manager; the query unit can screen the station area data meeting the query conditions from the second data table; the output unit can output and display the station area 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 present invention, the new data may further include a user table number.
According to one or more exemplary embodiments of the invention, the standard range may be: 0 to 10% inclusive.
According to one or more exemplary embodiments of the present invention, the analysis unit may further mark rebound data in the data of the station areas marked as not-compliant.
In another aspect of the present invention, a system for querying line loss information of a distribution room is also provided, where the querying method may include performing line loss query by using the system for querying line loss information of a distribution room.
Compared with the prior art, the beneficial effects of the invention can include: can save artifical labour, labour saving and time saving, it is efficient, easy and simple to handle, can improve the treatment effeciency of line loss, be favorable to developing the line loss investigation on line and administer.
Detailed Description
Hereinafter, the query system and query method of the line loss information of the distribution room of the present invention will be described in detail with reference to exemplary embodiments.
The invention provides a system for inquiring the line loss information of a transformer area on one hand.
In an exemplary embodiment of the present invention, the query system for the line loss information of the transformer 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 table area line loss tables, for example, more than 2. The transformer area line loss meter can be a historical line loss meter of a power utilization information acquisition system, transformer area information can be recorded in the line loss meter, a plurality of transformer area data can be recorded in the line loss meter, 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 a database, simultaneously extract the station area data in the line loss tables, and integrate the station area data into a data table, wherein the data table can be a first data table. The information acquisition module can traverse the database by using the dir function.
The first cache module is capable of storing a first data table.
The processing module can analyze and process the platform area data in the first data table and obtain a second data table, wherein the second data table comprises at least one of a distinguishing unit, an analyzing unit and a matter adding unit, and preferably, the second data table can comprise a distinguishing unit, an analyzing unit and a matter adding unit. The judging unit can judge whether the first data table has repeated station area data, 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 station area data in the first data table and classifying the station area data as one of standard and substandard according to an analysis result. The matter adding unit can add new data to each station 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, but the 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 can query and/or count the station area data in the second data table.
In this embodiment, the data of the distribution room may further include a power difference, i.e. a difference between the input power and the output power, for example, when the input power is 904kWh, the output power is 860.764kWh, and the power difference is 43.236 kWh.
Further, the station area data may also include actual line loss.
In this embodiment, the line loss table may be in the format of Excel, Word, TXT, etc., as just an example.
In this embodiment, further, the station area data may further include a theoretical line loss value to be compared with the actual line loss. Here, as an example, the theoretical line loss may be 5%. The theoretical line loss value can be a set value in a line loss table of the power utilization information acquisition system.
In this embodiment, there is no specific requirement on the sequence of operations of the discrimination unit, the analysis unit and the item addition unit. For example, the analysis unit may process the station area data processed by the discrimination unit, and the item addition unit may perform the data addition operation on the data processed by the analysis unit.
In this embodiment, when the platform 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 platform area data in the first data table, and determine whether the actual line loss is within a standard range, and mark the platform area data as up to standard if the actual line loss is within the standard range, otherwise, mark the platform area data as not up to standard.
Wherein, the standard range can be 0-10%, further more, more than 0 and less than 10%.
In this embodiment, the analysis unit can further mark the bounce data in the data of the station areas marked as not-reaching.
Specifically, the database stores the zone line loss tables of the previous month and the current month, and the analysis unit can mark the station zone data which does not reach the standard in the current month but reaches the standard in the previous month as the rebound data.
In this embodiment, the processing unit further includes a modification unit capable of modifying the station area data in the first data table. The correction unit can have the functions of account number and password authority login.
In this embodiment, the new data may further include a power supply station, a high-voltage line, and a manager, so as to clearly understand the management location and the manager of each power supply station, and to clearly understand the power supply station information data of each power supply station of the power supply company. Further, the new data may also include the number of user tables. The high voltage line name may include 10KV lines for 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 can input a query condition; the query unit can screen the station area data meeting the query conditions from the second data table, and further, can perform statistics on the screened data, wherein the statistics can be performed by using a countif function; the output unit can output and display the station area data meeting the conditions, and further can output and display a statistical result.
The query condition includes at least one of a power supply station, a district name, a status, and a manager, and further may include a status of district data (that is, standard or not standard).
In this embodiment, the query system may further have a login window, and the login window may have a user name and a password for login.
In this embodiment, after the query system performs data query and/or statistics, both the first and second cache 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 station area line loss information may be largely the same as that of the previous exemplary embodiment.
The difference lies in that:
each platform region data must include line loss data.
And the analysis unit can compare the actual line loss in each area data of the first data table with the standard range, and mark the area data as up-to-standard or not up-to-standard according to the comparison result.
In another aspect of the present invention, a system for querying line loss information of a distribution room is also provided, where the querying method may include performing line loss query by using the system for querying line loss information of a distribution room.
In summary, the advantages of the query system and query method for line loss information of a distribution room of 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 the confusion of data in the manual query process.
(2) The invention can save a large amount of manual labor and improve the treatment efficiency of line loss.
Claims (10)
1. The system for inquiring the line loss information of the transformer area is characterized by comprising a database, an information acquisition module, a first cache module, a processing module, a second cache module and an inquiry module,
the method comprises the following steps that a plurality of transformer area line loss meters are stored in a database, a plurality of transformer area data are recorded in the line loss meters, and each transformer area data comprises a transformer area name, input time, output time, input electric quantity and output electric quantity;
the information acquisition module can traverse a database to extract the station area data in the line loss tables 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 station area data in the first data table to obtain a second data table, and comprises at least one of a judging unit, an analyzing unit and an item adding unit, wherein the judging unit can judge whether the first data table has repeated station area data, and if so, redundant data are deleted; the analysis unit can analyze the platform area data in the first data table and mark the platform area data as up-to-standard or not up-to-standard according to an analysis result; the item adding unit can add new data into each station 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 can store a second data table;
the query module can query and/or count the station area data in the second data table.
2. The system for inquiring the line loss information of the transformer area is characterized by comprising a database, an information acquisition module, a first cache module, a processing module, a second cache module and an inquiry module,
the method comprises the following steps that a plurality of transformer area line loss meters are stored in a database, a plurality of transformer area data are recorded in the line loss meters, and each transformer area data comprises a transformer area name, input time, output time, input electric quantity, output electric quantity and actual line loss;
the information acquisition module can traverse a database to extract the station area data in the line loss tables 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 station area data in the first data table to obtain a second data table, and comprises at least one of a judging unit, an analyzing unit and an item adding unit, wherein the judging unit can judge whether the first data table has repeated station area data, and if so, redundant data are deleted; the analysis unit can compare the actual line loss in each area data of the first data table with the standard range, and mark the area data as up-to-standard or not up-to-standard according to the comparison result; the item adding unit can add new data into each station 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 can store a second data table;
the query module can query and/or count the station area data in the second data table.
3. The query system for line loss information of transformer area according to claim 1 or 2, wherein the information obtaining module is capable of traversing the database by using dir function.
4. The system for querying transformer district line loss information according to claim 1 or 2, wherein the query module comprises an input unit, a query 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 region name, a state and management personnel;
the query unit can screen the station area data meeting the query conditions from the second data table;
the output unit can output and display the station area data meeting the conditions.
5. The system for querying transformer area line loss information according to claim 1 or 2, wherein the new data further comprises a query time.
6. The system for querying transformer area line loss information according to claim 1, wherein the transformer area data further comprises an electric quantity difference and/or an actual line loss.
7. The system for querying transformer area line loss information according to claim 1, wherein the analyzing unit is capable of analyzing the transformer area data in the first data table, and marking the transformer area data as qualified or unqualified according to the analysis result comprises:
the analysis unit can obtain actual line loss according to the input current and the output electric quantity of the station area data in the first data table, judge whether the actual line loss is in a standard range, mark the station area data as up to standard under the condition that the actual line loss is in the standard range, and otherwise mark the station area data as not up to standard.
8. The system for querying transformer area line loss information according to claim 7, wherein the standard range is: 0 to 10% inclusive.
9. The system for querying transformer area line loss information according to claim 1, wherein the analysis unit is further capable of marking rebound data in the transformer area data marked as substandard.
10. The method for querying the line loss information of the distribution room according to claim 1, wherein the method for querying comprises performing line loss query by using the system for querying the line loss information of the distribution room according to claim 1, 2, 6, 7, 8 or 9.
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 true CN111831695A (en) | 2020-10-27 |
| CN111831695B 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 (2)
| Title |
|---|
| 周仁才;金仁云;秦如意;: "基于PI数据库的中低压配电网运行管理" * |
| 杨勇胜;钱卫杰;刘军;: "利用EXCEL图表分析多台区线损" * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111831695B (en) | 2023-09-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106815373A (en) | Big data methods of exhibiting and system are rushed to repair in distribution based on BI analyses | |
| CN110108955A (en) | A kind of new-energy grid-connected performance automatic test analysis platform and detection method | |
| CN107862392B (en) | Equipment account management and control method based on power distribution network intelligent operation and maintenance management and control platform | |
| CN107169880A (en) | Platform is monitored in power grid user electricity consumption on-line | |
| CN111461521A (en) | Residential housing vacancy rate analysis method based on electric power big data | |
| CN110046391A (en) | Transforming plant primary wiring diagram automatic generation method based on monitoring information table | |
| CN112698123A (en) | Low-voltage distribution area user topological relation identification method based on decision tree | |
| CN107194562A (en) | Electric company's platform area outage analysis system | |
| CN111984656B (en) | Method and system for checking basic data key parameters of intelligent substation automation equipment | |
| CN111831695B (en) | Query system and method for line loss information of transformer area | |
| CN109165753B (en) | Transformer substation defect management method based on mobile platform | |
| CN111698711B (en) | Analysis method and analysis system for intelligent diagnosis of public network wireless communication channel faults | |
| CN105335787A (en) | On-line repairing work processing method of cell | |
| CN110674235A (en) | Marketing and distribution topology file synchronous management system and method | |
| CN113282594B (en) | Automatic extraction and analysis method and system for basic data of distribution transformer | |
| CN114049082A (en) | Power grid technical improvement overhaul cost data structuring method | |
| CN112445796B (en) | New energy station report generation method | |
| CN114003774A (en) | A big data information collection system of electric power for wisdom city | |
| CN111049157B (en) | Distribution network transformer reactive compensation condition analysis method | |
| CN114860790A (en) | Marketing meter reading abnormity analysis system | |
| CN113313475A (en) | Intelligent skill review method based on big data | |
| CN114254906A (en) | Power dispatching report query method | |
| CN106066860A (en) | A kind of method of electric power meter management | |
| CN206863741U (en) | Monitoring information table auditing system | |
| CN111429154A (en) | Traceable system for cable product production and inspection procedures |
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 |