InfoSphere Warehouse 10 – The Real-Time Data Warehouse
So back to the grind – I’ve been away from the blogging and tweeting a bit for a number of good reasons, but the backlog of activities and news to share is staggering.
On a personal note, my wife and I had our 2nd child recently and well to be quite frank – That really kills the ability to crank out early morning or late night blog entries and such. I’m still in a half awake trance right now, in between burps, shooshes and fast walks around the foyer to get the Lil Mr. to sleep.
Last week I was out at the Gartner BI conference in Los Angeles, CA – Much more activity this year in my honest opinion and spoke with a number of current and prospective customers on their current BI and data warehousing situations. What really surprised me this year is that many folks are coming in asking about specific products and how it can help their company or organization – Marketing appears to be paying off – Yet we must be diligent to fully understanding the underlying business drivers before offering a solution. Will cover this in another post.
On top of the conference, our team launched our latest InfoSphere Warehouse 10 offering (in tandem with DB2 10) and has been getting some great reception. Now, I’m not going to spend all day recreating the wheel on its laundry list of features and benefits (there are plenty of sites that cover this that I will list) but I do want to discuss it’s overall purpose and why we released it.
Now if you were not aware, InfoSphere Warehouse 10 is built on top of DB2 (and thus DB2 10). This is the underlying database. What makes InfoSphere Warehouse different from DB2 proper is a feature known as the ‘database partitioning feature’ (or DPF for short) – This feature allows the DB2 10 inside of InfoSphere Warehouse to partition across nodes, increasing performance, manageability, scalabiltiy, etc. – All things important with a data warehouse implementation. This feature is not the only difference though, as InfoSphere Warehouse also includes its own data mining, cubing services, Cognos reporting and even basic ETL baked-in as standard components.
So with all of that being said – What is the big deal with InfoSphere Warehouse 10?
Real-Time Data Warehousing
From continuous ingest (populating the data warehouse on a continuous basis – as events occur) through time travel queries (baked-in support for temporal analytics) this data warehouse version enables customers to shorten the time it takes to record and capture an event, analyze and incorporate it and then take action on it.
Take this scenario. You are a retail store. A customer calls in (or emails, etc) to tell you that they are dissatisfied with your service. In the past, you would potentially deal with this customer in a customer service department individually and then ‘log’ and ‘update’ the customer’s complaint whenever the data warehouse loading was to occur (could be daily, could be weekly). While the customer service department handler has access to this ‘event’ (the customer complaining) – The rest of your organization and the underlying data warehouse and analytics infrastructure does not. How are you going to respond? Even analytical competitors have to wait until that event is loaded and processed before being able to respond.
Enter InfoSphere Warehouse 10. When the customer calls in, instead of having to wait until a batch load occurs, the specific event is ‘ingested’ into the data warehouse on the spot and incorporated into the repository. You have essentially reduced the time it takes to leverage that information from days and weeks to near immediate response. Your data warehouse is using the latest information, immediately after the events occur.
Continuous ingest in InfoSphere Warehouse 10 is an awesome illustration of some of the real-time capabilities yet the features don’t stop there. This offering is jam packed with built in queries, security features and other tools that drive higher performance, lower costs and increase overall team productivity.
I’ll follow up on some of the specific features over the next few days (yes, I promise to be better with writing) , but in the meantime, check out this aggregator of warehousing news for some other expert opinions, thoughts and critiques on the new InfoSphere Warehouse: