XML document tree storage


Any XML document inserted into DB2 is stored in native format in a tree structure. The tags in the XML documents are replaced by a unique integer and this integer is stored instead of the XML tags. We can obtain the XML string and string ID mapping in the catalog table SYSIBM.SYSXMLSTRINGS.


Advantages of replacing the XML tags with an integer includes :



SYSIBM.SYSXMLSTRINGS table definition