CN102521711B - The control method of the data model structure of equipment quality characteristic and device - Google Patents
The control method of the data model structure of equipment quality characteristic and device Download PDFInfo
- Publication number
- CN102521711B CN102521711B CN201110441436.0A CN201110441436A CN102521711B CN 102521711 B CN102521711 B CN 102521711B CN 201110441436 A CN201110441436 A CN 201110441436A CN 102521711 B CN102521711 B CN 102521711B
- Authority
- CN
- China
- Prior art keywords
- data
- product
- tables
- reliability
- testability
- 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.)
- Active
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Factory Administration (AREA)
Abstract
The control method of the data model structure of equipment quality characteristic and a device, comprising: system creates multiple tables of data in a database; Equipment data are imported to database, Data classification is carried out to the data imported, by sorted data stored in the respective table after establishment in this database, in above-mentioned table, sets up main external key, data in each table are carried out data correlation, completes the structure of the data model of equipment quality characteristic.The invention solves the current problem needing the data model monitoring the data such as the integration reliability maintainability and supportability of weaponry, testability and security.
Description
Technical field
The present invention relates to Data Control field, the control method that the data model being specifically related to a kind of equipment quality characteristic builds and device.
Background technology
Along with the technical complexity of weaponry improves constantly, cannot meet the requirement that high-tech weaponry use technology is ensured far away based on the development mode of the usability of weaponry in original equipment preparation process, cause a large amount of weaponry under arms the stage be often in ensure not enough, cannot localizing faults reason, servicing time long state, the request for utilization of army for weaponry can not be met.Current demands is equipped in life cycle process except will meeting original functional characteristic and requiring, also will meet the requirement of the quality monitoring characteristics such as reliability maintainability and supportability, testability and security.
The existing data management of the development of weaponry and management unit is based on the functional characteristic data management of product, can not meet the demands far away, must on the basis of original function performance data management, realize reliability, maintainability, protection, the management of the quality monitoring such as testability and security characteristic, in addition due to reliability, maintainability, protection, interrelated between the quality monitoring such as testability and security characteristic, influence each other, reliability is integrated in the urgent need to one, maintainability, protection, the technical scheme of the data model of the quality monitoring such as testability and security performance data solves the problems referred to above.
Summary of the invention
The control method that technical matters to be solved by this invention is to provide a kind of data model of equipment quality characteristic to build and device, to solve the current problem needing the data model monitoring the data such as the integration reliability maintainability and supportability of weaponry, testability and security.
In order to solve the problem, the control method that the data model that the invention provides a kind of equipment quality characteristic builds, comprising:
System initialization, connection data storehouse;
Create the product interleaving function needing quality monitoring to equip in a database and require table, using and satisfied requires table, product reliability, availability and maintainability RAM characteristic and failure modes effects and criticality analysis FMECA, maintenance analysis RCMA analytical data centered by reliability, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data, unit under test requires and tables of data is described, capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data, testability design analysis table and technical service tables of data,
Equipment data are imported to database, Data classification is carried out to the data imported, comprise product parameters data, product reliability data, Product maintenance data, product test data, Product Safety data, product protection data, product Support Resource data and product technology service data, by sorted data stored in the respective table after establishment in this database, main external key is set up in above-mentioned table, data in each table are carried out data correlation, completes the structure of the data model of equipment quality characteristic.
Further, said method also can comprise: the described product interleaving function needing quality monitoring to equip that creates in a database requires table, using and satisfied requires table, product RAM characteristic and FMECA, RCMA analytical data, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data, unit under test requires and tables of data is described, capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data, the step of testability design analysis table and technical service tables of data, comprise:
Based on GJB3837, GJB1371, GJB3872, GJB3206A, GJBZ1391-2006, GJB1378A-2007, MIL-STD-1388-2B, GEIA-STD-0007, ATAMSG-3, DefStan00-60, S4000M and S3000L standard-required, the product interleaving function setting up equipment requires table, using and satisfied requires table, product RAM characteristic and FMECA, RCMA analytical data, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data and unit under test require and tables of data are described, above-mentioned each table is used for storing about equipment Reliability, maintainability, the data of the design analysis result of testability and protection,
Based on GJBZ57, GJB900-90, GJB2547-1995, GJB450A-2004 and GJBZ299C-2006 standard-required, set up the capability of maintenance design analytical data of equipment, reliability design analysis tables of data, safety Design analytical data and testability design analysis table, above-mentioned each table analyzes the data of each link for the guarantee characteristics design stored about equipment Reliability, maintainability, testability and security;
Set up the technical service tables of data of equipment based on GJB841-90 standard-required, this table is for storing equipment use technology data.
Further, said method also can comprise: described product parameters data comprise product structure data, product essential information data, product-specific documentation data and product technology status data;
Described product reliability data comprise Reliability Distribution data, reliability prediction data, Reliability modeling data, Fault Tree Analysis data, reliability block diagram RBD data, Failure Mode Effective Analysis FMEA data, lifetime data and event thing and analyze ETA data;
Described Product maintenance data comprise maintainability conflict data, maintainability prediction data, maintainability modeling data and maintainability FMEA data;
Described product test data comprise testability allocation data, testability prediction data, testability modeling data, testability FMEA data and testability design analysis data;
Described Product Safety data comprise fault hazard analysis data, region security analyzes data, dangerous matter sources identification and control data and security FMEA data;
Described product protection data comprise use and maintenance requirement data, protection FMECA data, RCMA data and use and maintenance task and analyze O & MTA data;
Described product Support Resource data comprise manpower demographic data, guarantee and testing apparatus data, technical information data, packaging accumulating data, spare part and consumables data, facility data, training and training support resource data and computing machine Support Resource data;
Described product technology service data comprises usage data, fault data, test data, mantenance data, interchange data, technical bulletin data and fault closed-loop process data.
Further, said method also can comprise: describedly in above-mentioned table, set up main external key, data in each table is carried out the step of data correlation, comprising:
Require based on table by product interleaving function, using the object that product structure is analyzed as the guarantee characteristics design of reliability maintainability and supportability, testability and security, the equipment data of all importings are associated with product interleaving function requirement table;
Require that table and product RAM characteristic and FMECA, RCMA analytical data are for input, by using and satisfied job analysis tables of data, associate use technology operational data with required product Support Resource data with using and satisfied;
Based on using and satisfied requirement table and product RAM characteristic and FMECA, RCMA analytical data, by data in capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data and testability design analysis table, require to associate with the dependability parameter equipped and fault mode related data by using and satisfied;
By fault mode related data, data in technical service tables of data are associated with data in using and satisfied requirement table, product RAM characteristic and FMECA, RCMA analytical data and using and satisfied job analysis tables of data.
The control device that the data model that present invention also offers a kind of equipment quality characteristic builds, comprising:
Initialization unit, for system initialization, connection data storehouse;
Create tables of data unit, table is required for creating the product interleaving function needing quality monitoring to equip in a database, using and satisfied requires table, product reliability, availability and maintainability RAM characteristic and failure modes effects and criticality analysis FMECA, maintenance analysis RCMA analytical data centered by reliability, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data, unit under test requires and tables of data is described, capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data, testability design analysis table and technical service tables of data,
Data importing unit, for importing equipment data to database, Data classification is carried out to the data imported, comprise product parameters data, product reliability data, Product maintenance data, product test data, Product Safety data, product protection data, product Support Resource data and product technology service data, by sorted data stored in the respective table created in described establishment tables of data unit; And
Data in each table, for setting up main external key in the table of described establishment tables of data unit establishment, are carried out data correlation by data associating unit.
Further, said apparatus also can comprise: described establishment tables of data unit creates the product interleaving function needing quality monitoring to equip in a database and requires table, using and satisfied requires table, product RAM characteristic and FMECA, RCMA analytical data, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data, unit under test requires and tables of data is described, capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data, testability design analysis table and technical service tables of data, refer to:
Described establishment tables of data unit is based on GJB3837, GJB1371, GJB3872, GJB3206A, GJBZ1391-2006, GJB1378A-2007, MIL-STD-1388-2B, GEIA-STD-0007, ATAMSG-3, DefStan00-60, S4000M and S3000L standard-required, the product interleaving function setting up equipment requires table, using and satisfied requires table, product RAM characteristic and FMECA, RCMA analytical data, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data and unit under test require and tables of data are described, above-mentioned each table is used for storing about equipment Reliability, maintainability, the data of the design analysis result of testability and protection,
Described establishment tables of data unit is based on GJBZ57, GJB900-90, GJB2547-1995, GJB450A-2004 and GJBZ299C-2006 standard-required, set up the capability of maintenance design analytical data of equipment, reliability design analysis tables of data, safety Design analytical data and testability design analysis table, above-mentioned each table analyzes the data of each link for the guarantee characteristics design stored about equipment Reliability, maintainability, testability and security;
Described establishment tables of data unit sets up the technical service tables of data of equipment based on GJB841-90 standard-required, and this table is for storing equipment use technology data.
Further, said apparatus also can comprise: described data importing unit imports the described product parameters data of database, comprises product structure data, product essential information data, product-specific documentation data and product technology status data;
Described data importing unit imports the described product reliability data of database, comprises Reliability Distribution data, reliability prediction data, Reliability modeling data, Fault Tree Analysis data, reliability block diagram RBD data, Failure Mode Effective Analysis FMEA data, lifetime data and event thing and analyzes ETA data;
Described data importing unit imports the described Product maintenance data of database, comprises maintainability conflict data, maintainability prediction data, maintainability modeling data and maintainability FMEA data;
Described data importing unit imports the described product test data of database, comprises testability allocation data, testability prediction data, testability modeling data, testability FMEA data and testability design analysis data;
Described data importing unit imports the described Product Safety data of database, comprises fault hazard analysis data, region security analyzes data, dangerous matter sources identification and control data and security FMEA data;
Described data importing unit imports the described product protection data of database, comprises use and maintenance requirement data, protection FMECA data, RCMA data and use and maintenance task and analyzes O & MTA data;
Described data importing unit imports the described product Support Resource data of database, comprises manpower demographic data, guarantee and testing apparatus data, technical information data, packaging accumulating data, spare part and consumables data, facility data, training and training support resource data and computing machine Support Resource data;
Described data importing unit imports the described product technology service data of database, comprises usage data, fault data, test data, mantenance data, interchange data, technical bulletin data and fault closed-loop process data.
Further, said apparatus also can comprise: described data associating unit sets up main external key in above-mentioned table, data in each table is carried out data correlation, refers to:
Described data associating unit requires based on table by product interleaving function, using the object that product structure is analyzed as the guarantee characteristics design of reliability maintainability and supportability, testability and security, the equipment data of all importings are associated with product interleaving function requirement table;
With using and satisfied, described data associating unit requires that table and product RAM characteristic and FMECA, RCMA analytical data are for input, by using and satisfied job analysis tables of data, use technology operational data is associated with required product Support Resource data;
Described data associating unit is based on using and satisfied requirement table and product RAM characteristic and FMECA, RCMA analytical data, by data in capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data and testability design analysis table, require to associate with the dependability parameter equipped and fault mode related data by using and satisfied;
Data in technical service tables of data, by fault mode related data, associate with data in using and satisfied requirement table, product RAM characteristic and FMECA, RCMA analytical data and using and satisfied job analysis tables of data by described data associating unit.
Compared with prior art, application the present invention, provide the data model of the data such as the integration reliability maintainability and supportability of monitoring weaponry, testability and security, efficiently solve the unified storage of each quality monitoring characteristic expert data and the problem of data correlation, achieve the support completely to quality monitoring performance data design analysis work such as reliability maintainability and supportability, testability and securities.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of the control method that the data model of equipment quality characteristic of the present invention builds.
Fig. 2 is the structural representation of the control device that the data model of equipment quality characteristic of the present invention builds.
Fig. 3 is reliability in example of the present invention, maintainability, testability, security and protection result data graph of a relation.
Fig. 4 is reliability in example of the present invention, maintainability, testability and security four property data relationship model figure.
Embodiment
Below in conjunction with the drawings and specific embodiments, the invention will be further described.
As shown in Figure 1, the control method of the data model structure of a kind of equipment quality characteristic of the present invention, comprising:
Step 110, system initialization, connection data storehouse;
Step 120, create the product interleaving function needing quality monitoring to equip in a database and require table, using and satisfied requires table, product reliability, availability and maintainability RAM characteristic and failure modes effects and criticality analysis FMECA, maintenance analysis RCMA analytical data centered by reliability, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data, unit under test requires and tables of data is described, capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data, testability design analysis table and technical service tables of data,
Wherein, wherein, characteristic specialty characteristics is ensured based on reliability maintainability and supportability, testability and security etc., and the specification and requirement of reference GJB and the international standard such as American army mark, Europe superscript, set up the data model supporting above quality monitoring characteristic Specialty Design analytical work, specifically comprise the following steps:
Based on GJB3837, GJB1371, GJB3872, GJB3206A, GJBZ1391-2006, GJB1378A-2007, MIL-STD-1388-2B, GEIA-STD-0007, ATAMSG-3, DefStan00-60, S4000M and S3000L standard-required, the product interleaving function setting up equipment requires table, using and satisfied requires table, product RAM characteristic and FMECA, RCMA analytical data, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data and unit under test require and tables of data are described, above-mentioned each table is used for storing about equipment Reliability, maintainability, the data of the design analysis result of testability and protection,
Based on GJBZ57, GJB900-90, GJB2547-1995, GJB450A-2004 and GJBZ299C-2006 standard-required, set up the capability of maintenance design analytical data of equipment, reliability design analysis tables of data, safety Design analytical data and testability design analysis table, above-mentioned each table analyzes the data of each link for the guarantee characteristics design stored about equipment Reliability, maintainability, testability and security;
Set up the technical service tables of data of equipment based on GJB841-90 standard-required, this table is for storing equipment use technology data.
Step 130, to database import equipment data, Data classification is carried out to the data imported, comprise product parameters data, product reliability data, Product maintenance data, product test data, Product Safety data, product protection data, product Support Resource data and product technology service data, by sorted data stored in the respective table after establishment in this database, main external key is set up in above-mentioned table, data in each table are carried out data correlation, completes the structure of the data model of equipment quality characteristic.
Wherein, described product parameters data comprise product structure data, product essential information data, product-specific documentation data and product technology status data;
Described product reliability data comprise Reliability Distribution data, reliability prediction data, Reliability modeling data, Fault Tree Analysis data, reliability block diagram RBD data, Failure Mode Effective Analysis FMEA data, lifetime data and event thing and analyze ETA data;
Described Product maintenance data comprise maintainability conflict data, maintainability prediction data, maintainability modeling data and maintainability FMEA data;
Described product test data comprise testability allocation data, testability prediction data, testability modeling data, testability FMEA data and testability design analysis data;
Described Product Safety data comprise fault hazard analysis data, region security analyzes data, dangerous matter sources identification and control data and security FMEA data;
Described product protection data comprise use and maintenance requirement data, protection FMECA data, RCMA data and use and maintenance task and analyze O & MTA data;
Described product Support Resource data comprise manpower demographic data, guarantee and testing apparatus data, technical information data, packaging accumulating data, spare part and consumables data, facility data, training and training support resource data and computing machine Support Resource data;
Described product technology service data comprises usage data, fault data, test data, mantenance data, interchange data, technical bulletin data and fault closed-loop process data.
Wherein, for reciprocal influence between the data in each quality monitoring characteristic professional tool, set up the association between each quality monitoring characteristic expert data, carry out data correlation by data in each table, specifically comprise the following steps:
Require based on table by product interleaving function, using the object that product structure is analyzed as the guarantee characteristics design of reliability maintainability and supportability, testability and security, the equipment data of all importings are associated with product interleaving function requirement table;
Require that table and product RAM characteristic and FMECA, RCMA analytical data are for input, by using and satisfied job analysis tables of data, associate use technology operational data with required product Support Resource data with using and satisfied;
Based on using and satisfied requirement table and product RAM characteristic and FMECA, RCMA analytical data, by data in capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data and testability design analysis table, require to associate with the dependability parameter equipped and fault mode related data by using and satisfied;
By fault mode related data, data in technical service tables of data are associated with data in using and satisfied requirement table, product RAM characteristic and FMECA, RCMA analytical data and using and satisfied job analysis tables of data.
Further data model of the present invention considers the requirement of current all relevant criterion, also can support that user carries out cutting, customization or expansion according to installation feature and business characteristic.
Equipment data of the present invention are mainly derived from following standard:
The analytic record of GJB3837-1999 Equipment Indemnificatory;
GJB1371-1992 Equipment Indemnificatory is analyzed;
GJB3872-1999 Integrated Equipment Support General Requirement;
GJBZ57 maintainability conflict and expectation handbook;
The general outline of GJB900-90 security of system;
GJB2547-1995 equipment Test outline;
GJB450A-2004 equipment Reliability General Requirement;
GJBZ299C-2006 reliability of electronic equipment estimates handbook;
GJBZ1391-2006 fault mode, impact and HAZAN guide;
The maintenance analysis of GJB1378A-2007 equipment centered by reliability;
GJB3206A-2010 total quality management;
GJB841-90 FRACAS;
GEIA-STD-0007LogisticsProductData;
MIL-STD-1388-1ALogisticSupportAnalysis;
MIL-STD-1388-2BDODREQUIREMENTSFORALOGISTICSUPPORTANALYSISRECORD;
ATAMSG-3Operator/ManufacturerScheduledMaintenanceDevelopment;
S3000LInternationalprocedurespecificationforLogisticsSupportAnalysis(LSA);
S4000MInternationalprocedurehandbookfordevelopingscheduledmaintenanceprograms;
DefStan00-60IntegratedLogisticSupportLogisticSupportAnalysis(LSA)AndLogisticSupportAnalysisRecord(LSAR)。
As shown in Figure 2, the control device of the data model structure of equipment quality characteristic of the present invention, comprising: initialization unit, establishment tables of data unit, data importing unit and data associating unit, wherein
Initialization unit, for system initialization, connection data storehouse;
Create tables of data unit, table is required for creating the product interleaving function needing quality monitoring to equip in a database, using and satisfied requires table, product reliability, availability and maintainability RAM characteristic and failure modes effects and criticality analysis FMECA, maintenance analysis RCMA analytical data centered by reliability, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data, unit under test requires and tables of data is described, capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data, testability design analysis table and technical service tables of data,
Data importing unit, for importing equipment data to database, Data classification is carried out to the data imported, comprise product parameters data, product reliability data, Product maintenance data, product test data, Product Safety data, product protection data, product Support Resource data and product technology service data, by sorted data stored in the respective table created in described establishment tables of data unit;
Data in each table, for setting up main external key in the table of described establishment tables of data unit establishment, are carried out data correlation by data associating unit.
Described establishment tables of data unit creates the product interleaving function needing quality monitoring to equip in a database and requires table, using and satisfied requires table, product reliability, availability and maintainability RAM characteristic and failure modes effects and criticality analysis FMECA, maintenance analysis RCMA analytical data centered by reliability, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data, unit under test requires and tables of data is described, capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data, testability design analysis table and technical service tables of data, refer to:
Described establishment tables of data unit is based on GJB3837, GJB1371, GJB3872, GJB3206A, GJBZ1391-2006, GJB1378A-2007, MIL-STD-1388-2B, GEIA-STD-0007, ATAMSG-3, DefStan00-60, S4000M and S3000L standard-required, the product interleaving function setting up equipment requires table, using and satisfied requires table, product RAM characteristic and FMECA, RCMA analytical data, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data and unit under test require and tables of data are described, above-mentioned each table is used for storing about equipment Reliability, maintainability, the data of the design analysis result of testability and protection,
Described establishment tables of data unit is based on GJBZ57, GJB900-90, GJB2547-1995, GJB450A-2004 and GJBZ299C-2006 standard-required, set up the capability of maintenance design analytical data of equipment, reliability design analysis tables of data, safety Design analytical data and testability design analysis table, above-mentioned each table analyzes the data of each link for the guarantee characteristics design stored about equipment Reliability, maintainability, testability and security;
Described establishment tables of data unit sets up the technical service tables of data of equipment based on GJB841-90 standard-required, and this table is for storing equipment use technology data.
Described data importing unit imports the described product parameters data of database, comprises product structure data, product essential information data, product-specific documentation data and product technology status data;
Described data importing unit imports the described product reliability data of database, comprises Reliability Distribution data, reliability prediction data, Reliability modeling data, Fault Tree Analysis data, reliability block diagram RBD data, Failure Mode Effective Analysis FMEA data, lifetime data and event thing and analyzes ETA data;
Described data importing unit imports the described Product maintenance data of database, comprises maintainability conflict data, maintainability prediction data, maintainability modeling data and maintainability FMEA data;
Described data importing unit imports the described product test data of database, comprises testability allocation data, testability prediction data, testability modeling data, testability FMEA data and testability design analysis data;
Described data importing unit imports the described Product Safety data of database, comprises fault hazard analysis data, region security analyzes data, dangerous matter sources identification and control data and security FMEA data;
Described data importing unit imports the described product protection data of database, comprises use and maintenance requirement data, protection FMECA data, RCMA data and use and maintenance task and analyzes O & MTA data;
Described data importing unit imports the described product Support Resource data of database, comprises manpower demographic data, guarantee and testing apparatus data, technical information data, packaging accumulating data, spare part and consumables data, facility data, training and training support resource data and computing machine Support Resource data;
Described data importing unit imports the described product technology service data of database, comprises usage data, fault data, test data, mantenance data, interchange data, technical bulletin data and fault closed-loop process data.
Described data associating unit sets up main external key in above-mentioned table, data in each table is carried out data correlation, refers to:
Described data associating unit requires based on table by product interleaving function, using the object that product structure is analyzed as the guarantee characteristics design of reliability maintainability and supportability, testability and security, the equipment data of all importings are associated with product interleaving function requirement table;
With using and satisfied, described data associating unit requires that table and product RAM characteristic and FMECA, RCMA analytical data are for input, by using and satisfied job analysis tables of data, use technology operational data is associated with required product Support Resource data;
Described data associating unit is based on using and satisfied requirement table and product RAM characteristic and FMECA, RCMA analytical data, by data in capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data and testability design analysis table, require to associate with the dependability parameter equipped and fault mode related data by using and satisfied;
Data in technical service tables of data, by fault mode related data, associate with data in using and satisfied requirement table, product RAM characteristic and FMECA, RCMA analytical data and using and satisfied job analysis tables of data by described data associating unit.
Method of the present invention specifically comprises following content:
1, ensure characteristic specialty characteristics based on reliability maintainability and supportability, testability and security etc., and the specification and requirement of reference GJB and the international standard such as American army mark, Europe superscript, set up and support the above data model ensureing characteristic Specialty Design analytical work:
Based on GJB3837, GJB1371, GJB3872, GJB3206A, GJBZ1391-2006, GJB1378A-2007, MIL-STD-1388-2B, GEIA-STD-0007, ATAMSG-3, DefStan00-60, S4000M and S3000L requirement, establish X class table (requirement of product interleaving function), category-A table (using and satisfied requirement), category-B table (product RAM characteristic and FMECA, RCMA analytical data), C class table (using and satisfied job analysis tables of data), E class table (support equipment requirement tables of data), F class table (facility data table), G class table (personnel's technical ability considers tables of data), H class table (packaging and supply require tables of data), J class table (transportability engineering tables of data), U class table (unit under test requires and tables of data is described), for memory reliability, maintainability, the design analysis result of testability and protection,
Based on GJBZ57, GJB900-90, GJB2547-1995, GJB450A-2004, GJBZ299C-2006 establishes RM class table (capability of maintenance design analysis data), RR class table (reliability design analysis data), RS class table (safety Design analysis data), for memory reliability, maintainability, testability and security etc., RTE class table (testability design analysis), ensures that characteristics design analyzes the data of each link;
Set up RTS class table (technical service data) based on GJB841-90, support weaponry under arms after the collection of use technology data.
2, for reciprocal influence between the data in each guarantee characteristic professional tool, set up the association between each guarantee characteristic expert data:
Based on X class table, product structure is ensured as reliability maintainability and supportability, testability and security etc. and associates the object that characteristics design is analyzed all business datums with X class table;
With category-A table and category-B table for input, by C class table, the use technology work of weaponry is associated with required Support Resource;
Based on category-A table and category-B table, by RM, RR, RS, RTE etc. four the data of property require to associate with the dependability parameter equipped and failure mode information by using and satisfied;
By fault mode data, RTS class table data are associated with category-A table, category-B table and C class table data.
Below in conjunction with Fig. 3 and Fig. 4, according to wherein data model figure and the example of tables of data to four property and comprehensive coverage data model are described further.
Step 1, first installation data library software, recommendation ORACLE10g database;
Step 2, create above-mentioned X class table (requirement of product interleaving function) in a database, category-A table (using and satisfied requirement), category-B table (product RAM characteristic and FMECA, RCMA analytical data), E class table (support equipment requirement tables of data), F class table (facility data table), G class table (personnel's technical ability considers tables of data), H class table (packaging and supply require tables of data), J class table (transportability engineering tables of data), U class table (unit under test requires and tables of data is described), RM class table (capability of maintenance design analysis data), RR class table (reliability design analysis data), RS class table (safety Design analysis data), RTE class table (testability design analysis), RTS class table (technical service data)
Step 3, is increased to all fields in above-mentioned each tables of data;
Step 4, specifies each main foreign key field, sets up data correlation in each tables of data.
The above; be only the present invention's preferably embodiment, but protection scope of the present invention is not limited thereto, any people being familiar with this technology is in the technical scope disclosed by the present invention; the change that can expect easily or replacement, all should be encompassed within protection scope of the present invention.Therefore, protection scope of the present invention should be as the criterion with the protection domain of claim.
Claims (4)
1. a control method for the data model structure of equipment quality characteristic, is characterized in that, comprising:
System initialization, connection data storehouse;
Create the product interleaving function needing quality monitoring to equip in a database and require table, using and satisfied requires table, product RAM characteristic and FMECA, RCMA analytical data, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data, unit under test requires and tables of data is described, capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data, testability design analysis table and technical service tables of data,
Equipment data are imported to database, Data classification is carried out to the data imported, comprise product parameters data, product reliability data, Product maintenance data, product test data, Product Safety data, product protection data, product Support Resource data and product technology service data, by sorted data stored in the respective table after establishment in this database, main external key is set up in above-mentioned table, data in each table are carried out data correlation, completes the structure of the data model of equipment quality characteristic;
Described product parameters data comprise product structure data, product essential information data, product-specific documentation data and product technology status data;
Described product reliability data comprise Reliability Distribution data, reliability prediction data, Reliability modeling data, Fault Tree Analysis data, reliability block diagram RBD data, Failure Mode Effective Analysis FMEA data, lifetime data and ETA ETA data;
Described Product maintenance data comprise maintainability conflict data, maintainability prediction data, maintainability modeling data and maintainability FMEA data;
Described product test data comprise testability allocation data, testability prediction data, testability modeling data, testability FMEA data and testability design analysis data;
Described Product Safety data comprise fault hazard analysis data, region security analyzes data, dangerous matter sources identification and control data and security FMEA data;
Described product protection data comprise use and maintenance requirement data, protection FMECA data, RCMA data and use and maintenance task and analyze O & MTA data;
Described product Support Resource data comprise manpower demographic data, guarantee and testing apparatus data, technical information data, packaging accumulating data, spare part and consumables data, facility data, training and training support resource data and computing machine Support Resource data;
Described product technology service data comprises usage data, fault data, test data, mantenance data, interchange data, technical bulletin data and fault closed-loop process data;
Describedly in above-mentioned table, set up main external key, data in each table carried out the step of data correlation, comprising:
Require based on table by product interleaving function, using the object that product structure is analyzed as the guarantee characteristics design of reliability maintainability and supportability, testability and security, the equipment data of all importings are associated with product interleaving function requirement table;
Require that table and product RAM characteristic and FMECA, RCMA analytical data are for input, by using and satisfied job analysis tables of data, associate use technology operational data with required product Support Resource data with using and satisfied;
Based on using and satisfied requirement table and product RAM characteristic and FMECA, RCMA analytical data, by data in capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data and testability design analysis table, require to associate with the dependability parameter equipped and fault mode related data by using and satisfied;
By fault mode related data, data in technical service tables of data are associated with data in using and satisfied requirement table, product RAM characteristic and FMECA, RCMA analytical data and using and satisfied job analysis tables of data.
2. the method for claim 1, is characterized in that,
The described in a database product interleaving function that establishment needs quality monitoring to equip requires table, using and satisfied requires table, product RAM characteristic and FMECA, RCMA analytical data, support equipment requires that tables of data, facility data table, personnel's technical ability are considered tables of data, packaging and supply to require that tables of data, transportability engineering tables of data, unit under test require, with the step that tables of data, capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data, testability design analysis table and technical service tables of data are described, to comprise:
Based on GJB3837, GJB1371, GJB3872, GJB3206A, GJBZ1391-2006, GJB1378A-2007, MIL-STD-1388-2B, GEIA-STD-0007, ATAMSG-3, DefStan00-60, S4000M and S3000L standard, the product interleaving function setting up equipment requires table, using and satisfied requires table, product RAM characteristic and FMECA, RCMA analytical data, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data and unit under test require and tables of data are described, above-mentioned each table is for storing equipment Reliability, maintainability, the data of the design analysis result of testability and protection,
Based on GJBZ57, GJB900-90, GJB2547-1995, GJB450A-2004 and GJBZ299C-2006 standard-required, set up the capability of maintenance design analytical data of equipment, reliability design analysis tables of data, safety Design analytical data and testability design analysis table, above-mentioned each table analyzes the data of each link for the guarantee characteristics design stored about equipment Reliability, maintainability, testability and security;
Set up the technical service tables of data of equipment based on GJB841-90 standard-required, this table is for storing equipment use technology data.
3. a control device for the data model structure of equipment quality characteristic, is characterized in that, comprising:
Initialization unit, for system initialization, connection data storehouse;
Establishment tables of data unit, for creating in a database, the product interleaving function needing quality monitoring to equip requires table, using and satisfied requires table, product RAM characteristic and FMECA, RCMA analytical data, support equipment requires tables of data, facility data table, personnel's technical ability to consider tables of data, pack and supply requires tables of data, transportability engineering tables of data, unit under test to require and tables of data, capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data, testability design analysis table and technical service tables of data are described;
Data importing unit, for importing equipment data to database, Data classification is carried out to the data imported, comprise product parameters data, product reliability data, Product maintenance data, product test data, Product Safety data, product protection data, product Support Resource data and product technology service data, by sorted data stored in the respective table created in described establishment tables of data unit;
Described data importing unit imports the described product parameters data of database, comprises product structure data, product essential information data, product-specific documentation data and product technology status data;
Described data importing unit imports the described product reliability data of database, comprises Reliability Distribution data, reliability prediction data, Reliability modeling data, Fault Tree Analysis data, reliability block diagram RBD data, Failure Mode Effective Analysis FMEA data, lifetime data and event thing and analyzes ETA data;
Described data importing unit imports the described Product maintenance data of database, comprises maintainability conflict data, maintainability prediction data, maintainability modeling data and maintainability FMEA data;
Described data importing unit imports the described product test data of database, comprises testability allocation data, testability prediction data, testability modeling data, testability FMEA data and testability design analysis data;
Described data importing unit imports the described Product Safety data of database, comprises fault hazard analysis data, region security analyzes data, dangerous matter sources identification and control data and security FMEA data;
Described data importing unit imports the described product protection data of database, comprises use and maintenance requirement data, protection FMECA data, RCMA data and use and maintenance task and analyzes O & MTA data;
Described data importing unit imports the described product Support Resource data of database, comprises manpower demographic data, guarantee and testing apparatus data, technical information data, packaging accumulating data, spare part and consumables data, facility data, training and training support resource data and computing machine Support Resource data;
Described data importing unit imports the described product technology service data of database, comprise usage data, fault data, test data, mantenance data, interchange data, technical bulletin data and fault closed-loop process data and
Data in each table, for setting up main external key in the table of described establishment tables of data unit establishment, are carried out data correlation by data associating unit;
Described data associating unit requires based on table by product interleaving function, using the object that product structure is analyzed as the guarantee characteristics design of reliability maintainability and supportability, testability and security, the equipment data of all importings are associated with product interleaving function requirement table;
With using and satisfied, described data associating unit requires that table and product RAM characteristic and FMECA, RCMA analytical data are for input, by using and satisfied job analysis tables of data, use technology operational data is associated with required product Support Resource data;
Described data associating unit is based on using and satisfied requirement table and product RAM characteristic and FMECA, RCMA analytical data, by data in capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data and testability design analysis table, require to associate with the dependability parameter equipped and fault mode related data by using and satisfied;
Data in technical service tables of data, by fault mode related data, associate with data in using and satisfied requirement table, product RAM characteristic and FMECA, RCMA analytical data and using and satisfied job analysis tables of data by described data associating unit.
4. device as claimed in claim 3, is characterized in that,
Described establishment tables of data unit creates that the product interleaving function needing quality monitoring to equip requires table, using and satisfied requires table in a database, product RAM characteristic and FMECA, RCMA analytical data, support equipment require tables of data, facility data table, personnel's technical ability to consider tables of data, packaging and supply require tables of data, transportability engineering tables of data, unit under test to require and tables of data, capability of maintenance design analytical data, reliability design analysis tables of data, safety Design analytical data, testability design analysis table and technical service tables of data are described, refer to:
Described establishment tables of data unit is based on GJB3837, GJB1371, GJB3872, GJB3206A, GJBZ1391-2006, GJB1378A-2007, MIL-STD-1388-2B, GEIA-STD-0007, ATAMSG-3, DefStan00-60, S4000M and S3000L standard-required, the product interleaving function setting up equipment requires table, using and satisfied requires table, product RAM characteristic and FMECA, RCMA analytical data, support equipment requires tables of data, facility data table, personnel's technical ability considers tables of data, packaging and supply require tables of data, transportability engineering tables of data and unit under test require and tables of data are described, above-mentioned each table is used for storing about equipment Reliability, maintainability, the data of the design analysis result of testability and protection,
Described establishment tables of data unit is based on GJBZ57, GJB900-90, GJB2547-1995, GJB450A-2004 and GJBZ299C-2006 standard-required, set up the capability of maintenance design analytical data of equipment, reliability design analysis tables of data, safety Design analytical data and testability design analysis table, above-mentioned each table analyzes the data of each link for the guarantee characteristics design stored about equipment Reliability, maintainability, testability and security;
Described establishment tables of data unit sets up the technical service tables of data of equipment based on GJB841-90 standard-required, and this table is for storing equipment use technology data.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201110441436.0A CN102521711B (en) | 2011-12-26 | 2011-12-26 | The control method of the data model structure of equipment quality characteristic and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201110441436.0A CN102521711B (en) | 2011-12-26 | 2011-12-26 | The control method of the data model structure of equipment quality characteristic and device |
Publications (2)
Publication Number | Publication Date |
---|---|
CN102521711A CN102521711A (en) | 2012-06-27 |
CN102521711B true CN102521711B (en) | 2016-03-02 |
Family
ID=46292622
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201110441436.0A Active CN102521711B (en) | 2011-12-26 | 2011-12-26 | The control method of the data model structure of equipment quality characteristic and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102521711B (en) |
Families Citing this family (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US10922637B2 (en) | 2013-01-18 | 2021-02-16 | Packsize Llc | Tiling production of packaging materials |
CN112668203A (en) | 2013-01-18 | 2021-04-16 | 派克赛泽有限责任公司 | Splicing production of packaging materials |
CN103676854B (en) * | 2013-12-02 | 2016-03-23 | 北京航空航天大学 | Consider the avionics system mission reliability distribution method of onboard networks feature |
CN106294864A (en) * | 2016-08-23 | 2017-01-04 | 北京电子工程总体研究所 | A kind of data base for air missile weapon system hazard analysis |
CN108171346B (en) * | 2018-01-25 | 2022-03-29 | 中广核核电运营有限公司 | Method and device for processing instrument control maintenance data of nuclear power plant and computer equipment |
CN113642891B (en) * | 2021-08-16 | 2024-07-02 | 北京航空航天大学 | Maintenance efficiency-oriented RMT index comprehensive distribution method |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101211360A (en) * | 2006-12-28 | 2008-07-02 | 鸿富锦精密工业(深圳)有限公司 | System and method for processing a plurality of data form of report forms data source |
CN101655849A (en) * | 2008-08-20 | 2010-02-24 | 中兴通讯股份有限公司 | Method for defining and storing code information service data of electronic products |
CN102081661A (en) * | 2011-01-19 | 2011-06-01 | 吉林大学 | Data integration method and system of heterogeneous relational database based on XML (Extensive Makeup Language) |
-
2011
- 2011-12-26 CN CN201110441436.0A patent/CN102521711B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101211360A (en) * | 2006-12-28 | 2008-07-02 | 鸿富锦精密工业(深圳)有限公司 | System and method for processing a plurality of data form of report forms data source |
CN101655849A (en) * | 2008-08-20 | 2010-02-24 | 中兴通讯股份有限公司 | Method for defining and storing code information service data of electronic products |
CN102081661A (en) * | 2011-01-19 | 2011-06-01 | 吉林大学 | Data integration method and system of heterogeneous relational database based on XML (Extensive Makeup Language) |
Also Published As
Publication number | Publication date |
---|---|
CN102521711A (en) | 2012-06-27 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102521711B (en) | The control method of the data model structure of equipment quality characteristic and device | |
CN107248021B (en) | MES system is made to platform-based intelligence | |
KR101057614B1 (en) | Resources configuration automation system of moving production facilities and method thereof | |
CN103699693A (en) | Metadata-based data quality management method and system | |
CN106325883A (en) | Development method and system for industry business area information system | |
KR101171274B1 (en) | System and method with erp system to manage planet risk during outage | |
CN103345442A (en) | Equipment automated testing service integration system | |
Larreina et al. | Smart manufacturing execution system (SMES): The possibilities of evaluating the sustainability of a production process | |
CN107256457A (en) | A kind of automatic calibration of electric energy meter workshop intelligent inspection system | |
CN106502219A (en) | A kind of bearing Internet of Things intelligence fabrication line process control system | |
CN108280532A (en) | A kind of improved power equipment asset management system and method | |
CN104881730A (en) | Boiler virtual prototype collaborative design system and method based on workflow | |
CN111932129A (en) | Equipment digital maintenance management and control system | |
CN107944999A (en) | A kind of automatic execution method and device of audit expenses project | |
CN105260297A (en) | Test data management system and method | |
CN104967532A (en) | TOC technology operation and maintenance system and application method | |
CN111898808B (en) | Nuclear power plant in-service inspection data management and analysis method | |
CN102799526A (en) | Distributed intelligent scheduling method | |
CN107423035B (en) | Product data management system in software development process | |
CN109268248A (en) | Portable air compressor test device and method | |
CN102707943A (en) | Implementation method of remote control automation tool | |
Luo et al. | Research on integration method of integrated management system | |
CN110738427A (en) | electric power part work quality scoring system | |
CN103684814A (en) | Method and device for comparing data of communication system | |
CN112446619B (en) | Power distribution network rush-repair processing method and device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant |