1.Previous
3.Next

#XML is "shredded" into a series of tables based on a schema
#XML is stored into a native XML Type as defined by ISO Standard 9075-14

RDBMS that support the ISO XML Type are:
#IBM DB2 (pureXML)
#Microsoft SQL Server
#Oracle Database
#PostgreSQL

Typically an XML-enabled database is best suited where the majority of data are non-XML. For datasets where the majority of data are XML, a native XML database is better suited.

Example of XML Type Query in IBM DB2 SQL

select id, vol, xmlquery('$j/name', passing journal as "j") as name from journalswhere xmlexists('$j[licence="CreativeCommons"]', passing journal as "j")

1.Previous
3.Next