CN117992551A - Construction method, device, equipment and storage medium of equipment failure database - Google Patents

Construction method, device, equipment and storage medium of equipment failure database Download PDF

Info

Publication number
CN117992551A
CN117992551A CN202211380059.9A CN202211380059A CN117992551A CN 117992551 A CN117992551 A CN 117992551A CN 202211380059 A CN202211380059 A CN 202211380059A CN 117992551 A CN117992551 A CN 117992551A
Authority
CN
China
Prior art keywords
entities
equipment
influence
entity
database
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
CN202211380059.9A
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.)
China Petroleum and Chemical Corp
Sinopec Safety Engineering Research Institute Co Ltd
Original Assignee
China Petroleum and Chemical Corp
Sinopec Safety Engineering Research Institute 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 China Petroleum and Chemical Corp, Sinopec Safety Engineering Research Institute Co Ltd filed Critical China Petroleum and Chemical Corp
Priority to CN202211380059.9A priority Critical patent/CN117992551A/en
Publication of CN117992551A publication Critical patent/CN117992551A/en
Pending legal-status Critical Current

Links

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a construction method, a system, equipment and a storage medium of an equipment failure database, wherein the method comprises the following steps: collecting basic information data of entities included in the graph database, and storing each entity in the form of 'points'; establishing an association relation between entities, wherein the association relation comprises the steps of generating an influence degree grade between physical entities comprising a first class of entity and a second class of entity according to a preset rule, and taking the influence degree grade as five association relations in a graph database; and constructing the equipment failure database according to the basic information data of the entities and the association relation between the entities. According to the invention, after an accident occurs, the device or equipment with the most contribution to failure and the related information of the batch of the equipment with the most failure times can be obtained from the equipment failure database through the retrieval of the influence degree level, so that more effective data help can be obtained to check and treat hidden troubles of subsequent similar equipment.

Description

