CN107766493A - A kind of patch source power network resources Model analysis system and method - Google Patents
A kind of patch source power network resources Model analysis system and method Download PDFInfo
- Publication number
- CN107766493A CN107766493A CN201710974446.8A CN201710974446A CN107766493A CN 107766493 A CN107766493 A CN 107766493A CN 201710974446 A CN201710974446 A CN 201710974446A CN 107766493 A CN107766493 A CN 107766493A
- Authority
- CN
- China
- Prior art keywords
- data
- power network
- area
- model
- information
- 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
- 238000004458 analytical method Methods 0.000 title claims abstract description 25
- 238000000034 method Methods 0.000 title claims abstract description 20
- 238000003860 storage Methods 0.000 claims abstract description 35
- 238000013439 planning Methods 0.000 claims abstract description 12
- 238000013499 data model Methods 0.000 claims abstract description 10
- 238000013500 data storage Methods 0.000 claims abstract description 9
- 230000008520 organization Effects 0.000 claims abstract description 5
- 238000007726 management method Methods 0.000 claims description 37
- 230000003139 buffering effect Effects 0.000 claims description 24
- 239000000463 material Substances 0.000 claims description 19
- 230000010354 integration Effects 0.000 claims description 15
- 238000007405 data analysis Methods 0.000 claims description 13
- 230000005611 electricity Effects 0.000 claims description 8
- 230000015572 biosynthetic process Effects 0.000 claims description 6
- 238000012545 processing Methods 0.000 claims description 5
- 238000003786 synthesis reaction Methods 0.000 claims description 5
- 238000013075 data extraction Methods 0.000 claims description 3
- 238000012423 maintenance Methods 0.000 claims description 3
- 238000005259 measurement Methods 0.000 claims description 3
- 239000002245 particle Substances 0.000 claims description 3
- 230000007115 recruitment Effects 0.000 claims description 3
- 230000000717 retained effect Effects 0.000 claims description 3
- 230000001755 vocal effect Effects 0.000 claims description 3
- 230000003993 interaction Effects 0.000 claims 1
- 238000012544 monitoring process Methods 0.000 claims 1
- 230000010076 replication Effects 0.000 claims 1
- 238000012546 transfer Methods 0.000 claims 1
- 238000012384 transportation and delivery Methods 0.000 claims 1
- 239000002699 waste material Substances 0.000 claims 1
- 238000005516 engineering process Methods 0.000 abstract description 6
- 238000003745 diagnosis Methods 0.000 abstract description 2
- 238000003012 network analysis Methods 0.000 abstract description 2
- 230000004044 response Effects 0.000 abstract description 2
- 238000012549 training Methods 0.000 description 4
- 238000010276 construction Methods 0.000 description 3
- 238000013461 design Methods 0.000 description 3
- 239000000284 extract Substances 0.000 description 3
- 239000000203 mixture Substances 0.000 description 3
- 230000033228 biological regulation Effects 0.000 description 2
- 238000013144 data compression Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000005457 optimization Methods 0.000 description 2
- 238000013475 authorization Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007796 conventional method Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
- 230000014759 maintenance of location Effects 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 238000010079 rubber tapping Methods 0.000 description 1
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/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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- 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
-
- 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—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to a kind of patch source electrical network analysis method, more particularly to a kind of patch source power network resources Model analysis system and method, the present invention utilizes distributed column memory technology by the storage organization for power network resources model of making rational planning for, realize detailed data, the reasonable layout of combined data and analyze data, and made rational planning for data space with reference to CIM, lift electric network data storage, it is shared, the performance of analysis, also solved while improving power network overall operation efficiency from information-based angle in the prior art, data model is all to build on demand, it is not comprehensive, it is unfavorable for trans-departmental, across business diagnosis, demand could be supported by also needing to augment during in the event of demand or changing model, the problems such as response speed is slow.
Description
Technical field
The present invention relates to a kind of patch source electrical network analysis method, more particularly to a kind of patch source power network resources Model analysis system and
Method.
Background technology
With the development of power system, the growth requirement of business also tends to full-service collaboration, whole process is passed through direction and developed, deep
Enter mining data value, with data management enterprise, more urgent with the demand of information-driven business.Data are information-based core
The heart, it is the fusion of source full-service, the inevitable choice of rear end big data analysis to build full-service uniform data center, to construction information
It is significant to change enterprise.It is full-service uniform data center meanwhile the new technology such as big data, cloud computing reaches its maturity
Construction provides technical guarantee.Therefore, comprehensive, trans-departmental, trans-sectoral business electricity at efficient support full-service uniform data center is built
Net resource model realizes that data are unified extremely important.
But prior art still has many problems, each business bar line Information System configuration and application deepen continuously, cruelly
Expose multi-disciplinary business cooperation and information sharing deficiency, data accuracy, real-time be not strong, data extract repeatedly, redundant storage,
The problems such as of low quality.The data model that conventional method uses all is to build on demand, be not comprehensive, being unfavorable for trans-departmental, trans-sectoral business
Analysis, in the event of demand when also need to augment or change model and could support demand.The development trend in the field at present, builds
Vertical power network resources model, with reference to service application scene informations such as people's money, goods and materials, finance, using distributed column database purchase
Inquiring technology realizes the structure to data model, the online quick search analysis of supporting business application, improves efficiency data query,
Simultaneously according to business model feature, the redundant storage of data is reduced, lifts powernet analysis ability and predictive ability, improves effect
Rate reduced time.
The content of the invention
The present invention solves in the prior art, data model by a kind of patch source power network resources Model analysis system and method
All be on demand structure, not comprehensively, be unfavorable for it is trans-departmental, across business diagnosis, in the event of demand when also need to augment or change
The problems such as model could support demand, and response speed is slow.The storage organization for the power network resources model that the present invention makes rational planning for utilizes
Distributed column memory technology, the reasonable layout of detailed data, combined data and analyze data is realized, and combine CIM moulds
Type is made rational planning for data space, the storage of lifting electric network data, shared, analysis performance, electricity is improved from information-based angle
Net overall operation efficiency.
One kind is included based on patch source power network resources Model analysis system：Buffer module, views module, warehouse module, fairground
Module, power network resources model as views module important composition frequently with object-oriented mode, and utilize its line data
The characteristics of storehouse random write, completes data application.
Buffer module：Refer to one section of scratchpad area (SPA) in database, it deposits the source data provided by operation system, different
After the business source data of database platform (including text file type) reaches buffering area, realize source data on database platform
It is consistent, convenient to carry out Data Integration and processing, the data of buffering area storage are substantially consistent with source system, and buffering area is deposited
After the data of storage are processed, it will not be retained.
Views module：Buffering area is functional area important in the power network resources framework of patch source, except entering as data
Outside buffering area before depot area, it is integrated with from all kinds of business datums for being deployed in operation system database, and by right
ETL process forms consistent enterprise data integration view, is advantageous to end user and preferably takes a comprehensive view of the situation as a whole, and this region is referred to as
Unified information view area；By storage based on the themes such as equipment, product, client, complete enterprise's unified information view come
It is quick to obtain the complete information related to these themes, in unified information view area near real-time, the data storage that integrates causes
End user being capable of the recent details creation data of quick search；In addition, this region can also generate manipulation type with higher performance
Form.
Warehouse module：The centralization that is specific to Enterprise data integration and data history storage demand and organizes, one
The data storage areas of change.Warehouse area is made up of the company information for covering multiple subject areas, and these information are mainly low level, thin
Granularity data, while the combined data of certain particle size can be established according to data analysis requirements.They are regular according to certain frequency
Renewal, it is mainly used in providing after integrating, high quality data for fairground.Warehouse area typically seldom region be directly facing end user.
Warehouse area lays particular emphasis on the storage and integration of data, generally use lightweight index.
Data in warehouse area are deposited according to theme, and data granularity is consistent with buffering area or is coarser than buffering area, these data
Mainly Enterprise Data and historical information, the cycle of online data storage are general longer.The data of warehouse area are by buffering area
Data integrated according to the requirement of warehouse section model after formed.Mart module：Be one group it is specific, for some theme
The data acquisition system in domain, department or user's classification.These data need to optimize for the quick access of user and data output,
The mode of optimization can be by being collected and being indexed to data structure.The height that can ensure data warehouse by Data Mart can
With property, scalability and high-performance.
Power network resources model in the present invention uses patch source business, the data resource model of use, plays its on-line analysis
The speciality of processing, and based on a set of power network resources model of Distributed Storage technique construction under big data environment.This model
Design reduce the redundant storages of data, high degree improves data compression speed, reduces what is paid because resource is nervous
Storage cost, paste source power network resources model framework such as Fig. 1.
One kind is based on patch source power network resources model analysis method, and the implementation method step is as follows：
Step 1 obtained by way of acquisition terminal or manual entry power network people's money, finance, goods and materials, client, market,
The primary data information (pdi) of each service line such as power network, equipment, synthesis, safety；
Each service line administrative department of step 2 is respectively by respective information system, the industry that has been obtained in the range of storage management
Business data, and carry out independent vocational work based on business datum combination own service feature；
The relevant departments of step 3 information system management by data extraction tool by the business datum that each business department manages from
Operation system is extracted to patch source power network resources model, carries out distributed column storage, and the patch source power network resources model is with poly-
Class method analyzes sources operation system data base data model structure, and the progress of certain coefficient is exceeded to same alike result in data model
Cluster, then extracts redundancy, then establishes incidence relation, the Optimized model of proposition；
The relevant departments of step 4 information system management is based on patch source power network resources model, is needed with reference to the business of each business department
Carry out data analysis is asked, data analysis theme includes 10 points of people's money, finance, goods and materials, client, assets, market, power network type etc.
Analyse subject area；
The relevant departments of step 5 information system management will be based on patch source power network resources model, and the result for carrying out data analysis is led to
Cross with software information interface, hardware device instruction control interface and based on practical business flow specification, carry out information sharing, pass
Pass, instruction issuing, for electrical network business is scientific, regulation and standardization operation provides guidance foundation, and then it is overall to lift power network
Operational efficiency.
The present invention key point be warehouse area and collect urban district 7 priority theme domains (personnel, finance, goods and materials, assets,
Project, client, power network) physical model, it is specific as follows：
1st, personnel's numeric field data entity is abstracted, and forms personnel's domain information model, including is organized, recruited configuration, training
7 two level subject areas such as instruction exploitation, 206 data entities；
2nd, financial numeric field data entity is abstracted, and forms financial domain information model, including general ledger is circulated to form, is sold to
Gathering circulation, buying to 8 two level subject areas such as payment circulation, 353 data entities；
3rd, goods and materials numeric field data entity is abstracted, and forms goods and materials domain information model, including planning management, purchasing management, conjunction
With 10 two level subject areas such as management, 129 data entities；
4th, assets numeric field data entity is abstracted, and forms assets domain information model, including account for assets, assets O＆M, money
8 two level subject areas such as production maintenance, 198 data entities；
5th, item domains data entity is abstracted, and forms item domains information model, including item base, project planning, item
8 two level subject areas such as mesh deposit, 51 data entities；
6th, client's numeric field data entity is abstracted, and forms client's domain information model, including Business Process System, electricity bill control, use
7 two level subject areas such as electricity metering, 463 data entities；
7th, power network numeric field data entity is abstracted, and forms power network domain information model, including power network topology, measurement, control zone
7, domain etc. two level subject area, 74 data entities；
Beneficial effect
The online quick search analysis that preferably supporting business is applied of this method energy, improves efficiency data query, while root
According to business model feature, the redundant storage of data is reduced, practical business demand is combined, and can comprehensively lift storage, inquiry
Performance.
Brief description of the drawings
Fig. 1 pastes source power network resources model support composition
Fig. 2 business data flows turn flow chart
Graph of a relation between Fig. 3 data warehouses and each model of Data Mart
Fig. 4 personnel domain two level subject area graph of a relation
Fig. 5 finance domain two level subject area graph of a relation
Fig. 6 materials domain two level subject area graph of a relation
Fig. 7 assets domain two level subject area graph of a relation
Fig. 8 item domains two level subject area graphs of a relation
Fig. 9 client domain two level subject area graph of a relation
Figure 10 power networks domain two level subject area graph of a relation
Specific embodiment
In electric network data center business scope, four layers model generally use buffering area, view area, warehouse area, collection of urban district are entered
Row is built, and power network resources model is designed as the important composition of view area frequently with the mode of object-oriented, and utilizes it
The characteristics of line data storehouse random write, completes data application.
Buffer module：Refer to one section of scratchpad area (SPA) in database, it deposits the source data provided by operation system.It is different
After the business source data of database platform (including text file type) reaches buffering area, realize source data on database platform
It is consistent, convenient to carry out Data Integration and processing, the data of buffering area storage are substantially consistent with source system；Buffering area is deposited
After the data of storage are processed, it will not be retained.
Views module：Buffering area is functional area important in the power network resources framework of patch source, except entering as data
Outside buffering area before depot area, it is integrated with from all kinds of business datums for being deployed in operation system database, and by right
ETL process forms consistent enterprise data integration view, is advantageous to end user and preferably takes a comprehensive view of the situation as a whole, and this region is referred to as
Unified information view area.By storage based on the themes such as equipment, product, client, complete enterprise's unified information view come
It is quick to obtain the complete information related to these themes, in unified information view area near real-time, the data storage that integrates causes
End user being capable of the recent details creation data of quick search；In addition, this region can also generate manipulation type with higher performance
Form.
Warehouse module：The centralization that is specific to Enterprise data integration and data history storage demand and organizes, one
The data storage areas of change.Warehouse area is made up of the company information for covering multiple subject areas, and these information are mainly low level, thin
Granularity data, while the combined data of certain particle size can be established according to data analysis requirements.They are regular according to certain frequency
Renewal, it is mainly used in providing after integrating, high quality data for fairground.Warehouse area typically seldom region be directly facing end user.
Warehouse area lays particular emphasis on the storage and integration of data, generally use lightweight index.
Data in warehouse area are deposited according to theme, and data granularity is consistent with buffering area or is coarser than buffering area, these data
Mainly Enterprise Data and historical information, the cycle of online data storage are general longer.The data of warehouse area are by buffering area
Data integrated according to the requirement of warehouse section model after formed.
Mart module：It is one group of data acquisition system specific, for some subject area, department or user classification.These numbers
According to needing to optimize for the quick access of user and data output, the mode of optimization can be by converging to data structure
Summation indexes.The high availability, scalability and high-performance of data warehouse can be ensured by Data Mart.
Power network resources model in the present invention is designed using patch source business, designs the number for more conducively calculating, analyzing
According to resource model, the speciality of its Data Environments is played, and based on the Distributed Storage technology structure under big data environment
Build a set of power network resources model.The design of this model reduces the redundant storage of data, and high degree improves data compression speed,
Reduce because of the nervous storage cost paid of resource, paste source power network resources model framework such as Fig. 1.
Above-mentioned one kind is based on patch source power network resources model analysis method, and specific implementation step is as follows：
Step 1 obtained by way of acquisition terminal or manual entry power network people's money, finance, goods and materials, client, market,
The primary data information (pdi) of each service line such as power network, equipment, synthesis, safety, data message include：Organization and administration, performance management, labor
Dynamic relation, general ledger to form circulate, payment, contract management, account for assets, power network topology, electricity bill control, energy meter are arrived in buying
Draw, the data message of 74 themes such as planning management；
Step 2 people money, finance, goods and materials, client, market, power network, equipment, synthesis, safe Deng Ge service lines administrative department point
Not by respective information system, the business datum that has been obtained in the range of storage management, and itself industry is combined based on business datum
Business feature carries out independent vocational work；
The relevant departments of step 3 information system management by data extraction tool by the business datum that each business department manages from
Operation system is extracted to patch source power network resources model, carries out distributed column storage, and the patch source power network resources model is with poly-
Class method analyzes sources operation system data base data model structure, and the progress of certain coefficient is exceeded to same alike result in data model
Cluster, then extracts redundancy, then establishes incidence relation, the Optimized model of proposition, and the model includes people's money, finance, goods and materials, visitor
10 power network resources models such as family, assets, market, power network type are shown in Fig. 3；
The relevant departments of step 4 information system management is based on patch source power network resources model, is needed with reference to the business of each business department
Carry out data analysis is asked, data analysis theme includes 10 points of people's money, finance, goods and materials, client, assets, market, power network type etc.
Analyse subject area；
The relevant departments of step 5 information system management will be based on patch source power network resources model, and the result for carrying out data analysis is led to
Cross with software information interface, hardware device instruction control interface and based on practical business flow specification, carry out information sharing, pass
Pass, instruction issuing, for electrical network business is scientific, regulation and standardization operation provides guidance foundation, and then it is overall to lift power network
Operational efficiency.
The present invention key point be warehouse area and collect urban district 7 priority theme domains (personnel, finance, goods and materials, assets,
Project, client, power network) physical model, it is specific as follows：
1st, personnel's numeric field data entity is abstracted, and forms personnel's domain information model, including is organized, recruited configuration, training
7 two level subject areas such as instruction exploitation, 206 data entities；
| Two level subject area | Description |
| Organization and administration | Tissue, the related service of manpower authorization are described |
| Labor relation | The related services such as employee's essential information, side information are described |
| Recruitment configuration | Description recruitment management, internal human resources market management related service |
| Training exploitation | Training Management, talents' tapping, Internet college's related service are described |
| Performance management | The business such as performance standard, performance appraisal management are described |
| Payroll administration | The related services such as payroll administration, Labor Cost Management, welfare management are described |
| Program plan | The related services such as human resources planning are described |
2nd, financial numeric field data entity is abstracted, and forms financial domain information model, including general ledger is circulated to form, is sold to
Gathering circulation, buying to 8 two level subject areas such as payment circulation, 353 data entities；
3rd, goods and materials numeric field data entity is abstracted, and forms goods and materials domain information model, including planning management, purchasing management, conjunction
With 10 two level subject areas such as management, 129 data entities；
4th, assets numeric field data entity is abstracted, and forms assets domain information model, including account for assets, assets O＆M, money
8 two level subject areas such as production maintenance, 198 data entities；
5th, item domains data entity is abstracted, and forms item domains information model, including item base, project planning, item
8 two level subject areas such as mesh deposit, 51 data entities；
6th, client's numeric field data entity is abstracted, and forms client's domain information model, including Business Process System, electricity bill control, use
7 two level subject areas such as electricity metering, 463 data entities；
7th, power network numeric field data entity is abstracted, and forms power network domain information model, including power network topology, measurement, control zone
7, domain etc. two level subject area, 74 data entities；
Claims (7)
1. a kind of patch source power network resources Model analysis system, it is characterised in that the system includes buffer module, views module, storehouse
Library module, mart module carry on an exclusive server respectively, the data interaction between each module be by ETL instruments and
The mode of OGG synchronization Replication Tools realizes, data transfer from operation system to buffering area by ETL instruments (Informatica)+
Ogg is transmitted, and buffering area to view area is transmitted by ETL instruments (Informatica)+ogg, view area to warehouse area
It is transmitted by ETL instruments (Informatica), warehouse area is passed to collection urban district by ETL instruments (Informatica)
It is defeated；Buffer module refers to one section of scratchpad area (SPA) in database, deposits the source data provided by operation system；Views module passes through
The data of each operation system are drawn into the region by ETL modes from buffer module, and formation standard, the enterprise data integration of specification regard
Figure；Warehouse module is that the centralization organized for Enterprise data integration and data history storage demand, the data of integration are deposited
Storage area domain；Collection urban district module is one group of data acquisition system that is specific, classifying for some subject area, department, user.
A kind of 2. as claimed in claim 1, patch source power network resources Model analysis system, it is characterised in that buffer module refers to data
One section of scratchpad area (SPA) in storehouse, deposits the source data provided by operation system, and the business source data of disparate databases platform arrives
Up to after buffering area, realize that source data is consistent on database platform, it is convenient to carry out Data Integration and processing, buffering area storage
Data are substantially consistent with source system, after the data that buffering area stores are processed, will not be retained.
3. as claimed in claim 1, a kind of patch source power network resources Model analysis system, its sign is, views module buffering area
It is functional area important in the power network resources framework of patch source, in addition to the buffering area before entering depot area, collects except as data
Into from all kinds of business datums for being deployed in operation system database, and by forming consistent business data to ETL process
Integrated view, be advantageous to end user and preferably take a comprehensive view of the situation as a whole, this region is referred to as unified information view area；Pass through storage
Based on equipment, product, client's theme, complete enterprise's unified information view come it is quick obtain it is related to these themes complete
Information, in unified information view area near real-time, integrated data storage enable the recent details of end user's quick search
Creation data.
4. as claimed in claim 1, a kind of patch source power network resources Model analysis system, its sign is that warehouse module is special
The centralization organized for Enterprise data integration and data history storage demand, the data storage areas of integration；Warehouse area
It is made up of the company information of covering subject area, these information are mainly low level, fine-grained data, while can be divided according to data
Analysis demand establishes the combined data of certain particle size；Regularly update, provided for fairground after integrating, high quality according to certain frequency
Data；Warehouse area typically seldom region be directly facing end user；Warehouse area lays particular emphasis on the storage and integration of data, generally use light weight
Level index.
5. as claimed in claim 1, a kind of patch source power network resources Model analysis system, its sign is, mart module：It is one group
Specifically, for the data acquisition system of some subject area, department or user classification；These data need the quick access for user
And data output, by being collected to data structure and index optimizes.
A kind of 6. patch source power network resources model analysis method, it is characterised in that using following steps：Step 1 by acquisition terminal,
The mode of manual entry obtains power network in people's money, finance, goods and materials, client, market, power network, equipment, synthesis, each service line of safety
Primary data information (pdi)；
Each service line administrative department of step 2 is respectively by respective information system, the business number that has been obtained in the range of storage management
According to, and carry out independent vocational work based on business datum combination own service feature；
The relevant departments of step 3 information system management is by data extraction tool by the business datum that each business department manages from business
System is extracted to patch source power network resources model, carries out distributed column storage, the patch source power network resources model is to use cluster side
Method analyzes sources operation system data base data model structure, exceedes gathering for certain coefficient to same alike result in data model
Class, redundancy is extracted, establishes incidence relation, the Optimized model of proposition；
The relevant departments of step 4 information system management is based on patch source power network resources model, enters with reference to the business demand of each business department
Row data analysis, data analysis theme include 0 people's money, finance, goods and materials, client, assets, market, power network Class1 analysis theme
Domain；
The relevant departments of step 5 information system management will be based on patch source power network resources model, carry out the result of data analysis by with
Software information interface, hardware device instruct control interface and based on practical business flow specifications, carry out information sharing, transmit, refer to
Order is assigned.
7. as described in claim 1 or 6, it is characterised in that the physical model in 7 priority theme domains in warehouse area and collection urban district is such as
Under：(1) personnel's numeric field data entity is abstracted, and forms personnel's domain information model, including organization and administration, labor relation, recruitment are matched somebody with somebody
Put, train 7 exploitation, performance management, payroll administration, program plan two level subject areas, 206 data entities；(2) financial domain number
Factually body is abstracted, and forms financial domain information model, including general ledger is circulated to form, is sold to gathering circulation, buying is arrived and paid
Money circulation, engineering to asset cycle, cost to analysis circulation, fund to control circulation, risk arrive performance to treatment circulation, strategy
Circulate 8 two level subject areas, 353 data entities；(3) goods and materials numeric field data entity is abstracted, and forms goods and materials domain information model,
Including planning management, purchasing management, contract management, warehousing management, waste and old material processing, delivery management, quality supervision and control, specially
Family's management, supplier relationship management, procurement criteriaization manage 10 two level subject areas, 129 data entities；(4) assets domain number
Factually body is abstracted, and forms assets domain information model, including account for assets, assets O＆M, assets maintenance, asset environment, money
Produce 8 monitoring, Assets Analyst, assets failure, assets owner two level subject areas, 198 data entities；(5) project numeric field data is real
Body is abstracted, and forms item domains information model, including item base, project planning, project deposit, the project plan, project are held
8 row, project completion, project appraisal two level subject areas, 51 data entities；(6) client's numeric field data entity is abstracted, and is formed
Client's domain information model, including Business Process System, electricity bill control, Electro-metering, customer service, market management, intelligent power, synthesis
Manage 7 two level subject areas, 463 data entities；(7) power network numeric field data entity is abstracted, and forms power network domain information model,
Including 7 run-limiting, power network topology, generating, measurement, control area, state variable, line loss two level subject areas, 74 data
Entity.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710974446.8A CN107766493A (en) | 2017-10-19 | 2017-10-19 | A kind of patch source power network resources Model analysis system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710974446.8A CN107766493A (en) | 2017-10-19 | 2017-10-19 | A kind of patch source power network resources Model analysis system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107766493A true CN107766493A (en) | 2018-03-06 |
Family
ID=61269402
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710974446.8A Pending CN107766493A (en) | 2017-10-19 | 2017-10-19 | A kind of patch source power network resources Model analysis system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107766493A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108628931A (en) * | 2018-03-15 | 2018-10-09 | 阿里巴巴集团控股有限公司 | A kind of method, apparatus and equipment of data-driven business |
| CN109522292A (en) * | 2018-08-29 | 2019-03-26 | 云南电网有限责任公司信息中心 | Data processing equipment and method based on power grid standard uniform information model |
| CN109522367A (en) * | 2018-08-29 | 2019-03-26 | 云南电网有限责任公司信息中心 | The data processing equipment and method of power grid uniform information model |
| CN110502592A (en) * | 2019-08-27 | 2019-11-26 | 深圳供电局有限公司 | Project domain topic analysis system based on big data analysis technology |
| CN111198918A (en) * | 2020-01-17 | 2020-05-26 | 国网福建省电力有限公司 | Data processing system based on big data platform and link optimization method |
| CN112633621A (en) * | 2020-08-25 | 2021-04-09 | 南方电网科学研究院有限责任公司 | Power grid enterprise management decision system and method based on PAAS platform |
| CN112632025A (en) * | 2020-08-25 | 2021-04-09 | 南方电网科学研究院有限责任公司 | Power grid enterprise management decision support application system based on PAAS platform |
| CN113628069A (en) * | 2021-08-11 | 2021-11-09 | 广东电网有限责任公司 | Planning domain power grid data market construction method and system, computer and storage medium |
| CN113706060A (en) * | 2021-10-29 | 2021-11-26 | 中国电力科学研究院有限公司 | Power grid regulation and control data asset processing method, system, equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104134121A (en) * | 2014-07-30 | 2014-11-05 | 国家电网公司 | Method for achieving visualization of power grid information system business data |
| CN104516975A (en) * | 2014-12-29 | 2015-04-15 | 中国科学院电子学研究所 | Automatic correlation method facing multivariate data |
| CN104731791A (en) * | 2013-12-18 | 2015-06-24 | 东阳艾维德广告传媒有限公司 | Marketing analysis data market system |
| CN106339509A (en) * | 2016-10-26 | 2017-01-18 | 国网山东省电力公司临沂供电公司 | Power grid operation data sharing system based on large data technology |
| CN107256443A (en) * | 2017-04-18 | 2017-10-17 | 国网信通亿力科技有限责任公司 | Line loss real-time computing technique based on business and data integration |
-
2017
- 2017-10-19 CN CN201710974446.8A patent/CN107766493A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104731791A (en) * | 2013-12-18 | 2015-06-24 | 东阳艾维德广告传媒有限公司 | Marketing analysis data market system |
| CN104134121A (en) * | 2014-07-30 | 2014-11-05 | 国家电网公司 | Method for achieving visualization of power grid information system business data |
| CN104516975A (en) * | 2014-12-29 | 2015-04-15 | 中国科学院电子学研究所 | Automatic correlation method facing multivariate data |
| CN106339509A (en) * | 2016-10-26 | 2017-01-18 | 国网山东省电力公司临沂供电公司 | Power grid operation data sharing system based on large data technology |
| CN107256443A (en) * | 2017-04-18 | 2017-10-17 | 国网信通亿力科技有限责任公司 | Line loss real-time computing technique based on business and data integration |
Non-Patent Citations (2)
| Title |
|---|
| 王奔等: "基于 SG-CIM 的人力资源数据模型的设计与应用", 《电力信息化》 * |
| 蒋剑辉: "中药材指数信息***", 《指数创新与应用研究》 * |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108628931A (en) * | 2018-03-15 | 2018-10-09 | 阿里巴巴集团控股有限公司 | A kind of method, apparatus and equipment of data-driven business |
| CN109522292A (en) * | 2018-08-29 | 2019-03-26 | 云南电网有限责任公司信息中心 | Data processing equipment and method based on power grid standard uniform information model |
| CN109522367A (en) * | 2018-08-29 | 2019-03-26 | 云南电网有限责任公司信息中心 | The data processing equipment and method of power grid uniform information model |
| CN109522367B (en) * | 2018-08-29 | 2019-10-18 | 云南电网有限责任公司信息中心 | The data processing equipment and method of power grid uniform information model |
| CN109522292B (en) * | 2018-08-29 | 2020-02-18 | 云南电网有限责任公司信息中心 | Data processing device and method based on power grid standard unified information model |
| CN110502592B (en) * | 2019-08-27 | 2023-08-11 | 深圳供电局有限公司 | Project domain topic analysis system based on big data analysis technology |
| CN110502592A (en) * | 2019-08-27 | 2019-11-26 | 深圳供电局有限公司 | Project domain topic analysis system based on big data analysis technology |
| CN111198918A (en) * | 2020-01-17 | 2020-05-26 | 国网福建省电力有限公司 | Data processing system based on big data platform and link optimization method |
| CN112632025A (en) * | 2020-08-25 | 2021-04-09 | 南方电网科学研究院有限责任公司 | Power grid enterprise management decision support application system based on PAAS platform |
| CN112633621A (en) * | 2020-08-25 | 2021-04-09 | 南方电网科学研究院有限责任公司 | Power grid enterprise management decision system and method based on PAAS platform |
| CN113628069A (en) * | 2021-08-11 | 2021-11-09 | 广东电网有限责任公司 | Planning domain power grid data market construction method and system, computer and storage medium |
| CN113628069B (en) * | 2021-08-11 | 2023-01-20 | 广东电网有限责任公司 | Planning domain power grid data market construction method and system, computer and storage medium |
| CN113706060A (en) * | 2021-10-29 | 2021-11-26 | 中国电力科学研究院有限公司 | Power grid regulation and control data asset processing method, system, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107766493A (en) | A kind of patch source power network resources Model analysis system and method | |
| CN107256443B (en) | Line loss real-time computing technique based on business and data integration | |
| CN110175788A (en) | A kind of smart city energy cloud platform | |
| CN103679373B (en) | Produce the full chain budgetary data processing system and method for capital construction standard costs system | |
| CN110516901A (en) | Customer value hierarchical mode building system and client's layered approach based on big data | |
| CN108846644A (en) | A kind of integrated emulation technology, collaborative work, information management and project management managing and control system | |
| CN108846691A (en) | Regional grain and oil market price monitoring analysing and predicting system and monitoring method | |
| An et al. | A new approach for fair efficiency decomposition in two-stage structure system | |
| Zhang | Venture capital investment selection decision-making base on fuzzy theory | |
| CN106779104A (en) | A kind of campus maintenance service system and method based on mobile terminal | |
| CN112785427B (en) | Enterprise credit analysis system based on power data | |
| CN110852339A (en) | Industrial park industry aggregation degree quantitative evaluation method based on multiple indexes | |
| Cheng et al. | The strategic research on integrating service model for SMEs cloud supply chain in Taiwan | |
| Chen | [Retracted] Construction Project Cost Management and Control System Based on Big Data | |
| Zhu et al. | Research on Comprehensive Budget Management of Clothing E-commerce Enterprises under the Background of Big Data: Take H Group as an Example | |
| Tang et al. | [Retracted] A Comparative Study on the Competitiveness of Knowledge‐Driven Sports Brands | |
| Gong et al. | [Retracted] Green Energy Economic Efficiency and Enterprise Environmental Cost Control Based on the Internet of Things | |
| Wu et al. | Research on cost forecasting based on the BIM and neural network | |
| Fang et al. | [Retracted] Analysis of Human Resource Allocation Scheme for Digital Media Big Data Based on Recurrent Neural Network Model | |
| Niu | Smart supervision based on a new generation of information technology integration and its application | |
| Wang | [Retracted] Application Research of Data Mining in Urban Logistics Planning | |
| Wang et al. | Data analytics enabled power marketing analysis and decision-making supporting system | |
| Zhao et al. | [Retracted] The Management System Framework of Small‐and Medium‐Sized Enterprises Based on Strategic Flexible Management | |
| Zhang et al. | Production management of professional farmers under the new rural construction based on big data technology | |
| CN109242301A (en) | A kind of soil performance interactive mode real-time analysis method based on big data framework |
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: 20180306 |
|
| RJ01 | Rejection of invention patent application after publication |