@article{ART000930617},
author={Kim,Kil-Jun},
title={data Transformation through Mapping between XML and Relation Database},
journal={Journal of The Korea Society of Computer and Information},
issn={1598-849X},
year={2004},
volume={9},
number={4},
pages={5-12}
TY - JOUR
AU - Kim,Kil-Jun
TI - data Transformation through Mapping between XML and Relation Database
JO - Journal of The Korea Society of Computer and Information
PY - 2004
VL - 9
IS - 4
PB - The Korean Society Of Computer And Information
SP - 5
EP - 12
SN - 1598-849X
AB - 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.
KW - Mapping;OpenXML;DTD
DO -
UR -
ER -
Kim,Kil-Jun. (2004). data Transformation through Mapping between XML and Relation Database. Journal of The Korea Society of Computer and Information, 9(4), 5-12.
Kim,Kil-Jun. 2004, "data Transformation through Mapping between XML and Relation Database", Journal of The Korea Society of Computer and Information, vol.9, no.4 pp.5-12.
Kim,Kil-Jun "data Transformation through Mapping between XML and Relation Database" Journal of The Korea Society of Computer and Information 9.4 pp.5-12 (2004) : 5.
Kim,Kil-Jun. data Transformation through Mapping between XML and Relation Database. 2004; 9(4), 5-12.
Kim,Kil-Jun. "data Transformation through Mapping between XML and Relation Database" Journal of The Korea Society of Computer and Information 9, no.4 (2004) : 5-12.
Kim,Kil-Jun. data Transformation through Mapping between XML and Relation Database. Journal of The Korea Society of Computer and Information, 9(4), 5-12.
Kim,Kil-Jun. data Transformation through Mapping between XML and Relation Database. Journal of The Korea Society of Computer and Information. 2004; 9(4) 5-12.
Kim,Kil-Jun. data Transformation through Mapping between XML and Relation Database. 2004; 9(4), 5-12.
Kim,Kil-Jun. "data Transformation through Mapping between XML and Relation Database" Journal of The Korea Society of Computer and Information 9, no.4 (2004) : 5-12.
