CN113313475A - Intelligent skill review method based on big data - Google Patents

Intelligent skill review method based on big data Download PDF

Info

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
Application number
CN202110689814.0A
Other languages
Chinese (zh)
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.)
Energy Development Research Institute of China Southern Power Grid Co Ltd
Original Assignee
Energy Development Research Institute of China Southern Power Grid 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 Energy Development Research Institute of China Southern Power Grid Co Ltd filed Critical Energy Development Research Institute of China Southern Power Grid Co Ltd
Priority to CN202110689814.0A priority Critical patent/CN113313475A/en
Publication of CN113313475A publication Critical patent/CN113313475A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • 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
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management
    • 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/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2468Fuzzy queries
    • 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
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0639Performance analysis of employees; Performance analysis of enterprise or organisation operations
    • G06Q10/06393Score-carding, benchmarking or key performance indicator [KPI] analysis
    • 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/00Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/06Electricity, gas or water supply
    • YGENERAL 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
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE 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/00Energy 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

Intelligent skill review method based on big data
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
Figure 1
TABLE 2 typical cost data of south network and other fee combination table
Figure BDA0003126174540000042
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.
CN202110689814.0A 2021-06-22 2021-06-22 Intelligent skill review method based on big data Pending CN113313475A (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (3)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
Title
刘宏志等: "大数据环境下的电网工程造价分析管控体系研究", 《华东电力》 *
李大鹏等: "电网工程技术经济分析系统建设研究", 《科技资讯》 *

Cited By (1)

* Cited by examiner, † Cited by third party
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