Construction method, device, equipment and storage medium of equipment failure database
Technical Field
The present invention relates to the field of databases, and in particular, to a method, a system, an apparatus, and a storage medium for constructing an apparatus failure database.
Background
In the prior art, the construction method of the failure database of the refining enterprise generally collects a large number of (the first 5-10 years) equipment failure data of the cooperative enterprise, performs data arrangement and cleaning according to a corresponding equipment classification method, constructs a structure of the database in a field information form, then analyzes and regresses the data to obtain failure probability of corresponding type equipment, can update the data every several years, and then issues the data to the cooperative enterprise and the public, and a typical database (not limited to the refining industry) comprises: a failure rate data exchange network (FARABA) in the united states, a site failure analysis System (SADE) in france, sea and land reliability data (OREDA) sponsored by norway class society, and the like.
The failure database construction method has the advantages of being tightly combined with enterprises, being rich in data quantity, being capable of transversely collecting, analyzing and comparing data of similar equipment of different refining enterprises, and having stronger guiding significance in the aspect of data statistics.
The inventors have found that the failure database in the prior art has at least the following defects:
when analysis is performed after an accident, effective data help cannot be obtained through the failure database, so that hidden danger management of subsequent similar equipment is not facilitated.
The information disclosed in this background section is only for enhancement of understanding of the general background of the invention and should not be taken as an acknowledgement or any form of suggestion that this information forms the prior art already known to a person of ordinary skill in the art.
Disclosure of Invention
The invention aims to obtain information which is beneficial to hidden trouble management of subsequent similar equipment through the equipment failure database after an accident occurs.
The invention provides a construction method of an equipment failure database, which comprises the following steps:
S11, determining basic information data of entities included in the graph database, and storing each entity in a 'point' form, wherein the method comprises the following steps: the refining equipment is taken as a kind of entity in a graph database; the refining device (or unit) is taken as a second-class entity in the graph database; taking accidents of refining equipment as three types of entities in a graph database;
S12, establishing an association relationship among entities, including: taking the process flow position of the equipment as a relation as a type of association relation in a graph database; taking technical parameters and technical relativity between devices as a class-II association relationship in a graph database; taking the influence range of the accident as three kinds of association relations in the graph database; taking whether a device (or a unit) contains a certain equipment as four kinds of association relations in a graph database; generating an influence degree grade between physical entities including a first type entity and a second type entity according to a preset rule, and taking the influence degree grade as five types of association relations in a graph database;
S13, constructing the equipment failure database according to the basic information data of the entities and the association relation between the entities.
Preferably, in the present invention, the generating the level of influence between the physical entities including the first class of entities and the second class of entities according to the preset rule includes:
Determining a plurality of influence factors from three aspects of medium characteristics, process characteristics and operators of a physical entity in advance, and respectively constructing assignment rules of the influence factors;
When calculating the influence degree grade between two physical entities, firstly assigning the influence factors related to the two physical entities and calculating the total value; and then determining the corresponding influence degree level according to the total value.
Preferably, in the present invention, further comprising:
When the equipment failure database is used, the device or equipment with the most contribution to failure and the batch of equipment with the most failure times are obtained through the retrieval of the influence degree level.
Preferably, in the present invention, the determining a plurality of influencing factors from three aspects of medium characteristics, process characteristics and personnel relationships of operators of the physical entity in advance, and constructing assignment rules of the influencing factors respectively includes:
Influence factors belonging to the medium characteristics include: temperature influencing factors, sulfur content influencing factors, salt content influencing factors, pH value influencing factors, water content influencing factors, nitrogen content influencing factors, chlorine content influencing factors, iron content influencing factors, acid value influencing factors and hydrogen sulfide content influencing factors;
Influence factors belonging to the process characteristics include: a temperature assurance influence factor, a pressure assurance influence factor, a flow assurance influence factor, and a flow rate assurance influence factor;
influence factors belonging to the operator include: a personnel relationship influencing factor;
the assignment rule of the temperature influence factor comprises: the temperature difference is 3 within 10deg.C, 2 at 10-20deg.C, 1 at 20-50deg.C, and 0 at above 50deg.C;
the assignment rule of the sulfur content influence factor comprises: the difference of the sulfur content is within 1 percent, calculated as 3,1-2 percent, calculated as 2,2-3 percent, calculated as 1, and calculated as 0 above 3 percent.
The assignment rule of the salt content influence factor comprises: the difference of the salt content is within 3.2 mgNaCl/L, 2.2-0.5 mgNaCl/L, 1.5-1 mgNaCl/L and 0 more than 1 mgNaCl/L;
the assignment rule of the pH value influence factor comprises: a pH difference of 0.5 or less, 3,0.5-1 2,1-2 1,2 or more, 0;
The assignment rule of the water content influence factor comprises: the difference of the water content is up to 0.05 percent, 3,0.05 to 0.1 percent, 2 percent, 0.1 to 0.2 percent, 1 percent and 0 percent or more;
The assignment rule of the nitrogen content influence factor comprises: the difference of nitrogen content is within 100 mug/g, calculated as 3,100-300 mug/g, calculated as 2,300-1000 mug/g, calculated as 1,1000 mug/g and calculated as 0;
The assignment rule of the chlorine content influence factor comprises: the chlorine content difference is within 10mg/L, 3,10-20mg/L, 2,20-30mg/L, 1,30mg/L or more, 0;
The assignment rule of the iron content influence factor comprises: the difference of the iron content is 0.3mg/L or less, 3,0.3-0.5mg/L or 2,0.5-1mg/L or 1,1mg/L or more and 0;
The assignment rule of the acid value influence factor comprises: the difference of the acid value is within 0.1mgKOH/g, calculated as 3,0.1-0.2mgKOH/g, calculated as 2,0.2-0.3mgKOH/g, calculated as 1,0.3mgKOH/g and calculated as 0;
the assignment rule of the hydrogen sulfide influence factor includes: the difference of the hydrogen sulfide content is 3 in 0.1 percent, 2 in 0.1 to 0.5 percent, 1 in 0.5 to 1 percent and 0 in more than 1 percent;
the assignment rule of the temperature assurance impact factor includes: a specific temperature assurance requirement meter 2, a temperature requirement meter 1 and no temperature requirement meter 0 are arranged among the entities;
the assignment rule of the pressure assurance impact factor includes: a specific pressure assurance requirement meter 2, a pressure requirement meter 1 and no pressure requirement meter 0 are arranged between the entities;
the assignment rule of the flow assurance impact factor includes: a specific flow assurance demand meter 2, a flow demand meter 1 and a flow demand meter 0 are arranged among the entities;
The assignment rule of the flow rate guarantee influence factor includes: a specific flow rate guarantee requirement meter 2, a flow rate requirement meter 1 and no flow rate requirement meter 0 are arranged among the entities;
the assignment rule of the operator influence factor includes: the personnel are the same person 3, the personnel are the same group/team personnel 2, the personnel are the same basic unit 1, and the other meters 0.
Preferably, in the present invention, when calculating the level of the influence degree between two physical entities, the influence factors related to the two physical entities are assigned first and a total value is calculated; and then determining a corresponding influence degree level according to the total value, including:
When the total value is more than 30, the influence degree grade is 7; when the total value is 25-30, the influence degree grade is 6; when the total value is 20-25, the influence degree grade is 5; when the total value is 15-20, the influence degree grade is 4; when the total value is 10-15, the influence degree grade is 3; when the total value is 5-10, the influence degree grade is 2; when the total value is 5 or less, the degree of influence is 1.
Preferably, in the present invention, the constructing the equipment failure database according to the basic information data of the entity and the association relationship between the entities includes:
Presetting corresponding input forms for each type of entity and association relation respectively, wherein the input forms provide corresponding information selectable columns according to different categories;
when the entity or the association relation is required to be manually input, determining a corresponding input form according to the difference of the entity category and the association relation category; and information input is realized by selecting the required information in the information selectable field.
Preferably, in the present invention, the association between the basic information data of the entity and the entity includes:
inputting basic information of various entities and binding the basic information with the entities one by one;
linking one kind of entity according to the association relation of the process logic to form a graph database taking equipment as a main body and the process logic as a connecting line;
linking the second-class entity with the first-class entity according to the inclusion relation to perfect the inclusion attribute of the graph database;
linking the three types of entities with the one type of entity according to the influence range, and perfecting accident attributes of the graph database;
and determining the influence degree grade among the physical entities, and perfecting the influence degree grade attribute of the graph database.
In another aspect of the present invention, there is also provided a device for constructing an equipment failure database, where the equipment failure database is a graph database, including:
An entity determining unit for determining basic information data of entities included in the graph database and storing each entity in the form of "points", including: the refining equipment is taken as a kind of entity in a graph database; the refining device (or unit) is taken as a second-class entity in the graph database; taking accidents of refining equipment as three types of entities in a graph database;
the association relation establishing unit is used for establishing association relation among entities, and comprises the following steps: taking the process flow position of the equipment as a relation as a type of association relation in a graph database; taking technical parameters and technical relativity between devices as a class-II association relationship in a graph database; taking the influence range of the accident as three kinds of association relations in the graph database; taking whether a device (or a unit) contains a certain equipment as four kinds of association relations in a graph database; generating an influence degree grade between physical entities including a first type entity and a second type entity according to a preset rule, and taking the influence degree grade as five types of association relations in a graph database;
The input unit is used for constructing the equipment failure database according to the basic information data of the entities and the association relation between the entities.
Preferably, in the present invention, further comprising:
And the searching unit is used for acquiring the device or equipment with the most contribution to failure and the batch of the equipment with the most failure times through searching the influence degree level when the equipment failure database is used.
In another aspect of the embodiment of the present invention, there is also provided an apparatus for constructing an apparatus failure database, including:
A memory for storing a computer program;
a processor for invoking and executing the computer program to implement the steps of the method of constructing a device failure database according to any of the preceding claims.
In another aspect of the embodiments of the present invention, there is also provided a storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the method for building an equipment failure database according to any one of the above.
The digital platform construction device for the hazardous chemical double prevention mechanism comprises a computer program stored on a medium, wherein the computer program comprises program instructions which, when executed by a computer, cause the computer to perform the method described in the above aspects and achieve the same technical effects.
Compared with the prior art, the invention has the following beneficial effects:
In the equipment failure database constructed by the invention, the entities are classified, and the equipment failure database comprises physical entities, namely equipment serving as one type of entity and a device serving as two types of entity, and accidents caused by refining equipment are taken as three types of entities; in addition, classification is performed according to the difference of the association relations between the entities, wherein the association relation of the type (namely, five association relations) of the degree of influence level between the physical entities (comprising the first type of entity and the second type of entity) is particularly set; through the equipment failure database constructed after setting, after an accident occurs, the device or equipment with the most contribution to failure and the related information of the batch of the equipment with the most failure times can be conveniently obtained from the equipment failure database through the retrieval of the influence degree level, so that more effective data help can be obtained to check and treat hidden dangers of the follow-up similar equipment.
The foregoing description is only an overview of the present invention, and it is to be understood that it is intended to provide a more clear understanding of the technical means of the present invention and to enable the technical means to be carried out in accordance with the contents of the specification, while at the same time providing a more complete understanding of the above and other objects, features and advantages of the present invention, and one or more preferred embodiments thereof are set forth below, together with the detailed description given below, along with the accompanying drawings.
Drawings
In order to more clearly illustrate the technical solutions of the present invention, the drawings that are needed for the embodiments will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a step diagram of a method of constructing an equipment failure database according to the present invention;
FIG. 2 is a schematic diagram of the construction apparatus of the equipment failure database according to the present invention;
FIG. 3 is a schematic diagram of the construction equipment of the equipment failure database according to the present invention.
Detailed Description
The following detailed description of embodiments of the invention is, therefore, to be taken in conjunction with the accompanying drawings, and it is to be understood that the scope of the invention is not limited to the specific embodiments.
Throughout the specification and claims, unless explicitly stated otherwise, the term "comprise" or variations thereof such as "comprises" or "comprising", etc. will be understood to include the stated element or component without excluding other elements or other components.
The terms "first," "second," and the like herein are used for distinguishing between two different elements or regions and are not intended to limit a particular position or relative relationship. In other words, in some embodiments, the terms "first," "second," etc. may also be interchanged with one another.
Example 1
In order to obtain information beneficial to hidden danger management of subsequent similar equipment through an equipment failure database after an accident, as shown in fig. 1, in an embodiment of the present invention, a method for constructing an equipment failure database is provided, where the equipment failure database is a graph database, and includes the steps of:
S11, determining basic information data of entities included in the graph database, and storing each entity in a 'point' form, wherein the method comprises the following steps: the refining equipment is taken as a kind of entity in a graph database; the refining device (or unit) is taken as a second-class entity in the graph database; taking accidents of refining equipment as three types of entities in a graph database;
The equipment failure database in the embodiment of the invention is based on the graph database, and when the graph database is constructed, the entities which need to be input into the graph database are firstly determined.
The refining device is composed of a plurality of refining equipment, and the refining equipment is divided into one type of entity as the minimum unit of entity composition in the embodiment of the invention; dividing the refining device (or unit) into two types of entities in the graph database; accidents occurring in refining equipment are divided into three types of entities in a graph database.
S12, establishing an association relationship among entities, including: taking the process flow position of the equipment as a relation as a type of association relation in a graph database; taking technical parameters and technical relativity between devices as a class-II association relationship in a graph database; taking the influence range of the accident as three kinds of association relations in the graph database; taking whether a device (or a unit) contains a certain equipment as four kinds of association relations in a graph database; generating an influence degree grade between physical entities including a first type entity and a second type entity according to a preset rule, and taking the influence degree grade as five types of association relations in a graph database;
When the graph database is constructed, basic information data corresponding to each entity is needed, and association relations among the entities needing to be input into the graph database are also determined, and in the embodiment of the invention, the association relations are classified, and the method specifically comprises the following steps:
The process flow position of the equipment is used as a relation to be used as a kind of association relation in a graph database, including upstream, downstream, parallel connection, redundancy (compound line) and the like, and the corresponding association relation can be added according to the actual encountered situation due to the characteristics of the graph database.
The technical parameters and the technical relativity between the devices are used as the two kinds of relativity in the graph database, including the similar devices (such as pumps), the same devices (such as instrument control devices), the same manufacturer devices, the same batch devices, the same installation devices of the same factory, the same unit devices of the same factory, the same location devices of the same factory (i.e. the standby machine), the same installation devices of different factories, the same unit devices of different factories, the location devices of different factories (i.e. the standby machine) and the like.
Taking the influence range of the accident as three kinds of association relations in the graph database; the influence range of the accident is used as three kinds of association relations in the graph database, including affected, slightly affected and the like, and the corresponding association relation can be added according to the actual encountered situation due to the characteristics of the graph database.
And whether the device (or the unit) contains a certain equipment is used as four kinds of association relations in the graph database, and the corresponding association relation can be added according to the actual encountered situation due to the characteristics of the graph database.
In addition, in the embodiment of the invention, the influence degree grade between the physical entities including the first-class entity and the second-class entity is also generated according to the preset rule, and the influence degree grade is used as five kinds of association relations in the graph database.
When an accident occurs in a physical entity of a refining device or a refining apparatus as a physical entity, other physical entities are likely to be affected to different degrees.
In practical applications, the specific way to generate the level of influence between physical entities may be: determining a plurality of influence factors from three aspects of medium characteristics, process characteristics and operators of a physical entity in advance, and respectively constructing assignment rules of the influence factors; in this way, when calculating the influence degree grade between two physical entities, firstly, assigning the influence factors related to the two physical entities and calculating the total value; then determining a corresponding influence degree level according to the total value; specific:
Influence factors belonging to the medium characteristics include: temperature influencing factors, sulfur content influencing factors, salt content influencing factors, pH value influencing factors, water content influencing factors, nitrogen content influencing factors, chlorine content influencing factors, iron content influencing factors, acid value influencing factors and hydrogen sulfide content influencing factors;
Influence factors belonging to the process characteristics include: a temperature assurance influence factor, a pressure assurance influence factor, a flow assurance influence factor, and a flow rate assurance influence factor;
influence factors belonging to the operator include: a personnel relationship influencing factor;
the assignment rule of the temperature influence factor comprises: the temperature difference is 3 within 10deg.C, 2 at 10-20deg.C, 1 at 20-50deg.C, and 0 at above 50deg.C;
the assignment rule of the sulfur content influence factor comprises: the difference of the sulfur content is within 1 percent, calculated as 3,1-2 percent, calculated as 2,2-3 percent, calculated as 1, and calculated as 0 above 3 percent.
The assignment rule of the salt content influence factor comprises: the difference of the salt content is within 3.2 mgNaCl/L, 2.2-0.5 mgNaCl/L, 1.5-1 mgNaCl/L and 0 more than 1 mgNaCl/L;
the assignment rule of the pH value influence factor comprises: a pH difference of 0.5 or less, 3,0.5-1 2,1-2 1,2 or more, 0;
The assignment rule of the water content influence factor comprises: the difference of the water content is up to 0.05 percent, 3,0.05 to 0.1 percent, 2 percent, 0.1 to 0.2 percent, 1 percent and 0 percent or more;
The assignment rule of the nitrogen content influence factor comprises: the difference of nitrogen content is within 100 mug/g, calculated as 3,100-300 mug/g, calculated as 2,300-1000 mug/g, calculated as 1,1000 mug/g and calculated as 0;
The assignment rule of the chlorine content influence factor comprises: the chlorine content difference is within 10mg/L, 3,10-20mg/L, 2,20-30mg/L, 1,30mg/L or more, 0;
The assignment rule of the iron content influence factor comprises: the difference of the iron content is 0.3mg/L or less, 3,0.3-0.5mg/L or 2,0.5-1mg/L or 1,1mg/L or more and 0;
The assignment rule of the acid value influence factor comprises: the difference of the acid value is within 0.1mgKOH/g, calculated as 3,0.1-0.2mgKOH/g, calculated as 2,0.2-0.3mgKOH/g, calculated as 1,0.3mgKOH/g and calculated as 0;
the assignment rule of the hydrogen sulfide influence factor includes: the difference of the hydrogen sulfide content is 3 in 0.1 percent, 2 in 0.1 to 0.5 percent, 1 in 0.5 to 1 percent and 0 in more than 1 percent;
the assignment rule of the temperature assurance impact factor includes: a specific temperature assurance requirement meter 2, a temperature requirement meter 1 and no temperature requirement meter 0 are arranged among the entities;
the assignment rule of the pressure assurance impact factor includes: a specific pressure assurance requirement meter 2, a pressure requirement meter 1 and no pressure requirement meter 0 are arranged between the entities;
the assignment rule of the flow assurance impact factor includes: a specific flow assurance demand meter 2, a flow demand meter 1 and a flow demand meter 0 are arranged among the entities;
The assignment rule of the flow rate guarantee influence factor includes: a specific flow rate guarantee requirement meter 2, a flow rate requirement meter 1 and no flow rate requirement meter 0 are arranged among the entities;
the assignment rule of the operator influence factor includes: the personnel are the same person 3, the personnel are the same group/team personnel 2, the personnel are the same basic unit 1, and the other meters 0.
When calculating the influence degree grade between two physical entities, firstly assigning the influence factors related to the two physical entities and calculating the total value; then determining the corresponding influence degree level according to the total value, wherein the specific mode can be as follows:
When the total value is more than 30, the influence degree grade is 7; when the total value is 25-30, the influence degree grade is 6; when the total value is 20-25, the influence degree grade is 5; when the total value is 15-20, the influence degree grade is 4; when the total value is 10-15, the influence degree grade is 3; when the total value is 5-10, the influence degree grade is 2; when the total value is 5 or less, the degree of influence is 1.
S13, constructing the equipment failure database according to the basic information data of the entities and the association relation between the entities.
After determining the association relationship between the entities included in the graph database, the association relationship between the entities needs to be entered.
Preferably, the specific manner of the embodiment of the present invention according to the basic information data of the entity and the association relationship between the entities may include:
Presetting corresponding input forms for each type of entity and association relation respectively, wherein the input forms provide corresponding information selectable columns according to different categories;
when the entity or the association relation is required to be manually input, determining a corresponding input form according to the difference of the entity category and the association relation category; and information input is realized by selecting the required information in the information selectable field.
Because the entity and the association relationship are pre-classified in the embodiment of the invention, a corresponding input form can be constructed for each category which is the entity and the association relationship; the information selectable fields of each input form are matched with the entities or the association relations of each type, namely, corresponding information can be selected or input in the information selectable fields conveniently and rapidly. Furthermore, the recording efficiency during manual recording can be effectively improved, and the probability of manual error is reduced (namely, the standardability is improved).
In practical application, when constructing a database according to entities (points) and association relations (edges), the following operations need to be performed:
inputting basic information of various entities and binding the basic information with the entities one by one;
linking one kind of entity according to the association relation of the process logic to form a graph database taking equipment as a main body and the process logic as a connecting line;
linking the second-class entity with the first-class entity according to the inclusion relation to perfect the inclusion attribute of the graph database;
linking the three types of entities with the one type of entity according to the influence range, and perfecting accident attributes of the graph database;
and determining the influence degree grade among the physical entities, and perfecting the influence degree grade attribute of the graph database.
In a specific example, a specific process of applying an embodiment of the present invention may be:
1, determining an entity
In this example: one class of entities includes plant 1 (fractionation column), plant 2 (feed pump), and plant 3 (fractionation column overhead reflux drum); the second class of entities comprises device 1 (atmospheric and vacuum device); three types of entities include Accident 1 (3.13 pump leakage fire Accident); wherein 3.13 is used to identify different incidents.
Meanwhile, basic information data of the entities are prepared respectively, the basic information data belongs to conventional data, and the richness of the basic information data is positively correlated with the search result of part of association relations.
The basic data information of the three devices, namely the fractionating tower, the feed pump and the reflux tank at the top of the fractionating tower, which are entities can be specifically the size, the material, the medium, the manufacturer, the batch, the date of use and the like of the devices. The basic data information of the atmospheric and vacuum devices of the second kind of entity can be specifically content such as capacity, date of use, design units and the like. The basic data information of the 3.13 pump leakage fire accident which is three types of entities can be specifically that the medium leakage of the feeding pump causes the feeding pump to catch fire and thus affects the normal operation of the fractionating tower.
2, Constructing the relation among the entities
Constructing an association relation between each kind of entity, wherein the feed pump is upstream equipment of the fractionating tower, so that the relation between the feed pump and the fractionating tower is feed pump-fractionating tower, and the relation between the feed pump and the fractionating tower is downstream; the fractionation column is an upstream device of the fractionation column overhead reflux drum, so the relationship between the two is fractionation column→fractionation column overhead reflux drum, and the relationship is downstream.
And constructing an association relation between the first-class entity and the second-class entity, wherein three devices of the fractionating tower, the feeding pump and the fractionating tower top reflux tank are all affiliated to the atmospheric and vacuum device, so that the relationship is contained from the atmospheric and vacuum device to the devices.
Constructing an association relation between one type of entity and three types of entities, wherein in a 3.13 pump leakage fire accident, a feed pump is directly influenced, so that the relationship between the two is 3.13 pump leakage fire accident- & gt feed pump, and the relationship is influenced; the fractionation column was partially affected but not directly affected in this event, so the relationship between the two was 3.13 pump leakage fire event→fractionation column, the relationship was slightly affected.
According to the basic information data, the influence degree grade among various entities can be automatically generated through the preset rules; the level of the mutual influence degree between the feed pump and the fractionating tower is 7 levels through the determination and corresponding calculation of the influence factors; the fractionation tower and the reflux tank at the top of the fractionation tower are subjected to the determination and corresponding calculation of the influence factors, and the grade of the degree of interaction between the two is 5; the level of the mutual influence between the feed pump and the reflux drum at the top of the fractionating tower is 4 levels through the determination and corresponding calculation of influence factors.
It should be noted that, the traditional "table" database needs to set fields in advance and input data according to the fields, and expansion of the data can be performed at any time, but expansion of the fields is almost impossible, unless the database is updated at the cost of losing part of the data; in the embodiment of the invention, the graph database is not formed in a table type form of fixed fields, and only the corresponding entity and the association relation are added, so that the expanding performance is much stronger.
For example, in this example, if expansion is required, one kind of entity (such as the device 4 and the device 5), two kinds of entity (such as the device 2 and the device 3), three kinds of entity (such as the accident 2 and the accident 3) can be added, and the relationship and the influence degree level between the entities and the existing entity are established, so that expansion of the graph database is realized, and the existing entity and relationship are not destroyed.
3, Searching the graph database
When the graph database constructed by the embodiment is searched, basic information data of the entity can be searched except for conventional searching, and the basic information data are displayed according to the recorded detail degree; in addition, the search can be performed under a certain relational condition, for example, "the device 1 is affected by the accident 1", so that two devices, namely the device 1 and the device 2, can be obtained more conveniently, and in practical application, when: searching is carried out by using normal-pressure reduction device equipment slightly affected by accidents, and the result of a fractionating tower is conveniently obtained in the example; the device (the influence degree level exceeds 3) with stronger relevance with the fractionating tower is used for searching, and two results of the feed pump and the reflux tank at the top of the fractionating tower can be conveniently obtained, so that an effective risk monitoring object can be provided, and the enterprise safety production is supported.
It should be noted that, for easy understanding, the retrieval content listed in this example is simpler, and when the graph database is huge or the retrieval relationship is complex, the retrieval efficiency of the framework database will be far superior to that of the traditional database.
In summary, in the equipment failure database constructed by the embodiment of the invention, the entities are classified, which not only includes the physical entities of the equipment serving as a first type entity and the device serving as a second type entity, but also takes the accidents occurring by the refining equipment as three types of entities; in addition, classification is performed according to the difference of the association relations between the entities, wherein the association relation of the type (namely, five association relations) of the degree of influence level between the physical entities (comprising the first type of entity and the second type of entity) is particularly set; through the equipment failure database constructed after setting, after an accident occurs, the device or equipment with the most contribution to failure and the related information of the batch of the equipment with the most failure times can be conveniently obtained from the equipment failure database through the retrieval of the influence degree level, so that more effective data help can be obtained to check and treat hidden dangers of the follow-up similar equipment.
Example two
On the basis of the first embodiment, the embodiment of the invention can further comprise a step of applying the equipment failure database, and specifically comprises the following steps:
s16, when the equipment failure database is used, acquiring the most-contributed failed device or equipment and the most-failed batch of equipment by influencing the degree-level retrieval.
That is, the device failure database constructed by the embodiment of the invention not only can perform conventional searching based on basic information and various relations of the device, but also can acquire the most-contributed failed device or device and the related information of the batch of the most-failed device from the device failure database through searching of the influence degree level after an accident occurs, so that more effective data help can be obtained to check and treat hidden danger of the subsequent similar devices.
Example III
Corresponding to the method embodiment, on the other side of the embodiment of the present invention, a device for building an equipment failure database is further provided, fig. 2 is a schematic structural diagram of the device for building an equipment failure database provided in the embodiment of the present invention, where the device for building an equipment failure database is a device corresponding to the method for building an equipment failure database in the embodiment corresponding to fig. 1, that is, the method for building an equipment failure database in the embodiment corresponding to fig. 1 is implemented by means of a virtual device, and each virtual module that forms the device for building an equipment failure database may be executed by an electronic device, for example, a network device, a terminal device, or a server. Specifically, the device for constructing the equipment failure database in the embodiment of the invention comprises the following steps:
An entity determining unit 01 for determining basic information data of entities included in the graph database and storing each entity in the form of "dots", comprising: the refining equipment is taken as a kind of entity in a graph database; the refining device (or unit) is taken as a second-class entity in the graph database; taking accidents of refining equipment as three types of entities in a graph database;
An association relationship establishing unit 02, configured to establish an association relationship between entities, including: taking the process flow position of the equipment as a relation as a type of association relation in a graph database; taking technical parameters and technical relativity between devices as a class-II association relationship in a graph database; taking the influence range of the accident as three kinds of association relations in the graph database; taking whether a device (or a unit) contains a certain equipment as four kinds of association relations in a graph database; generating an influence degree grade between physical entities including a first type entity and a second type entity according to a preset rule, and taking the influence degree grade as five types of association relations in a graph database;
the input unit 03 is configured to construct the equipment failure database according to the basic information data of the entities and the association relationship between the entities.
It should be noted that, the specific implementation manner and the technical effect of the device for constructing an equipment failure database in the embodiment of the present invention may refer to the construction method of the equipment failure database corresponding to fig. 1, and will not be described herein.
Example IV
Corresponding to the method embodiment, the embodiment of the invention also provides construction equipment of the equipment failure database, such as a terminal, a server and the like. The server may be an independent physical server, a server cluster or a distributed system formed by a plurality of physical servers, or a cloud server providing cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, CDNs, basic cloud computing services such as big data and artificial intelligent platforms. The terminal may be, but is not limited to, a smart phone, a tablet computer, a notebook computer, a desktop computer, etc.
An example diagram of a hardware structure block diagram of a device for constructing a device failure database provided by an embodiment of the present invention is shown in fig. 3, and may include:
a processor 1, a communication interface 2, a memory 3 and a communication bus 4;
wherein the processor 1, the communication interface 2 and the memory 3 complete the communication with each other through the communication bus 4;
alternatively, the communication interface 2 may be an interface of a communication module, such as an interface of a GSM module;
the processor 1 may be a central processing unit CPU, or an Application-specific integrated Circuit ASIC (Application SPECIFIC INTEGRATED Circuit), or one or more integrated circuits configured to implement embodiments of the present application.
The memory 3 may comprise a high-speed RAM memory or may further comprise a non-volatile memory, such as at least one disk memory.
Wherein the processor 1 is specifically configured to execute a computer program stored in the memory 3 to perform the following steps:
S11, determining basic information data of entities included in the graph database, and storing each entity in a 'point' form, wherein the method comprises the following steps: the refining equipment is taken as a kind of entity in a graph database; the refining device (or unit) is taken as a second-class entity in the graph database; taking accidents of refining equipment as three types of entities in a graph database;
S12, establishing an association relationship among entities, including: taking the process flow position of the equipment as a relation as a type of association relation in a graph database; taking technical parameters and technical relativity between devices as a class-II association relationship in a graph database; taking the influence range of the accident as three kinds of association relations in the graph database; taking whether a device (or a unit) contains a certain equipment as four kinds of association relations in a graph database; generating an influence degree grade between physical entities including a first type entity and a second type entity according to a preset rule, and taking the influence degree grade as five types of association relations in a graph database;
S13, constructing the equipment failure database according to the basic information data of the entities and the association relation between the entities.
Preferably, in an embodiment of the present invention, the method further includes:
When the equipment failure database is used, the device or equipment with the most contribution to failure and the batch of equipment with the most failure times are obtained through the retrieval about the degree of influence.
The product can execute the method provided by the embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method. Technical details which are not described in detail in the present embodiment can be referred to the method for constructing the equipment failure database provided in the embodiment of the present invention.
Example five
In an embodiment of the present invention, there is also provided a storage medium storing a program adapted to be executed by a processor, the program being configured to:
S11, determining basic information data of entities included in the graph database, and storing each entity in a 'point' form, wherein the method comprises the following steps: the refining equipment is taken as a kind of entity in a graph database; the refining device (or unit) is taken as a second-class entity in the graph database; taking accidents of refining equipment as three types of entities in a graph database;
S12, establishing an association relationship among entities, including: taking the process flow position of the equipment as a relation as a type of association relation in a graph database; taking technical parameters and technical relativity between devices as a class-II association relationship in a graph database; taking the influence range of the accident as three kinds of association relations in the graph database; taking whether a device (or a unit) contains a certain equipment as four kinds of association relations in a graph database; generating an influence degree grade between physical entities including a first type entity and a second type entity according to a preset rule, and taking the influence degree grade as five types of association relations in a graph database;
S13, constructing the equipment failure database according to the basic information data of the entities and the association relation between the entities.
Preferably, in an embodiment of the present invention, the method further includes:
When the equipment failure database is used, the device or equipment with the most contribution to failure and the batch of equipment with the most failure times are obtained through the retrieval about the degree of influence.
Alternatively, the refinement function and the extension function of the program may be described with reference to the above.
The product can execute the method provided by the embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method. Technical details not described in detail in this embodiment may be found in the methods provided in other embodiments of the present invention.
Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
In the several embodiments provided by the present application, it should be understood that the disclosed systems, devices, and methods may be implemented in other manners. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit.
It should be understood that in the embodiments of the present application, the claims, the various embodiments, and the features may be combined with each other, so as to solve the foregoing technical problems.
The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a usb disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (11)

