How do I get XML into or out of a database?
Answer:
Ask your database manufacturer: they all provide XML import and export modules to
connect XML applications with databases. In some trivial cases there will be a 1:1 match
between field names in the database table and element type names in the XML Schema or
DTD, but in most cases some programming will be required to establish the desired
match. This can usually be stored as a procedure so that subsequent uses are simply
commands or calls with the relevant parameters.
In less trivial, but still simple, cases, you could export by writing a report routine that
formats the output as an XML document, and you could import by writing an XSLT
transformation that formatted the XML data as a load file.
connect XML applications with databases. In some trivial cases there will be a 1:1 match
between field names in the database table and element type names in the XML Schema or
DTD, but in most cases some programming will be required to establish the desired
match. This can usually be stored as a procedure so that subsequent uses are simply
commands or calls with the relevant parameters.
In less trivial, but still simple, cases, you could export by writing a report routine that
formats the output as an XML document, and you could import by writing an XSLT
transformation that formatted the XML data as a load file.
No comments:
Post a Comment