CN103049522A - Automatic substitution method for multi-data sources of electric quantity - Google Patents
Automatic substitution method for multi-data sources of electric quantity Download PDFInfo
- Publication number
- CN103049522A CN103049522A CN2012105553007A CN201210555300A CN103049522A CN 103049522 A CN103049522 A CN 103049522A CN 2012105553007 A CN2012105553007 A CN 2012105553007A CN 201210555300 A CN201210555300 A CN 201210555300A CN 103049522 A CN103049522 A CN 103049522A
- Authority
- CN
- China
- Prior art keywords
- data
- electric quantity
- substitutes
- server
- electric weight
- 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
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides an automatic substitution method for multi-data sources of electric quantity based on an automatic substitution method for the multi-data sources of the electric quantity. The system comprises an application server, a middleware server and a database server. The method includes the steps: S1, analyzing acquired electric quantity data by the application server and transmitting electric quantity missing data into the middleware server after packaging the electric quantity missing data when the electric quantity missing data are determined; S2, sequentially substituting the data sources of the packaged electric quantity missing data by the middleware server according to a priority distribution order and a substitution rule to form new packaged electric quantity data; and S3, storing the formed new packaged electric quantity data into the database server when the data sources of the electric quantity missing data are successfully substituted. In the automatic substitution method for the multi-data sources of the electric quantity, the electric quantity missing data can be automatically substituted by the aid of the middleware server, and the problem that subsequent real-time line loss analysis is affected by missing of electric energy acquisition data is solved.
Description
Technical field
The present invention relates to the electric power data acquisition system field, be specifically related to a kind of for the automatic method that substitutes of electric weight multi-data source.
Background technology
The electric energy information acquisition system realizes monitoring, management, analysis and the information issue to electric quantity data, and in such large database application system, the real time data type class of collection is various, and the data total amount is huge.Owing to reasons such as communication channel and data volume obstructions, can cause the part data acquisition disappearance.On the one hand; because acquisition server, application server and the database server of system often are deployed in different places; network topology more complicated each other; if according to general flow process with acquired data storage in database; cause in case going wrong between unusual or the application module appears in network data can not normal storage in database; the disappearance of data be can cause, the operational effect of system and normally carrying out of follow-up flow process affected.And the operational efficiency that the compensatory collection that system carries out missing data after Network Abnormal or software anomaly recovery and storage have reduced system.
More be to introduce how accurate, the real-time abnormal conditions that detect metering in the prior art, but do not solve the integrality that how under the loss of learning condition, to guarantee data message, satisfy the data access demand of user's use and other real-time functions, make the user obtain best experience.
Summary of the invention
The present invention relates to a kind of for the automatic method that substitutes of electric weight multi-data source, described method is based on being used for the automatic system that substitutes of electric weight multi-data source, described system comprises application server, middleware server and database server, described application server be connected database server and connect communication or directly connect communication by described middleware server;
Described method comprises:
Step S1, described application server is analyzed the electric quantity data that gathers, and when defining the electric weight missing data, imports described middleware server into after described electric weight missing data encapsulated;
The data source that step S2, the described middleware server electric weight missing data after according to described encapsulation carries out the electric weight missing data successively according to priority order and alternative rule substitutes the electric quantity data that forms new encapsulation;
Step S3, the electric quantity data with the new encapsulation of described formation when the data source of described electric weight missing data substitutes successfully deposits described database server in.
In the first preferred embodiment provided by the invention: among the described step S1, described application server reads the electric quantity data of described collection from described database server; The electric quantity data of described collection of reading is the electric quantity data of the described collection in certain time limit, and described certain time limit is set according to the cycle or the user's request that gather electric quantity data.
In the second preferred embodiment provided by the invention: among the described step S1, when described application server is analyzed rear judgement and do not had described electric weight missing data the electric quantity data of described collection, directly finish the process that described data source substitutes automatically.
In the 3rd preferred embodiment provided by the invention: among the described step S1, during the normal and described middleware server normal operation of network connection between described application server and the described middleware server, described application server directly call middleware interface with described encapsulation after the electric weight missing data be passed in the described middleware server; If described middleware server exists unusual or described application server recording exceptional event appears when unusual in network connection.
In the 4th preferred embodiment provided by the invention: among the described step S2, described data source substitutes and comprises that subtabulation substitutes, the opposite end circuit table substitutes, telemetry substitutes and other tables substitute;
Described priority is sequentially for selecting the order of described data source substitution tables, the user according to demand or the actual installation situation described priority is sequentially set.
In the 5th preferred embodiment provided by the invention: among the described step S2, determine described alternative rule according to the ammeter connection principle, described alternative rule comprises that normally alternative and intersection substitutes; Described normal substituting refers to substitute forward with/without the merit electric weight with forward with/without the merit electric weight, oppositely substitutes oppositely with/without the merit electric weight with/without the merit electric weight; Described intersection substitutes and refers to substitute oppositely with/without the merit electric weight with/without the merit electric weight with forward, oppositely substitutes forward with/without the merit electric weight with/without electric weight.
In the 6th preferred embodiment provided by the invention: among the described step S3, if it is unsuccessful that described data source substitutes, then described data source is substituted unsuccessful turkey information and deposit in the described database server, described turkey information comprises that described data source substitutes event and alternative failure cause.
In the 7th preferred embodiment provided by the invention: among the described step S3, when the data source of described electric weight missing data substitutes successfully, the electric quantity data of the new encapsulation of described formation is deposited in the distributed caching and object database of described database server, described distributed caching refers to be distributed in the memory database that the datarams buffer memory in a large amount of physical machines is set up, and described object database refers to be equipped with the database server of business data library software.
In the 8th preferred embodiment provided by the invention: if described distributed caching or described object database have obtained the electric quantity data of the new encapsulation of described formation, then described database server sends object information by calling interface to described application server, and described application server refreshes the electric quantity data of described collection according to described object information or ejects prompting frame and point out the electric quantity data needs of described collection to upgrade;
If described distributed caching and described object database all do not obtain the electric quantity data of the new encapsulation of described formation, then described database server returns abnormal information to described middleware server.
A kind of beneficial effect for the automatic method that substitutes of electric weight multi-data source provided by the invention comprises:
1, provided by the invention a kind of for the automatic method that substitutes of electric weight multi-data source, middleware server is set realizes automatically substituting of electric weight missing data, and the electric quantity data after will substituting deposits in the database server, solves the problem that the generated energy acquisition shortage of data affects follow-up real-time line loss analyzing.
2, the electric weight missing data is carried out multi-data source according to the priority order and select to substitute, the user can be according to demand or the actual installation situation priority order is set, adapt to the situation of different geographical.
3, the collection electric quantity data real-time Transmission after data source substitutes is advanced database server and application server, and stores synchronized has improved data storage quality, has guaranteed the smoothness operation of system, guarantees the system data information integrity.
Description of drawings
Be illustrated in figure 1 as a kind of structural representation for the automatic system that substitutes of electric weight multi-data source provided by the invention;
Be illustrated in figure 2 as a kind of process flow diagram for the automatic method that substitutes of electric weight multi-data source provided by the invention;
Be illustrated in figure 3 as the process flow diagram of the embodiment of a kind of method that automatically substitutes for the electric weight multi-data source provided by the invention.
Embodiment
The invention provides a kind of for the automatic method that substitutes of electric weight multi-data source, based on a kind of system that automatically substitutes for the electric weight multi-data source, the structural representation of this system as shown in Figure 1, comprise application server, middleware server and database server, application server is connected middleware server and connects communication or directly connect communication with database server.Based on the method flow diagram of this system as shown in Figure 2, comprising:
Step S1, application server is analyzed the electric quantity data that gathers, and when defining the electric weight missing data, imports middleware server into after this electric weight missing data encapsulated.
Step S2, middleware server substitutes the electric quantity data that forms new encapsulation according to the data source that the electric weight missing data after encapsulating carries out the electric weight missing data successively according to priority order and alternative rule.
Step S3, the electric quantity data of the new encapsulation that will form when the data source of electric weight missing data substitutes successfully deposits database server in.
Application server is connected with database server, among the step S1, application server reads the electric quantity data of collection from database server, and the electric quantity data of the collection that this reads is the electric quantity data that gathers in certain time limit, and this certain time limit can be set according to the cycle or the user's request that gather electric quantity data.
Be illustrated in figure 3 as the process flow diagram of the embodiment of a kind of method that automatically substitutes for the electric weight multi-data source provided by the invention, as shown in Figure 3, among the step S1, when application server is analyzed rear judgement and do not had the electric weight missing data the electric quantity data that gathers, directly finish the process that this data source substitutes automatically.And the network connection between application server and the middleware server is normal and during the middleware server normal operation; application server directly call middleware interface will encapsulate after the electric weight missing data be passed in the middleware server; if middleware server exists unusual or network connection occurs when unusual, application server records this anomalous event.
Among the step S2, data source substitutes and comprises that subtabulation substitutes, the opposite end circuit table substitutes, telemetry substitutes and other tables substitute,
The major-minor table refers to the Source of Gateway Meter at two ad eundems of same stoichiometric point installing, wherein a table is as master meter for public same set of voltage transformer (VT), current transformer and secondary circuit, in advance appointment, and the delivery clearing are used, another piece table is as subtabulation, and its electric weight uses as reference; The opposite end circuit table refers to install simultaneously electric energy meter at the circuit two ends, substitutes the data of opposite end electric energy meter with the data of a table wherein; Telemetry is replaced by uses the data by telemetry terminal system that receive by sensor to substitute.Priority order is namely selected the order of data source substitution tables, the user can be according to demand or the actual installation situation this priority is sequentially set.Alternative rule be divided into normal substitute and intersect substitute, refer to determine according to principles such as ammeter wiring; Normal substituting refers to substitute forward with/without the merit electric weight with forward with/without the merit electric weight, oppositely substitutes oppositely with/without the merit electric weight with/without the merit electric weight; Alternative the referring to of intersecting substitutes oppositely with/without the merit electric weight with/without the merit electric weight with forward, oppositely substitutes forward with/without the merit electric weight with/without electric weight.
Among the step S3, unsuccessful if data source substitutes, then data source is substituted unsuccessful turkey information and deposit in the database server, this turkey information comprises that data source substitutes event and alternative failure cause etc.When the data source of electric weight missing data substitutes successfully, the electric quantity data of the new encapsulation that forms is deposited in the distributed caching and object database of database server, distributed caching refers to be distributed in the memory database that the datarams buffer memory in a large amount of physical machines is set up, and object database refers to be equipped with the database server of business data library software.
If distributed caching or object database have obtained the electric quantity data of the new encapsulation of this formation, then database server sends object information by calling interface to application server, and application server refreshes the electric quantity data of collection or ejects the electric quantity data needs renewal that the prompting frame prompting gathers according to object information.If distributed caching and object database all do not obtain the electric quantity data of the new encapsulation of this formation, then database server returns abnormal information to middleware server.
Should be noted that at last: above embodiment is only in order to illustrate that technical scheme of the present invention is not intended to limit, although with reference to above-described embodiment the present invention is had been described in detail, those of ordinary skill in the field are to be understood that: still can make amendment or be equal to replacement the specific embodiment of the present invention, and do not break away from any modification of spirit and scope of the invention or be equal to replacement, it all should be encompassed in the middle of the claim scope of the present invention.
Claims (9)
1. one kind is used for the method that the electric weight multi-data source substitutes automatically, it is characterized in that, described method is based on being used for the automatic system that substitutes of electric weight multi-data source, described system comprises application server, middleware server and database server, described application server be connected database server and connect communication or directly connect communication by described middleware server;
Described method comprises:
Step S1, described application server is analyzed the electric quantity data that gathers, and when defining the electric weight missing data, imports described middleware server into after described electric weight missing data encapsulated;
The data source that step S2, the described middleware server electric weight missing data after according to described encapsulation carries out the electric weight missing data successively according to priority order and alternative rule substitutes the electric quantity data that forms new encapsulation;
Step S3, the electric quantity data with the new encapsulation of described formation when the data source of described electric weight missing data substitutes successfully deposits described database server in.
2. the method for claim 1 is characterized in that, among the described step S1, described application server reads the electric quantity data of described collection from described database server; The electric quantity data of described collection of reading is the electric quantity data of the described collection in certain time limit, and described certain time limit is set according to the cycle or the user's request that gather electric quantity data.
3. the method for claim 1 is characterized in that, among the described step S1, when described application server is analyzed rear judgement and do not had described electric weight missing data the electric quantity data of described collection, directly finishes the process that described data source substitutes automatically.
4. the method for claim 1, it is characterized in that, among the described step S1, during the normal and described middleware server normal operation of network connection between described application server and the described middleware server, described application server directly call middleware interface with described encapsulation after the electric weight missing data be passed in the described middleware server; If described middleware server exists unusual or described application server recording exceptional event appears when unusual in network connection.
5. the method for claim 1 is characterized in that, among the described step S2, described data source substitutes and comprises that subtabulation substitutes, the opposite end circuit table substitutes, telemetry substitutes and other tables substitute;
Described priority is sequentially for selecting the order of described data source substitution tables, the user according to demand or the actual installation situation described priority is sequentially set.
6. the method for claim 1 is characterized in that, among the described step S2, determines described alternative rule according to the ammeter connection principle, and described alternative rule comprises that normally alternative and intersection substitutes; Described normal substituting refers to substitute forward with/without the merit electric weight with forward with/without the merit electric weight, oppositely substitutes oppositely with/without the merit electric weight with/without the merit electric weight; Described intersection substitutes and refers to substitute oppositely with/without the merit electric weight with/without the merit electric weight with forward, oppositely substitutes forward with/without the merit electric weight with/without electric weight.
7. the method for claim 1, it is characterized in that, among the described step S3, if it is unsuccessful that described data source substitutes, then described data source is substituted unsuccessful turkey information and deposit in the described database server, described turkey information comprises that described data source substitutes event and alternative failure cause.
8. the method for claim 1, it is characterized in that, among the described step S3, when the data source of described electric weight missing data substitutes successfully, the electric quantity data of the new encapsulation of described formation is deposited in the distributed caching and object database of described database server, described distributed caching refers to be distributed in the memory database that the datarams buffer memory in a large amount of physical machines is set up, and described object database refers to be equipped with the database server of business data library software.
9. method as claimed in claim 8, it is characterized in that, if described distributed caching or described object database have obtained the electric quantity data of the new encapsulation of described formation, then described database server sends object information by calling interface to described application server, and described application server refreshes the electric quantity data of described collection according to described object information or ejects prompting frame and point out the electric quantity data needs of described collection to upgrade;
If described distributed caching and described object database all do not obtain the electric quantity data of the new encapsulation of described formation, then described database server returns abnormal information to described middleware server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210555300.7A CN103049522B (en) | 2012-12-19 | 2012-12-19 | A kind of method automatically substituted for electricity multi-data source |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210555300.7A CN103049522B (en) | 2012-12-19 | 2012-12-19 | A kind of method automatically substituted for electricity multi-data source |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103049522A true CN103049522A (en) | 2013-04-17 |
| CN103049522B CN103049522B (en) | 2016-01-20 |
Family
ID=48062163
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210555300.7A Active CN103049522B (en) | 2012-12-19 | 2012-12-19 | A kind of method automatically substituted for electricity multi-data source |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103049522B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104200395A (en) * | 2014-08-22 | 2014-12-10 | 国家电网公司 | Technology for achieving missing data intelligent automatic additional recording based on automatic additional recording strategy definition |
| CN106169160A (en) * | 2016-06-01 | 2016-11-30 | 国网河北省电力公司电力科学研究院 | A kind of electricity abnormity diagnosis based on critical point power system and electricity complementing method |
| CN111127247A (en) * | 2019-11-21 | 2020-05-08 | 深圳供电局有限公司 | Electric quantity data acquisition method and device, computer equipment and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1581241A (en) * | 2003-08-15 | 2005-02-16 | 深圳市科陆电子科技股份有限公司 | Long-distance collecting method for electric power |
| US20060026209A1 (en) * | 2002-09-05 | 2006-02-02 | Garth Burrill | System and method for processing control data |
| CN101707399A (en) * | 2009-11-20 | 2010-05-12 | 深圳市科陆电子科技股份有限公司 | Method and system for acquiring electric energy information |
| CN101719315A (en) * | 2009-12-23 | 2010-06-02 | 山东大学 | Method for acquiring dynamic traffic information based on middleware |
| CN102651116A (en) * | 2012-03-31 | 2012-08-29 | 上海市电力公司 | Power load data refining method |
| CN102654531A (en) * | 2011-03-04 | 2012-09-05 | 河南电力试验研究所 | Remedying method and remedying device of lacked electric energy qualitative data |
| CN102692558A (en) * | 2011-03-23 | 2012-09-26 | 沈阳易讯科技股份有限公司 | Monitoring and analyzing system for electricity data and realization method thereof |
-
2012
- 2012-12-19 CN CN201210555300.7A patent/CN103049522B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060026209A1 (en) * | 2002-09-05 | 2006-02-02 | Garth Burrill | System and method for processing control data |
| CN1581241A (en) * | 2003-08-15 | 2005-02-16 | 深圳市科陆电子科技股份有限公司 | Long-distance collecting method for electric power |
| CN101707399A (en) * | 2009-11-20 | 2010-05-12 | 深圳市科陆电子科技股份有限公司 | Method and system for acquiring electric energy information |
| CN101719315A (en) * | 2009-12-23 | 2010-06-02 | 山东大学 | Method for acquiring dynamic traffic information based on middleware |
| CN102654531A (en) * | 2011-03-04 | 2012-09-05 | 河南电力试验研究所 | Remedying method and remedying device of lacked electric energy qualitative data |
| CN102692558A (en) * | 2011-03-23 | 2012-09-26 | 沈阳易讯科技股份有限公司 | Monitoring and analyzing system for electricity data and realization method thereof |
| CN102651116A (en) * | 2012-03-31 | 2012-08-29 | 上海市电力公司 | Power load data refining method |
Non-Patent Citations (1)
| Title |
|---|
| 李苏扬: "基于J2EE架构的电能量计量系统设计与实现", 《中国优秀硕士学位论文全文数据库工程科技辑Ⅱ辑》, no. 01, 15 January 2010 (2010-01-15) * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104200395A (en) * | 2014-08-22 | 2014-12-10 | 国家电网公司 | Technology for achieving missing data intelligent automatic additional recording based on automatic additional recording strategy definition |
| CN106169160A (en) * | 2016-06-01 | 2016-11-30 | 国网河北省电力公司电力科学研究院 | A kind of electricity abnormity diagnosis based on critical point power system and electricity complementing method |
| CN111127247A (en) * | 2019-11-21 | 2020-05-08 | 深圳供电局有限公司 | Electric quantity data acquisition method and device, computer equipment and storage medium |
| CN111127247B (en) * | 2019-11-21 | 2024-01-19 | 深圳供电局有限公司 | Electric quantity data acquisition method, device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103049522B (en) | 2016-01-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| RU2518178C2 (en) | System and method for control of electric power system | |
| CN105915398B (en) | Rural power grid fault based rapid detection and power restoration system and concentrator detection method thereof | |
| JP5932668B2 (en) | Utility grid command filter system | |
| CN106556765B (en) | The test method and RTDS emulator of distributed distribution automation system | |
| CN106712001A (en) | Data modeling method for network message recording analysis device | |
| CN102355368B (en) | Fault processing method of network equipment and system | |
| CN102323499A (en) | Method for automatically testing relay protection equipment | |
| CN106357305A (en) | Self-networking method, device and system of tree structure network | |
| CN103095498B (en) | Bill record collection method and system | |
| CN105957321A (en) | Power utilization information acquisition method based on object-oriented system architecture | |
| CN112235250B (en) | Method and system for acquiring data of distribution room in minute-level same frequency | |
| CN105319482A (en) | Power distribution network fault diagnosis system and method based on multi-source information fusion | |
| CN104123134A (en) | Intelligent electricity use data management method and system based on AMI and J2EE | |
| CN108400993A (en) | The Internet of things system and storage medium that intelligent industrial apparatus components formula is set up | |
| CN113517688B (en) | Low-voltage area topology identification method and computer medium | |
| CN113300356B (en) | Low-voltage distribution area topology identification method | |
| CN102157057A (en) | Wi-Fi (Wireless Fidelity)-based wireless meter reading device | |
| KR101256944B1 (en) | System and method for data recovery for automatic meter reading system | |
| CN113036930B (en) | Power grid data communication management system | |
| CN102571429B (en) | A kind of OO intelligent power distribution communication business analyzing method and related device | |
| CN110995785A (en) | Low-voltage distribution network cloud platform based on Internet of things | |
| CN102404760B (en) | Method and device for real-time measurement of system performance | |
| CN110677286A (en) | Power failure alarm monitoring method, device and system | |
| CN103049522A (en) | Automatic substitution method for multi-data sources of electric quantity | |
| CN107918273A (en) | A kind of application system of mobile technology of Internet of things on halved belt sorter |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |