CN109840243A - A kind of digitlization O&M support process data conversion method based on multistage rule - Google Patents
A kind of digitlization O&M support process data conversion method based on multistage rule Download PDFInfo
- Publication number
- CN109840243A CN109840243A CN201811619345.XA CN201811619345A CN109840243A CN 109840243 A CN109840243 A CN 109840243A CN 201811619345 A CN201811619345 A CN 201811619345A CN 109840243 A CN109840243 A CN 109840243A
- Authority
- CN
- China
- Prior art keywords
- data
- xml format
- exchange
- information
- format document
- 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
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Document Processing Apparatus (AREA)
Abstract
The present invention provides a kind of digitlization O&M support process data conversion method based on multistage rule, using secondary exchange process, in first time exchange process, the second XML format document is converted by the first XML format document by operation exchange specification, also that is, initial data to be exchanged for intermediate standard data, and in second of exchange process, target XML format document is converted for the second XML format document by concurrentization;Therefore, initial data demand can be shielded in first time exchange process, in addition, data exchange standard can be formed in the exchange specification that second of data exchange uses, it is multiplexed in other occasions, so that concurrentization has standard and versatility, for digitlization O&M support process provide one can describe, expansible, executable implementation method.
Description
Technical field
The invention belongs to digitize O&M to support field more particularly to a kind of digitlization O&M support based on multistage rule
Process data conversion method.
Background technique
Digitlization O&M supports process to have the characteristics that business is numerous, data flow is complicated, isomeric data amount is big.Digitlization fortune
It ties up all kinds of business supported and its system generates a large amount of dynamic dataflow, and data description form disunity, therefore, in the people
In the digital Construction of machine customer service business, the data exchange system for establishing data mapping is to promote business data in number
Necessary means that are reasonable, orderly in change O&M support system, efficiently circulating.
In data exchange process, every profession and trade is intended to use or the data system requirement of reference standard is (such as using Europe
The S series standard system of continent space flight and the proposition of national defense industry association, ISO 10303-239 product life cycels guarantee (PLCS)
Standard), to reach the quick exchange circulation of data, meanwhile, also meet since business demand changes, leads to data exchange standard
Frequently the problem of change.But business datum complex, data in actual application, are led to due to the complexity of business
It cannot achieve the standard of directlying adopt to be described, carry out data exchange according to standard to realize, then need to be extended standard
With it is perfect.The consequence being implemented is that standard can not fix, and be frequently necessary to be adjusted.
In frequently-used data exchange method, the method for use is about following two mode:
1) (for example Excel formatted data is extracted) is extracted to initial data, establishes certain data sample in memory
Formula directly generates the XML file of object format;
2) (for example Excel formatted data is extracted) is extracted to initial data, establishes certain data sample in memory
Formula, and the XML format file of structuring is formed, by an exchange process, directly generate the XML file of object format.
However in different industries, such as aircraft industry, railway systems, there is it for the definition of the contents such as fault mode
The business correlation of industry, and descriptor format is different, for example uses Excel format or Word format, and Excel call format
It is inconsistent;It need to be a set of exchange specification of each data format definition, and cannot be according to mark if directly carrying out data exchange process
The form of alignment request swaps the description of content, does not have standard and versatility so as to cause concurrentization.
Summary of the invention
To solve the above problems, the present invention provides a kind of digitlization O&M support process data conversion based on multistage rule
Method can shield initial data demand in first time exchange process, second of data exchange using secondary exchange process
The exchange specification used can form data exchange standard, have standard and versatility.
A kind of digitlization O&M support process data conversion method based on multistage rule, comprising the following steps:
S1: initial data is obtained, wherein the initial data is Excel format;
S2: traversing each unit lattice of the initial data, and the data of each unit lattice are transformed to triple data,
In, the triple data are { line number, row number, cell value };
S3: it is based on predefined XML Schema data format, converts XML format file structure for triple data
Data obtain the structural data of the first XML format document;
S4: extracting line number, row number and the cell value in the first XML format document, then to original in Excel format
The corresponding each line number of data assigns different object informations, different object properties information is assigned to each row number, then cell value
As the object attribute values of its corresponding object properties information, then by the attribute information of the object information and object according to default
Operation exchange specification stored, obtain the second XML format document;
S5: object information, object properties information and the object attribute values of the second XML format document are extracted, in present count
According to finding transition specification corresponding with object information defined in the second XML format document in exchange specification, wherein described turn
It changes specification and defines the storage pattern of its corresponding object information and the storage pattern of corresponding object properties information, then press
Object information defined in the second XML format document and object properties information are converted to and meet preset data according to the transition specification
The storage pattern of exchange specification, wherein the storage pattern of object attribute values is constant, obtains target XML format document.
The utility model has the advantages that
The present invention provides a kind of digitlization O&M support process data conversion method based on multistage rule, using secondary friendship
Process is changed, in first time exchange process, the second XML format is converted for the first XML format document by operation exchange specification
Document, also that is, initial data to be exchanged for intermediate standard data, such as S3000L formatted data, and second
In secondary exchange process, target XML format document is converted for the second XML format document by concurrentization, is such as passed through
S3000L_TO_S1000D exchange specification is converted into final S1000D specification;It therefore, can be to original in first time exchange process
Beginning data requirements is shielded, in addition, data exchange standard can be formed in the exchange specification that second of data exchange uses, at it
He is multiplexed occasion, so that concurrentization has standard and versatility, is able to solve digitlization O&M and supports process
Data Styles multiplicity, isomeric data amount be big, the variation of data exchange process business demand greatly, data exchange standard change frequent etc. one
The problem of data quickly circulate between series of problems and a variety of data standards, multi-stage cross work flow, to digitize O&M branch
The process of holding provides the implementation method that can be described, is expansible, can be performed.
Detailed description of the invention
Fig. 1 is a kind of stream that process data conversion method is supported based on the digitlization O&M of multistage rule provided by the invention
Cheng Tu;
Fig. 2 is the initial data schematic diagram of Excel format provided by the invention;
Fig. 3 is the memory form schematic diagram of Table structure provided by the invention;
Fig. 4 is schematic diagram of the Excel tableau format provided by the invention to Table structured data transition process;
The definition requirement that Fig. 5 is XML schema provided by the invention;
Fig. 6 is provided by the invention according to the definition of XML schema requirement, the XML document content-form signal of generation
Figure;
Fig. 7 is the process provided by the invention that the first XML format document is converted into from memory data structure;
Fig. 8 converts the second XML format text for the first XML format document by operation exchange specification to be provided by the invention
The exchange process flow chart of shelves;
Fig. 9 assigns different object informations to each line number to be provided by the invention, and different object categories is assigned to each row number
The transition diagram of property information;
Figure 10 converts target XML format for the second XML format document by concurrentization to be provided by the invention
The exchange process flow chart of document;
Figure 11 be it is provided by the invention according to transition specification by object information and object defined in the second XML format document
Attribute information is converted to the schematic diagram for meeting the storage pattern of preset data exchange specification.
Specific embodiment
In order to make those skilled in the art more fully understand application scheme, below in conjunction in the embodiment of the present application
Attached drawing, the technical scheme in the embodiment of the application is clearly and completely described.
Referring to Fig. 1, which is that a kind of digitlization O&M based on multistage rule provided in this embodiment supports process data
The flow chart of conversion method.A kind of digitlization O&M support process data conversion method based on multistage rule, including following step
It is rapid:
S1: initial data is obtained, wherein the initial data is Excel format.
Referring to fig. 2, which is the initial data schematic diagram of Excel format provided in this embodiment.As shown, original number
Summarize according to for 32-45-01 fault mode.
S2: traversing each unit lattice of the initial data, and the data of each unit lattice are transformed to triple data,
In, the triple data are { line number, row number, cell value }.
It should be noted that after the Excel table in Fig. 2 is read in memory, structuring number can be formed by software code
It is specific as follows according to content:
1) Table representation Excel document is used in memory;Referring to Fig. 3, which is provided in this embodiment
The memory form schematic diagram of Table structure;
2) Table structure can be managed list data by chained list mode, and each of chained list node can correspond to
There is the cell of data in one, cell can be used triple mode and be described, and concrete form is { line number, row number, unit
Lattice value }.Referring to fig. 4, which is signal of the Excel tableau format provided in this embodiment to Table structured data transition process
Figure.
For example, triple { D, 5, fault mode } can be used to be retouched in chained list for cell D5 (fault mode)
It states.
S3: it is based on predefined XML Schema data format, converts XML format file structure for triple data
Data obtain the structural data of the first XML format document.
It should be noted that the structural data Table structure to memory mode of management traverses, according to XML
The definition requirement of schema, generates the first XML format document;Wherein, the definition of XML schema requires as shown in figure 5, specific
:
<table>is object (element), is the top mode of XML file, includes<row>object daughter element;
<title>is the attribute information of table objects;
<row>is object (element), identifies row information, includes<column>object daughter element;
<line number>is the attribute information of row object;
<column>are object (element), identify column information,<column>object are received in cell value;
<row number>is the attribute information of row object;
It is then required according to the definition of XML schema, the XML document content-form of generation is as shown in Figure 6.
For the triple data of cell D5 (fault mode), it is described as following form in xml:
<every trade number=" 5 ">
<column number="D">fault mode</column number>
</row>
Further, Fig. 7 describes the process that the first XML format document is converted into from memory data structure.
S4: extracting line number, row number and the cell value in the first XML format document, then to original in Excel format
The corresponding each line number of data assigns different object informations, different object properties information is assigned to each row number, then cell value
As the object attribute values of its corresponding object properties information, then by the attribute information of the object information and object according to default
Operation exchange specification stored, obtain the second XML format document.
Referring to Fig. 8, which is provided in this embodiment to convert for the first XML format document by operation exchange specification
The exchange process flow chart of two XML format documents.
Detailed process is as follows:
1) the first XML format document is chosen, file has been converted into XML format, than the XML of form as described previously
File content;
2) start first time exchange process, form the second XML format document;
(1) the relevant XSL configuration file content of selection service template specification layer;
(2) XML file content to be transformed is traversed, the traversal of XML data is carried out according to depth first method, is reading certain
After a specific XML element and attribute, pass through template in XSL format (such as < xsl:template match=" FMEA "
>) conversion that carries out data, generate corresponding XML element data raw content;
(3) if XML does not traverse completion, step (2) content is continued to execute, otherwise, output uses the 2nd XML of business element
Format file data;
In above process, operation exchange specification is described using XSL mode.Referring to Fig. 9, which is that the present embodiment mentions
What is supplied assigns different object informations to each line number, and the transition diagram of different object properties information is assigned to each row number;Then
For the above process, it is exemplified below according to Fig. 9:
For
After being converted by operation exchange specification, it can convert are as follows:
Attribute in<Failure_mode>object
Failure_mode_description=" failure of load/torsion is overweight ability and/or a wheel inflation ".
S5: object information, object properties information and the object attribute values of the second XML format document are extracted, in present count
According to finding transition specification corresponding with object information defined in the second XML format document in exchange specification, wherein described turn
Change depositing for the object properties information for standardizing the storage pattern and the corresponding object information that define its corresponding object information
Then sample storage formula is converted object information defined in the second XML format document and object properties information according to the transition specification
For the storage pattern for meeting preset data exchange specification, wherein the storage pattern of object attribute values is constant, obtains target XML lattice
Formula document.
It should be noted that preset data exchange specification can be the S series of European space flight and the proposition of national defense industry association
Standards system, ISO the guarantee of 10303-239 product life cycels (PLCS) standard), to data element, data exchange process into
Row definition and clear, conversion of the finishing service data to normal data.
Referring to Figure 10, which is provided in this embodiment to be converted the second XML format document to by concurrentization
The exchange process flow chart of target XML format document.
Start second of exchange process, output complies with standard the XML file of format;
(1) the second XML format document is obtained;
(2) the relevant XSL configuration file content of selection concurrentization layer;
(3) the second XML format document is traversed, the traversal of XML data is carried out according to depth first method, is reading some tool
After the XML element and attribute of body, by the template (such as<xsl:template match=" FMEA ">) in XSL format into
The conversion of row data generates corresponding XML element data raw content;
(3) if XML does not traverse completion, step (2) content is continued to execute, otherwise, output complies with standard the mesh of call format
XML format document is marked, for example meets the data of S1000D format specification.
In above process, concurrentization is described using XSL mode, for example uses S3000L_TO_S1000D
Specification.Referring to Figure 11, the figure be it is provided in this embodiment according to transition specification by object defined in the second XML format document believe
Breath and object properties information are converted to the schematic diagram for meeting the storage pattern of preset data exchange specification.Then for the above process,
It is exemplified below according to Figure 11:
For
< Failure_mode Failure_mode_identifier=" ID_1 "
Failure_mode_description=" failure of load/torsion is overweight ability and/or a wheel inflation "
</Failure_mode>
After being converted by concurrentization, it can convert are as follows:
It can be seen that supporting the XML file of the object format of process to require to meet certain specification in digitlization O&M
Call format, such as S1000D code requirement, and content is repaired for fault mode etc., it is described using S3000L format;
When S3000L formatted data is converted to S1000D specification, S1003X specification can refer to, carrying out customized extension appropriate
Afterwards, S3000L_TO_S1000D exchange specification is formed, the data exchange requirement of two specifications can be met.
In the data exchange process of the present embodiment description, using exchange process will be former in first time exchange process twice
Beginning data exchange is intermediate standard data, such as S3000L formatted data, and in second of exchange process, it can pass through
S3000L_TO_S1000D exchange specification is converted into final S1000D specification.In this way, can be to original in first time exchange process
Beginning data requirements is shielded, in addition, data exchange standard can be formed in the exchange specification that second of data exchange uses, at it
He is multiplexed occasion.
Certainly, the invention may also have other embodiments, without deviating from the spirit and substance of the present invention, ripe
Various corresponding changes and modifications can be made according to the present invention certainly by knowing those skilled in the art, but these it is corresponding change and
Deformation all should fall within the scope of protection of the appended claims of the present invention.
Claims (1)
1. a kind of digitlization O&M based on multistage rule supports process data conversion method, which is characterized in that including following step
It is rapid:
S1: initial data is obtained, wherein the initial data is Excel format;
S2: traversing each unit lattice of the initial data, the data of each unit lattice is transformed to triple data, wherein institute
Stating triple data is { line number, row number, cell value };
S3: it is based on predefined XML Schema data format, converts XML format file structure number for triple data
According to obtaining the structural data of the first XML format document;
S4: extracting line number, row number and the cell value in the first XML format document, then to initial data in Excel format
Corresponding each line number assigns different object informations, different object properties information is assigned to each row number, then cell value becomes
The object attribute values of its corresponding object properties information, then by the attribute information of the object information and object according to preset industry
Business exchange specification is stored, and the second XML format document is obtained;
S5: extracting object information, object properties information and the object attribute values of the second XML format document, hands in preset data
It changes in specification and finds transition specification corresponding with object information defined in the second XML format document, wherein the conversion rule
Model defines the storage pattern of its corresponding object information and the storage pattern of corresponding object properties information, then according to this
Transition specification, which is converted to object information defined in the second XML format document and object properties information, meets preset data exchange
The storage pattern of specification, wherein the storage pattern of object attribute values is constant, obtains target XML format document.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811619345.XA CN109840243A (en) | 2018-12-28 | 2018-12-28 | A kind of digitlization O&M support process data conversion method based on multistage rule |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811619345.XA CN109840243A (en) | 2018-12-28 | 2018-12-28 | A kind of digitlization O&M support process data conversion method based on multistage rule |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109840243A true CN109840243A (en) | 2019-06-04 |
Family
ID=66883541
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811619345.XA Pending CN109840243A (en) | 2018-12-28 | 2018-12-28 | A kind of digitlization O&M support process data conversion method based on multistage rule |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109840243A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111208789A (en) * | 2020-01-02 | 2020-05-29 | 北京航天测控技术有限公司 | Data management method, device, system and storage medium |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070150885A1 (en) * | 2005-12-22 | 2007-06-28 | Fabrice Jogand-Coulomb | Method for program code execution |
CN101354759A (en) * | 2007-07-23 | 2009-01-28 | 兰雨晴 | Method and system of work process flow defining conversion based on element model |
CN101739436A (en) * | 2009-09-28 | 2010-06-16 | 孙彬 | XML-based flexible data migration method |
CN103678625A (en) * | 2013-12-18 | 2014-03-26 | 北京航天测控技术有限公司 | Method and device for transforming interactive electronic technical manual data |
CN104598590A (en) * | 2015-01-20 | 2015-05-06 | 国家电网公司 | Conversion method of CIM data and DLMS/COSEM data |
CN105786926A (en) * | 2014-12-26 | 2016-07-20 | 北京航天测控技术有限公司 | Method and apparatus for converting reliability centered maintenance (RCM) analysis data into interactive electronic technical manual (IETM) standard data |
-
2018
- 2018-12-28 CN CN201811619345.XA patent/CN109840243A/en active Pending
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070150885A1 (en) * | 2005-12-22 | 2007-06-28 | Fabrice Jogand-Coulomb | Method for program code execution |
CN101354759A (en) * | 2007-07-23 | 2009-01-28 | 兰雨晴 | Method and system of work process flow defining conversion based on element model |
CN101739436A (en) * | 2009-09-28 | 2010-06-16 | 孙彬 | XML-based flexible data migration method |
CN103678625A (en) * | 2013-12-18 | 2014-03-26 | 北京航天测控技术有限公司 | Method and device for transforming interactive electronic technical manual data |
CN105786926A (en) * | 2014-12-26 | 2016-07-20 | 北京航天测控技术有限公司 | Method and apparatus for converting reliability centered maintenance (RCM) analysis data into interactive electronic technical manual (IETM) standard data |
CN104598590A (en) * | 2015-01-20 | 2015-05-06 | 国家电网公司 | Conversion method of CIM data and DLMS/COSEM data |
Non-Patent Citations (1)
Title |
---|
夏开建 等: "基于XML的Excel数据提取和集成研究", 《常熟理工学院学报(自然科学)》 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111208789A (en) * | 2020-01-02 | 2020-05-29 | 北京航天测控技术有限公司 | Data management method, device, system and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107918666B (en) | Data synchronization method and system on block chain | |
CN110222237B (en) | Method and system for converting database table and XML message | |
CN104035754A (en) | XML (Extensible Markup Language)-based custom code generation method and generator | |
CN101996067A (en) | Data export method and device | |
CN108388640B (en) | Data conversion method and device and data processing system | |
CN104216961A (en) | Method and device for data processing | |
CN110955714B (en) | Method and device for converting unstructured text into structured text | |
CN114490641B (en) | Sharing method, equipment and medium of industrial Internet data | |
CN101430714A (en) | Content structuring process method and system based on model | |
CN105278961A (en) | Method and system for generating database table structure document | |
CN111695330B (en) | Method and device for generating table, electronic equipment and computer readable storage medium | |
CN102915344B (en) | SQL (structured query language) statement processing method and device | |
CN114239097A (en) | Method and device for generating process file, storage medium and electronic device | |
CN109840243A (en) | A kind of digitlization O&M support process data conversion method based on multistage rule | |
JP2011034264A (en) | Personal information masking system | |
CN113505245A (en) | Knowledge graph generation method, computer readable storage medium and computer device | |
CN113407565A (en) | Cross-database data query method, device and equipment | |
CN108241620B (en) | Query script generation method and device | |
CN117539981A (en) | Method, equipment and medium for constructing theme data set | |
CN104572730A (en) | Method and device for importing and exporting digital resources | |
CN106909570B (en) | Data conversion method and device | |
CN108228604B (en) | Model construction method based on memory object, information query method and device | |
CN106021349A (en) | A foreign exchange data submitting method and device | |
CN108228688B (en) | Template generation method, system and server based on XBRL | |
CN112115159A (en) | SQL statement generation method and device, electronic equipment and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190604 |