Product Data Integration and Management Research Based on XML

Product information technology has been widely applied in manufacturing field, improved the rapid response ability of enterprises to the market demands, and to some extent enhanced the competitiveness of enterprise products. However, product data information generated by different information system has the characteristics of diversification and differentiation. The integration and management of these product heterogeneous data has become the bottleneck which restricts the development of enterprise information technology. Based on XML, this paper researches the integration and management of heterogeneous data, expounds integration structure of heterogeneous data, introduces integration process and schema mapping of heterogeneous data, and realizes schema translation of heterogeneous data. Finally, through the PLM XML schema which is provided by the product life-cycle management software, this paper verifies the integrated management of relational heterogeneous data on Teamcenter.

METHODOLOGY FOR DATA CONVERSION FROM XML DOCUMENTS TO RELATIONS USING EXTENSIBLE STYLESHEET LANGUAGE TRANSFORMATION

Extensible Markup Language (XML) has been used for data-transport and data-transformation while the business sector continues to store critical business data in relational databases. Extracting relational data and formatting it into XML documents, and then converting XML documents back to relational structures, becomes a major daily activity. It is important to have an efficient methodology to handle this conversion between XML documents and relational data. This paper aims to perform data conversion from XML documents into relational databases. It proposes a prototype and algorithms for this conversion process. The pre-process is schema translation using an XML schema definition. The proposed approach is based on the needs of an Order Information System to suggest a methodology to gain the benefits provided by XML technology and relational database management systems. The methodology is a stepwise procedure using XML schema definition and Extensible Stylesheet Language Transformations (XSLT) to ensure that the data constraints are not scarified after data conversion. The implementation of the data conversion is performed by decomposing the XML document of a hierarchical tree model into normalized relations interrelated with their artifact primary keys and foreign keys. The transformation process is performed by XSLT. This paper will also demonstrate the entire conversion process through a detailed case study.