CN110866150A - Method for rapidly generating ledger data map and overhauling defects of pre-control equipment family - Google Patents

Method for rapidly generating ledger data map and overhauling defects of pre-control equipment family Download PDF

Info

Publication number
CN110866150A
CN110866150A CN201911056066.1A CN201911056066A CN110866150A CN 110866150 A CN110866150 A CN 110866150A CN 201911056066 A CN201911056066 A CN 201911056066A CN 110866150 A CN110866150 A CN 110866150A
Authority
CN
China
Prior art keywords
data
equipment
dimensional table
defect
ledger 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
CN201911056066.1A
Other languages
Chinese (zh)
Other versions
CN110866150B (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.)
China Southern Power Grid Peak Shaving And Frequency Modulation Guangdong Energy Storage Technology Co ltd
Peak and Frequency Regulation Power Generation Co of China Southern Power Grid Co Ltd
Original Assignee
Peak and Frequency Regulation Power Generation Co 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 Peak and Frequency Regulation Power Generation Co of China Southern Power Grid Co Ltd filed Critical Peak and Frequency Regulation Power Generation Co of China Southern Power Grid Co Ltd
Priority to CN201911056066.1A priority Critical patent/CN110866150B/en
Publication of CN110866150A publication Critical patent/CN110866150A/en
Application granted granted Critical
Publication of CN110866150B publication Critical patent/CN110866150B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/901—Indexing; Data structures therefor; Storage structures
    • G06F16/9024—Graphs; Linked lists
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/903—Querying
    • G06F16/90335—Query processing
    • 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/20—Administration of product repair or maintenance

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Economics (AREA)
  • Software Systems (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Computational Linguistics (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a maintenance method for quickly generating a ledger data map and pre-controlling equipment family defects. The method comprises the following steps: firstly, forming a two-dimensional table containing all standing book data fields; forming a standing book data map according to the specified range; acquiring information of potential mutual spare parts and the quality condition of the ledger data according to the type, the manufacturer and the technical parameters of the associated equipment in the same functional position type in the ledger data map, and correcting the ledger data with data quality problems; and acquiring the defects of the equipment family according to the functional position type, defect appearance, defect reason and treatment field associated with the same type and model, and forming a maintenance scheme for pre-controlling the development of the defects of the equipment family in a targeted manner according to the treatment field. The method provided by the invention realizes automatic detection and control for the maintenance method for the development of the family defects of the pre-control equipment, can effectively avoid risks, and provides reliable technical guarantee for industrial safe and stable production.

Description

Method for rapidly generating ledger data map and overhauling defects of pre-control equipment family
Technical Field
The invention relates to the technical field of electrical equipment, in particular to a maintenance method for quickly generating a ledger data map and pre-controlling equipment family defects.
Background
In an industrial system, information such as functional position type, model, manufacturer, equipment parameters, defect information, operation and maintenance information and the like is used as key fields of ledger data, and ledger data IDs are used as main keys to be organized together. It is worth noting that the standing book data belongs to mass data, and in the past, due to the lack of effective means for mining, the value of the mass standing book data is not mined, but becomes the maintenance burden of production technicians.
The model data can change along with the upgrading of manufacturer products, and the problem of irregular entry of ledger data also exists simultaneously. Therefore, the related information and the decision of the spare parts always depend on the experience of personnel, a method for visually displaying and reflecting is lacked, the information of the spare parts is difficult to obtain from massive ledger data, the spare parts are easy to be repeatedly purchased, and the stock spare parts cannot be reused, so that the production and the operation are not facilitated.
In the past, the data quality of the machine account data can be controlled only by on-site checking and checking, and the data quality problem can be found only by on-site checking and comparing by production technicians, so that the improvement can be promoted, and time and labor are wasted. The bottleneck of data quality problem and standing book data presentation problem makes it all the more can't talk about to know the equipment family defect through the analysis of huge amount of standing book data.
In the graph theory, the adjacent matrix can store data of all vertex data and relations (edges or arcs) between vertexes in the graph by using a two-dimensional array, the two-dimensional array is called as the adjacent matrix, and it is not difficult to imagine that if a standard method can be used for converting any two-dimensional table into the adjacent matrix and then converting the adjacent matrix into the graph, an effective method is undoubtedly provided for rapidly forming the graph by the account data.
After the standing book data map is quickly formed according to the incidence relation of the standing book data fields, the standing book data map can be imagined. Undoubtedly, production technicians can simply and conveniently find the relation among the fields of the ledger according to the graph and the clue, so that the production technicians can conveniently perform transverse comparison, the data quality problem can be found by the production technicians, and the family defects of the equipment can be found by the production technicians.
The invention combines engineering experience, fully considers the characteristics of the standing book data, standardizes the method for forming the map, and combines computer control, so that the quality of the standing book data is improved, the familial defects of the equipment are found, automatic detection and control are realized for the maintenance method for pre-controlling the development of the familial defects of the equipment, the familial defects of the equipment to which the standing book data belong are exposed in advance, and technical support is provided for the familial defect elimination work of the equipment. The risk can be effectively avoided, and reliable technical guarantee is provided for industrial safe and stable production.
Disclosure of Invention
In order to overcome the defects in the prior art, the invention aims to provide an overhauling method for quickly generating a ledger data map and pre-controlling equipment family defects.
The purpose of the invention is realized by the following technical scheme.
The invention provides an overhauling method for quickly generating a standing book data map and pre-controlling equipment family defects, which is used for forming a two-dimensional table according to the incidence relation of standing book data fields, converting the two-dimensional table into an adjacent matrix, generating the standing book data map through the adjacent matrix, comprehensively considering the characteristics of standing book data by utilizing the standing book data map and combining engineering experience, improving the quality of the standing book data, finding the equipment family defects and providing the overhauling method for the development of the pre-controlling equipment family defects.
The invention provides a maintenance method for quickly generating a ledger data map and pre-controlling equipment family defects, which comprises the following steps of:
(1.1) form two-dimensional table B containing all standing book data fields0；
(1.2) forming a two-dimensional table B consisting of function position types, equipment models, manufacturers and technical parameter fields according to the specified range1According to two-dimensional table B1Form standing book data map T1；
(1.3) according to the standing book data map T1Acquiring the information of potential mutual spare parts and the quality condition of the ledger data by the associated equipment model, manufacturer and technical parameters in the same functional position type, and correcting the ledger data with data quality problems;
(1.4) forming a two-dimensional table B consisting of equipment types, equipment models, function positions, defect representations, defect causes, and treatment measure fields according to the specified range2According to two-dimensional table B2Form standing book data map T2；
(1.5) according to the standing book data map T2And acquiring the defects of the equipment family by using the functional position type, defect appearance, defect reason and treatment field associated with the same type and model, and forming a targeted maintenance method for pre-controlling the development of the defects of the equipment family according to the treatment field.
Further, the step (1.1) forms a second machine account data field containing all machine account data fieldsDimension table B0Ledger fields include the following:
(2.1) equipment ledger data ID;
(2.2) equipment category;
(2.3) equipment model;
(2.4) a manufacturer;
(2.5) technical parameters;
(2.6) a functional location type;
(2.7) defect appearance;
(2.8) defect cause;
(2.9) treatment measures;
and (2.10) equipment operation and maintenance department.
Further, the step (1.1) forms a two-dimensional table B containing all standing book data fields0Is a two-dimensional table formed with the device ledger data ID as a primary key.
Further, the step (1.2) and the step (1.4) of forming the standing book data map according to the two-dimensional table comprise the following steps:
(4.1) acquiring the row number M and the column number N of the two-dimensional table B, wherein M belongs to [1, + ∞ ], and N belongs to [1, + ∞);
(4.2) taking the unique value according to the column, namely combining the same data in the same column into one data;
(4.3) obtaining the number O of the unique values of 1-N columns after the unique values are taken according to the columns;
(4.4) numbering each unique value according to 1 to O, and writing the numbers back to the two-dimensional table B to form a new two-dimensional table BB, wherein the BB is an M multiplied by N matrix;
(4.5) setting the adjacent matrix TT as a sparse matrix of all zeros of O multiplied by O;
(4.6) setting i to 1;
(4.7) setting j to 1;
(4.8) TT (BB (i, j), BB (i, j +1)) is assigned a value of 1;
(4.9) adding 1 to the value of j, if the value of j is not more than N-1, then going to execute the step (4.8), otherwise, going to execute the step (4.10);
(4.10) adding 1 to the value of i, if the value of i is not more than M, then the step (4.7) is executed, otherwise, the step (4.11) is executed;
(4.11) obtaining the adjacency matrix TT of the two-dimensional table B;
(4.12) setting i to 1;
(4.13) setting j to 1;
(4.14) if TT (i, j) is not equal to 1, drawing a line from the ith point to the jth point, converting the node number into the original machine account data according to the two-dimensional table BB, and otherwise, executing the step (4.15);
(4.15) adding 1 to the value of j, if the value of j is not more than N, then the step (4.13) is executed, otherwise, the step (4.16) is executed;
(4.16) adding 1 to the value of i, if the value of i is not more than N, then switching to execution (4.13), otherwise, switching to execution (4.17);
and (4.17) obtaining the standing book data map of the two-dimensional table B.
Further, it is characterized in that the specified range in step (1.2) and step (1.4) is specified ledger data obtained by searching for a condition index in the ledger data field.
Further, the step (1.3) of obtaining the information of potential mutual spare parts and the quality condition of the account data according to the associated equipment model, the manufacturer and the technical parameters in the same functional position type means that the equipment represented by the account data in the same functional position type can play the same role, if a plurality of different account data exist, the equipment represented by the plurality of different account data can be mutually spare parts (namely can be mutually replaced) through comparing different account data in the same field, and if no data quality problem exists; if there is a data quality problem, the error field can be located quickly.
Further, the step (1.5) of obtaining the device family defect according to the functional position type, the defect representation, the defect reason and the processing measure field associated with the same type and the same model means that the defect representation and the defect reason field of the ledger data corresponding to the functional position type associated with the same type and the same model are both device family defects, and the corresponding processing measure is an overhaul method for pre-controlling the development of the device family defects.
Compared with the prior art, the invention has the following advantages and effects:
(1) the invention provides a standardization implementation method for forming a two-dimensional table according to the incidence relation of the standing book data fields, converting the two-dimensional table into an adjacent matrix, and then generating a standing book data map through the adjacent matrix, so that the automatic generation of the quickly generated standing book data map is realized;
(2) the invention combines engineering experience, takes the characteristics of the standing book data into full consideration, provides a method for transversely comparing different standing book data with the same field, and provides an effective technical means for acquiring data quality information and information of mutual spare parts;
(3) the invention provides a maintenance method for acquiring the defects of the equipment family through the functional position type, the defect representation, the defect reasons and the processing measure field which are associated with the same type and model in the map, and forming targeted pre-control on the development of the defects of the equipment family according to the processing measure field.
Drawings
Fig. 1 is a flowchart of an overhaul method for rapidly generating a ledger data map and pre-controlling device family defects in embodiment 1 of the present invention.
FIG. 2 is a two-dimensional table B of the example1Standing book data map T1。
FIG. 3 is a two-dimensional table B of the example2Standing book data map T2。
Detailed Description
The following description of the embodiments of the present invention is provided in connection with the accompanying drawings and examples, but the invention is not limited thereto. It is noted that the processes described below, if not specifically described in detail, are all realizable or understandable by those skilled in the art with reference to the prior art.
Example 1
The following example analysis is performed on the ledger data of southern power grid peak-shaving frequency modulation power generation ltd. With reference to the flow of fig. 1, the method for rapidly generating the ledger data map and repairing the defects of the pre-control equipment family comprises the following steps:
step 1, forming a two-dimensional table B containing all standing book data fields0(as shown in table 1);
TABLE 1
Figure BDA0002256583260000071
Step 2, searching conditions in the standing book data field (the type of the function position is factory change) "&&"voltage class ═ 10 kV"&&"rated capacity of 50 MVA"&&Dry type) index to obtain a two-dimensional table B composed of function location type, device model, manufacturer, technical parameter fields as shown in table 21(as shown in table 2);
TABLE 2
Figure BDA0002256583260000081
According to two-dimensional table B1Form standing book data map T1Obtained by the following steps:
(2.1) obtaining two-dimensional table B1The number of rows M and columns N, M being 4 and N being 5;
(2.2) taking the unique value according to the column, namely combining the same data in the same column into one data;
(2.3) obtaining the number O of the unique values of 1-N columns as 11 after the unique values are taken according to the columns;
(2.4) numbering each unique value from 1 to 11 and writing the numbers back into the two-dimensional table B to form a new two-dimensional table BB, which is a 4 x 5 matrix,
Figure BDA0002256583260000082
(2.5) setting the adjacent matrix TT as a sparse matrix of 11 multiplied by 11 all zeros;
(2.6) setting i to 1;
(2.7) setting j to 1;
(2.8) TT (BB (i, j), BB (i, j +1)) is assigned a value of 1;
(2.9) adding 1 to the value of j, if the value of j is not more than N-1, then the step (3.8) is executed, otherwise, the step (2.10) is executed;
(2.10) adding 1 to the value of i, if the value of i is not more than M, then the step (2.7) is executed, otherwise, the step (2.11) is executed;
(2.11) obtaining a two-dimensional TableB1Is adjacent to the matrix TT. The matrix TT is a sparse matrix, and the following elements are elements with the numerical value of 1: TT (1,5), TT (2,5), TT (3,5), TT (4,5), TT (5,6), TT (5,7), TT (7,8), TT (7,9), TT (6,10), TT (7,10), TT (8,11), TT (9,11) and TT (10, 11).
(2.12) setting i to 1;
(2.13) setting j to 1;
(2.14) if TT (i, j) is not equal to 1, drawing a line from the ith point to the jth point, converting the node number into the original machine account data according to the two-dimensional table BB, and otherwise, executing the step (2.15);
(2.15) adding 1 to the value of j, if the value of j is not more than N, then the step (2.13) is executed, otherwise, the step (2.16) is executed;
(2.16) adding 1 to the value of i, if the value of i is not more than N, then switching to execution (2.13), otherwise, switching to execution (2.17);
(2.17) obtaining two-dimensional Table B1Standing book data map T1(as shown in fig. 2). FIG. 2 is a two-dimensional table B of the example1Standing book data map T1According to the ledger data map T1And the information of potential mutual spare parts and the quality condition of the ledger data are obtained by the associated equipment model, manufacturer information and technical parameters in the same functional position type, and the ledger data with data quality problems are corrected.
Step 3, according to the standing book data atlas T1And the information of potential mutual spare parts and the quality condition of the ledger data are obtained by the associated equipment model, manufacturer information and technical parameters in the same functional position type, and the ledger data with data quality problems are corrected.
Through standing book data map T1The same functional position type plant use change can be easily found, the correct writing method of the model name of the SCB10-400/10 can be presumed to be SCB10-400/10 according to the associated equipment model, the Hainan golden disk and the Hainan golden disk electric limited company can be inferred to be the same manufacturer according to the manufacturer information, the accurate name of the Hainan golden disk electric limited company is the Hainan golden disk electric limited company, similarly, the vacant information can be the Hainan golden disk electric limited company according to the analysis condition, and the account data of the data quality problem can be further enteredAnd (5) correcting the rows. Meanwhile, it can be seen that the devices represented by the four pieces of standing book data in the same functional position type have the same technical parameters and should play the same role, and the devices represented by the four pieces of different standing book data can be spare parts for each other.
Step 4, forming a two-dimensional table B composed of equipment types, equipment models, function positions, defect representations, defect reasons and processing measure fields according to the specified range, wherein the two-dimensional table B is shown in table 32；
TABLE 3
Figure BDA0002256583260000101
According to two-dimensional table B2Form standing book data map T2Obtained by the following steps:
(4.1) obtaining two-dimensional table B2The number of rows M and columns N, M being 4 and N being 6;
(4.2) taking the unique value according to the column, namely combining the same data in the same column into one data;
(4.3) obtaining the number O of the unique values of 1-N columns as 12 after the unique values are taken according to the columns;
(4.4) numbering each unique value from 1 to 12 and writing the numbers back into the two-dimensional table B to form a new two-dimensional table BB, which is a 4 x 6 matrix,
Figure BDA0002256583260000111
(4.5) setting the adjacent matrix TT as a sparse matrix of 12 x 12 all zeros;
(4.6) setting i to 1;
(4.7) setting j to 1;
(4.8) TT (BB (i, j), BB (i, j +1)) is assigned a value of 1;
(4.9) adding 1 to the value of j, if the value of j is not more than N-1, then the step (4.8) is executed, otherwise, the step (4.10) is executed;
(4.10) adding 1 to the value of i, if the value of i is not more than M, then the step (4.7) is executed, otherwise, the step (4.11) is executed;
(4.11) obtaining two-dimensional Table B2Is a sparse matrix TTThe following elements are elements with a value of 1: TT (1,2), TT (2,3), TT (2,4), TT (2,5), TT (2,6), TT (5,7), TT (3,8), TT (6,9), TT (4,10), TT (7,11), TT (8,11), TT (9,11), TT (10,11) and TT (11, 12).
(4.12) setting i to 1;
(4.13) setting j to 1;
(4.14) if TT (i, j) is not equal to 1, drawing a line from the ith point to the jth point, converting the node number into the original machine account data according to the two-dimensional table, and otherwise, executing the step (4.15);
(4.15) adding 1 to the value of j, if the value of j is not more than N, then the step (4.13) is executed, otherwise, the step (4.16) is executed;
(4.16) adding 1 to the value of i, if the value of i is not more than N, then switching to execution (4.13), otherwise, switching to execution (4.17);
(4.17) obtaining two-dimensional Table B2Standing book data map T2(as shown in fig. 3). FIG. 3 is a two-dimensional table B of the example2Standing book data map T2According to the ledger data map T2And the fields of the functional position type, the defect representation, the defect reason and the treatment measure related to the same product type and model number know that the defect of the equipment family is unqualified joint insulation.
Step 5, according to the standing book data atlas T2And in the method, functional position types, defect representations, defect reasons and treatment measure fields related to the same type and model are used for knowing that the defect of the equipment family is that the joint is unqualified in insulation, targeted pre-control measures are formed according to the treatment measure fields to enhance the frequency of infrared inspection observation, and the joint is replaced when next maintenance is carried out.
And (4) conclusion:
therefore, the invention provides a standardization implementation method for forming the two-dimensional table according to the incidence relation of the standing book data fields, converting the two-dimensional table into the adjacent matrix, and then generating the standing book data map through the adjacent matrix, so that the automatic generation of the quickly generated standing book data map is realized. The invention combines engineering experience, takes the characteristics of the standing book data into full consideration, provides transverse comparison through different standing book data with the same field, and provides an effective technical means for acquiring data quality information and information of mutual spare parts. The invention also obtains the defects of the equipment family through the functional position type, defect representation, defect reason and treatment field which are associated with the same type and model in the map, and forms a targeted maintenance method for pre-controlling the development of the defects of the equipment family according to the treatment field.
The above examples are only preferred embodiments of the present invention, which are intended to be illustrative and not limiting, and those skilled in the art should understand that they can make various changes, substitutions and alterations without departing from the spirit and scope of the invention.

Claims (7)

1. A maintenance method for quickly generating a ledger data map and pre-controlling equipment family defects is characterized by comprising the following steps:
(1.1) form two-dimensional table B containing all standing book data fields0；
(1.2) forming a two-dimensional table B consisting of function position types, equipment models, manufacturers and technical parameter fields according to the specified range1According to two-dimensional table B1Form standing book data map T1；
(1.3) according to the standing book data map T1Acquiring the information of potential mutual spare parts and the quality condition of the ledger data by the associated equipment model, manufacturer and technical parameters in the same functional position type, and correcting the ledger data with data quality problems;
(1.4) forming a two-dimensional table B consisting of equipment types, equipment models, function positions, defect representations, defect causes, and treatment measure fields according to the specified range2According to two-dimensional table B2Form standing book data map T2；
(1.5) according to the standing book data map T2And acquiring the defects of the pre-controlled equipment family according to the functional position type, defect appearance, defect reason and treatment field associated with the same type and model, and specifically repairing the defects of the pre-controlled equipment family according to the treatment field.
2. According to claim 1The maintenance method is characterized in that the two-dimensional table B containing all standing book data fields is formed in the step (1.1)0Ledger fields include the following:
(2.1) equipment ledger data ID;
(2.2) equipment category;
(2.3) equipment model;
(2.4) a manufacturer;
(2.5) technical parameters;
(2.6) a functional location type;
(2.7) defect appearance;
(2.8) defect cause;
(2.9) treatment measures;
and (2.10) equipment operation and maintenance department.
3. The method of servicing of claim 1, wherein step (1.1) forms a two-dimensional table B containing all ledger data fields0Is a two-dimensional table formed with the device ledger data ID as a primary key.
4. The service method according to claim 1, wherein the step (1.2) and the step (1.4) of forming the ledger data map from the two-dimensional table comprise the steps of:
(4.1) acquiring the row number M and the column number N of the two-dimensional table B, wherein M belongs to [1, + ∞ ], and N belongs to [1, + ∞);
(4.2) taking the unique value according to the column, namely combining the same data in the same column into one data;
(4.3) obtaining the number O of the unique values of 1-N columns after the unique values are taken according to the columns;
(4.4) numbering each unique value according to 1 to O, and writing the numbers back to the two-dimensional table B to form a new two-dimensional table BB, wherein the BB is an M multiplied by N matrix;
(4.5) setting the adjacent matrix TT as a sparse matrix of all zeros of O multiplied by O;
(4.6) setting i to 1;
(4.7) setting j to 1;
(4.8) TT (BB (i, j), BB (i, j +1)) is assigned a value of 1;
(4.9) adding 1 to the value of j, if the value of j is not more than N-1, then the step (4.8) is executed, otherwise, the step (4.10) is executed;
(4.10) adding 1 to the value of i, if the value of i is not more than M, then the step (4.7) is executed, otherwise, the step (4.11) is executed;
(4.11) obtaining the adjacency matrix TT of the two-dimensional table B;
(4.12) setting i to 1;
(4.13) setting j to 1;
(4.14) if TT (i, j) is not equal to 1, drawing a line from the ith point to the jth point, converting the node number into the original machine account data according to the two-dimensional table BB, and otherwise, executing the step (4.15);
(4.15) adding 1 to the value of j, if the value of j is not more than N, then the step (4.13) is executed, otherwise, the step (4.16) is executed;
(4.16) adding 1 to the value of i, if the value of i is not more than N, then switching to execution (4.13), otherwise, switching to execution (4.17);
and (4.17) obtaining the standing book data map of the two-dimensional table B.
5. The overhaul method according to claim 1, wherein the specified range in step (1.2) and step (1.4) is specified ledger data obtained by searching for a condition index in a ledger data field.
6. The overhaul method according to claim 1, wherein in step (1.3), the information of potential mutual spare parts and the quality condition of the ledger data are obtained according to the associated equipment model, manufacturer and technical parameters in the same functional position type, which means that the equipment represented by the ledger data in the same functional position type can play the same role, if a plurality of different ledger data appear, the comparison is performed through different ledger data in the same field, and if there is no data quality problem, the equipment represented by the plurality of different ledger data can be mutual spare parts; if there is a data quality problem, the error field can be located quickly.
7. The overhaul method according to claim 1, wherein in step (1.5), the device family defect is obtained according to the functional position type, defect appearance, defect cause, and treatment measure field associated with the same type and model, and the method means that the defect appearance and defect cause field of the ledger data corresponding to the functional position type and the function position type associated with the same type and model are both device family defects, and the corresponding treatment measure is an overhaul method for pre-controlling the development of the device family defect.
CN201911056066.1A 2019-10-31 2019-10-31 Method for rapidly generating ledger data map and overhauling defects of pre-control equipment family Active CN110866150B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911056066.1A CN110866150B (en) 2019-10-31 2019-10-31 Method for rapidly generating ledger data map and overhauling defects of pre-control equipment family

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911056066.1A CN110866150B (en) 2019-10-31 2019-10-31 Method for rapidly generating ledger data map and overhauling defects of pre-control equipment family

Publications (2)

Publication Number Publication Date
CN110866150A true CN110866150A (en) 2020-03-06
CN110866150B CN110866150B (en) 2022-09-30

Family

ID=69653707

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911056066.1A Active CN110866150B (en) 2019-10-31 2019-10-31 Method for rapidly generating ledger data map and overhauling defects of pre-control equipment family

Country Status (1)

Country Link
CN (1) CN110866150B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111898961A (en) * 2020-05-26 2020-11-06 南方电网调峰调频发电有限公司 Error checking method suitable for same field of standing book data of similar power equipment

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7136768B1 (en) * 2005-03-31 2006-11-14 Network Appliance, Inc. Method and system for reliability analysis of disk drive failures
CN102840918A (en) * 2012-08-17 2012-12-26 中国电力科学研究院 Method for managing and analyzing infrared spectrogram of electric transmission and transformation equipment
CN107730079A (en) * 2017-09-15 2018-02-23 广西电网有限责任公司电力科学研究院 A kind of power transmission and transforming equipment defect portrait method based on data mining
CN110008254A (en) * 2019-04-02 2019-07-12 云南电网有限责任公司电力科学研究院 A kind of transformer equipment account verification processing method

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7136768B1 (en) * 2005-03-31 2006-11-14 Network Appliance, Inc. Method and system for reliability analysis of disk drive failures
CN102840918A (en) * 2012-08-17 2012-12-26 中国电力科学研究院 Method for managing and analyzing infrared spectrogram of electric transmission and transformation equipment
CN107730079A (en) * 2017-09-15 2018-02-23 广西电网有限责任公司电力科学研究院 A kind of power transmission and transforming equipment defect portrait method based on data mining
CN110008254A (en) * 2019-04-02 2019-07-12 云南电网有限责任公司电力科学研究院 A kind of transformer equipment account verification processing method

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
刘斌: "电力变压器故障诊断方法与检修辅助决策系统的研究", 《中国优秀博硕士学位论文全文数据库(硕士) 工程科技Ⅱ辑》 *
张珂斐: "电力变压器全维度智能决策支持系统研究", 《中国优秀博硕士学位论文全文数据库(博士) 工程科技Ⅱ辑》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111898961A (en) * 2020-05-26 2020-11-06 南方电网调峰调频发电有限公司 Error checking method suitable for same field of standing book data of similar power equipment
CN111898961B (en) * 2020-05-26 2024-03-15 南方电网调峰调频发电有限公司 Error checking method suitable for same fields of ledger data of similar power equipment

Also Published As

Publication number Publication date
CN110866150B (en) 2022-09-30

Similar Documents

Publication Publication Date Title
CN107633155B (en) Method and apparatus for computer-based generation of component fault trees
CN110310134B (en) Customized furniture management tracing method based on coding information association
CN103942726A (en) Intelligent inspection method for condition evaluation work of power grid equipment
WO2024060725A1 (en) Aircraft tool change method and apparatus, device, and storage medium
Fan et al. Human factors’ complexity measurement of human‐based station of assembly line
CN110866150B (en) Method for rapidly generating ledger data map and overhauling defects of pre-control equipment family
Lomte et al. Reliability improvement for TSR machine of Banburry mixer using plant optimization process
CN113642912A (en) Method, system, equipment and storage medium for reporting labor and preventing mistake
KR101527080B1 (en) Digital Manufacturing Optimization System for Scenario Simulation and Discovering Bottleneck Processes Based
KR101405567B1 (en) System and method for equipment stability and engineering process effectiveness assessment
US20180157735A1 (en) Method and system for clustering engineering data in a multidisciplinary engineering system
JP5868688B2 (en) Substation equipment repair plan support system and repair plan support method thereof
Zhou Failure trend analysis using time series model
Zhang et al. A simulation‐based differential evolution algorithm for stochastic parallel machine scheduling with operational considerations
Kitriastika et al. A Redesign Layout to Increase Productivity of a Company
CN113793049A (en) Method, device, equipment and medium for positioning bad root cause in production process of product
Hickling et al. The verification and early validation of a plant status and alarm display system
Tselishchev et al. Improving CAD Application Efficiency in the Design of Control Schemes for Self-Use Mechanisms
Shojaie et al. Impact analysis of TQM's hard aspects on sigma level in electronics and telecommunication production process
CN112507516B (en) Reliability-based preventive maintenance optimization method and device for electrical equipment
Petrochenkov Practical Aspects of Genetic Algorithms’ Implementation in Life Cycle Management of Electrotechnical Equipment
Plura Procedures and methods of quality planning and their use for forming process optimization
Tanuska et al. Knowledge discovery from production databases for hierarchical process control
CN117541215A (en) Method and device for managing life cycle of nuclear power plant electric instrument equipment
Hussain An Effective Cybersecurity Risk Assessment Framework for a Public Sector Gas Production/Distribution Company

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
TA01 Transfer of patent application right

Effective date of registration: 20210623

Address after: 511400 room 208, 100 Dongxing Road, Donghuan street, Panyu District, Guangzhou City, Guangdong Province

Applicant after: SOUTHERN POWER GRID PEAK LOAD AND FREQUENCY REGULATION POWER GENERATION Co.,Ltd.

Applicant after: Guangzhou peak frequency modulation technology development Co.,Ltd.

Address before: 510630 32, Longkou East Road, Tianhe District, Guangzhou, Guangdong.

Applicant before: SOUTHERN POWER GRID PEAK LOAD AND FREQUENCY REGULATION POWER GENERATION Co.,Ltd.

TA01 Transfer of patent application right
GR01 Patent grant
GR01 Patent grant
CP01 Change in the name or title of a patent holder

Address after: 511400 room 208, 100 Dongxing Road, Donghuan street, Panyu District, Guangzhou City, Guangdong Province

Patentee after: SOUTHERN POWER GRID PEAK LOAD AND FREQUENCY REGULATION POWER GENERATION Co.,Ltd.

Patentee after: China Southern power grid peak shaving and frequency modulation (Guangdong) energy storage technology Co.,Ltd.

Address before: 511400 room 208, 100 Dongxing Road, Donghuan street, Panyu District, Guangzhou City, Guangdong Province

Patentee before: SOUTHERN POWER GRID PEAK LOAD AND FREQUENCY REGULATION POWER GENERATION Co.,Ltd.

Patentee before: Guangzhou peak frequency modulation technology development Co.,Ltd.

CP01 Change in the name or title of a patent holder