In my last post, I talked about Microsoft's new, upcoming columnar offering, Apollo. I said it was designed to take some pressure off the core DBMS to do it all and do it all fast. That's doubly true for Parallel Data Warehouse (PDW), the new MPP offering from Microsoft. This is probably one of the last times you'll hear the word DataAllegro, but that technology, acquired in 2008 by Microsoft, is what PDW is based on. MIcrosoft has spent the last 2 years replacing the core (Ingres) DBMS with SQL Server and the Linux/Java with Windows/C#. PDW currently works on HP hardware and is in early release.
Microsoft is giving its users 2 major additional data storage options in Denali - columnar and MPP. Microsoft is going down the path of functional parity between the core SMP offering and PDW, which is already integrated with the SQL BI stack. It hopes to keep some of those SMP customers hitting its scalability limits in the Microsoft tent.
There is a lot of overlap in capabilities among SMP, columnar and MPP. It's your job to sort through your workloads and make a plan. I have found MPP much more advantageous the larger the data is and columnar useful for those high column selectivity workloads.
I'll be part of a virtual seminar focused on PDW on Tuesday. I'll be talking about data consolidation strategies, a topic Microsoft is ready to take on with PDW.
As budgets languish, data growth balloons and business demand intensifies, BI and data warehousing professionals are under immense pressure to squeeze every last dollar of value from existing investments, while providing 24/7 access to mission-critical business information. That's the bad news.
The good news is you're invited to join renowned visionaries Bill Inmon (the father of data warehousing) and William McKnight (leading information management consultant), for our LIVE, interactive virtual seminar on November 16th (9:00 AM - 1:30 PM (EDT)) - designed to help you leverage next-generation data warehousing technologies for maximum gain.
Posted November 14, 2010 8:44 AM
Permalink | 1 Comment |