CN102663037A - Comprehensive statistics inquiring system for SCADA (supervisory control and data acquisition) historical data - Google Patents
Comprehensive statistics inquiring system for SCADA (supervisory control and data acquisition) historical data Download PDFInfo
- Publication number
- CN102663037A CN102663037A CN201210083470XA CN201210083470A CN102663037A CN 102663037 A CN102663037 A CN 102663037A CN 201210083470X A CN201210083470X A CN 201210083470XA CN 201210083470 A CN201210083470 A CN 201210083470A CN 102663037 A CN102663037 A CN 102663037A
- Authority
- CN
- China
- Prior art keywords
- historical data
- scada
- information
- data
- hand
- 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
Abstract
The invention discloses a comprehensive statistics inquiring system for SCADA (supervisory control and data acquisition) historical data. The system comprises a client, a WEB application server and a database which are connected orderly, wherein a system disclosed by the invention is capable of processing comprehensive application to historical data collected by an automatic system and retaining the historical data before and after the automatic system is updated, avoiding historical data lost resulted by changes of system platform after the automatic system is updated and providing a long-term load analyzing data for power grid plan; the system can enable works of SCADA historical data to be very efficient and fast only by an selected condition, and can automatically list each data of host changes or circuits and directly export EXCEL reports for further data process. Different from manners of traditional manual statistics, the error rate in the automatic statistics of the comprehensive statistics inquiring system for SCADA historical data is almost zero under guarantee on correctness of program and accuracy of quota and other original data.
Description
Technical field
The present invention relates to a kind of SCADA historical data comprehensive statistics inquiry system.
Background technology
The SCADA system can realize the data query to each factory station current data very easily, yet along with many new websites put into operation, for the statistics of the SCADA system data more and more difficult that becomes; The renewal of new SCADA system is reached the standard grade, and also makes historical data interrupt, and has lost the continuity of data, causes and can't add up the old and new's system history data simultaneously.
During meeting the kurtosis summer, the manual statistics of the line load of every day will have been spent the time of yardman's number hour, and the also easy error that wastes time and energy has taken a large amount of working times, and planning authorities also need spend the plenty of time to the statistical study of historical data.
Summary of the invention
The objective of the invention is to overcome the defective of prior art and a kind of SCADA historical data comprehensive statistics inquiry system is provided,, let system add up each association of operation of power networks automatically through having imported historical data in advance.
The objective of the invention is to realize like this:
A kind of SCADA historical data comprehensive statistics inquiry system of the present invention comprises the client, WEB application server and the database that link to each other successively, wherein,
Described client is used to import SCADA historical data and nameplate information on the one hand, and is sent to the WEB application server, is used to receive the querying command of user's input on the other hand, is sent to the WEB application server, receives feedback result and demonstration;
Described WEB application server comprises:
The data importing module is used to receive the SCADA historical data that described client is imported on the one hand, it is pressed the basic document information classification of initialization system, and this basic document information is imported database, is used to provide the inquiry of basic document information on the other hand;
The schedule information administration module is used to provide main transformer negative rate, line load rate, transformer station's load factor and the average negative report query that cuts rate of cutting;
The nameplate information management module is used for receiving the nameplate information of client input and being stored in database on the one hand, is used to provide the change and the inquiry of nameplate information on the other hand;
The load analysis module is used to provide the inquiry of load form;
System management module is used to be provided with the global tissue framework, sets up login user information, and the configure user authority is carried out operation log recording to system.
Above-mentioned a kind of SCADA historical data comprehensive statistics inquiry system, wherein, described client is sent to the WEB application server through soap protocol with the SCADA historical data.
Above-mentioned a kind of SCADA historical data comprehensive statistics inquiry system, wherein, described basic document information comprises block, factory's station information and facility information.
System of the present invention carries out integrated application with the historical data of automated system collection; Kept the historical data before and after automated system is upgraded; Avoided automated system to upgrade the back, analyzed data, made the statistical work of SCADA historical data become very efficient, quick for Electric Power Network Planning provides macrocyclic load because the historical data that the system platform variation causes is lost; As long as the condition of choosing; System will list the main transformer that satisfies condition or each association of circuit automatically one by one, and can directly export to the EXCEL form, convenient further data processing.Be different from the conventional artificial statistical, as long as guarantee the accuracy of raw data such as program correctness and limit, the error rate that SCADA historical data comprehensive statistics inquiry system is added up automatically is almost nil.
Description of drawings
Fig. 1 is a schematic diagram of the present invention.
Embodiment
To combine accompanying drawing that the present invention is described further below.
See also Fig. 1, SCADA historical data comprehensive statistics inquiry system of the present invention has been shown among the figure, comprise the client 1, WEB application server 2 and the database 3 that link to each other successively, wherein:
Client 1 is used to import SCADA historical data and nameplate information, and is sent to the WEB application server on the one hand, is used to receive the querying command of user's input on the other hand, is sent to WEB application server 2, receives feedback result and demonstration;
WEB application server 2 comprises:
Data importing module 21; Be used to receive the SCADA historical data of described client input; It is pressed the basic document information classification of initialization system; And with this basic document information importing database, wherein basic document information comprises block, factory's station information and facility information, and the inquiry of block, factory's station information and facility information is provided simultaneously.
Schedule information administration module 22 is used to provide main transformer negative rate, line load rate, transformer station's load factor and the average negative report query that cuts rate of cutting;
Nameplate information management module 23 is used for receiving the nameplate information of client input and being stored in database on the one hand, is used to provide the change and the inquiry of nameplate information on the other hand;
Load analysis module 24; Be used to provide the load report query of variant object, comprise that main transformer day peak load, main transformer peak load moon form, factory's station load year are analyzed, factory's station load growth rate is analyzed, main transformer stage maximum load rate of growth is analyzed, factory's station load negatively cuts a rate analysis, factory's station load fixed point analysiss, maximum load analysiss of circuit day, circuit peak load moon form, analyze in line load year, the analysis of line load rate of growth, the maximum load analysis of circuit stage, the maximum load rate of growth analysis of circuit stage and block substation capacity;
System management module 25 is used to be provided with the global tissue framework, sets up login user information, and the configure user authority is carried out operation log recording to system.
Above embodiment only supplies to explain the present invention's usefulness; But not limitation of the present invention; The technician in relevant technologies field under the situation that does not break away from the spirit and scope of the present invention, can also make various conversion or modification; Therefore all technical schemes that are equal to also should belong to category of the present invention, should be limited each claim.
Claims (3)
1. a SCADA historical data comprehensive statistics inquiry system comprises the client, WEB application server and the database that link to each other successively, it is characterized in that,
Described client is used to import SCADA historical data and nameplate information on the one hand, and is sent to the WEB application server, is used to receive the querying command of user's input on the other hand, is sent to the WEB application server, receives feedback result and demonstration;
Described WEB application server comprises:
The data importing module is used to receive the SCADA historical data that described client is imported on the one hand, it is pressed the basic document information classification of initialization system, and this basic document information is imported database, is used to provide the inquiry of basic document information on the other hand;
The schedule information administration module is used to provide main transformer negative rate, line load rate, transformer station's load factor and the average negative report query that cuts rate of cutting;
The nameplate information management module is used for receiving the nameplate information of client input and being stored in database on the one hand, is used to provide the change and the inquiry of nameplate information on the other hand;
The load analysis module is used to provide the inquiry of load form;
System management module is used to be provided with the global tissue framework, sets up login user information, and the configure user authority is carried out operation log recording to system.
2. a kind of SCADA historical data comprehensive statistics inquiry system as claimed in claim 1 is characterized in that described client is sent to the WEB application server through soap protocol with the SCADA historical data.
3. a kind of SCADA historical data comprehensive statistics inquiry system as claimed in claim 1 is characterized in that, described basic document information comprises block, factory's station information and facility information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210083470XA CN102663037A (en) | 2012-03-27 | 2012-03-27 | Comprehensive statistics inquiring system for SCADA (supervisory control and data acquisition) historical data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210083470XA CN102663037A (en) | 2012-03-27 | 2012-03-27 | Comprehensive statistics inquiring system for SCADA (supervisory control and data acquisition) historical data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102663037A true CN102663037A (en) | 2012-09-12 |
Family
ID=46772528
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210083470XA Pending CN102663037A (en) | 2012-03-27 | 2012-03-27 | Comprehensive statistics inquiring system for SCADA (supervisory control and data acquisition) historical data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102663037A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020134A (en) * | 2012-11-20 | 2013-04-03 | 北京思特奇信息技术股份有限公司 | Web application-based recording system and web application-based recording method |
| CN109166051A (en) * | 2018-08-17 | 2019-01-08 | 广东电网有限责任公司 | A kind of dispatching of power netwoks data programming count and multidimensional visualize application method |
| CN109299121A (en) * | 2018-09-13 | 2019-02-01 | 南京国电南自轨道交通工程有限公司 | A kind of efficient querying method of SCADA system history alarm |
| CN110099077A (en) * | 2018-01-29 | 2019-08-06 | 北京视联动力国际信息技术有限公司 | A kind of querying method and system of travel information |
| CN110930264A (en) * | 2019-11-15 | 2020-03-27 | 国网安徽省电力有限公司黄山供电公司 | Regional power grid tripping information management and control system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101043152A (en) * | 2006-03-24 | 2007-09-26 | 上海市电力公司 | Intelligent decision support system for urban power grid accidents |
| CN201853256U (en) * | 2009-12-10 | 2011-06-01 | 北京国际系统控制有限公司 | Intelligent scheduling system |
| CN102368634A (en) * | 2011-09-14 | 2012-03-07 | 文存润 | Unified information platform system for state monitoring of intelligent transformer substation |
-
2012
- 2012-03-27 CN CN201210083470XA patent/CN102663037A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101043152A (en) * | 2006-03-24 | 2007-09-26 | 上海市电力公司 | Intelligent decision support system for urban power grid accidents |
| CN201853256U (en) * | 2009-12-10 | 2011-06-01 | 北京国际系统控制有限公司 | Intelligent scheduling system |
| CN102368634A (en) * | 2011-09-14 | 2012-03-07 | 文存润 | Unified information platform system for state monitoring of intelligent transformer substation |
Non-Patent Citations (2)
| Title |
|---|
| EBATA Y. 等: "Development of the Intranet-Based SCADA (Supervisory Control and Data Acquisition System) for Power System", 《POWER ENGINEERING SOCIETY WINTER MEETING,2000,IEEE》, vol. 3, 27 January 2000 (2000-01-27), pages 1656 - 1661 * |
| 吴俊杰: "基于SCADA系统的电网数据分析及应用", 《2007中国电机工程学会电力系统自动化专委会供用电管理自动化学科组（分专委会）二届三次会议论文集》, 30 November 2007 (2007-11-30), pages 301 - 306 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020134A (en) * | 2012-11-20 | 2013-04-03 | 北京思特奇信息技术股份有限公司 | Web application-based recording system and web application-based recording method |
| CN110099077A (en) * | 2018-01-29 | 2019-08-06 | 北京视联动力国际信息技术有限公司 | A kind of querying method and system of travel information |
| CN109166051A (en) * | 2018-08-17 | 2019-01-08 | 广东电网有限责任公司 | A kind of dispatching of power netwoks data programming count and multidimensional visualize application method |
| CN109299121A (en) * | 2018-09-13 | 2019-02-01 | 南京国电南自轨道交通工程有限公司 | A kind of efficient querying method of SCADA system history alarm |
| CN109299121B (en) * | 2018-09-13 | 2022-02-15 | 南京国电南自轨道交通工程有限公司 | Efficient historical alarm query method for SCADA system |
| CN110930264A (en) * | 2019-11-15 | 2020-03-27 | 国网安徽省电力有限公司黄山供电公司 | Regional power grid tripping information management and control system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103427417B (en) | Based on the distribution network failure processing method of Multi-source Information Fusion | |
| CN107167704B (en) | Power distribution network fault diagnosis system and method based on CIM model | |
| CN105277851A (en) | Distribution network fault judgment searching and positioning system | |
| CN106815373B (en) | Distribution network first-aid repair big data display method and system based on BI analysis | |
| CN102663037A (en) | Comprehensive statistics inquiring system for SCADA (supervisory control and data acquisition) historical data | |
| CN102545213A (en) | System and method for managing line loss of power grid in real time | |
| CN106814286B (en) | Power distribution network fault positioning system, method and server based on multi-element fault acquisition | |
| CN103761625A (en) | Outage management system based on information exchange bus and data processing method thereof | |
| CN109871965A (en) | A kind of breakdown repair App platform of combination GIS and power customer fault location information | |
| CN102938109B (en) | Grid power blackout method of combination and device | |
| CN102668454B (en) | For providing method and the operations support systems of the performance management in mobile communication system | |
| CN103066700B (en) | Power grid fault information processing method and system | |
| CN105305617A (en) | Transformer substation online secondary equipment standing book information acquisition method | |
| CN105119282A (en) | On-line calculation system and method for theoretical line loss of power grid | |
| EP2897401A1 (en) | Method and device for guaranteeing consistency of planning data | |
| CN105207358B (en) | The quality of power supply monitors platform on-line | |
| CN102968687A (en) | Substation automation information parameter setting method | |
| CN106530112A (en) | Distribution management system | |
| CN103700024A (en) | Automatic importing method of provincial and prefectural integrated telecontrol information based on D5000 system | |
| CN104112183A (en) | Plug-and-play intelligent scheduling model management system and management method of intelligent substation | |
| CN108846552B (en) | Distribution network automation terminal defect analysis system and method thereof | |
| CN104317868A (en) | Control integration method based on single-front and multi-SCADA (Supervisory Control and Data Acquisition) application | |
| CN104243218B (en) | A kind of communication of power system mode list preparation method based on more schedule constraints | |
| CN104199663A (en) | Comprehensive automated information table automatic generating method and system | |
| CN104578404A (en) | Online monitoring system for secondary equipment of power system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| ASS | Succession or assignment of patent right |
Owner name: STATE ELECTRIC NET CROP. Effective date: 20121015 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20121015 Address after: 200122 Shanghai City, Pudong New Area source deep road, No. 1122 Applicant after: Shanghai Electric Power Corporation Applicant after: State Grid Corporation of China Address before: 200122 Shanghai City, Pudong New Area source deep road, No. 1122 Applicant before: Shanghai Electric Power Corporation |
|
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120912 |