CN109522453B - Standard standard digital processing method for equipment technical index - Google Patents
Standard standard digital processing method for equipment technical index Download PDFInfo
- Publication number
- CN109522453B CN109522453B CN201811231228.6A CN201811231228A CN109522453B CN 109522453 B CN109522453 B CN 109522453B CN 201811231228 A CN201811231228 A CN 201811231228A CN 109522453 B CN109522453 B CN 109522453B
- Authority
- CN
- China
- Prior art keywords
- index
- standard
- technical
- xml
- data model
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application provides a standard specification digital processing method for equipment technical indexes, which comprises the following steps: step 1, constructing a data model, namely establishing a general technical index data model of equipment by using an XML editing tool; step 2, index data extraction, namely, an XML document is created for each standard specification file to form an instantiated XML document; step 3, XML document verification, namely, automatically verifying the instantiated XML document based on the rule defined by the data model; and 4, mapping and warehousing the data, namely creating a technical index database, and importing the XML documents verified in the step 3 into the technical index database in batches according to corresponding mapping rules. By adopting the XML document, the index data can ensure the data quality, the index data extraction efficiency is improved, and the interoperability of the standard specification is improved.
Description
Technical Field
The invention belongs to the technical field of standardization and information, and particularly relates to a standard specification digital processing method for equipment technical indexes.
Background
The standard is a normative document, agreed upon and approved by a recognized agency, commonly used and reused for the best sequence within a certain range.
For the standard specification in the traditional form, the technical index information can only exist in a text form, cannot be used as a structured technical requirement to be directly used by equipment requirement modeling personnel, cannot be embedded into an equipment digital environment as modeled engineering data, and cannot be used as a parameterized index value to support equipment model selection optimization design.
Therefore, a digital processing method for standard specification is needed to improve the form of standard specification, so that the standard specification can be matched with the existing computer technology, the interoperability of the standard specification is improved, the application mode of the standard specification is changed, and the use efficiency and the effect of the standard specification are improved.
Disclosure of Invention
The invention provides a product technical index-oriented standard specification digital processing method aiming at the use limitation of text standards. The method can extract technical indexes of product functions, performances, interfaces, tests, packages, transports and the like in standard specifications one by one and one by one to form relatively minimized data entries and form a structured, parameterized and modeled database.
The invention is realized by the following steps:
a standard specification digital processing method oriented to product technical indexes comprises the following steps:
step 3, XML document verification: automatically checking the instantiated XML document based on the rule defined by the data model, if the verification fails, revising the instantiated XML document according to the rule of the data model until the document verification is completed to form a final XML document corresponding to the standard specification; after the XML documents of all the standard specification files are verified, the step 4 is entered;
and 4, mapping and warehousing data: and (3) creating a technical index database according to the rules of the relational database, and importing all the final XML documents in the step (3) into the relational data in batches according to the corresponding mapping rules to form the structured, parameterized and schematized technical index database.
Preferably, the general technical index data model specifically comprises standard information and product information, wherein the standard information comprises a standard number and a standard name, the product information comprises a product name, a product to which the product belongs and a technical index, and the technical index further comprises an index name, an index to which the product belongs, an index chapter number, an index technical requirement, an index numerical value, an index metering unit, a test method chapter number, an identification test method, a quality consistency test method, a first-part inspection method and an experience training.
Preferably, the automatic verification in step 3 includes: the structure of elements and attributes, the order of elements, data values of elements and attributes are matched according to range, enumeration, or style, and uniqueness of values in instances.
Preferably, the technical index database at least comprises the following fields of index ID, index name, standard number, standard name, product name, superior index name, index chapter number, index requirement, index value, chart contained in the index requirement, test method chapter number, test method, chart contained in the test method and experience teaching.
Preferably, in step 4, each final XML document is mapped to the technical index database as a plurality of index records, and each index record is identified by a unique ID.
The application has the advantages that:
1. the standard standardization and datamation process is simpler, and the standardized and datamation structure is unified and convenient to use;
2. the XML document is adopted to input data, so that the input of repeated data items can be avoided, and the index data extraction efficiency is improved;
3. the XML SCHEMA is adopted to define a data model, so that index data can be effectively verified, and the data quality is ensured;
3. the XML document is adopted to store data, so that the traditional standard specification can be matched with the existing computer technology, and the interoperability of the standard specification is improved.
Drawings
FIG. 1 is a schematic diagram of creating a SCHEMA file;
FIG. 2 is a block diagram of a generic technical indicator data model;
FIG. 3 is a schematic diagram of a SCHEMA file of the general technical indicator data model;
FIG. 4 is a schematic diagram of creating an XML file;
FIG. 5 extracts and enters XML data items;
FIG. 6 a technical index database structure;
FIG. 7 is a schematic diagram of a technical index database file;
FIG. 8 is a flowchart of a standard specification digitization processing method for equipment specifications.
Detailed Description
The present application realizes standard specification digitization by establishing a standard specification data model, so that a computer can directly use the standard specification to perform various operations such as selection, construction, optimization and the like on a product, and the present invention is further described in detail with reference to fig. 8 and a specific implementation method.
A standard specification digital processing method facing equipment technical indexes specifically comprises the following steps:
Analyzing the product standard type and index composition characteristics commonly used by the product, and establishing a general technical index data model of the equipment by using an XML editing tool. The general technical index data model is used as a master file for index digital processing, defines information composition, attribute relation, necessity, constraint and value range of equipment technical indexes, and mainly comprises the following steps: the system comprises a standard number, a product name, a product to which the standard number belongs, an index name, an index to which the index belongs, an index chapter number, an index technical requirement, an index numerical value, an index metering unit, a test method chapter number, an identification test method, a quality consistency test method, a first article inspection method, experience teaching and training and the like.
As shown in fig. 1, a SCHEMA file is created by using a general XML editing tool (such as XMLSpy, xmlquiire, etc.), and a W3C XML SCHEMA is selected in fig. 1 to create the SCHEMA file, which may be named as "general technical indicator model. XSD", and the SCHEMA file is a specific implementation of the general technical indicator data model.
The general technical index data model in the SCHEMA file may specifically include standard information and product information, where the standard information includes a standard number and a standard name, the product information includes a product name, a product to which the standard information belongs and a technical index, and the technical index includes an index name, an index to which the standard information belongs, an index chapter number, an index technical requirement, an index value, an index measurement unit, a test method chapter number, an identification test method, a quality consistency test method, a first article inspection method, and an experience training. Fig. 2 is a block diagram of the universal specification data model, and those skilled in the art can set the elements in the universal specification data model according to actual needs.
The specific content in the SCHEMA file is determined according to the elements in the generic technical indicator data model, and the SCHEMA file functions to define a legal component group of an XML document, such as: elements that may appear in a document, attributes that may appear in a document, which elements are sub-elements, the order of sub-elements, the number of sub-elements, etc. Fig. 3 is a SCHEMA file created from the structure diagram of the generic technical indicator data model shown in fig. 2.
Creating a new XML document for each standard specification file based on the general technical index data model constructed in the step 1; extracting technical contents in aspects of product functions, performances, interfaces, tests, packaging, transportation and the like in the corresponding standard specification file one by one and one by one according to element composition defined by the universal technical index data model, and sequentially inputting the technical contents into the corresponding XML tags to form an instantiated XML document; a standard may contain a plurality of products, and a product may contain a plurality of index information.
Firstly, a general XML document is created based on the general technical index data model constructed in the step 1 by using a general XML editing tool. As shown in FIG. 4, in this embodiment, Altova XMLSpy is used to create an XML instantiated document based on the Universal technical indicator model XSD file.
And then, extracting the technical contents related to the indexes in the standard specification one by one and one by one, and respectively inputting the technical contents into the corresponding XML tags. As shown in fig. 5, taking the extraction of information in the standard "general specification for aircraft wheels and brake devices" as an example, the following information is extracted:
standard information:
standard number: GJB 1184A-2010
Standard name: general specification of aircraft wheel and brake device
Product information:
the product name is as follows: airplane wheel
The product is a lifting device
The technical indexes are as follows:
index name: air tightness of tubeless airplane wheel
The indexes are as follows: air tightness
The number of the index seal bar: 3.2.2.1
The technical requirements of the indexes are that the airplane wheel rolls for 40km under rated static load, and the pressure drop is not more than 0.03 MPa.
Index value: 0.03
The index measurement unit is as follows: mpa (Mpa)
Test methods chapter number: 4.5.2
The identification test method comprises the following steps: the wheel provided with the inner tube vertically rolls for 40km under rated load and inflation pressure, and the pressure drop meets the requirement of c) in 3.2.2.1. The rolling mileage of the experiment can be accumulated in the rolling experiment mileage.
Quality consistency test method: NULL
The first piece inspection method comprises the following steps: NULL
Experience training: NULL
Step 3, XML document verification
After the standard index data is extracted, automatically checking the instantiated XML document based on the rule defined by the data model so as to verify whether the XML document has effective data and good format. The SCHEMA data model may verify: structure of elements and attributes; the order of the elements; data values of elements and attributes, according to range, enumeration and style matching; uniqueness of values in the examples, etc. If the verification fails, the instantiated XML document needs to be re-modified according to the rules of the SCHEMA data model until the document verification is completed. In the embodiment, the instantiated XML document is automatically checked by using the rule defined by the XSD, so as to form a final XML document corresponding to the standard specification.
After the standard index data is extracted and the instantiated XML document is formed, the document can be verified by using the format checking function and the data verification function of the Altova XMLSpy tool. And after the verification is passed, a final XML document with good format and effective data is formed. The following is a validated XML document for "general aviation wheel and brake device specifications":
<?xml version="1.0"encoding="UTF-8"?>
< general technical indicator model xmlns: xsi ═ http:// www.w.3. org/2001/XMLSchema-instance "xsi: nonnaspasceSesamaLocation ═ general technical indicator model. XSD" >)
< Standard information >
< Standard No. > GJB 1184A-2010 </Standard No. >
< Standard name > general Specification for aircraft wheels and brake devices >
</Standard information >
< product information >
< product name > airplane wheel </product name >
< product > landing gear </product >)
< technical index >
Index name tubeless airplane wheel airtightness
< air tightness associated index >
< index chapter number >3.2.2.1 >
< technical requirement > the wheel rolls for 40km under rated static load, and the pressure drop is not more than 0.03MPa >
< index value >0.03 </index value >
< indicator measurement Unit > MPA >
< test methods section number >4.5.2 </test methods section number >
< identification test method > the wheel with tubeless tube vertically rolls for 40km under rated load and inflation pressure, and the pressure drop should meet the requirement of c) in 3.2.2.1. The rolling mileage of the test can be accumulated in the rolling test mileage. [ identification test method ]
< method for testing consistency of quality XXX </method for testing consistency of quality >
< first article inspection method XXX </first article inspection method >
< experience lesson > XXXXXXXXX </experience lesson >
[ technical index ]
< technical index >
< index name XXXX >
< indication of affiliation > XXXX </indication of affiliation >
< index chapter number > X.X.X.X </index chapter number >
< finger technical requirement > XXXX technical requirement >
< index value > XX </index value >
< index measurement Unit > XX >
< test method section number > X.X.X.X </test method section number >
< identification test method XXXXXXXXXXXXXXXXXX </identification test method >
< method for testing consistency of Mass XXXX >
< first article inspection method XXXX </first article inspection method >
< experience lesson > XXXXXXXXX </experience lesson >
[ technical index ]
[ product information ]
General technical indicator model
Step 4, data mapping and warehousing
And creating the technical index database according to the general design rule of the relational database. And then, importing the standard specification XML instantiation files verified in the step 3 into the relational data in batch according to the corresponding mapping rules to form a structured, parameterized and modeled technical index database.
A general relational database system, such as MYSQL, ORACLE, etc., may be utilized to create a relational database structure, which may include the following fields, as shown in table 1:
TABLE 1
Name of field | Data type | Length of | |
targetId | int | ||
11 | Index ID | ||
targetName | varchar | 64 | Index |
std_Number | varchar | ||
64 | Standard | ||
std_ChinName | varchar | ||
128 | Standard | ||
productName | varchar | ||
64 | Product | ||
parentProductName | varchar | ||
64 | Superior product | ||
parentTargetName | varchar | ||
64 | Superior index | ||
targetNumber | varchar | ||
32 | Number of the seal | ||
targetRequirement | varchar | 1024 | Index requirement (index clause) |
targetValue | varchar | 256 | Index |
targetImgUrl | varchar | ||
256 | Diagram included in index | ||
testModeNumber | varchar | ||
32 | Test method seal number | ||
testMode | varchar | 2048 | Test |
testModeImgUrl | varchar | ||
256 | Charts included in the test methods | ||
experince | text | 65535 | Experience teaching and training |
And 3, mapping and importing the XML instantiation files passing the verification in the step 3 into relational data in batches to form a structured, parameterized and modeled technical index database. Mapping an XML instantiation file to a database will become a plurality of pointer record data, and each pointer data is identified by a unique ID, as shown in table 2:
TABLE 2
Each record in the technical index database corresponds to an index technical requirement of a product in a standard, and by using the contents of the technical index database, various operations can be performed, such as quickly inquiring all index systems of a certain product, conveniently comparing and optimizing technical parameters of domestic and foreign standards, and directly reading the index technical requirements into an equipment digital application system, such as a DOORS system, and tracing the terms of which standard the requirements come from, so that the standards can be directly integrated into an equipment digital development system, thereby improving the use efficiency and the effect of the standards.
Finally, it should be noted that: the above-mentioned embodiments are only used for illustrating the technical solution of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (3)
1. A standard specification digital processing method facing equipment technical indexes is characterized in that: the method comprises the following steps:
step 1, data model construction: analyzing the product specification type and index composition characteristics commonly used by a product, creating an SCHEMA file by using an XML editing tool, selecting a W3C XML SCHEMA to create the file, naming the file as a 'general technical index model (XSD)', wherein the SCHEMA file is a specific implementation of a general technical index data model, and the general technical index data model defines the information composition, attribute relationship, necessity, constraint and value range of equipment technical indexes; the general technical index data model in the SCHEMA file specifically comprises standard information and product information, wherein the standard information comprises a standard number and a standard name, the product information comprises a product name, a product to which the standard information belongs and a technical index, and the technical index also comprises an index name, an index to which the standard information belongs, an index chapter number, an index technical requirement, an index numerical value, an index metering unit, a test method chapter number, an identification test method, a quality consistency test method, a first article inspection method and experience teaching;
the specific content in the SCHEMA file is determined according to elements in a general technical index data model, and the SCHEMA file is used for defining a legal component group of an XML document; one standard at least comprises one product, and one product comprises a plurality of pieces of index information;
step 2, index data extraction: creating a new XML document for each standard specification file based on the universal technical index data model, specifically using Altova XMLSpy, and creating an XML instantiation document according to the 'universal technical index model XSD' file; then extracting the technical content in the corresponding standard specification file according to the element composition defined by the general technical index data model, and sequentially inputting the technical content into the corresponding XML tags to form an instantiated XML document;
step 3, XML document verification: automatically checking the instantiated XML document based on rules defined by the data model, and the SCHEMA data model verification comprises the following steps: structure of elements and attributes; the order of the elements; data values of elements and attributes, according to range, enumeration and style matching, and uniqueness of values in instances; automatically checking the instantiated XML document by using a rule defined by a 'general technical index model and XSD', specifically, carrying out document verification by using a format checking function and a data verification function of an Altova XMLSpy tool, and if the verification fails, revising the instantiated XML document according to the rule of the SCHEMA data model until the document verification is completed to form a final XML document corresponding to a standard specification; after the XML documents of all the standard specification files are verified, the step 4 is entered;
and 4, mapping and warehousing data: and (3) creating a technical index database according to the rules of the relational database, and importing all the final XML documents in the step (3) into the relational data in batches according to the corresponding mapping rules to form the structured, parameterized and schematized technical index database.
2. The equipment technical indicator-oriented standard specification digitization processing method of claim 1, wherein:
the technical index database at least comprises the following fields of index ID, index name, standard number, standard name, product name, superior index name, index bar number, index requirement, index value, chart contained in the index requirement, test method bar number, test method, chart contained in the test method and experience teaching.
3. The equipment technical indicator-oriented standard specification digitization processing method of claim 1, wherein:
in the step 4, each final XML document is mapped to the technical index database to be a plurality of index records, and each index record is identified by a unique ID.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811231228.6A CN109522453B (en) | 2018-10-22 | 2018-10-22 | Standard standard digital processing method for equipment technical index |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811231228.6A CN109522453B (en) | 2018-10-22 | 2018-10-22 | Standard standard digital processing method for equipment technical index |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109522453A CN109522453A (en) | 2019-03-26 |
CN109522453B true CN109522453B (en) | 2020-10-16 |
Family
ID=65772322
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811231228.6A Active CN109522453B (en) | 2018-10-22 | 2018-10-22 | Standard standard digital processing method for equipment technical index |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109522453B (en) |
Families Citing this family (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110135705A (en) * | 2019-04-24 | 2019-08-16 | 徐昊 | Security management indicatorization executes system |
CN111367499A (en) * | 2019-12-10 | 2020-07-03 | 中国航空综合技术研究所 | Product demand definition and tracing method based on standard index library |
CN114338335A (en) * | 2021-12-15 | 2022-04-12 | 一汽资本控股有限公司 | Integrated monitoring system and method |
CN115619266A (en) * | 2022-10-12 | 2023-01-17 | 中国航空综合技术研究所 | Index acquisition method for aviation equipment research and development activities |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101794278A (en) * | 2009-09-21 | 2010-08-04 | 广东省标准化研究院 | Method and software for digitalizing full text of standard document |
CN107562934A (en) * | 2017-09-20 | 2018-01-09 | 四川大学 | Ecological engineering material digital development method |
CN108595594A (en) * | 2018-04-19 | 2018-09-28 | 中航建设集团有限公司 | A kind of assembled architecture data collaborative management method and system based on BIM |
Family Cites Families (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20090132496A1 (en) * | 2007-11-16 | 2009-05-21 | Chen-Kun Chen | System And Method For Technique Document Analysis, And Patent Analysis System |
CN105787808A (en) * | 2016-03-01 | 2016-07-20 | 中国电力科学研究院 | IEC61968 standard document generation system and method based on generic programming and reflection mechanism |
CN106202292B (en) * | 2016-06-30 | 2022-03-18 | 中国电力科学研究院 | Standard information analysis method based on structured data model |
CN106528684B (en) * | 2016-10-25 | 2020-11-10 | 北京瑞风协同科技股份有限公司 | Method and system for establishing engineering material database |
CN107943764A (en) * | 2017-12-05 | 2018-04-20 | 中国航空综合技术研究所 | Standard Structured based on XML writes generation method |
-
2018
- 2018-10-22 CN CN201811231228.6A patent/CN109522453B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101794278A (en) * | 2009-09-21 | 2010-08-04 | 广东省标准化研究院 | Method and software for digitalizing full text of standard document |
CN107562934A (en) * | 2017-09-20 | 2018-01-09 | 四川大学 | Ecological engineering material digital development method |
CN108595594A (en) * | 2018-04-19 | 2018-09-28 | 中航建设集团有限公司 | A kind of assembled architecture data collaborative management method and system based on BIM |
Also Published As
Publication number | Publication date |
---|---|
CN109522453A (en) | 2019-03-26 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109522453B (en) | Standard standard digital processing method for equipment technical index | |
US8019795B2 (en) | Data warehouse test automation framework | |
US8655918B2 (en) | System and method of transforming data for use in data analysis tools | |
US9098566B2 (en) | Method and system for presenting RDF data as a set of relational views | |
US8161070B2 (en) | Efficient delta handling in star and snowflake schemes | |
US20050183002A1 (en) | Data and metadata linking form mechanism and method | |
US20040167870A1 (en) | Systems and methods for providing a mixed data integration service | |
CN106021494A (en) | Master data synchronization method and device | |
CN105956410B (en) | A kind of Universal-purpose quick detection method of IEC61850 full models | |
CN106372044A (en) | Method for generating typed dimension XBRL (Extensible Business Reporting Language) report based on report form | |
CN105138588B (en) | A kind of database overlap scheme abstraction generating method propagated based on multi-tag | |
CN114357088A (en) | Nuclear power industry data warehouse system | |
CN105260300B (en) | Service test method based on accounting standard universal classification standard application platform | |
CN106933845A (en) | The method and apparatus that MDX inquires about effect are realized using SQL | |
CN109933578A (en) | A kind of configurable automated data detection method for quality and system | |
CN114417015A (en) | Method for constructing maintainability knowledge graph of high-speed train | |
CN107256315A (en) | A kind of pipe stress analyzes the intelligent Drawing method of zooming figure | |
WO2005076900A2 (en) | Data and metadata linking form mechanism and method | |
CN1722161B (en) | Electronic government affair cooperative work data standard compliance testing method | |
Sneed et al. | Measuring legacy database structures | |
CN106355439A (en) | Knowledge base modeling method for association relation analysis | |
CN113642291B (en) | Method, system, storage medium and terminal for constructing logical structure tree reported by listed companies | |
WO2008094851A2 (en) | Apparatus and method for analyzing relationships between multiple source data objects | |
CN116010439A (en) | Visual Chinese SQL system and query construction method | |
CN112115271B (en) | Knowledge graph construction method and device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |