The Study of Applying XML Technology to Assist Schema Matching and Transforming in Data Exchange
碩士 === 中原大學 === 工業工程研究所 === 93 === Data exchange between information systems of different enterprises needs to fulfill requirements of both schema integration and message translation. Since information system with relational database system are developed independently, schema conflicts between datab...
| Main Authors: | , |
|---|---|
| Other Authors: | |
| Format: | Others |
| Language: | zh-TW |
| Published: |
2005
|
| Online Access: | http://ndltd.ncl.edu.tw/handle/ae352w |
| Summary: | 碩士 === 中原大學 === 工業工程研究所 === 93 === Data exchange between information systems of different enterprises needs to fulfill requirements of both schema integration and message translation. Since information system with relational database system are developed independently, schema conflicts between databases and exchanged data is a common problem for schema integration. Thus, enterprises need to preserve the data integrity of transacting message with respect to the database of information systems. The core technology of data exchange is matching XML documents to relational database schemas. An interactive tool was designed to simplify the integration and implementation efforts of data exchange between database systems. The matching methods of this interactive tool provided mapping suggestions, and the system relied on users with specific schema knowledge to provide final verification of the matching results.
XML schema and XSL transformation were applied to translate message and solve schema conflicts between XML documents and the database system. The interactive tool used repository of synonyms and common words dictionary as references to match XML documents schemas and target database schemas. According to the matching results, XSLT would translate the element names of the XML documents to the database schemas. XSLT transformations were also applied to transform schema structures of the documents to comply with the database schema structures. This tool provided an environment for enterprises to exchange data and it is a prototype of solving semantic conflict problems in data integration.
|
|---|