An Intelligent Web Digital Image Metadata Service Platform for Social Curation Commerce Environment

Procedure 1

Procedure to store XML documents into RDBMS.

CREATE PROCEDURE INSERTXMLDOC

AS

DECLARE @xmlDATA VARCHAR(2000)

SET @xmlDATA = ‘

?xml version=“1.0”>

<images>

 <image>

 <iid> i00002</iid>

 <subject> samsung cellular phone </subject>

 <category> Phone </category>

 <ref> image02.jpg </ref>

 <description> good cellular phone </description>

 </image>

</images>

’

DECLARE @iTree INTEGER

EXEC sp_xml_preparedocument @iTree OUTPUT, @xmlDATA

INSERT images (iid, subject, category, type, descript)

SELECT iid, subject, category, type, descript

FROM

OPENXML(@iTree, ‘images/image’, 1)

WITH  (iid varchar(10) ‘iid’,

    subject varchar(100) ‘subject’,

    category varchar(30) ‘category’,

    ref varchar(10) ‘ref’,

    description varchar(500) ‘description’)