Each storage option has advantages and disadvantages. You must choose the option or options best for your operation.
If you use element storage, all of the data from the XML document is available as normal SQL data that you can query and update using SQL operations. However, element storage has the overhead of assembling and disassembling the XML documents for interchange.
Document storage eliminates the need for assembling and disassembling the data for interchange. However, you need to use Java methods to reference or update the elements of the XML documents while they are in SQL, which is slower and less convenient than the direct SQL access of element storage.
Hybrid storage balances the advantages of element storage and document storage, but has the cost and complexity of redundant storage of the extracted data.
