Sybase IQ supports element storage of XML data. This method extracts data elements from an XML document and stores them as data rows and columns in an Sybase IQ database. All of the data from the XML document is available as normal SQL data that you can query and update using SQL operations.
For example, using the XML Order sample document, you can create SQL tables with columns for the individual elements of an order: Date, CustomerId, CustomerName, ItemId, ItemName, Quantity, and Units. You can then manage that data in SQL with normal SQL operations:
To produce an XML document for Order data contained in SQL, retrieve the data, and assemble an XML document with it.
To store an XML document with new Order data, extract the elements of that document, and update the SQL tables with that data.
