SQL Server

Gartner Magic Quadrant for Data Warehouse Database Management Systems

The annual "Gartner Magic Quadrant for Data Warehouse Database Management Systems" was published last week.Like many folk out there, I am as interested in what the industry analysts make of the report as the report itself. Curt Monash's comments are here: http://www.dbms2.com/2012/02/08/gartner-magic-quadrant-data-warehouse-2011-2012/

The comments from Curt I picked up on are as follows...

"Teradata really needs to do is evolve to a more pick-your-own-node-combination mix-match kind of offering"

Whilst I agree with this in some respects, and it's something I have always hoped to see, Teradata has always taken the reasonable view that their 'stuff' consists of a tightly integrated stack that only they can assemble, test and certify.

It would also cause support nightmares for Teradata's GSC. At present there is just the eponymous Teradata DBMS running on top of SUSE Linux (with legacy NCR MP-RAS), Dell servers and LSI or EMC storage to support. The BYNET interconnect for MPP systems is also a potential showstopper.I think we'll but stuck with 2 AMP Teradata VMs and software-only single node Teradata Data Mart SMP servers as the choices for running on 'non-standard' hardware for the foreseeable.

Regarding IBM, Curt states "But Gartner does mention concurrency as a strength. I agree, especially if we presume that that was a reference to DB2 rather than Netezza."

Wise words. Concurrency was an issue that Netezza struggled with in the early days, but doesn't everyone? It's a lot better than it was, no doubt. Workload management on large data warehouse systems is never easy, but it tends to improve over time as products mature.

This really made me chuckle: "in Netezza’s defense, it has had to endure IBM’s post-acquisition on-boarding process."As a long-term Netezza partner we baulked at the "on-boarding" required to maintain this status once Netezza was gorged by IBM.

The comments relating to EMC Greenplum seem entirely fair and reasonable. The only thing I would add is that until Teradata goes down the 'mix and match' route (see above), Greenplum is likely to maintain it's status as the only 'roll-your-own' MPP play anywhere near Gartner's Data Warehouse Database Management Systems leaders quadrant.

Although the Greenplum DBMS is promoted by EMC as part of the EMC Greenplum Data Computing Appliance, it is still very much available as a software-only offering that can be deployed on a wide range of OS, server and storage choices. This we like, a lot.

Perhaps the most notable of Curt's comments relate to Microsoft:"there isn’t a single production reference for Microsoft’s Parallel Data Warehouse".This comes as no surprise. Despite considering ourselves well connected in the DW/BI world, and despite posting on several forums, we had been unable to confirm a single PDW deployment out in the wild.The 40 billion row Dataupia-powered SQL Server system built by yours truly at ITIS in the UK in 2009 looks even more impressive now ;-)