More on Data Warehousing and XML…
June 23, 2010
Earlier this year I wrote about XML and Data Warehousing, and I continue to see use cases where companies integrate XML data in their warehouses.
Some companies collect XML messages from transactional systems and use DB2′s pureXML features to extract a subset of the XML elements from each message and integrate these values into the relational tables of their warehouse. In other cases this mapping from XML to relational is avoided and XML documents are stored “as-is” in the warehouse.
There is a very nice podcast that explains in 5 minutes and 47 seconds why and how companies are integrating XML into their data warehouses:
If you are interested in another discussion of this topic, you might want to attend this upcoming free Webinar offered by The Data Warehousing Institute (TDWI) :
Title: XML – The Key to the Next Generation Data Warehouse,
Date: Tuesday, June 29, 2010
Time: 9am US Pacific Time, 12noon US Eastern Time
Earlier this year I was involved in an XML data warehouse benchmark with 10TB worth of XML documents. I will share some details in my next blog post…