CN103246695A - Integrating method of HighSoon real-time database and IES600P system - Google Patents
Integrating method of HighSoon real-time database and IES600P system Download PDFInfo
- Publication number
- CN103246695A CN103246695A CN2013100832910A CN201310083291A CN103246695A CN 103246695 A CN103246695 A CN 103246695A CN 2013100832910 A CN2013100832910 A CN 2013100832910A CN 201310083291 A CN201310083291 A CN 201310083291A CN 103246695 A CN103246695 A CN 103246695A
- Authority
- CN
- China
- Prior art keywords
- real
- data base
- time
- time data
- database
- 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
Images
Abstract
The invention discloses an integrating method of a HighSoon real-time database and an IES600P system, and belongs to the technical field of electrical system scheduling automation. A hybrid storage environment of the real-time database and a relational database is supported by the system firstly; then, an overall configuration environment of the system, database deployment strategies and the like are updated appropriately; and database access interfaces of the system are unified to shield direct accesses to the real-time database. With the integrating method, integration is achieved on the condition of guaranteeing stable system operation, and data storage accuracy, query efficiency and support for fine applications of the system are improved completely.
Description
Technical field
The invention belongs to the dispatching automation of electric power systems technical field, particularly relate to the integrated approach of a kind of real-time data base and intelligent grid dispatching technique back-up system.
Background technology
Hisoon real-time data base (HighSoon, be called for short HS) be the flagship product of China Realtime Database Co., Ltd., the Hisoon real-time data base has ultra-large data-handling capacity and leading mixing compress technique, adopt the distributed system framework, can run on different operating system platforms, realize automatic collection, the compression storage of historical data, query and search and the statistical study efficiently of magnanimity real time data, can online storage the several years historical data of hundreds thousand of even up to ten million collection points, acquisition resolution can reach delicate.The Hisoon real-time data base provides a series of external member application tool and complete secondary development environment.
IES600Pro is a cover automation system for the power network dispatching of designing and developing at power scheduling production division, this system adopts advanced design philosophy and realization means, and the application of dispatch automated system is monitored to bring up to control and realizes the senior operational management of electrical network and realize that the technology support system aspect of electrical network analysis type scheduling comes from participating in electric power netting safe running simply.
IES600Pro adopts advanced opening architecture, realized the opening from the system platform layer to the application layer, for the user provides good portability, interoperability and distributivity, make things convenient for the user to carry out the sustainable expansion of application level function, enable to adapt to the business demand that Automation of Electric Systems constantly changes, really accomplished open to the outside world is extended to the user.
But along with the continuous expansion of power grid construction scale, what researchs such as intelligent grid, intelligent substation were used deepens continuously, and the collection point that dispatch automated system is faced is more and more.Low frequency had been difficult to satisfy the requirement of electrical network fine-grained management according to the history data store of minute level in the past, and holographic all details of operation of power networks of preserving have become trend of the times, original periodicity historical data preserving type can not meet the demands, should store according to the actual real-time continuous that changes, to satisfy the more applications demand, this also will cause the growth of tens of times of data storage size; Simultaneously, the storage organization strategy of historical data and query and search strategy also will become quite complicated.Traditional relational database all will be difficult to satisfy demands of applications on response speed, storage size, search efficiency and variation memory mechanism.
The Hisoon real-time data base be used for specially handling target magnanimity when having in real time/database of historical data, have very high storage speed, query and search efficient and data compression ratio.But in current dispatch automated system IES600Pro, still adopt relational database (Oracle) to preserve time series data.Can't holographicly preserve the operation of power networks record for resolution system, inquiry velocity is slow, and problems such as the analytical applications that becomes more meticulous difficulty need to carry out real-time data base and intelligent grid dispatching technique back-up system integrated.Exploitation realizes in order to realize the integrated of real-time data base and intelligent grid dispatching technique back-up system just in the present invention.
Summary of the invention
At relational database in the prior art and real-time data base can't be integrated problem, the present invention proposes a kind of real-time data base and be integrated into method in the intelligent grid dispatching technique back-up system, realized the integrated of Hisoon real-time data base and IES600P system.This method realizes integrated under the condition that guarantees system stable operation, improves data storage precision, search efficiency and the supporting dynamics to becoming more meticulous and using of system comprehensively.
Specifically, the present invention takes following technical scheme to realize, comprises the following steps:
1) the overall data lab environment of system is expanded to by the real-time storehouse of internal memory, relational database and real-time data base constitutes jointly, wherein relational database is used for store electricity pessimistic concurrency control and static parameter and passes through to adorn down generating the real-time storehouse of internal memory to satisfy the high speed access to model and static parameter, and real-time data base then is used for preserving the time series data of the variation that has time mark intactly to record the running orbit of electrical network;
2) in the configuration surroundings of system, increase the real-time data base server, and use disk array as the storage medium of real-time data base;
3) the unified Access Management Access layer of the real-time storehouse of the internal memory in the podium level of system and relational database, middle increase comprise inquiry, storage and management request to real-time data base to the access portion of real-time data base.
Beneficial effect of the present invention is as follows: the present invention has realized the integrated of Hisoon real-time data base and intelligent grid scheduling IES600Pro system, characteristic in conjunction with real-time data base, can realize changing memory mechanism based on the operation of power networks of overall process, make sampled data submit to frequency to rise to a second rank from an original minute rank, the operating analysis of monitoring for regional power grid scheduling that becomes more meticulous provides advanced technological means and strong data support.
Description of drawings
Accompanying drawing 1 is the IES600P configuration surroundings synoptic diagram based on real-time data base of the inventive method.
Accompanying drawing 2 is the preposition transformation maps of the data acquisition of the inventive method.
Accompanying drawing 3 is data access mode figure of the inventive method.
Accompanying drawing 4 is effect contrast figures of the inventive method.
Embodiment
Below in conjunction with accompanying drawing, describe the present invention.
The functional specification of regional intelligent grid dispatching technique back-up system is followed in technical scheme strictness of the present invention, carry out integrated exploitation in system, at first make system support the storage environment that mixes of real-time data base and relational database, correspondingly, the configured in one piece environment of system, database deployment strategy etc. all will suitably be upgraded; Secondly need the database access interface of integrated system, shielding is to the direct visit of real-time data base.
Technical matters to be solved by this invention is: a kind of system integration method is provided, it is integrated to make that Hisoon real-time data base and intelligent grid scheduling IES600Pro system is able to, and realizes that on the basis that guarantees system stable operation intelligent grid scheduling IES600Pro system is to the holographic recording of operation of power networks process and the efficient inquiry of data.In order to solve the problems of the technologies described above, the present invention has adopted following technical scheme.Comprise following components:
(1) to the construction scheme of system data lab environment.The overall data lab environment of system expanded to by the real-time storehouse of internal memory, relational database and real-time data base constitute jointly.Electric network model and static parameter adopt relational database to store in actual applications, and generate the real-time storehouse of internal memory to satisfy the high speed access to model and static parameter by adorning down; Real-time data base then is mainly used to preserve the time series data of the variation that has time mark, the running orbit of this part data integrity ground record electrical network.
(2) to the construction scheme of system configuration environment.In order to increase real-time data base, in the configuration surroundings of system, increase the real-time data base server, use disk array as the storage medium of real-time data base.
(3) the unified encapsulation scheme of database access interface.In the podium level of system, the unified Access Management Access layer that the real-time storehouse of pair internal memory and relational database are arranged, in order to satisfy the demand to the real-time data base visit, in this Access Management Access layer, increase the access portion to real-time data base, comprise inquiry, storage and other management requests to real-time data base, guarantee that like this access layer externally remains transparent, uses concrete memory location and the file layout of not knowing various data.
Particularly, as shown in Figure 1, service in real time receives the data of preposition collection, send to communication bus after handling, the client that need obtain or other services can be by registering to communication bus, just can submit request of data to real-time service by communication bus afterwards, receive data then.The work of Hisoon real time data interface is exactly this mode of API that the data that will receive provide by calling Hisoon, and real time data is offered the real-time storehouse of Hisoon.
When being integrated into the Hisoon real-time data base in the intelligent grid scheduling IES600P system, at first to carry out the upgrading construction of database environment.As shown in Figure 2, in data acquisition system (DAS), increase the real-time data base server, data dispatching is directly deposited in concerned the storehouse and in real time in the storehouse, and in the uniform database access layer, increased real-time data base access interface part.System's upper layer application is by the visit of uniform database access layer realization to real-time data base, and the storage mode of data is to change the i.e. mode of storage, and this partial data submission frequency height, and data volume is big.
As shown in Figure 3, data access is simultaneously from concerning storehouse and real-time storehouse visit data.Need to be encapsulated into the access interface of real-time data base in the database access administration layer of systematic unity, guarantee that database access externally is transparent.Inquiry, storage and management at the podium level real-time data base also encapsulates in addition, and unified interface is provided, and comprises parts such as real-time data base status surveillance, sampled point definition, data submission and data query.
As shown in Figure 4, adopted the inventive method after, its system effectiveness has had remarkable lifting than simple employing relational database (Oracle), is all showing great superiority aspect a plurality of systematic parameters.
Though the present invention is with preferred embodiment openly as above, embodiment be not limit of the present invention.Without departing from the spirit and scope of the invention, any equivalence of doing changes or retouching, belongs to the present invention's protection domain equally.Therefore protection scope of the present invention should be standard with the application's the content that claim was defined.
Claims (1)
1. the integrated approach of Hisoon real-time data base and IES600P system is characterized in that, comprises the following steps:
1) the overall data lab environment of system is expanded to by the real-time storehouse of internal memory, relational database and real-time data base constitutes jointly, wherein relational database is used for store electricity pessimistic concurrency control and static parameter and passes through to adorn down generating the real-time storehouse of internal memory to satisfy the high speed access to model and static parameter, and real-time data base then is used for preserving the time series data of the variation that has time mark intactly to record the running orbit of electrical network;
2) in the configuration surroundings of system, increase the real-time data base server, and use disk array as the storage medium of real-time data base;
3) the unified Access Management Access layer of the real-time storehouse of the internal memory in the podium level of system and relational database, middle increase comprise inquiry, storage and management request to real-time data base to the access portion of real-time data base.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013100832910A CN103246695A (en) | 2013-03-15 | 2013-03-15 | Integrating method of HighSoon real-time database and IES600P system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013100832910A CN103246695A (en) | 2013-03-15 | 2013-03-15 | Integrating method of HighSoon real-time database and IES600P system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103246695A true CN103246695A (en) | 2013-08-14 |
Family
ID=48926215
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013100832910A Pending CN103246695A (en) | 2013-03-15 | 2013-03-15 | Integrating method of HighSoon real-time database and IES600P system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103246695A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104792362A (en) * | 2015-04-14 | 2015-07-22 | 国家电网公司 | Method for monitoring load and temperature of 10kV switching station and based on Hisoon database |
| CN108256079A (en) * | 2018-01-18 | 2018-07-06 | 杭州吉利易云科技有限公司 | A kind of Product Manufacturing Information obtains systems, devices and methods |
| CN108595254A (en) * | 2018-03-09 | 2018-09-28 | 北京永洪商智科技有限公司 | A kind of query scheduling method |
| CN109062960A (en) * | 2018-06-26 | 2018-12-21 | 国电南瑞科技股份有限公司 | Electric network model and real time data decoupling method in electric power scheduling automatization system |
| CN111400284A (en) * | 2020-03-20 | 2020-07-10 | 广州咨元信息科技有限公司 | Method for establishing dynamic anomaly detection model based on performance data |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20050028411A (en) * | 2003-09-18 | 2005-03-23 | 동부제강주식회사 | An archive and retrieval method of lengthwise real-time data for continuous galvanizing line |
| CN102215253A (en) * | 2011-05-18 | 2011-10-12 | 中国电力科学研究院 | Layered exchange and control method for real-time monitoring system data by power dispatching |
| CN102682051A (en) * | 2011-12-09 | 2012-09-19 | 江苏省电力公司苏州供电公司 | Method for integrating time series database with intelligent grid scheduling technology support system |
-
2013
- 2013-03-15 CN CN2013100832910A patent/CN103246695A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20050028411A (en) * | 2003-09-18 | 2005-03-23 | 동부제강주식회사 | An archive and retrieval method of lengthwise real-time data for continuous galvanizing line |
| CN102215253A (en) * | 2011-05-18 | 2011-10-12 | 中国电力科学研究院 | Layered exchange and control method for real-time monitoring system data by power dispatching |
| CN102682051A (en) * | 2011-12-09 | 2012-09-19 | 江苏省电力公司苏州供电公司 | Method for integrating time series database with intelligent grid scheduling technology support system |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104792362A (en) * | 2015-04-14 | 2015-07-22 | 国家电网公司 | Method for monitoring load and temperature of 10kV switching station and based on Hisoon database |
| CN108256079A (en) * | 2018-01-18 | 2018-07-06 | 杭州吉利易云科技有限公司 | A kind of Product Manufacturing Information obtains systems, devices and methods |
| CN108256079B (en) * | 2018-01-18 | 2021-06-22 | 杭州吉利易云科技有限公司 | Product manufacturing information acquisition system, device and method |
| CN108595254A (en) * | 2018-03-09 | 2018-09-28 | 北京永洪商智科技有限公司 | A kind of query scheduling method |
| CN109062960A (en) * | 2018-06-26 | 2018-12-21 | 国电南瑞科技股份有限公司 | Electric network model and real time data decoupling method in electric power scheduling automatization system |
| CN111400284A (en) * | 2020-03-20 | 2020-07-10 | 广州咨元信息科技有限公司 | Method for establishing dynamic anomaly detection model based on performance data |
| CN111400284B (en) * | 2020-03-20 | 2023-09-12 | 广州咨元信息科技有限公司 | Method for establishing dynamic anomaly detection model based on performance data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Munshi et al. | Big data framework for analytics in smart grids | |
| CN102682051B (en) | Method for integrating time series database with intelligent grid scheduling technology support system | |
| CN102385739B (en) | A kind of county power supply company integration information management platform | |
| CN102855271B (en) | The storage of a kind of multi-version power grid model and traceable management method | |
| CN102214228B (en) | Large-grid distributed real-time database system and data management method thereof | |
| CN106326331A (en) | Intelligent power utilization data service system based on cloud computation | |
| CN105069690A (en) | Power grid operating data processing method | |
| CN104317800A (en) | Hybrid storage system and method for mass intelligent power utilization data | |
| CN105631764A (en) | Smart power grid big data application system orienting smart city | |
| CN103246695A (en) | Integrating method of HighSoon real-time database and IES600P system | |
| CN107832876B (en) | Partition maximum load prediction method based on MapReduce framework | |
| CN107590749A (en) | A kind of processing method and system with electricity consumption data | |
| CN108108517A (en) | A kind of Electric Power Network Planning intelligence aided analysis method based on big data | |
| CN103325074A (en) | Electric system real-time data processing method | |
| CN107807961B (en) | Spark calculation engine-based power distribution network big data partition processing method | |
| CN103051714A (en) | Implementation method of water conservation cloud platform | |
| CN105681474A (en) | System architecture for supporting upper layer applications based on enterprise-level big data platform | |
| CN103064670A (en) | Method and system for innovation platform data management based on place net | |
| Ceci et al. | Big data techniques for supporting accurate predictions of energy production from renewable sources | |
| CN103489139A (en) | Comprehensive analysis and management system for urban distribution network planning | |
| CN102509198A (en) | Method and system for monitoring low-voltage power grid equipment | |
| CN105956932A (en) | Distribution and utilization data fusion method and system | |
| CN105391777A (en) | Algorithm escrow PaaS platform for decoupling logic code and performance code | |
| CN102306354A (en) | System for storing and scheduling state monitoring data of transmission equipment | |
| CN105574074A (en) | Smart grid WAMS-based time-series big data storage method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130814 |