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:
http://www.ibm.com/podcasts/software/data/infosphere/index.rss

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
Registration: online

Enjoy!

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…


About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 50 other followers

%d bloggers like this: