Research Article
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’) |
|