CN106815373A - Big data methods of exhibiting and system are rushed to repair in distribution based on BI analyses - Google Patents

Big data methods of exhibiting and system are rushed to repair in distribution based on BI analyses Download PDF

Info

Publication number
CN106815373A
CN106815373A CN201710073063.3A CN201710073063A CN106815373A CN 106815373 A CN106815373 A CN 106815373A CN 201710073063 A CN201710073063 A CN 201710073063A CN 106815373 A CN106815373 A CN 106815373A
Authority
CN
China
Prior art keywords
information
work order
distribution
repair
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201710073063.3A
Other languages
Chinese (zh)
Other versions
CN106815373B (en
Inventor
游大宁
刘远龙
公伟勇
瞿寒冰
张远鹏
王萍
张海娟
杨慕华
杨坤
辛刚
李宁宁
王李
于立涛
隗寿晨
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Corp of China SGCC
State Grid Shandong Electric Power Co Ltd
Shandong Luruan Digital Technology Co Ltd
Original Assignee
State Grid Corp of China SGCC
State Grid Shandong Electric Power Co Ltd
Shandong Luneng Software Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by State Grid Corp of China SGCC, State Grid Shandong Electric Power Co Ltd, Shandong Luneng Software Technology Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN201710073063.3A priority Critical patent/CN106815373B/en
Publication of CN106815373A publication Critical patent/CN106815373A/en
Application granted granted Critical
Publication of CN106815373B publication Critical patent/CN106815373B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/06Energy or water supply

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Economics (AREA)
  • Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Human Resources & Organizations (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Public Health (AREA)
  • Water Supply & Treatment (AREA)
  • General Health & Medical Sciences (AREA)
  • Databases & Information Systems (AREA)
  • Marketing (AREA)
  • Primary Health Care (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

Big data methods of exhibiting and system are rushed to repair the invention discloses the distribution analyzed based on BI, the existing work order data of distribution repairing maneuvering platform, power marketing business application system interface data, power information acquisition system interface data, power distribution automation interface data etc. is collected.In by sending data to BI databases, on available data parser basis of software, realize the analysis of distribution repairing maneuvering platform relevant information and compare.Once there is data exception, by abnormal information automatic screening out, the abnormal information to filtering out is verified, and is sent again after verification and is analyzed into database, and show analysis result in front end, form distribution repairing maneuvering platform business datum form, analytic statistics form.

Description

Big data methods of exhibiting and system are rushed to repair in distribution based on BI analyses
Technical field
The present invention relates to distribution damage repair technology field, the distribution repairing big data displaying side more particularly to based on BI analyses Method and system.
Background technology
At present, the present situation of distribution repairing data display is:
1. is developed new time reporting period long, it is impossible to solve customer requirement in real time.
2. cannot dynamic configuration, have new form demand every time, be required for upgrade-system, have shadow to the stability of system Ring.
Chinese invention patent (application number:201510614724.X, patent name:A kind of electricity market based on BI analyses The methods of exhibiting of marketing decision system data), a kind of method for exhibiting data is disclosed, but it there is also certain deficiency:
1. data statistic analysis results page is poor with the correlation comparison of parent page, it is impossible to association analysis.
According to the relevant requirement that " three collection five are big " responsibility adjustment and company " first-class power distribution network " implementation management works, company adjusts Control system is disposed in basic function across the entire province and realizes stable operation, the overall process standardization of network distributing failure emergency repair business Management and control dynamics is further strengthened.Preferably to lift the lean managerial skills of company power distribution network operation, power distribution network resource is realized Distribute rationally, improve distribution optimization operation level and breakdown repair commander efficiency, reduce customer outage hours, improve power supply matter Amount, realizes safe efficient, high-quality, efficiently electric service target, it is necessary on the basis of existing power distribution network, complete multidimensional industry Distribution repairing Real Time Monitoring and the abnormality processing of data of being engaged in, build the standardized management new model of low-voltage distribution network scheduling, real The transition and upgrade of commander's business is rushed to repair in existing distribution.
In sum, field multidimensional data showing problem is rushed to repair for distribution in the prior art, still lacks effective solution Scheme.
The address information of the most of only user of fault message that user reports for repairment in the prior art, it is impossible to meet scene rush to repair Personnel's fast accurate failure judgement equipment and the requirement of position.
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.
Brief description of the drawings
The Figure of description for constituting the part of the application is used for providing further understanding of the present application, and the application's shows Meaning property embodiment and its illustrated for explaining the application, does not constitute the improper restriction to the application.
Fig. 1 is that system of the invention connects Organization Chart;
Fig. 2 is flow chart of the method for the present invention.
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.

Claims (10)

1. big data methods of exhibiting is rushed to repair in the distribution based on BI analyses, it is characterized in that,
Step (1):Data Collection and Data Integration:
Work order information is rushed to repair by 95598 system acquisition 95598, it is single to gather marketing power supply by power marketing business application system Position information, by 95598 repairing work order information storages to 95598 repairing work order information tables;Marketing power supply unit information Store is arrived In marketing power supply unit information table, and 95598 repairing work order information tables and marketing power supply unit information table are uploaded to distribution and robbed Repair maneuvering platform;The dictionary table of maneuvering platform is rushed to repair in the distribution repairing self-defined distribution of maneuvering platform;Distribution repairing maneuvering platform exists During to 95598 repairing work order information list processings, work order procedure information table is rushed to repair in generation 95598;
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 label Association, generates the details table of 95598 worksheet flows;
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, are used Report Form Design module generates the subject heading list of 95598 worksheet flow detail informations;
The 95598 repairing work order information tables and 95598 repairing work order procedure information tables that step (1) is obtained, table structure is introduced BI analysis systems, generate 95598 and rush to repair work order information subject heading list using Report Form Design module;
Marketing power supply unit information table and distribution that step (1) is obtained rush to repair the dictionary table of maneuvering platform, and table structure is introduced BI analysis systems, generate marketing power supply unit information dimension table and the word of maneuvering platform are rushed to repair in various distributions using Report Form Design module The corresponding dimension table of allusion quotation;
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) holds Line number is according to statistics.
2. big data methods of exhibiting is rushed to repair in the distribution based on BI analyses as claimed in claim 1, it is characterized in that,
The step of step (4a) is:
95598 repairing work order information subject heading lists in step (3) are carried out according to different statistical units and live classification type Classified statistics, the work order that each group of statistics has processed completion is reported quantity, effective time, duration of reaching the spot for repairment, is reached the spot Promptness rate, recovery power transmission duration, recovery power transmission promptness rate and work order return number;
Selective listing simultaneously according to marketing power supply unit information dimension table generation statistical unit and the work of corresponding 95598 work order informations The timing statisticses control of process time field carries out condition query in single message subject table.
3. big data methods of exhibiting is rushed to repair in the distribution based on BI analyses as claimed in claim 1, it is characterized in that,
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, statistics is each Client's work order that group has processed completion is reported for repairment at quantity, treatment completion work order quantity, troubleshooting total duration and mean failure rate Reason duration;
Selective listing simultaneously according to marketing power supply unit information dimension table generation statistical unit and the work of corresponding 95598 work order informations The timing statisticses control of process time field carries out condition query in single message subject table.
4. big data methods of exhibiting is rushed to repair in the distribution based on BI analyses as claimed in claim 1, it is characterized in that,
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, statistics is each Client's work order that group has processed completion reports quantity, work order backfill quantity, terminal backfill quantity and terminal backfill ratio for repairment;
Selective listing simultaneously according to marketing power supply unit information dimension table generation statistical unit and the work of corresponding 95598 work order informations The timing statisticses control of process time field carries out condition query in single message subject table.
5. big data methods of exhibiting is rushed to repair in the distribution based on BI analyses as claimed in claim 1, it is characterized in that,
The step of step (4d) is:
The subject heading list of 95598 worksheet flow detail informations in step (3) is grouped according to different statistical units Statistics, has processed the work order flow processing detail information of completion under statistics each group;The work order flow processing detail information bag Include:95598 work orders are distributed, work order examination & verification passes through, audit do not pass through, work order is recalled, rollback provincial company, when sending man-hour long and auditing It is long;
Simultaneously according to the 95598 worksheet flows 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 detail information.
6. big data methods of exhibiting is rushed to repair in the distribution based on BI analyses as claimed in claim 1, it is characterized in that, in step (5) Also include step (6) below;
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, according to all prefecture-level company's troubleshooting total durations of threshold query 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 reason for the troubleshooting total duration for analyzing work order exceeds threshold value, It is saved in 95598 repairing work order information tables, for the continuous repairing work of rear distribution provides foundation.
7. big data display systems are rushed to repair in the distribution based on BI analyses, it is characterized in that, 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;From with Power utilization information collection system obtains data, Distribution Network Failure information is obtained from electrical power distribution automatization system, from 95598 system acquisitions 95598 Repairing work order information;The data of acquisition are extracted, changed by distribution repairing maneuvering platform by BI analysis systems, statistical Analysis, most analysis result is shown at last.
8. system as claimed in claim 7, it is characterized in that,
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 into one Unique ID number;Further according to positioning malfunction approach set in each positioning malfunction approach attribute, by each No. ID with the failure The fault location scheme of a matching is bound in targeting 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 No. ID carries out classification storage;
Fault location is carried out to the information with identical No. ID respectively using the positioning malfunction approach with No. ID binding and exports fixed Position result.
9. system as claimed in claim 7, it is characterized in that,
Further, in distribution repairing maneuvering platform, and No. ID failure for matching of electrical power distribution automatization system is distributed to Targeting 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 to face When failure 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, import distribution Automated 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 system The user profile of 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, according to power network topology connection, down analyzing influence has a power failure Distribution transformer, if nothing, fault location terminates;If there is the transformer of power failure, step 1.4 is gone successively to;
Step 1.4:The power failure equipments that until user's electricity box, will be analyzed down are analyzed according to power network topology connection continuation and is imported and stopped Film rings 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, are such as associated with, It is generated as influenceing the record of 95598 work orders;As association less than, record is not generated, fault location terminates.
10. system as claimed in claim 7, it is characterized in that,
Further, in distribution repairing maneuvering platform, and the fault location side that system identifiers No. 95598 match is distributed to Case is:
Step 2.1:According to the family number in user's repairing information, marketing data is inquired about, judge demand charge information, such as arrearage is obtained The conclusion that is 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 has voltage no current to draw the knot of exception after user's table By there is voltage to there is 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 x current lacks Mutually draw 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, comparing user equipment place circuit is In line outage data known to no association, if not associating, the up transformer exception conclusion of circuit where user is drawn;If closing On connection, the specific outage information that influence user has a power failure is drawn:Plan, interim and failure simultaneously terminate;
Further, in distribution repairing maneuvering platform, with it is distributing to that power information acquisition system ID matches therefore Hindering targeting scheme is:
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, in slave unit storehouse The type of query facility, is such as user's electric energy meter equipment, and fault location terminates;It is such as distribution transformer equipment, into step 3.2;
Step 3.2:Call the real-time voltage current data for surveying transformer together, if any Current Voltage, three-phase is complete to be judged as invalid failures; 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, passes through The known outage information accessed in Distribution Fault Location System is associated with the circuit, if not associating, is judged as transformer It is abnormal;Such as in association, it is judged as plan or interim or fault outage, terminates.
CN201710073063.3A 2017-02-10 2017-02-10 Distribution network first-aid repair big data display method and system based on BI analysis Active CN106815373B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710073063.3A CN106815373B (en) 2017-02-10 2017-02-10 Distribution network first-aid repair big data display method and system based on BI analysis

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710073063.3A CN106815373B (en) 2017-02-10 2017-02-10 Distribution network first-aid repair big data display method and system based on BI analysis

Publications (2)

Publication Number Publication Date
CN106815373A true CN106815373A (en) 2017-06-09
CN106815373B CN106815373B (en) 2020-04-03

Family

ID=59112380

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710073063.3A Active CN106815373B (en) 2017-02-10 2017-02-10 Distribution network first-aid repair big data display method and system based on BI analysis

Country Status (1)

Country Link
CN (1) CN106815373B (en)

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108761272A (en) * 2018-04-25 2018-11-06 杭州华春科技有限公司 A kind of simple method for testing bacterial resistance of current leakage detection system
CN109658214A (en) * 2018-12-03 2019-04-19 厦门亿力吉奥信息科技有限公司 The movement of repairing terminal is made out an invoice analysis and method for early warning and storage medium
CN110245142A (en) * 2019-06-26 2019-09-17 广西电网有限责任公司南宁供电局 Breakdown repair aid decision and intelligent managing and control system are pressed in a kind of distribution
CN110458442A (en) * 2019-08-07 2019-11-15 成都九鼎瑞信科技股份有限公司 Water utilities system cost analysis method
CN111325422A (en) * 2018-12-14 2020-06-23 ***通信集团河南有限公司 Work order distribution method and system
CN111709629A (en) * 2020-06-05 2020-09-25 航电建筑科技(深圳)有限公司 Property equipment maintenance work order query method
CN112444687A (en) * 2019-08-29 2021-03-05 北京科东电力控制***有限责任公司 Effective power failure event studying and judging method and device
CN112865316A (en) * 2021-01-22 2021-05-28 国网冀北电力有限公司廊坊供电公司 Power supply service analysis command system and method based on big data
CN115905364A (en) * 2022-12-07 2023-04-04 国网江苏省电力有限公司苏州供电分公司 Electric power marketing data analysis system and method

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102570602A (en) * 2011-12-04 2012-07-11 江苏省电力公司南京供电公司 Fault comprehensive processing platform and method of distribution network
CN103915827A (en) * 2014-03-14 2014-07-09 国网山东省电力公司青岛供电公司 Power distribution network fault studying and judging method and system
CN104091231A (en) * 2014-06-30 2014-10-08 国家电网公司 Distribution network fault repairing commanding and processing system and method
CN104240043A (en) * 2014-10-10 2014-12-24 国家电网公司 Full-service centralized management service platform for electric power customer service based on number 95598
CN105719076A (en) * 2016-01-19 2016-06-29 国网山东省电力公司青岛供电公司 Big data work order processing method and device
CN105809373A (en) * 2016-04-27 2016-07-27 国网山东省电力公司济南市长清区供电公司 Distribution network fault information comprehensive collection and management platform

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102570602A (en) * 2011-12-04 2012-07-11 江苏省电力公司南京供电公司 Fault comprehensive processing platform and method of distribution network
CN103915827A (en) * 2014-03-14 2014-07-09 国网山东省电力公司青岛供电公司 Power distribution network fault studying and judging method and system
CN104091231A (en) * 2014-06-30 2014-10-08 国家电网公司 Distribution network fault repairing commanding and processing system and method
CN104240043A (en) * 2014-10-10 2014-12-24 国家电网公司 Full-service centralized management service platform for electric power customer service based on number 95598
CN105719076A (en) * 2016-01-19 2016-06-29 国网山东省电力公司青岛供电公司 Big data work order processing method and device
CN105809373A (en) * 2016-04-27 2016-07-27 国网山东省电力公司济南市长清区供电公司 Distribution network fault information comprehensive collection and management platform

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
宋丹等: "新兴技术在商业智能创新发展中的应用", 《中国管理信息化》 *

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108761272A (en) * 2018-04-25 2018-11-06 杭州华春科技有限公司 A kind of simple method for testing bacterial resistance of current leakage detection system
CN109658214A (en) * 2018-12-03 2019-04-19 厦门亿力吉奥信息科技有限公司 The movement of repairing terminal is made out an invoice analysis and method for early warning and storage medium
CN111325422A (en) * 2018-12-14 2020-06-23 ***通信集团河南有限公司 Work order distribution method and system
CN111325422B (en) * 2018-12-14 2023-10-27 ***通信集团河南有限公司 Work order dispatching method and system
CN110245142A (en) * 2019-06-26 2019-09-17 广西电网有限责任公司南宁供电局 Breakdown repair aid decision and intelligent managing and control system are pressed in a kind of distribution
CN110458442A (en) * 2019-08-07 2019-11-15 成都九鼎瑞信科技股份有限公司 Water utilities system cost analysis method
CN112444687A (en) * 2019-08-29 2021-03-05 北京科东电力控制***有限责任公司 Effective power failure event studying and judging method and device
CN111709629A (en) * 2020-06-05 2020-09-25 航电建筑科技(深圳)有限公司 Property equipment maintenance work order query method
CN112865316A (en) * 2021-01-22 2021-05-28 国网冀北电力有限公司廊坊供电公司 Power supply service analysis command system and method based on big data
CN112865316B (en) * 2021-01-22 2023-06-02 国网冀北电力有限公司廊坊供电公司 Big data-based power supply service analysis command system and method
CN115905364A (en) * 2022-12-07 2023-04-04 国网江苏省电力有限公司苏州供电分公司 Electric power marketing data analysis system and method

Also Published As

Publication number Publication date
CN106815373B (en) 2020-04-03

Similar Documents

Publication Publication Date Title
CN106815373A (en) Big data methods of exhibiting and system are rushed to repair in distribution based on BI analyses
CN106815709B (en) Service quick response center support system and method
CN106875114A (en) The SMS platform optimization system and method for distribution repairing maneuvering platform
CN109460833B (en) Method and system for processing equipment data and repair work order data of distribution network fault
CN102570602B (en) Fault comprehensive processing platform and method of distribution network
CN106990328A (en) The analysis of distribution repairing abnormal data, fault location system and method
CN107909295A (en) A kind of outage information monitor and analysis system
CN106557991A (en) Voltage monitoring data platform
CN106872856A (en) Distribution network failure based on polynary fault collection actively rushes to repair system, method
CN110570101A (en) Intelligent OMS system for power grid distribution network
CN109447284B (en) Distribution network fault information sending method and system for power supply service command platform
CN105809373A (en) Distribution network fault information comprehensive collection and management platform
CN110647567B (en) Power failure plan auxiliary decision system based on end data fusion
CN110879327B (en) 10KV line monitoring method by multi-data fusion
CN107167704A (en) Fault Diagnosis of Distribution Network system and method based on CIM
CN107256442B (en) Line loss calculation method based on mobile client
CN109615088A (en) A kind of processing operation/maintenance work orders based on power information acquisition label
CN106814286A (en) Distribution Fault Location System, method and server based on polynary fault collection
CN104881737A (en) Control figure billing system
CN106374458A (en) Intelligent analysis method for identifying unreasonable power-failure management
CN113610253A (en) Operation and maintenance management type photovoltaic station control system based on CS version
CN111667143A (en) Method for realizing fusion of real-time monitoring data and service management data in power grid dispatching
CN109523422A (en) A kind of method for digging of distribution network failure influence factor
CN109035062A (en) A kind of client's electricity charge anomaly analysis and tactful application system
CN109193946B (en) Urgent repair information release system for power consumer

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
GR01 Patent grant
GR01 Patent grant
CP01 Change in the name or title of a patent holder

Address after: 250001 No. 150 Jing No. 2 Road, Jinan City, Shandong Province

Patentee after: STATE GRID SHANDONG ELECTRIC POWER Co.

Patentee after: STATE GRID CORPORATION OF CHINA

Patentee after: Shandong luruan Digital Technology Co.,Ltd.

Address before: 250001 No. 150 Jing No. 2 Road, Jinan City, Shandong Province

Patentee before: STATE GRID SHANDONG ELECTRIC POWER Co.

Patentee before: State Grid Corporation of China

Patentee before: SHANDONG LUNENG SOFTWARE TECHNOLOGY Co.,Ltd.

CP01 Change in the name or title of a patent holder