The content of the invention
In order to solve the deficiencies in the prior art, the invention provides a kind of distribution repairing big data displaying based on BI analyses
Method and system, collect the existing work order data of distribution repairing maneuvering platform, power marketing business application system interface data, electricity consumption
Information acquisition system interface data, power distribution automation interface data etc..In by sending data to BI databases, in existing number
According on parser basis of software, realize distribution repairing maneuvering platform relevant information analysis and compare.It is different once data occur
Often, by abnormal information automatic screening out, the abnormal information to filtering out is verified, and is sent again to database after verification
In be analyzed, and show analysis result in front end, form distribution repairing maneuvering platform business datum form, analytic statistics report
Table.
Big data methods of exhibiting is rushed to repair the invention provides a kind of distribution based on BI analyses, including:
Step (1):Data Collection and Data Integration:
Work order information is rushed to repair by 95598 system acquisition 95598, gathering marketing by power marketing business application system supplies
Electric unit information, by 95598 repairing work order information storages to 95598 repairing work order information tables;Marketing power supply unit information is deposited
In storing up marketing power supply unit information table, and 95598 repairing work order information tables and marketing power supply unit information table are uploaded to and matched somebody with somebody
Net repairing maneuvering platform;The dictionary table of maneuvering platform is rushed to repair in the distribution repairing self-defined distribution of maneuvering platform;Repairing commander is flat for distribution
During to 95598 repairing work order information list processings, work order procedure information table is rushed to repair in generation 95598 to platform;
Step (2):Data pick-up:
The 95598 repairing work order information tables and 95598 repairing work order procedure information tables obtained to step (1) carry out work order mark
Number association, generate 95598 worksheet flows details table;
Step (3):Data conversion:
The table structural information of the details table of the 95598 worksheet flows that step (2) is obtained introduces BI analyses system
System, the subject heading list of 95598 worksheet flow detail informations is generated using Report Form Design module;
The table structural information of the 95598 repairing work order information tables that step (1) is obtained introduces BI analysis systems, uses form
Work order information subject heading list is rushed to repair in design module generation 95598;
The table structure of the dictionary table of the marketing power supply unit information table that step (1) is obtained and distribution repairing maneuvering platform is drawn
Enter BI analysis systems, generate marketing power supply unit information dimension table using Report Form Design module and maneuvering platform is rushed to repair in various distributions
The corresponding dimension table of dictionary;
Step (4):Data statistics processing:
Step (4a):Worksheet situation is counted;Step (4b):TT processing duration is counted;
Step (4c):Breakdown gang's terminal receipt rate statistics;Step (4d):Seat personnel work statistic;
Step (5):Verification modification is carried out to the abnormal information in step (4), amended information is again returned into step
(4) data statistics is performed.
The step of step (4a) is:
Work order information subject heading lists are rushed to repair into 95598 in step (3) according to different statistical units and live classification type
Classified statistics are carried out, the work order that each group of statistics has processed completion is reported quantity, effective time, duration of reaching the spot for repairment, reached
Live promptness rate, recovery power transmission duration, recovery power transmission promptness rate and work order return number;
Simultaneously according to 95598 work order informations of selective listing and correspondence of marketing power supply unit information dimension table generation statistical unit
Work order information subject heading list in the timing statisticses control of process time field carry out condition query.
The step of step (4b) is:
95598 repairing work order information subject heading lists in step (3) are carried out into classified statistics according to different statistical units, is united
Client's work order that meter each group has processed completion reports quantity, treatment completion work order quantity, troubleshooting total duration and average event for repairment
Barrier handling duration;
Simultaneously according to 95598 work order informations of selective listing and correspondence of marketing power supply unit information dimension table generation statistical unit
Work order information subject heading list in the timing statisticses control of process time field carry out condition query.
The step of step (4c) is:
95598 repairing work order information subject heading lists in step (3) are carried out into classified statistics according to different statistical units, is united
Client's work order that meter each group has processed completion reports quantity, work order backfill quantity, terminal backfill quantity and terminal backfill ratio for repairment;
Simultaneously according to 95598 work order informations of selective listing and correspondence of marketing power supply unit information dimension table generation statistical unit
Work order information subject heading list in the timing statisticses control of process time field carry out condition query.
The step of step (4d) is:
The subject heading list of 95598 worksheet flow detail informations in step (3) is carried out according to different statistical units
Classified statistics, have processed the work order flow processing detail information of completion under statistics each group;The work order flow processing details letter
Breath includes:95598 work orders are distributed, work order examination & verification passes through, audit do not pass through, work order is recalled, rollback provincial company, send man-hour long and careful
Core duration;
Simultaneously according to 95598 worksheets of selective listing and correspondence of marketing power supply unit information dimension table generation statistical unit
The timing statisticses control of process time field carries out condition query in the subject heading list of flow detail information.
Step (6):Data statistics interpretation of result:Step (4b) data statistics result is analyzed;
Step (6a):Extract the work order list associated by troubleshooting total duration;
Step (6b):The threshold value of troubleshooting total duration is set, it is total according to all prefecture-level company's troubleshootings of threshold query
Duration is more than the work order data of threshold value, if statistical magnitude is 0, then it represents that without the work order for needing analysis;Otherwise enter step
(6c);
Step (6c):Work order is analyzed, the detail information of work order and each flow processing duration of work order is analyzed;
Step (6d):According to the analysing content of step (6c), the troubleshooting total duration of work order is analyzed beyond threshold value
Reason, is saved in 95598 repairing work order information tables, for the continuous repairing work of rear distribution provides foundation.
Big data display systems are rushed to repair in distribution based on BI analyses, including:
Maneuvering platform is rushed to repair in distribution, and the distribution is rushed to repair maneuvering platform and obtains data from power marketing business application system;
Data are obtained from power information acquisition system, Distribution Network Failure information is obtained from electrical power distribution automatization system, from 95598 system acquisitions
95598 repairing work order informations;The data of acquisition are extracted, are changed, are united by distribution repairing maneuvering platform by BI analysis systems
Meter analysis, most analysis result is shown at last.
Maneuvering platform is rushed to repair in distribution, the positioning that is inside also stored with malfunction approach set;
Maneuvering platform is rushed to repair in distribution, and electrical power distribution automatization system, 95598 systems and power information acquisition system are respectively allocated
One unique ID number;Further according to positioning malfunction approach set in each positioning malfunction approach attribute, by each No. ID with it is described
The fault location scheme of a matching is bound in fault location scheme set;
Receive the next information of electrical power distribution automatization system, 95598 systems and power information acquisition system transmission and be respectively associated
Corresponding ID number carries out classification storage;
Fault location and defeated is carried out to the information with identical No. ID respectively using the positioning malfunction approach with No. ID binding
Go out positioning result.
Further, in distribution repairing maneuvering platform, and distribute to what electrical power distribution automatization system ID matched
Fault location scheme is:
Step 1.1:The next Distribution Network Failure information of electrical power distribution automatization system transmission of distributing to receiving carries out failure judgement
It is temporary derangement or permanent fault;If temporary derangement, then fault location terminates;Otherwise enter step 1.2;
Step 1.2:According to faulty equipment line topological relation, the 10kV power failure equipments information of fault impact is analyzed, imported
Electrical power distribution automatization system has a power failure in influence table;The batch meter of power failure is further analyzed according to equipment topological relation, according to marketing
The user profile of system maintenance, the user profile of the influence that has a power failure is imported in the influence user's table that has a power failure;
Step 1.3:According to the 10kV power failure equipments that step 1.2 is analyzed, down analyzing influence is connected according to power network topology
The distribution transformer of power failure, if nothing, fault location terminates;If there is the transformer of power failure, step 1.4 is gone successively to;
Step 1.4:Continue down to analyze until user's electricity box according to power network topology connection, the power failure equipments that will be analyzed are led
Enter to have a power failure influence table, into step 1.5;
Step 1.5:The power failure electricity box that facility information associated steps 1.4 in user's repairing information are analyzed, such as close
It is linked to, is generated as influenceing the record of 95598 work orders;As association less than, record is not generated, fault location terminates.
Its produce effect be:The power failure that the equipment that breaks down and the failure cause can be accurately positioned by the method
Region and user, facilitate scene rush to repair personnel to understand fault details and formulate fault solution, select suitable first-aid repair machine
Tool and goods and materials, reduction cause solution formulation mistake or repairing utensil to carry mistake and waste because fault details do not know about
Time.Outage information is actively sent to the customer interrupted for analyzing to notify and inform troubleshooting situation, reduce user malfunction
Report quantity for repairment, improve user satisfaction.
Further, in distribution repairing maneuvering platform, determine with the failure that system identifiers No. 95598 match is distributed to
Position scheme be:
Step 2.1:According to the family number in user's repairing information, marketing data is inquired about, judge demand charge information, such as owed
Take, the conclusion that must be out of order subscriber arrearage, breakdown judge terminates;Such as without arrearage information, into step 2.2;
Step 2.2:Call survey user's electric energy meter information together, calling the data for measuring together, to have voltage no current to draw abnormal after user's table
Conclusion, has voltage to have electric current to draw the normal conclusion of electric supply meter;As no-voltage and electric current enter step 2.3;
Step 2.3:Call the information for surveying user's distribution transformer together, there is voltage and electric current, draw family table exception conclusion, voltage electricity
Stream phase shortage draws low-voltage circuit exception conclusion;No-voltage electric current, into step 2.4;
Step 2.4:The line outage information accessed by Distribution Fault Location System, compares user equipment institute online
Whether road is associated in known line outage data, if not associating, draws the up transformer exception conclusion of circuit where user;
If in association, drawing the specific outage information that influence user has a power failure:Plan, interim and failure simultaneously terminate.
Its produce effect be:Administrative address in user's repairing information is converted into the power equipment letter in adapted power network
Breath, whether by the inquiry of marketing management information, it is arrearage, arrearage situation direct feedback user, it is to avoid blind to judge that user has a power failure
The repairing wasting of resources that work of mesh sending is caused.It is not the situation of arrearage, analyzes the reason for causing failure, fault point, it is convenient existing
Understanding of the field repair personnel to fault details, formulates suitable Rush Repair Scheme, is rapidly completed the treatment of failure, reduces power failure thing
Part, improves user satisfaction.
Further, in distribution repairing maneuvering platform, match with power information acquisition system ID is distributed to
Fault location scheme be:
Step 3.1:The equipment that the association of each acquisition terminal equipment has a power failure in the power utilization information collection system that will be uploaded, slave unit
The type of query facility in storehouse, is such as user's electric energy meter equipment, and fault location terminates;It is such as distribution transformer equipment, into step
Rapid 3.2;
Step 3.2:Call the real-time voltage current data for surveying transformer together, if any Current Voltage, three-phase is complete be judged as it is invalid
Failure;Such as no-voltage electric current, into step 3.3;
Step 3.3:Step 3.2 judges the transformer of no current voltage, is connected according to line topological, derives the circuit,
Associated with the circuit by the known outage information accessed in Distribution Fault Location System, if not associating, be judged as becoming
Depressor exception;Such as in association, it is judged as plan or interim or fault outage, terminates.
Its produce effect be:Faulty equipment is accurately positioned, facilitates formulation and repair personnel and the goods and materials of Rush Repair Scheme
Scheduling.Further by historical data analysis, circuit or equipment that derivation power failure is three times and more than three times are distribution transformation
Foundation is provided.
The detail information of the work order, including:The essential information of failure, failure cause (influence troubleshooting duration), therefore
Barrier address (having influence on up to fault in-situ duration);
The work order each flow processing duration, including:Reach the spot duration, in-situ processing duration recovers power transmission duration,
Examination & verification duration.
The statistical unit refer to provincial company, electric company of province, electric company of city, electric company of county, customer service center,
Power supply station and breakdown gang.
95598 repairing work order information tables:Essential information and 95598 repairing work orders comprising 95598 repairing work orders are in treatment
Business datum in the process time point and flow that are gathered in flow.95598 repairing work orders essential informations include work order number,
Flow state and process time.
Marketing power supply unit information table:Comprising power supply unit numbering, title, higher level's work order unit, work order unit class (state
Net unit, provincial company, prefecture-level company, district company, branch company, power supply station etc.), whether unit effectively identifies.
95598 repairing work order procedure information tables:Comprising work order number, fault type, work order flow state, treatment people's letter
Breath, handling process description information.
The dictionary table of maneuvering platform is rushed to repair in distribution:Comprising marking code, code classification mark, higher level's marking code, code
The fields such as classification, code value, name of code, display sequence number.
The details table of 95598 worksheet flows:It is that work order information table and 95598 repairing works are rushed to repair in association 95598
What single process information table occurred, associate field is work order number, is closed by master meter of 95598 repairing work order procedure information tables
Connection.
Subject heading list is the central table in Based Data Warehouse System, it include the digital metric value of contact subject heading list and dimension table and
Key.Subject data table includes describing the data of narration business (such as work order flow) interior particular event.
Dimension table is the set of dimensional attribute.It is a forms of problem analysis.The specific angle of data is observed, is a class property
When to consider a problem, the size of the attribute composition of collection.
Distribution rushes to repair maneuvering platform during to 95598 repairing work order information list processings, and 95598 rush to repair work order information tables
Each information occurs change can all generate a work order procedure information, the work order procedure information storage to 95598 repairing works
In single process information table.
Work order can be changed when distributing 95598 repairing work order informations distribute personnel and work order distributes the time, while generation one
95598 new work order procedure informations of bar are stored in 95598 repairing work order procedure information tables.
Distribution rushes to repair maneuvering platform during to 95598 repairing work order information list processings, according in national grid system
Work order data are rushed to repair in power information acquisition system interface data, electrical power distribution automatization system interface data and 95598 by Customs Assigned Number
Be associated analysis, fed back according to analysis result or arrangement personnel reach the spot, scene rush to repair and recover power transmission, according to
Reach the spot, scene rush to repair, recover power transmission difference flow, distribution repairing maneuvering platform receives different work order status information and places
Reason opinion, each step can increase corresponding work order procedure information newly in work order procedure information table, and work order is rushed to repair in generation 95598
Procedure information table.
Live classification type refer to distribution repairing maneuvering platform dictionary table in configure generation power-off fault live institute
The areal type of category, for example:City or rural area.
Classified statistics are that the data of inquiry are grouped according to electric company's title first, then that each districts and cities are public
The included data of department are grouped in the service centre for installing subordinate, finally by the data of each service centre according to classification now
Information is grouped.
Compared with prior art, the beneficial effects of the invention are as follows:
Related data is extracted from multidimensional business platform to be analyzed and provide distribution repairing maneuvering platform by result data,
Regulation and control care workers can carry out referring to and Pre-Evaluation effect according to accurate analysis result;
The data that distribution repairing maneuvering platform available data and relevant interface are accessed are collected, by data inputting BI databases
In, relevant search information field screens abnormal information, is re-typed after confirmation, and the field information to inquiring is divided
Analysis, foreground is illustrated in by analysis result, realizes the visualization of data analysis.
BI big data analysis means are rushed to repair by distribution, repairing operator on duty's express statistic business datum is done step-by-step, it is right
Data are analyzed, and by analysis result, it is determined that interim operating efficiency, plans next stage target, effectively improve master
Dynamic repairing ability, lifting breakdown repair efficiency, reduce distribution security risk and General Promotion is powered good service level.
Specific embodiment
The present invention will be further described with reference to the accompanying drawings and examples.
As shown in figure 1, big data display systems are rushed to repair in the distribution based on BI analyses, including:
Maneuvering platform is rushed to repair in distribution, and the distribution is rushed to repair maneuvering platform and obtains data from power marketing business application system;
Data are obtained from power information acquisition system, Distribution Network Failure information is obtained from electrical power distribution automatization system, from 95598 system acquisitions
95598 repairing work order informations;The data of acquisition are extracted, are changed, are united by distribution repairing maneuvering platform by BI analysis systems
Meter analysis, most analysis result is shown at last.
As shown in Fig. 2 big data methods of exhibiting is rushed to repair in a kind of distribution based on BI analyses, including:
Step (1):Data Collection and Data Integration:
Work order information is rushed to repair by 95598 system acquisition 95598, gathering marketing by power marketing business application system supplies
Electric unit information, by 95598 repairing work order information storages to 95598 repairing work order information tables;Marketing power supply unit information is deposited
In storing up marketing power supply unit information table, and 95598 repairing work order information tables and marketing power supply unit information table are uploaded to and matched somebody with somebody
Net repairing maneuvering platform;
The dictionary table of maneuvering platform is rushed to repair in the distribution repairing self-defined distribution of maneuvering platform;
Distribution rushes to repair maneuvering platform during to 95598 repairing work order information list processings, and work order stream is rushed to repair in generation 95598
Journey information table;
Step (2):Data pick-up:
The 95598 repairing work order information tables and 95598 repairing work order procedure information tables obtained to step (1) carry out work order mark
Number association, generate 95598 worksheet flows details table;
Step (3):Data conversion:
The details table of the 95598 worksheet flows that step (2) is obtained, BI analysis systems are introduced by table structure,
The subject heading list of 95598 worksheet flow detail informations is generated using Report Form Design module;
The 95598 repairing work order information tables and 95598 repairing work order procedure information tables that step (1) is obtained, by table structure
BI analysis systems are introduced, generating 95598 using Report Form Design module rushes to repair work order information subject heading list;
Marketing power supply unit information table and distribution that step (1) is obtained rush to repair the dictionary table of maneuvering platform, by table structure
BI analysis systems are introduced, marketing power supply unit information dimension table is generated using Report Form Design module and maneuvering platform is rushed to repair in various distributions
The corresponding dimension table of dictionary;
Step (4):Data statistics processing:
Step (4a):Worksheet situation is counted:
Work order information subject heading lists are rushed to repair into 95598 in step (3) according to different statistical units and live classification type
Classified statistics are carried out, the work order that each group of statistics has processed completion is reported quantity, effective time, duration of reaching the spot for repairment, reached
Live promptness rate, recovery power transmission duration, recovery power transmission promptness rate and work order return number;
Simultaneously according to 95598 work order informations of selective listing and correspondence of marketing power supply unit information dimension table generation statistical unit
Work order information subject heading list in the timing statisticses control of process time field carry out condition query.
Step (4b):TT processing duration is counted:
95598 repairing work order information subject heading lists in step (3) are carried out into classified statistics according to different statistical units, is united
Client's work order that meter each group has processed completion reports quantity, treatment completion work order quantity, troubleshooting total duration and average event for repairment
Barrier handling duration;
Simultaneously according to 95598 work order informations of selective listing and correspondence of marketing power supply unit information dimension table generation statistical unit
Work order information subject heading list in the timing statisticses control of process time field carry out condition query.
Step (4c):Breakdown gang's terminal receipt rate statistics:
95598 repairing work order information subject heading lists in step (3) are carried out into classified statistics according to different statistical units, is united
Client's work order that meter each group has processed completion reports quantity, work order backfill quantity, terminal backfill quantity and terminal backfill ratio for repairment;
Simultaneously according to 95598 work order informations of selective listing and correspondence of marketing power supply unit information dimension table generation statistical unit
Work order information subject heading list in the timing statisticses control of process time field carry out condition query.
Step (4d):Seat personnel work statistic:
The subject heading list of 95598 worksheet flow detail informations in step (3) is carried out according to different statistical units
Classified statistics, have processed the work order flow processing detail information of completion under statistics each group;The work order flow processing details letter
Breath includes:95598 work orders are distributed, work order examination & verification passes through, audit do not pass through, work order is recalled, rollback provincial company, send man-hour long and careful
Core duration;
Simultaneously according to 95598 worksheets of selective listing and correspondence of marketing power supply unit information dimension table generation statistical unit
The timing statisticses control of process time field carries out condition query in the subject heading list of flow detail information.
Step (5):Verification modification is carried out to the abnormal information in step (4), amended information is again returned into step
(4) data statistics is performed.
Step (6):Data statistics interpretation of result:
Step (4b) data statistics result is analyzed;
Step (6a):Extract the work order list associated by troubleshooting total duration;
Step (6b):The threshold value of troubleshooting total duration is set, it is total according to all prefecture-level company's troubleshootings of threshold query
Duration is more than the work order data of threshold value, if statistical magnitude is 0, then it represents that without the work order for needing analysis;Otherwise enter step
(6c);
Step (6c):Work order is analyzed, the detail information of work order and each flow processing duration of work order is analyzed;
Step (6d):According to the analysing content of step (6c), the troubleshooting total duration of work order is analyzed beyond threshold value
Reason, is saved in 95598 repairing work order information tables, for the continuous repairing work of rear distribution provides foundation.
The particular technique that BI big datas are used is as follows:
1. OracleExadata data warehouses are used, it is ensured that the carrying out safety backup of data.
2. typing, data processing, analysis are carried out to data using Yonghong Data Mart Data Marts.
Yonghong Data Mart Floor layer Technologies:1) Distributed Calculation;2) distributed communication;3) internal memory is calculated;4) arrange
Storage;5) calculated in storehouse.
3. leading portion Open-Source Tools use JasperSoft, and the leading portion for realizing data processing shows.
The seat personnel of distribution repairing maneuvering platform, can basis after the 95598 repairing work order informations attended a banquet and distribute are received
In national grid system Customs Assigned Number by power information acquisition system interface data, electrical power distribution automatization system interface data with
95598 repairing work order data are associated analysis, fed back according to analysis result or arrangement personnel reach the spot, scene is robbed
Power transmission is repaiied and recovered, and final process result is submitted to examination & verification of attending a banquet.Background data base can be repaiied according to the difference of operating process
Change the reaching the spot of 95598 repairing work orders, scene rush to repair, recover power transmission and work order submits the msu message (time of each step to
Point, the supplement of key point information), each step can increase corresponding work order procedure information newly in database.
The seat personnel of distribution repairing maneuvering platform can check submission information after the msu message that breakdown gang submits to,
After inspection has no problem, can audit and pass through, file, call power marketing business application system interface synchronization result.Meanwhile, backstage
95598 work order informations in database can be changed, and increases a work order auditing flow information newly.Otherwise, breakdown gang's weight can be return
Examination & verification is submitted in new modification to.
The preferred embodiment of the application is the foregoing is only, the application is not limited to, for the skill of this area
For art personnel, the application can have various modifications and variations.It is all within spirit herein and principle, made any repair
Change, equivalent, improvement etc., should be included within the protection domain of the application.