1. The construction method of the equipment failure database is characterized by comprising the following steps:
S11, collecting basic information data of entities included in the graph database, and storing each entity in a 'point' form, wherein the method comprises the following steps: the refining equipment is taken as a kind of entity in a graph database; the refining device (or unit) is taken as a second-class entity in the graph database; taking accidents of refining equipment as three types of entities in a graph database;
S12, establishing an association relationship among entities, including: taking the process flow position of the equipment as a relation as a type of association relation in a graph database; taking technical parameters and technical relativity between devices as a class-II association relationship in a graph database; taking the influence range of the accident as three kinds of association relations in the graph database; taking whether a device (or a unit) contains a certain equipment as four kinds of association relations in a graph database; generating an influence degree grade between physical entities including a first type entity and a second type entity according to a preset rule, and taking the influence degree grade as five types of association relations in a graph database;
S13, constructing the equipment failure database according to the basic information data of the entities and the association relation between the entities.
2. The method for constructing a device failure database according to claim 1, wherein the generating the degree of influence level between the physical entities including the first type of entity and the second type of entity according to the preset rule includes:
Determining a plurality of influence factors from three aspects of medium characteristics, process characteristics and operators of a physical entity in advance, and respectively constructing assignment rules of the influence factors;
When calculating the influence degree grade between two physical entities, firstly assigning the influence factors related to the two physical entities and calculating the total value; and then determining the corresponding influence degree level according to the total value.
3. The construction method of an equipment failure database according to claim 1 or 2, further comprising:
when the equipment failure database is used, the device or equipment with the most contribution to failure and the batch of equipment with the most failure times are obtained through the retrieval of the influence degree level.
4. The method for building a failure database of equipment according to claim 3, wherein determining a plurality of influencing factors from three aspects of medium characteristics, process characteristics and personnel relationships of operators of the physical entity in advance, and building assignment rules of the influencing factors respectively comprises:
Influence factors belonging to the medium characteristics include: temperature influencing factors, sulfur content influencing factors, salt content influencing factors, pH value influencing factors, water content influencing factors, nitrogen content influencing factors, chlorine content influencing factors, iron content influencing factors, acid value influencing factors and hydrogen sulfide content influencing factors;
Influence factors belonging to the process characteristics include: a temperature assurance influence factor, a pressure assurance influence factor, a flow assurance influence factor, and a flow rate assurance influence factor;
influence factors belonging to the operator include: a personnel relationship influencing factor;
the assignment rule of the temperature influence factor comprises: the temperature difference is 3 within 10deg.C, 2 at 10-20deg.C, 1 at 20-50deg.C, and 0 at above 50deg.C;
the assignment rule of the sulfur content influence factor comprises: the difference of the sulfur content is within 1 percent, calculated as 3,1-2 percent, calculated as 2,2-3 percent, calculated as 1, and calculated as 0 above 3 percent.
The assignment rule of the salt content influence factor comprises: the difference of the salt content is within 3.2 mgNaCl/L, 2.2-0.5 mgNaCl/L, 1.5-1 mgNaCl/L and 0 more than 1 mgNaCl/L;
the assignment rule of the pH value influence factor comprises: a pH difference of 0.5 or less, 3,0.5-1 2,1-2 1,2 or more, 0;
The assignment rule of the water content influence factor comprises: the difference of the water content is up to 0.05 percent, 3,0.05 to 0.1 percent, 2 percent, 0.1 to 0.2 percent, 1 percent and 0 percent or more;
The assignment rule of the nitrogen content influence factor comprises: the difference of nitrogen content is within 100 mug/g, calculated as 3,100-300 mug/g, calculated as 2,300-1000 mug/g, calculated as 1,1000 mug/g and calculated as 0;
The assignment rule of the chlorine content influence factor comprises: the chlorine content difference is within 10mg/L, 3,10-20mg/L, 2,20-30mg/L, 1,30mg/L or more, 0;
The assignment rule of the iron content influence factor comprises: the difference of the iron content is 0.3mg/L or less, 3,0.3-0.5mg/L or 2,0.5-1mg/L or 1,1mg/L or more and 0;
The assignment rule of the acid value influence factor comprises: the difference of the acid value is within 0.1mgKOH/g, calculated as 3,0.1-0.2mgKOH/g, calculated as 2,0.2-0.3mgKOH/g, calculated as 1,0.3mgKOH/g and calculated as 0;
the assignment rule of the hydrogen sulfide influence factor includes: the difference of the hydrogen sulfide content is 3 in 0.1 percent, 2 in 0.1 to 0.5 percent, 1 in 0.5 to 1 percent and 0 in more than 1 percent;
the assignment rule of the temperature assurance impact factor includes: a specific temperature assurance requirement meter 2, a temperature requirement meter 1 and no temperature requirement meter 0 are arranged among the entities;
the assignment rule of the pressure assurance impact factor includes: a specific pressure assurance requirement meter 2, a pressure requirement meter 1 and no pressure requirement meter 0 are arranged between the entities;
the assignment rule of the flow assurance impact factor includes: a specific flow assurance demand meter 2, a flow demand meter 1 and a flow demand meter 0 are arranged among the entities;
The assignment rule of the flow rate guarantee influence factor includes: a specific flow rate guarantee requirement meter 2, a flow rate requirement meter 1 and no flow rate requirement meter 0 are arranged among the entities;
the assignment rule of the operator influence factor includes: the personnel are the same person 3, the personnel are the same group/team personnel 2, the personnel are the same basic unit 1, and the other meters 0.
5. The method for constructing a failure database of equipment according to claim 1, wherein when calculating the level of influence between two physical entities, assigning the influence factors related to the two physical entities and calculating a total value; and then determining a corresponding influence degree level according to the total value, including:
When the total value is more than 30, the influence degree grade is 7; when the total value is 25-30, the influence degree grade is 6; when the total value is 20-25, the influence degree grade is 5; when the total value is 15-20, the influence degree grade is 4; when the total value is 10-15, the influence degree grade is 3; when the total value is 5-10, the influence degree grade is 2; when the total value is 5 or less, the degree of influence is 1.
6. The method for constructing an equipment failure database according to claim 5, wherein the constructing the equipment failure database according to the basic information data of the entity and the association relationship between the entities comprises:
Presetting corresponding input forms for each type of entity and association relation respectively, wherein the input forms provide corresponding information selectable columns according to different categories;
when the entity or the association relation is required to be manually input, determining a corresponding input form according to the difference of the entity category and the association relation category; and information input is realized by selecting the required information in the information selectable field.
7. The method for constructing an equipment failure database according to claim 5, wherein the constructing the equipment failure database according to the basic information data of the entity and the association relationship between the entities comprises:
inputting basic information of various entities and binding the basic information with the entities one by one;
linking one kind of entity according to the association relation of the process logic to form a graph database taking equipment as a main body and the process logic as a connecting line;
linking the second-class entity with the first-class entity according to the inclusion relation to perfect the inclusion attribute of the graph database;
linking the three types of entities with the one type of entity according to the influence range, and perfecting accident attributes of the graph database;
and determining the influence degree grade among the physical entities, and perfecting the influence degree grade attribute of the graph database.
8. A construction apparatus for an equipment failure database, the equipment failure database being a graph database, comprising:
An entity determining unit for determining basic information data of entities included in the graph database and storing each entity in the form of "points", including: the refining equipment is taken as a kind of entity in a graph database; the refining device (or unit) is taken as a second-class entity in the graph database; taking accidents of refining equipment as three types of entities in a graph database;
the association relation establishing unit is used for establishing association relation among entities, and comprises the following steps: taking the process flow position of the equipment as a relation as a type of association relation in a graph database; taking technical parameters and technical relativity between devices as a class-II association relationship in a graph database; taking the influence range of the accident as three kinds of association relations in the graph database; taking whether a device (or a unit) contains a certain equipment as four kinds of association relations in a graph database; generating an influence degree grade between physical entities including a first type entity and a second type entity according to a preset rule, and taking the influence degree grade as five types of association relations in a graph database;
The input unit is used for constructing the equipment failure database according to the basic information data of the entities and the association relation between the entities.
9. The apparatus for constructing an equipment failure database according to claim 8, further comprising:
And the searching unit is used for acquiring the device or equipment with the most contribution to failure and the batch of the equipment with the most failure times through searching the influence degree level when the equipment failure database is used.
10. A device for building a device failure database, comprising:
A memory for storing a computer program;
A processor for invoking and executing said computer program to implement the steps of the method of constructing a device failure database according to any of claims 1-7.
11. A storage medium comprising a software program adapted to be executed by a processor for performing the steps of the method of constructing a device failure database according to any of claims 1-7.
CN202211380059.9A 2022-11-04 2022-11-04 Construction method, device, equipment and storage medium of equipment failure database Pending CN117992551A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211380059.9A CN117992551A (en) 2022-11-04 2022-11-04 Construction method, device, equipment and storage medium of equipment failure database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211380059.9A CN117992551A (en) 2022-11-04 2022-11-04 Construction method, device, equipment and storage medium of equipment failure database

