Method of integrating data of XML document with database on web

摘要

Disclosed herein is a method of integrating data of an XML document with a DB on a web. In the method, an XML document provided with user-defined tags is designed. An XSL format document for normal data mapping and an XSL format document for repetitive data mapping are designed. Mapping information required to map the normal data and the repetitive data of the XML document to the XSL format document for normal data mapping and the XSL format document for repetitive data mapping is created. An XSL document for normal data mapping and an XSL document for repetitive data mapping are generated using the mapping information. An SQL query statement required to integrate the normal data and the repetitive data of the XML document with a DB is generated. Data of the XML document is integrated with the DB by executing the SQL query statement on the DB.

主权项

1. A method of integrating data of an Extensible Markup Language (XML) document with a database (DB) on a web, comprising:
designing an XML document provided with user-defined tags; designing an Extensible Stylesheet Language (XSL) format document for normal data mapping, which is used when mapping normal text among structural data of the XML document, and an XSL format document for repetitive data mapping, which is used when mapping repetitive text; creating mapping information required to map the normal text and the repetitive text of the XML document to the XSL format document for normal data mapping and the XSL format document for repetitive data mapping, respectively; designing an XSL document for normal data mapping to which the normal text is mapped and an XSL document for repetitive data mapping to which the repetitive text is mapped, by mapping the normal text and the repetitive text of the XML document to the XSL format document for normal data mapping and the XSL format document for repetitive data mapping, respectively, using the mapping information; generating a Structured Query Language (SQL) query statement required to integrate the normal text and the repetitive text of the XML document with a DB associated with the XML document on the web by performing Extensible Stylesheet Language Transformation (XSLT) on the XML document and the XSL documents for mapping using an XSL transformer; and integrating data of the XML document with the DB by executing the SQL query statement on the DB; wherein the designing the XSL format document for mapping comprises: designing the XSL format document for normal data mapping; and designing the XSL format document for repetitive data mapping, wherein the XSL format document for normal data mapping comprises a mapping XSL format document for normal data storage and a mapping XSL format document for normal data revision, and wherein the XSL format document for repetitive data mapping comprises a mapping XSL format document for repetitive data storage and a mapping XSL format document for repetitive data revision.