본문 바로가기
  • Home

data Transformation through Mapping between XML and Relation Database

  • Journal of The Korea Society of Computer and Information
  • Abbr : JKSCI
  • 2004, 9(4), pp.5-12
  • Publisher : The Korean Society Of Computer And Information
  • Research Area : Engineering > Computer Science

Kim,Kil-Jun 1

1성결대학교

Candidate

ABSTRACT

The data transformation between XML and Relation Database is made through the principle of mapping bewtween them. There are two ways to access SQL Server, one is to assign SQL query to URL and the other is to use template file. MS-SQL server takes advantage of OpenXML function to transform the results of executing SQL query into XML documents. That is, OpenXML first makes node tree and then transforms row set data of XML documents into XML data of relation type. In order to insert XML data into database data, data is extracted from parsing XML documents using sp_xml_preparedocument procedure, and then the document structure is mapped into tree structure and stored in a table of database. Consequently, Data transformation between XML and Relation Database is made through mapping bewtween them. This article proposes the principle of mapping between XML and Relation Database and then shows the implementation of transformation between them so that it introduces the possibilty of bringing the extension and efficiency of data and various effects.

Citation status

* References for papers published after 2022 are currently being built.