Publications (1)

Publication Number Publication Date
CN117992551A true CN117992551A (en) 2024-05-07

Family

ID=90894119

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211380059.9A Pending CN117992551A (en) 2022-11-04 2022-11-04 Construction method, device, equipment and storage medium of equipment failure database

Country Status (1)

Country Link
CN (1) CN117992551A (en)

Similar Documents

Publication Publication Date Title
Sinnamon et al. Improved accuracy in quantitative fault tree analysis
CN110826976A (en) Enterprise actual controller operation system and method
CN111460312A (en) Method and device for identifying empty-shell enterprise and computer equipment
CN108183897B (en) Safety risk assessment method for information physical fusion system
Montalvo et al. Retrospective analysis of hydraulic bridge collapse
CN115686910A (en) Fault analysis method and device, electronic equipment and medium
CN111562930A (en) Upgrading method and system for web application security
CN110532461A (en) Information platform method for pushing, device, computer equipment and storage medium
CN113434708A (en) Address information detection method and device, electronic equipment and storage medium
CN117992551A (en) Construction method, device, equipment and storage medium of equipment failure database
CN113220777A (en) Service data processing method and device, computer equipment and storage medium
CN110852893A (en) Risk identification method, system, equipment and storage medium based on mass data
CN107085603A (en) A kind of data processing method and device
CN114881503A (en) Scoring determination method, device, equipment and storage medium
CN115033412A (en) Task log merging method and device
CN114091699A (en) Power communication equipment fault diagnosis method and system
CN113537806A (en) Abnormal user identification method and device, electronic equipment and readable storage medium
CN113887932A (en) Operation and maintenance management and control method and device based on artificial intelligence and computer equipment
CN105117821A (en) Industrial control system information safety asset identifying method based on area division
CN111352818A (en) Application program performance analysis method and device, storage medium and electronic equipment
CN116433197B (en) Information reporting method, device, reporting end and storage medium
CN114817929B (en) Method and device for dynamically tracking and processing vulnerability of Internet of things, electronic equipment and medium
CN114513441B (en) System maintenance method, device, equipment and storage medium based on block chain
CN115543991B (en) Data restoration method and device based on feature sampling and related equipment
CN112907009B (en) Standardized model construction method and device, storage medium and equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination