CN108090844A - A kind of power distribution network scheduling information reflow method and system - Google Patents
A kind of power distribution network scheduling information reflow method and system Download PDFInfo
- Publication number
- CN108090844A CN108090844A CN201711159949.6A CN201711159949A CN108090844A CN 108090844 A CN108090844 A CN 108090844A CN 201711159949 A CN201711159949 A CN 201711159949A CN 108090844 A CN108090844 A CN 108090844A
- Authority
- CN
- China
- Prior art keywords
- distribution network
- scheduling information
- power distribution
- cities
- districts
- 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
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
-
- 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
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Abstract
The invention discloses a kind of power distribution network scheduling information reflow method and systems, are serviced from data resource management platform and data warehouse by SOA extract scheduling information to provincial power distribution network operational management skill support platform first；Then support platform is serviced by ETL to extract scheduling information from provincial power distribution network operational management skill；Distribution main website of last districts and cities, electricity consumption scheduling OS2 access the scheduling information in districts and cities' reflux storehouse with electricity consumption Application share.System includes data warehouse, data resource management platform, provincial power distribution network operational management skill and supports platform, power supply bureau's power distribution network operational management skill that platform, OS2 is supported to match somebody with somebody electricity consumption application.
Description
Technical field
The present invention relates to data warehouse technology field, more particularly, to a kind of power distribution network scheduling information reflow method and
System.
Background technology
The deployment way of power grid enterprises' grade management information system is transformed by the distributed deployment of power supply bureau of districts and cities at present
Provincial to concentrate deployment, the business datum of corresponding each system is also stored into provincial company, power supply bureau of districts and cities no longer storage service data.
Effectively to solve the construction of the existing application of power supply bureau of districts and cities or pilot application, meet power supply bureau's localization business datum application
Demand work, it is necessary to which Develop Data flows back, current existing method substantially have：It is flowed back by method of service, regular offline derivative
According to file.
By method of service reflux information mode, can be mainly used in opposite more in real time data backflow to districts and cities
The fixed information exchange infrequently updated and data volume is few；But its major defect is：1) for high-volume data update or deposit
Data pick-up is measured, performance can not support；2) when data model occurs change or increases data object, it is required for carrying out service change
More, quantities is big, is not easy to safeguard.
Periodically offline derivative can accurately be led data message by offline mode according to file mode and be powered to prefectures and cities
Office, but information automatic flow is can not achieve, it is necessary to which manpower participation, is unfavorable for safeguarding, also lacks real-time.
The content of the invention
Present invention aim to address above-mentioned one or more deficiencies, propose a kind of power distribution network scheduling information reflow method
And system.
For realization more than goal of the invention, the technical solution adopted is that：
A kind of power distribution network scheduling information reflow method, comprises the following steps：
S1：Extraction scheduling information is serviced from data resource management platform and data warehouse by SOA to transport to provincial power distribution network
Row administrative skill supports platform；
S2：Support platform is serviced by ETL to extract scheduling information from provincial power distribution network operational management skill；
S3：Distribution main website of districts and cities, electricity consumption scheduling OS2 access the scheduling information in districts and cities' reflux storehouse with electricity consumption Application share.
Scheduling information described in step S1 includes distribution net equipment account, files on each of customers, Metrological archives, people's money account.
Step S1 further includes data initialization dmp files.
Scheduling information is extracted described in step S2 includes full dose extraction or increment extraction.
A kind of power distribution network scheduling information return-flow system, including data warehouse, data resource management platform, provincial power distribution network fortune
Row administrative skill supports platform, power supply bureau's power distribution network operational management skill that platform, OS2 is supported to match somebody with somebody electricity consumption application；Wherein save grading
Regulation technical support platform extracts scheduling information, power supply bureau's power distribution network from data resource management platform and data warehouse
Operational management skill supports platform from provincial power distribution network operational management skill platform to be supported to extract scheduling information, and OS2 should with electricity consumption
The scheduling information in platform is supported with share and access power supply bureau power distribution network operational management skill.
Wherein described OS2 is applied with electricity consumption includes distribution main website, electricity consumption scheduling.
Wherein described provincial power distribution network operational management skill supports platform to include Production database and saves reflux storehouse；It is wherein raw
Production database is by saving ETL services by transmitting scheduling information to province's reflux storehouse.
Wherein described power supply bureau's power distribution network operational management skill supports platform to include districts and cities reflux storehouse and districts and cities' storage facility located at processing plant；Its
Middle districts and cities' storage facility located at processing plant is serviced by districts and cities ETL and extracts scheduling information from districts and cities' reflux storehouse.
Wherein described districts and cities' storage facility located at processing plant services the extraction scheduling information from districts and cities' reflux storehouse by districts and cities ETL includes Guangdong electricity
19, net is directly under office of districts and cities according to the number passed ETL in principle and service daily timing extraction province reflux Ku Zhong prefectures and cities for design of avoiding the peak hour
It flows back storehouse according to districts and cities.
Wherein described Guangdong Power Grid 19 extracts scheduling information directly under office of districts and cities by batch.
Compared with prior art, the beneficial effects of the invention are as follows：
The present invention establishes a kind of power distribution network scheduling information reflow method and system, can be to the scheduling information of storage/increment
Timing automatic back flow is to the reflux storehouse of power supply bureau of prefectures and cities, so that the reflux Kucheng of prefectures and cities is a shared scheduling information
Data platform.
Description of the drawings
Fig. 1 is flow chart of the method for the present invention；
Fig. 2 is the system architecture diagram of the present invention.
Specific embodiment
Attached drawing is only for illustration, it is impossible to be interpreted as the limitation to this patent；
Below in conjunction with drawings and examples, the present invention is further elaborated.
Embodiment 1
A kind of power distribution network scheduling information reflow method, comprises the following steps：
S1：Extraction scheduling information is serviced from data resource management platform and data warehouse by SOA to transport to provincial power distribution network
Row administrative skill supports platform；
S2：Support platform is serviced by ETL to extract scheduling information from provincial power distribution network operational management skill；
S3：Distribution main website of districts and cities, electricity consumption scheduling OS2 access the scheduling information in districts and cities' reflux storehouse with electricity consumption Application share.
Scheduling information described in step S1 includes distribution net equipment account, files on each of customers, Metrological archives, people's money account.
Step S1 further includes data initialization dmp files.
Scheduling information is extracted described in step S2 includes full dose extraction or increment extraction.
A kind of power distribution network scheduling information return-flow system, including data warehouse, data resource management platform, provincial power distribution network fortune
Row administrative skill supports platform, power supply bureau's power distribution network operational management skill that platform, OS2 is supported to match somebody with somebody electricity consumption application；Wherein save grading
Regulation technical support platform extracts scheduling information, power supply bureau's power distribution network from data resource management platform and data warehouse
Operational management skill supports platform from provincial power distribution network operational management skill platform to be supported to extract scheduling information, and OS2 should with electricity consumption
The scheduling information in platform is supported with share and access power supply bureau power distribution network operational management skill.
Wherein described OS2 is applied with electricity consumption includes distribution main website, electricity consumption scheduling.
Wherein described provincial power distribution network operational management skill supports platform to include Production database and saves reflux storehouse；It is wherein raw
Production database is by saving ETL services by transmitting scheduling information to province's reflux storehouse.
Wherein described power supply bureau's power distribution network operational management skill supports platform to include districts and cities reflux storehouse and districts and cities' storage facility located at processing plant；Its
Middle districts and cities' storage facility located at processing plant is serviced by districts and cities ETL and extracts scheduling information from districts and cities' reflux storehouse.
Wherein described districts and cities' storage facility located at processing plant services the extraction scheduling information from districts and cities' reflux storehouse by districts and cities ETL includes Guangdong electricity
19, net is directly under office of districts and cities according to the number passed ETL in principle and service daily timing extraction province reflux Ku Zhong prefectures and cities for design of avoiding the peak hour
It flows back storehouse according to districts and cities.
Wherein described Guangdong Power Grid 19 extracts scheduling information directly under office of districts and cities by batch.
As shown in Figure 1, 2, the data resource management platform intergration model data of 6+1 operation systems, distribution network operation pipe
After technical support platform is managed by storage dmp data initializations, serviced and received in data resource management platform by power grid SOA
Then the data of each operation system, storage to Production database service timing extraction into province's reflux storehouse by provincial ETL；
ETL services are saved simultaneously also extracts related data to province's reflux storehouse from data warehouse.
The data that Guangdong Power Grid 19 services daily timing extraction province reflux Ku Zhong prefectures and cities directly under office of districts and cities by ETL arrive
Design is extracted in districts and cities' reflux storehouse according to avoiding the peak hour, and 19 districts and cities can be divided into several batches and carry out, and prefectures and cities can match somebody with somebody according to respective situation
It puts full dose to extract or increment extraction, realizes that the accurate of power distribution network scheduling information highly reliable is back to prefectures and cities.
Finally, the OS2 such as the distribution main website of office of prefectures and cities, electricity consumption scheduling can share visit by various modes with electricity consumption application
Ask the scheduling information in districts and cities' reflux storehouse, the effective demand data with electricity consumption application for supporting office of prefectures and cities.
Obviously, the above embodiment of the present invention is only intended to clearly illustrate example of the present invention, and is not pair
The restriction of embodiments of the present invention.For those of ordinary skill in the art, may be used also on the basis of the above description
To make other variations or changes in different ways.There is no necessity and possibility to exhaust all the enbodiments.It is all this
All any modification, equivalent and improvement made within the spirit and principle of invention etc., should be included in the claims in the present invention
Protection domain within.
Claims (10)
1. a kind of power distribution network scheduling information reflow method, which is characterized in that comprise the following steps：
S1：It is serviced from data resource management platform and data warehouse by SOA and extracts scheduling information to provincial distribution network operation pipe
Manage technical support platform；
S2：Support platform is serviced by ETL to extract scheduling information from provincial power distribution network operational management skill；
S3：Distribution main website of districts and cities, electricity consumption scheduling OS2 access the scheduling information in districts and cities' reflux storehouse with electricity consumption Application share.
A kind of 2. power distribution network scheduling information reflow method according to claim 1, which is characterized in that scheduling described in step S1
Information includes distribution net equipment account, files on each of customers, Metrological archives, people's money account.
3. a kind of power distribution network scheduling information reflow method according to claim 1, which is characterized in that step S1 further includes number
According to initialization dmp files.
A kind of 4. power distribution network scheduling information reflow method according to claim 1, which is characterized in that extraction described in step S2
Scheduling information includes full dose extraction or increment extraction.
It is 5. a kind of according to claim 1-4 any one of them systems, which is characterized in that including data warehouse, data resource pipe
Platform, provincial power distribution network operational management skill support platform, power supply bureau's power distribution network operational management skill that platform, OS2 is supported to match somebody with somebody
Electricity consumption application；Wherein provincial power distribution network operational management skill supports platform is extracted from data resource management platform and data warehouse to adjust
Information is spent, power supply bureau's power distribution network operational management skill supports platform to support platform extracts to adjust from provincial power distribution network operational management skill
Information is spent, OS2 accesses the scheduling information in power supply bureau's power distribution network operational management skill support platform with electricity consumption Application share.
6. a kind of power distribution network scheduling information return-flow system according to claim 5, which is characterized in that the OS2 matches somebody with somebody electricity consumption
Using including distribution main website, electricity consumption scheduling.
A kind of 7. power distribution network scheduling information return-flow system according to claim 5, which is characterized in that the provincial power distribution network
Operational management skill supports platform to include Production database and saves reflux storehouse；Wherein Production database will be adjusted by saving ETL services
Degree information is transmitted to province's reflux storehouse.
A kind of 8. power distribution network scheduling information return-flow system according to claim 5, which is characterized in that power supply bureau's distribution
Network operation administrative skill supports platform to include districts and cities reflux storehouse and districts and cities' storage facility located at processing plant；Wherein districts and cities' storage facility located at processing plant is taken by districts and cities ETL
Business extracts scheduling information in flowing back storehouse from districts and cities.
A kind of 9. power distribution network scheduling information return-flow system according to claim 8, which is characterized in that districts and cities' storage facility located at processing plant
Scheduling information is extracted in flowing back storehouse from districts and cities by districts and cities ETL services to set according to avoiding the peak hour directly under office of districts and cities for 19 including Guangdong Power Grid
The ETL that passes in principle of meter services daily timing extraction and saves the data of reflux Ku Zhong prefectures and cities and flows back storehouse to districts and cities.
A kind of 10. power distribution network scheduling information return-flow system according to claim 9, which is characterized in that the Guangdong Power Grid
19 are extracted scheduling information directly under office of districts and cities by batch.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711159949.6A CN108090844A (en) | 2017-11-20 | 2017-11-20 | A kind of power distribution network scheduling information reflow method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711159949.6A CN108090844A (en) | 2017-11-20 | 2017-11-20 | A kind of power distribution network scheduling information reflow method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108090844A true CN108090844A (en) | 2018-05-29 |
Family
ID=62172704
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711159949.6A Pending CN108090844A (en) | 2017-11-20 | 2017-11-20 | A kind of power distribution network scheduling information reflow method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108090844A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102750606A (en) * | 2012-05-16 | 2012-10-24 | 中国电力科学研究院 | Power grid scheduling cloud system |
| CN104124756A (en) * | 2013-04-27 | 2014-10-29 | 国家电网公司 | Province-level power distribution network operation monitoring system based on network-wide data |
| CN104391989A (en) * | 2014-12-16 | 2015-03-04 | 浪潮电子信息产业股份有限公司 | Distributed ETL all-in-one machine system |
| CN105846473A (en) * | 2016-04-06 | 2016-08-10 | 北京科东电力控制系统有限责任公司 | Prefecture-county integration method based on intelligent power grid dispatching control system |
-
2017
- 2017-11-20 CN CN201711159949.6A patent/CN108090844A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102750606A (en) * | 2012-05-16 | 2012-10-24 | 中国电力科学研究院 | Power grid scheduling cloud system |
| CN104124756A (en) * | 2013-04-27 | 2014-10-29 | 国家电网公司 | Province-level power distribution network operation monitoring system based on network-wide data |
| CN104391989A (en) * | 2014-12-16 | 2015-03-04 | 浪潮电子信息产业股份有限公司 | Distributed ETL all-in-one machine system |
| CN105846473A (en) * | 2016-04-06 | 2016-08-10 | 北京科东电力控制系统有限责任公司 | Prefecture-county integration method based on intelligent power grid dispatching control system |
Non-Patent Citations (2)
| Title |
|---|
| 伍江瑶: "广东电网数据回流系统ETL的设计与实现", 《自动化与仪器仪表》 * |
| 张诗军: "基于SOA技术的南方电网数据交换平台设计", 《现代计算机(专业版)》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6563491B2 (en) | Power grid system and method for integrating power input and consumption in a power grid system | |
| CN106203890B (en) | Battalion's auxiliary tone integration data modeling method based on CIM | |
| CN102999975B (en) | Intelligent power consumption payment management system | |
| CN108183869B (en) | Electric quantity data acquisition system based on distributed message queue | |
| CN106127385A (en) | Electric power first-aid method of servicing based on mobile Internet platform | |
| CN103353888B (en) | A kind of law court tries automatic division system and method | |
| CN102592246A (en) | System and method for estimating demand response in electric power systems | |
| Soto-Garcia et al. | The role of information and communication technologies in the modernisation of water user associations’ management | |
| WO2018120829A1 (en) | Charging facility scheduling system and method | |
| CN101867226A (en) | Wide-area distribution type data collection method for dispatching automation system | |
| CN104346839B (en) | A kind of employee's electronic attendance system based on LAN | |
| CN108985650A (en) | A kind of rice equilibrium of supply and demand scheduling system and method | |
| CN103399562A (en) | Device and method for processing real-time dynamic cost calculation information of production line | |
| CN114362238B (en) | Photovoltaic control system and method | |
| Woltemade et al. | Economic efficiency of residential water conservation programs in a Pennsylvania public water utility | |
| CN108090844A (en) | A kind of power distribution network scheduling information reflow method and system | |
| CN102789211A (en) | Method for dynamically balancing suspend production line | |
| JP5527712B2 (en) | Distributed power control method and distributed power control system | |
| CN108196493A (en) | A kind of wisdom water utilities control system and method based on cloud platform | |
| CN104240149A (en) | Energy efficiency metering system | |
| CN109766224A (en) | A kind of operation system of direct drinking and the operation method of operation system | |
| Sagynganova et al. | Comprehensive methods to obtain and process information flows in centralized heat supply systems | |
| CN109636668A (en) | The scale battery energy storage system cluster of commercial operation participates in the control method of power grid ancillary service | |
| KR100937032B1 (en) | Apparatus and method for workload balancing of postal delivery | |
| CN111667129A (en) | Cleaning labor dispatching management system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180529 |
|
| RJ01 | Rejection of invention patent application after publication |