CN105574065A - Method for counting leakage point rate of real-time data - Google Patents
Method for counting leakage point rate of real-time data Download PDFInfo
- Publication number
- CN105574065A CN105574065A CN201510618644.1A CN201510618644A CN105574065A CN 105574065 A CN105574065 A CN 105574065A CN 201510618644 A CN201510618644 A CN 201510618644A CN 105574065 A CN105574065 A CN 105574065A
- Authority
- CN
- China
- Prior art keywords
- module
- data
- leak source
- real time
- source rate
- 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
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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical 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/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Probability & Statistics with Applications (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Fuzzy Systems (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for counting leakage point rate of real-time data. The method comprises the following steps of storing all real-time data test point information required to be accessed to a real-time historical database in an oracle table; carrying out refresh data time point recording on a test point of refresh data by an interface program when the real-time data of a cross section is submitted to the real-time historical database every time, and counting the test points of which the real-time data is not submitted respectively according to supervisory control and data acquisition (SCADA) and an electric energy leakage point rate formula; writing the counted leakage point rate of each cross section in a dss_statistics table by the interface program; counting an average value of all-day leakage point rates of the leakage points in the dss_statistics table; giving out a warning short message when the all-day leakage point rate reaches 20%; and generating leakage point rate report information and displaying the information. By the method, the operation and maintenance difficulty of an operation and maintenance worker is reduced, the data quality is improved, and a solid foundation is laid for a service system to normally use the real-time data.
Description
Technical field
The present invention relates to a kind of method to real time data leak source rate statistics, the invention belongs to power system information communication technical field.
Background technology
2012, Zhejiang company and state's net DianKeYuan shared Liao Guowang corporate HQ science and technology item " distribution type real-time database management system is researched and developed and application ", Zhejiang company is supporting simultaneously " applied research of domestic distribution type real-time database management system " and " magnanimity history/real-time data base data service capabilities intelligent optimization research " Liang Ge county telephone central office pilot study project.Carry out through pilot work, accessed typical apply system data, demonstrate the security of data access, stability, reliability and maintainability; Move existing typical apply, demonstrate the convenience of migration; Start with from personalize development and centralized exploitation two aspect, respectively model regions office with different mode developments typical case new opplication, demonstrate new opplication exploitation convenience.Therefore, Zhejiang power grid in real time/historical data platform possessed and popularized the condition implemented in an all-round way on the basis of summing up research and development in early stage, pilot.
Zhejiang power grid real-time history data management system has accessed the real time data of multiple production system such as the whole province ground, city-level SCADA system, electric energy system.Along with the access of distribution data, also can be more to the demand of Real-time Alarm.
Along with project is carried out, a large amount of real time data measuring points is integrated into Hisoon database, service application is more and more higher to data quality requirements, needs a kind of method can monitor in real time the quality of data access, and can send warning information to maintainer when going wrong.
Summary of the invention
The present invention seeks to by monitoring the real time data quality of data access interface, record the measuring point quantity that every secondary data does not write data, the mean value of statistics leak source rate every day, when leak source rate reaches threshold values, system sends alarm message to operation maintenance personnel, and notice operation maintenance personnel docking port program and data source systems carry out quality of data inspection, reduces the O&M difficulty of operation maintenance personnel, improve the quality of data, for operation system normally uses real time data to lay a solid foundation.
Technical scheme of the present invention is as follows:
To a method for real time data leak source rate statistics, specifically comprise the steps:
Step one: will need all real time data measuring point information being linked into real time historical database application platform, is stored in oracle table;
Step 2: interface routine is when submitting section real time data to data to real time historical database each time, renewal data time point record is carried out to the measuring point of more new data, to the measuring point not submitting real time data to, add up according to SCADA and electric flux leak source rate formula respectively;
Step 3: set up dss_statistics table, the leak source rate that each section is added up by interface routine is written in dss_statistics table;
Step 4: whole day leak source rate mean value statistics is carried out to the leak source rate in dss_statistics table;
Step 5: when whole day leak source rate reaches 20%, send alarm message to system operation maintenance personnel;
Step 6: generate leak source rate report messages, carry out relative information displaying.
Further, described real time historical database application platform is connected with other system end with user side respectively;
Described user side comprises enterprise portal unit, and described enterprise portal unit comprises Unified Identity library module, application access module and single-sign-on module, and some enterprise customers set up contact by user side and real time historical database application platform;
Described real time historical database application platform comprises system authentication service module, message center console module, HTTP service module, business application module, base application module, system interface service module, HS database platform module, oracle database module; User's synchronizing information of described enterprise portal transfers to system authentication service module, and system authentication service module intercoms mutually with message center console module and business application module, and message center console module intercoms mutually with business application module; Described application access module is intercomed with business application module mutually by HTTP service module, described single-sign-on module is connected with base application module with business application module respectively by HTTP service module, business application module intercoms mutually with base application module, system interface service module and HS database platform module respectively, and base application module intercoms mutually with system interface service module and oracle database module;
The information of described real time historical database application platform exports the other system end comprising PMS production management system, marketing management system, dispatching management information system to.
Further, the leak source rate of described SCADA is: (the measuring point sum of the current E file measuring point number/forms data source interface of 1-forms data source interface) × 100%.
Further, the leak source rate of described electric flux is the leak source rate of mending trick the same day for the last time, for: (the effective forward of 1-meritorious total/electricity measuring point number) × 100%, because electricity measuring point have employed timesharing compression, get typical data and judge.
Further, the drain conditions of data comprises interface name, leak source rate, start time and end time, leak source reason.
Beneficial effect of the present invention is as follows:
Data leak source statistics is the one of data quality monitoring, by interface operating statistic instrument Real-time Monitoring Data access interface ruuning situation.After alarm platform is subscribed to, the interface message of data leak source rate more than 20% is sent to booking reader by alarm instrument, thus makes business personnel understand data run situation better, and save time cost, increases work efficiency.
Accompanying drawing explanation
Fig. 1 is system logic architecture figure.
Fig. 2 is data leak source statistics application surface chart.
Fig. 3 is dss_statistics list structure figure.
Fig. 4 is architectural schemes figure of the present invention.
Embodiment
Below in conjunction with accompanying drawing, the present invention is described in further detail.
The data leak source rate statistical project of a kind of method to real time data leak source rate statistics of the present invention is as follows:
The interface message of data leak source situation display data interface leak source rate more than 20%, the leak source rate of SCADA refers to (the measuring point sum of the current E file measuring point number/forms data source interface of 1-forms data source interface) × 100%;
The leak source rate of electric flux refers to the leak source rate of mending trick the same day for the last time, computing formula: (the effective forward of 1-meritorious total/electricity measuring point number) × 100% (because electricity measuring point have employed timesharing compression, get typical data and judge);
Data leak source situation comprises:
Interface name: the title of access interface.
Leak source rate: as above-mentioned leak source rate definition.
Start time and end time: the initial time of statistics and end time.
Leak source reason: the reason of data-interface leak source.
This information is after alarm platform is subscribed to, and the interface message of data leak source rate more than 20% is sent to booking reader by alarm instrument.
Leakage rate statistics implementation method is as follows:
Step one: will need all real time data measuring point information being linked into real time historical database application platform, is stored in oracle table;
Step 2: interface routine is when submitting section real time data to data to real time historical database each time, renewal data time point record is carried out to the measuring point of more new data, to the measuring point not submitting real time data to, add up according to SCADA and electric flux leak source rate formula respectively;
Step 3: set up dss_statistics table, the leak source rate that each section is added up by interface routine is written in dss_statistics table;
Step 4: real time historical database application platform arranges DSS_UPDATE2 storing process, morning every day, DSS_UPDATE2 storing process carried out whole day leak source rate mean value statistics to the leak source rate in dss_statistics table;
Step 5: real time historical database application platform comprises alarm api interface, when whole day leak source rate reaches 20%, calls alarm api interface, sends alarm message to system operation maintenance personnel;
Step 6: generate leak source rate report messages, carry out relative information displaying.
As embodiments of the invention, described real time historical database application platform is connected with other system end with user side respectively, and its system logic architecture figure as shown in Figure 1.
User side comprises enterprise portal unit, and described enterprise portal unit comprises Unified Identity library module, application access module and single-sign-on module, and some enterprise customers set up contact by user side and real time historical database application platform;
Real time historical database application platform comprises system authentication service module, message center console module, HTTP service module, business application module, base application module, system interface service module, HS database platform module, oracle database module; User's synchronizing information of described enterprise portal transfers to system authentication service module, and system authentication service module intercoms mutually with message center console module and business application module, and message center console module intercoms mutually with business application module; Described application access module is intercomed with business application module mutually by HTTP service module, described single-sign-on module is connected with base application module with business application module respectively by HTTP service module, business application module intercoms mutually with base application module, system interface service module and HS database platform module respectively, and base application module intercoms mutually with system interface service module and oracle database module;
The information of real time historical database application platform exports the other system end comprising PMS production management system, marketing management system, dispatching management information system to.
Data leak source statistics application interface of the present invention as shown in Figure 2; Dss_statistics list structure as shown in Figure 3.
Architectural schemes of the present invention is as shown in Figure 4:
The application of alarm api interface establishes protocols call according to state's net allusion quotation, adopts deployment/operational mode of concentrating greatly of the whole province, by application deployment Zhejiang power grid in real time/historical data application platform.
The feature of this architectural schemes is: 1) each producer develops different business modules separately, under packing is deployed to an App after merging; 2) each producer adopts unified technology path, Development Framework instrument.
The advantage of this architectural schemes is: 1) respectively develop packing and issuing in the application sets of unit and, in an application, achieve unifying user authentication, information department management and rights management; 2) adopt identical technology path and Development Framework, after being conducive to applying to development, the operation in later stage is promoted.
The shortcoming of this architectural schemes is: the technology path that constituent parts must be unified, and technological frame needs to select, and development teams needs to adjust technically.
Application platform general frame is:
1) application platform is based on J2EE framework
In real time/historical data application platform will adopt J2EE framework, and all application modules will operate in a unified WebAPP.
2) message desk
Application platform, by providing message service, comprising directly access Outside Mail system and short-message system, notifying function for providing message in business application module.
The foregoing is only preferred embodiment of the present invention, not in order to limit the present invention.All any amendments done within the spirit and principles in the present invention, equivalent replacement and improvement etc., all should be included within protection scope of the present invention.
Claims (5)
1., to a method for real time data leak source rate statistics, specifically comprise the steps:
Step one: will need all real time data measuring point information being linked into real time historical database application platform, is stored in oracle table;
Step 2: interface routine is when submitting section real time data to data to real time historical database each time, renewal data time point record is carried out to the measuring point of more new data, to the measuring point not submitting real time data to, add up according to SCADA and electric flux leak source rate formula respectively;
Step 3: set up dss_statistics table, the leak source rate that each section is added up by interface routine is written in dss_statistics table;
Step 4: whole day leak source rate mean value statistics is carried out to the leak source rate in dss_statistics table;
Step 5: when whole day leak source rate reaches 20%, send alarm message to system operation maintenance personnel;
Step 6: generate leak source rate report messages, carry out relative information displaying.
2. a kind of method to real time data leak source rate statistics according to claim 1, is characterized in that: described real time historical database application platform is connected with other system end with user side respectively;
Described user side comprises enterprise portal unit, and described enterprise portal unit comprises Unified Identity library module, application access module and single-sign-on module, and some enterprise customers set up contact by user side and real time historical database application platform;
Described real time historical database application platform comprises system authentication service module, message center console module, HTTP service module, business application module, base application module, system interface service module, HS database platform module, oracle database module; User's synchronizing information of described enterprise portal transfers to system authentication service module, and system authentication service module intercoms mutually with message center console module and business application module, and message center console module intercoms mutually with business application module; Described application access module is intercomed with business application module mutually by HTTP service module, described single-sign-on module is connected with base application module with business application module respectively by HTTP service module, business application module intercoms mutually with base application module, system interface service module and HS database platform module respectively, and base application module intercoms mutually with system interface service module and oracle database module;
The information of described real time historical database application platform exports the other system end comprising PMS production management system, marketing management system, dispatching management information system to.
3. a kind of method to real time data leak source rate statistics according to claim 1 and 2, is characterized in that: the leak source rate of described SCADA is: (the measuring point sum of the current E file measuring point number/forms data source interface of 1-forms data source interface) × 100%.
4. a kind of method to real time data leak source rate statistics according to claim 1 and 2, it is characterized in that: the leak source rate of described electric flux is the leak source rate of mending trick the same day for the last time, for: (the effective forward of 1-meritorious total/electricity measuring point number) × 100%, because electricity measuring point have employed timesharing compression, get typical data and judge.
5. a kind of method to real time data leak source rate statistics according to claim 1 and 2, is characterized in that: the drain conditions of data comprises interface name, leak source rate, start time and end time, leak source reason.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510618644.1A CN105574065A (en) | 2015-09-25 | 2015-09-25 | Method for counting leakage point rate of real-time data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510618644.1A CN105574065A (en) | 2015-09-25 | 2015-09-25 | Method for counting leakage point rate of real-time data |
Publications (1)
Publication Number | Publication Date |
---|---|
CN105574065A true CN105574065A (en) | 2016-05-11 |
Family
ID=55884201
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510618644.1A Pending CN105574065A (en) | 2015-09-25 | 2015-09-25 | Method for counting leakage point rate of real-time data |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN105574065A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107436924A (en) * | 2017-07-07 | 2017-12-05 | 国网浙江省电力公司信息通信分公司 | A kind of real-time data imputing system quality monitoring method based on magnanimity big data platform |
CN107608804A (en) * | 2017-09-21 | 2018-01-19 | 山东浪潮云服务信息科技有限公司 | A kind of task processing system and method |
CN111310782A (en) * | 2019-12-31 | 2020-06-19 | 国网浙江省电力有限公司电力科学研究院 | Label generation method for operation and maintenance of power acquisition equipment |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101247277A (en) * | 2007-02-15 | 2008-08-20 | 华为技术有限公司 | Alarm method and device |
WO2012039684A2 (en) * | 2010-09-23 | 2012-03-29 | Eutech Cybernetic Pte Ltd | Computer implemented method and system for integrating multiple building systems and business applications |
CN102566546A (en) * | 2012-01-13 | 2012-07-11 | 冶金自动化研究设计院 | Alarm statistic and aided scheduling system of process data |
CN104317603A (en) * | 2014-11-13 | 2015-01-28 | 国电南京自动化股份有限公司 | Intelligent alarm system based on SCADA (supervisory control and data acquisition) system |
-
2015
- 2015-09-25 CN CN201510618644.1A patent/CN105574065A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101247277A (en) * | 2007-02-15 | 2008-08-20 | 华为技术有限公司 | Alarm method and device |
WO2012039684A2 (en) * | 2010-09-23 | 2012-03-29 | Eutech Cybernetic Pte Ltd | Computer implemented method and system for integrating multiple building systems and business applications |
CN102566546A (en) * | 2012-01-13 | 2012-07-11 | 冶金自动化研究设计院 | Alarm statistic and aided scheduling system of process data |
CN104317603A (en) * | 2014-11-13 | 2015-01-28 | 国电南京自动化股份有限公司 | Intelligent alarm system based on SCADA (supervisory control and data acquisition) system |
Non-Patent Citations (2)
Title |
---|
刘志军 等: "数字化变电站电能计量技术研究", 《2008中国电力系统保护与控制学术研讨会论文集》 * |
刘笑天 等: "SIS实时历史数据库应用建议", 《电力信息化》 * |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107436924A (en) * | 2017-07-07 | 2017-12-05 | 国网浙江省电力公司信息通信分公司 | A kind of real-time data imputing system quality monitoring method based on magnanimity big data platform |
CN107608804A (en) * | 2017-09-21 | 2018-01-19 | 山东浪潮云服务信息科技有限公司 | A kind of task processing system and method |
CN111310782A (en) * | 2019-12-31 | 2020-06-19 | 国网浙江省电力有限公司电力科学研究院 | Label generation method for operation and maintenance of power acquisition equipment |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105915398B (en) | Rural power grid fault based rapid detection and power restoration system and concentrator detection method thereof | |
CN103595816B (en) | Expense plateform system is urged in power marketing integration | |
CN106651643A (en) | Power security management and control method for whole process based on distribution and adjustment | |
CN103632312A (en) | Power grid resource module building method based on GIS (geographic information system) | |
CN102082826A (en) | Electric energy data cloud collection system and method | |
CN103246630A (en) | Distribution network integrated platform information integration method based on model data center | |
CN102118446A (en) | WEB-based high-performance intelligent reporting system | |
CN105574065A (en) | Method for counting leakage point rate of real-time data | |
CN103971204A (en) | Enterprise power dispatching and distributing method and system and virtual power storage station system | |
CN110555583A (en) | method for uniformly processing wide-area operation data of intelligent power grid dispatching control system | |
CN105025511A (en) | Energy consumption real time monitoring method of mobile communication base station | |
US9047757B2 (en) | Systems and methods for remotely controlling an advanced metering infrastructure | |
CN205121640U (en) | Distribution fault handling information interaction terminal based on remove operation technology | |
CN211180055U (en) | Power failure and restoration analysis and emergency repair management system | |
CN103475091A (en) | Electric-energy metering and managing system of power grid gateway | |
CN105577467A (en) | Real-time data interruption rate statistical method | |
CN106446177A (en) | Factory digitalization real-time fine management system | |
CN110146786A (en) | Multi-user based on low-voltage distribution net topology reports Fault Locating Method for repairment | |
CN115276233A (en) | Intelligent operation and maintenance system for urban rail subway power supply | |
CN106934538B (en) | Power grid data fusion method based on data blood relationship and gene comparison | |
CN104966152B (en) | Electric power safety production management system | |
CN112446619B (en) | Power distribution network rush-repair processing method and device | |
CN108694508B (en) | Management and control method and system based on operation and inspection service | |
CN105574602A (en) | Alarming method for third party to call application program interface (API) | |
CN108303956B (en) | Automatic on-duty centralized monitoring system for power grid dispatching |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160511 |
|
RJ01 | Rejection of invention patent application after publication |