CN113313475A - Intelligent skill review method based on big data - Google Patents
Intelligent skill review method based on big data Download PDFInfo
- Publication number
- CN113313475A CN113313475A CN202110689814.0A CN202110689814A CN113313475A CN 113313475 A CN113313475 A CN 113313475A CN 202110689814 A CN202110689814 A CN 202110689814A CN 113313475 A CN113313475 A CN 113313475A
- Authority
- CN
- China
- Prior art keywords
- data
- review
- technical
- intelligent
- matching
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000012552 review Methods 0.000 title claims abstract description 82
- 238000000034 method Methods 0.000 title claims abstract description 20
- 238000004458 analytical method Methods 0.000 claims abstract description 9
- 230000000007 visual effect Effects 0.000 claims abstract description 7
- 238000013075 data extraction Methods 0.000 claims abstract description 4
- 238000005516 engineering process Methods 0.000 claims description 6
- 238000007405 data analysis Methods 0.000 claims description 5
- 238000004140 cleaning Methods 0.000 claims description 3
- 238000013210 evaluation model Methods 0.000 claims description 3
- 238000007781 pre-processing Methods 0.000 claims description 3
- 230000008569 process Effects 0.000 claims description 3
- 238000005215 recombination Methods 0.000 claims description 3
- 230000006798 recombination Effects 0.000 claims description 3
- 238000003860 storage Methods 0.000 claims description 2
- 238000011156 evaluation Methods 0.000 abstract description 3
- 238000010276 construction Methods 0.000 description 5
- 238000004519 manufacturing process Methods 0.000 description 5
- 238000011161 development Methods 0.000 description 4
- 238000004364 calculation method Methods 0.000 description 2
- 238000007728 cost analysis Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 238000005259 measurement Methods 0.000 description 2
- 238000012916 structural analysis Methods 0.000 description 2
- 230000009466 transformation Effects 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 238000012854 evaluation process Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 239000004615 ingredient Substances 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 229920006395 saturated elastomer Polymers 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2468—Fuzzy queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
An intelligent technical review method based on big data comprises the steps of building a technical data base by data such as technical history data and electric power industry review specifications, then extracting data for technical review from a technical review actual service scene, building a technical review data pool, extracting the data in the built technical data base to build a data extraction model, dividing the data to be reviewed into structured data and unstructured data, finally forming one-to-one correspondence between the technical review data pool and the extracted data through the structured data, combining artificial adjustment to complete data matching and build a data matching model, simultaneously performing data matching comparison between the technical review data pool and the unstructured data to be reviewed, designing a review mode, further building an intelligent review model, then obtaining the data to be analyzed from the review data base, and realizing visual presentation after intelligent review, greatly improving the evaluation efficiency of the experts and better supporting the experts to finish evaluation and analysis work.
Description
Technical Field
The invention relates to the technical field of technical review, in particular to an intelligent technical review method based on big data.
Background
With the vigorous development of the electric power industry in China, the cost review is changing to the direction of intelligence, high efficiency and lean development, but the problems of isolated and dispersed data of historical skills, shortage of talents of review experts, saturated business volume, no formation of a systematic review mechanism and the like influence the development of the skill review.
The existing electric power industry still adopts the traditional manual mode to review, not only the workload is large, but also the defects of incomplete review and the like exist, although the improvement is carried out on the traditional manual review, only the management modes on the lines of review flow circulation, data collection and the like are emphasized, for example: the on-line informatization of the appraisers, the on-line online evaluation process, the on-line filling of the appraisers and the like can only meet the management functions of standardizing the appraising process and storing the appraising data, and cannot essentially reduce the current situation of the appraisers of the technology; huge historical skill data can not be reasonably utilized as data support for next evaluation, and the functions of intelligently analyzing the manufacturing cost file, intelligently generating analysis results, analyzing big data and the like can not be realized.
In order to promote the development of more scientific, more comprehensive and more deep investment cost analysis and cost examination of power grid projects, a technology based on big data acquisition and intelligent matching is urgently needed to be constructed for intelligent review so as to improve the quality and effect of the review.
Disclosure of Invention
The technical problem to be solved by the invention is to provide an intelligent skill review method based on big data to solve the problems in the background art.
The technical problem solved by the invention is realized by adopting the following technical scheme:
the intelligent technology review method based on big data comprises the following specific steps:
step 1) establishing a technical course database
Acquiring typical engineering data of nearly five years, preprocessing the data, importing the preprocessed data into a constructed technical data base, extracting technical indexes of key characteristics of the engineering from the engineering data of the technical data base through structural analysis to serve as identification codes, and performing report visual display on the technical data;
step 2) establishing a technical review data pool
Extracting data for technical review from an actual technical review service scene, and then building a technical review data pool for intelligent matching analysis;
step 3) extracting data
Extracting data in the technical data base built in the step 1), constructing a data extraction model, and dividing the data to be evaluated into structured data and unstructured data by a big data analysis method, wherein the structured data is used as a key factor for later stage matching, and the unstructured data is used as scanned content;
step 4) establishing a data matching model
Forming one-to-one correspondence between the technical review data pool established in the step 2) and the data extracted in the step 3) through structured data, and establishing a data matching model by combining artificial adjustment to complete data matching, and simultaneously performing data matching comparison on the technical review data pool and the non-structural data to be reviewed;
step 5) establishing an intelligent evaluation model
After the data continuously accumulated in the steps 1) to 4) are refined and upgraded, a review mode is designed, an intelligent review model is further established, data to be analyzed are obtained from a review database, and the complete review process and content are analyzed, so that the intelligent review is completed and the visual display is realized.
In the invention, the preprocessing in the step 1) comprises cleaning, statistics/analysis and classification of data.
In the invention, the data for technical review in the step 2) comprises compliance review data and industry normative data, the industry normative data is split, and an identification code is set for each split sub-item for classified storage.
In the invention, the structured data in the step 3) is identified and inquired through keyword fuzzy identification, and the unstructured data is analyzed and extracted to identify and inquire the key field.
In the invention, the data matching model in the step 4) realizes data matching through keyword identification, category matching and field splitting, recombining and matching.
In the invention, after the data to be analyzed is obtained from the review database in the step 5), the data to be analyzed is obtained through engineering key characteristic technical indexes, the intelligent review model adopts field recombination, forms byte splicing, outputs splicing results after completing comparison, and completes highlight visual display of data results according to the splicing results.
Has the advantages that: according to the invention, an intelligent technical review mode is constructed by extracting the data value, and the expert is assisted to finish the technical review work in a brand-new intelligent review mode, so that the review efficiency of the expert can be greatly improved, and the expert is better supported to finish the review analysis work; meanwhile, auxiliary work such as technical data analysis, cost control index measurement and updating, quota adjustment coefficient measurement and calculation and the like is provided, so that the potential of historical big data analysis is fully explored.
Drawings
FIG. 1 is a flow chart of the preferred embodiment of the present invention.
Detailed Description
In order to make the technical means, the creation characteristics, the achievement purposes and the effects of the invention easy to understand, the invention is further explained below by combining the specific drawings.
Referring to fig. 1, the intelligent technology review method based on big data specifically comprises the following steps:
step 1) establishing a technical course database
Typical engineering data of nearly five years are collected, the data are cleaned, counted/analyzed, classified and then imported into a constructed technical data base, and then key engineering characteristic technical indexes (such as ' main transformer capacity, current stage number, long stage number, 220kV/110kV/20kV/10kV outgoing line side loop number, power distribution device and arrangement mode ' required to be extracted in power transformation engineering, voltage grade, wire section, loop number, path length, wire name, specification and laying mode ' required to be extracted in line engineering are extracted to serve as identification codes, and report visualization display is carried out on the technical data through structural analysis;
step 2) establishing a technical review data pool
The intelligent review can realize compliance review and normative review, such as: the method comprises the steps of splitting typical construction cost data of the south network with industrial normativity, setting identification codes for each split sub-item, and storing in a classified mode, so that a material data pool, a typical construction cost data pool, a fee-taking data pool and the like are built;
taking the typical cost of south net as an example:
table 1 south net typical cost data building part table building part
TABLE 2 typical cost data of south network and other fee combination table
The typical construction cost data of the south network is subjected to modularized splitting, then the data of each part are assigned to different parts, finally module matching is carried out, and modularized splicing calculation is completed, for example: typical manufacturing cost A total (static investment) ═ basic scheme (CSG-110B-G2a) -1 (110B-G1-1GIS2A) +1 (110B-G1-1GIS2B) +18 (G2-1GIS-MX1) +2 (G2-1GIS-BY) -40 (G2-1BYQ-MX2) -1 (G2-4KYN-FD2) +1 (G2-4KYN-FD1) -8 (G2-4KYN-MX2) -2 (G2-4 ZXD-002B) +2 (G2-4ZXD-001) + annual price difference + other cost adjustment + basic preparation cost;
step 3) extracting data
Extracting data in a skill database built in the step 1), analyzing and extracting key fields of unstructured data through keyword fuzzy recognition query of structured data, constructing a data extraction model, dividing data to be evaluated into structured data and unstructured data through a big data analysis method, taking the structured data as key factors for later stage matching, taking the unstructured data as scanned content, and extracting and classifying the data according to specific classification, such as: the construction cost files of the power transformation project and the line project are different in composition, and the acquired data table needs to be stored independently;
step 4) establishing a data matching model
Forming one-to-one correspondence between the technical review data pool established in the step 2) and the data extracted in the step 3) through structured data, and then combining with artificial adjustment to complete data matching and establishing a data matching model, and simultaneously matching and comparing the technical review data pool and the non-structural data to be reviewed, wherein the data matching model mainly realizes data matching through keyword identification, category matching and field splitting, recombining and matching;
step 5) establishing an intelligent evaluation model
After the data continuously accumulated in the steps 1) to 4) are refined and upgraded, a review mode is designed, an intelligent review model is further established, and the complete review flow and content are analyzed to complete the related functions of cost analysis and investment decision, such as: building an engineering investment amount analysis model, and acquiring data to be analyzed from a review database by taking an engineering type and a voltage grade as dimensions; meanwhile, acquiring data to be analyzed through engineering key characteristic technical indexes, adopting field recombination and byte splicing by the intelligent review model, outputting a splicing result after completing comparison, and finishing highlight visual display of data results according to the splicing result;
step 6) application analysis
The intelligent review model is used for finishing the functions of index comparison, typical technical data comparison, normative file content comparison, key equipment material price comparison, key technical index comparison, historical data comparison, different stage comparison, different version comparison, index analysis statistical chart, technical review intelligent report and the like, wherein the functions comprise: historical engineering comparison table 3:
TABLE 3 History engineering comparison table
Serial number | Project or expense name | Pending project (A) | History engineering (B) | Difference (%) (B-A)/A |
- | Main and auxiliary production engineering | 521.3 | 600 | |
(A) | Main production engineering | 521.3 | 600 | |
(II) | Auxiliary production engineering | |||
II | Single project relating to site | |||
Small counter | 521.3 | 512.3 | ||
III | Compiling reference time price difference | 154.4 | 154.4 | |
Five of them | Other costs | 5401.2 | 5401.2 | |
1 | Wherein: construction site requisition and cleaning fee | 712.9 | 1000 | |
Five of them | Basic reserve charge | 91 | 91 | |
Six ingredients | Special projects |
The foregoing is only a preferred embodiment of the present invention and it should be noted that modifications and adaptations can be made by those skilled in the art without departing from the principle of the present invention and are intended to be included within the scope of the present invention.
Claims (6)
1. The intelligent technology review method based on big data is characterized by comprising the following specific steps:
step 1) establishing a technical course database
Typical engineering data are collected, the data are preprocessed and then are led into a constructed technical channel database, and then through structured analysis, engineering key characteristic technical indexes are extracted from the engineering data of the technical channel database and serve as identification codes;
step 2) establishing a technical review data pool
Extracting data for technical review from an actual technical review service scene, and then building a technical review data pool;
step 3) extracting data
Extracting data in the technical data base built in the step 1), constructing a data extraction model, and dividing the data to be evaluated into structured data and unstructured data by a big data analysis method, wherein the structured data is used as a key factor for later stage matching, and the unstructured data is used as scanned content;
step 4) establishing a data matching model
Forming one-to-one correspondence between the technical review data pool established in the step 2) and the data extracted in the step 3) through structured data, and establishing a data matching model by combining artificial adjustment to complete data matching, and simultaneously performing data matching comparison on the technical review data pool and the non-structural data to be reviewed;
step 5) establishing an intelligent evaluation model
After the data continuously accumulated in the steps 1) to 4) are refined and upgraded, a review mode is designed, an intelligent review model is further established, data to be analyzed are obtained from a review database, and the complete review process and content are analyzed, so that the intelligent review is completed and the visual display is realized.
2. The big data based intelligent technical review method according to claim 1, wherein in the step 1), the preprocessing comprises cleaning, counting/analyzing and classifying the data.
3. An intelligent technical review method based on big data according to claim 1, wherein in the step 2), the data for technical review includes compliance review data and industry normative data, the industry normative data is split, and an identification code is set for each split sub-item for classified storage.
4. The big data-based intelligent technical review method according to claim 1, wherein in the step 3), the structured data is identified and queried through keyword fuzzy identification, and the unstructured data is analyzed to extract a key field identification and query.
5. The big data-based intelligent technology review method according to claim 1, wherein in step 4), the data matching model realizes data matching through keyword recognition, category matching, and field splitting, recombining and matching.
6. The intelligent technical review method based on big data according to claim 1, wherein in step 5), after the data to be analyzed is obtained from the review database, the data to be analyzed is obtained through engineering key feature technical indexes, the intelligent review model adopts field recombination, forms byte splicing, completes comparison, outputs a splicing result, and completes highlight visual display of data results according to the splicing result.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110689814.0A CN113313475A (en) | 2021-06-22 | 2021-06-22 | Intelligent skill review method based on big data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110689814.0A CN113313475A (en) | 2021-06-22 | 2021-06-22 | Intelligent skill review method based on big data |
Publications (1)
Publication Number | Publication Date |
---|---|
CN113313475A true CN113313475A (en) | 2021-08-27 |
Family
ID=77380049
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202110689814.0A Pending CN113313475A (en) | 2021-06-22 | 2021-06-22 | Intelligent skill review method based on big data |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN113313475A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN116645057A (en) * | 2022-07-15 | 2023-08-25 | 国网四川省电力公司经济技术研究院 | Information processing method and system for power transmission and transformation project review |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103854137A (en) * | 2014-03-14 | 2014-06-11 | 国家电网公司 | Method for evaluating economic and technical indexes of engineering project |
CN104375998A (en) * | 2013-08-13 | 2015-02-25 | 王建平 | Intelligentized project matching analysis tool and implementation method thereof |
CN110135671A (en) * | 2018-02-08 | 2019-08-16 | 国网青海省电力公司经济技术研究院 | The method for building up of project of transmitting and converting electricity technical-economic index analysis model building sample database |
-
2021
- 2021-06-22 CN CN202110689814.0A patent/CN113313475A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104375998A (en) * | 2013-08-13 | 2015-02-25 | 王建平 | Intelligentized project matching analysis tool and implementation method thereof |
CN103854137A (en) * | 2014-03-14 | 2014-06-11 | 国家电网公司 | Method for evaluating economic and technical indexes of engineering project |
CN110135671A (en) * | 2018-02-08 | 2019-08-16 | 国网青海省电力公司经济技术研究院 | The method for building up of project of transmitting and converting electricity technical-economic index analysis model building sample database |
Non-Patent Citations (2)
Title |
---|
刘宏志等: "大数据环境下的电网工程造价分析管控体系研究", 《华东电力》 * |
李大鹏等: "电网工程技术经济分析系统建设研究", 《科技资讯》 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN116645057A (en) * | 2022-07-15 | 2023-08-25 | 国网四川省电力公司经济技术研究院 | Information processing method and system for power transmission and transformation project review |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107402976B (en) | Power grid multi-source data fusion method and system based on multi-element heterogeneous model | |
CN110674311A (en) | Knowledge graph-based power asset heterogeneous data fusion method | |
CN107818427B (en) | Engineering quantity list information and WBS information coupling method and system for power grid technical improvement and major repair engineering | |
WO2023115842A1 (en) | Data-driven offline and online integrated simulation system and method for power distribution network | |
CN107357940A (en) | A kind of method and apparatus of real estate Data Integration | |
CN111090643B (en) | Mass electricity consumption data mining method based on data analysis system | |
CN103679544A (en) | Comprehensive assessment method for running of intelligent power distribution network | |
CN107862392B (en) | Equipment account management and control method based on power distribution network intelligent operation and maintenance management and control platform | |
CN113723844B (en) | Low-voltage station theoretical line loss calculation method based on ensemble learning | |
CN111461521A (en) | Residential housing vacancy rate analysis method based on electric power big data | |
CN112948572A (en) | Method for visually displaying equipment information and relation of power system through knowledge graph | |
CN113313475A (en) | Intelligent skill review method based on big data | |
CN116340437A (en) | Multi-clustering method for large-scale multi-source heterogeneous data | |
CN112200209A (en) | Poor user identification method based on day-to-day power consumption | |
CN111105218A (en) | Power distribution network operation monitoring method based on holographic image technology | |
CN111079809A (en) | Intelligent system method for electric connector | |
CN111178676A (en) | Power distribution network project investment assessment method and system | |
CN109214927A (en) | Method based on the investment of national grid General Engineering Cost digital simulation electricity power engineering | |
CN112200458B (en) | Power distribution network planning data application method and system | |
CN112069400A (en) | Whole-network searching method based on regional power grid information | |
CN112308388A (en) | Electric power engineering overhaul project risk auditing method based on semantic analysis | |
CN113642835A (en) | Work ticket generation method based on data similarity and terminal | |
CN108875038A (en) | The method and system of hierarchical structure real-time data base are attached under relational database data | |
Cao et al. | Dimension construction and test of dynamic capability of enterprise supply chain | |
Zou et al. | Research on Burrs Processing Method in Load Data and Electric Load Forecasting |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210827 |