October 12, 2007

Three ways Oracle or Microsoft could go MPP

I’ve been arguing for a while that Oracle and Microsoft are screwed in high-end data warehousing. The reason is that they’re stuck with SMP (Symmetric Multi-Processing) architectures, while Teradata, Netezza, DATAllegro, and many others enjoy the benefits of MPP (Massively Parallel Processing). Thus, Teradata and DATAllegro boast installations in the hundreds of terabytes each, while Oracle and Microsoft users usually have to perform unnatural acts of hard-coded partitioning even to reach the 10 terabyte level.

That said, there are at least three ways Oracle and/or Microsoft could get out of this technical box:

1. They could buy or just partner with MPP vendors such as Dataupia, who offer plug-compatibility with their respective main DBMS.

2. They could buy whoever they want, plug-compatibility be damned. Presumably, they’d quickly add a light-weight data federation front-end to give the appearance of integration, then merge the products more closely over time.

3. They could develop or buy technology like DATAllegro’s, which essentially federates instances of an ordinary SMP DBMS across nodes of an MPP grid (Greenplum does something similar). I imagine that, for example, ripping Ingres out of DATAllegro and slotting in Oracle instead would be a pretty straightforward exercise; even without dramatic change to any of the optimizations, the resulting port would be something that ran pretty quickly on Day 1.

Bottom line: Oracle and Microsoft are hemorrhaging at the data warehouse high end now. But there are ways they could stanch the bleeding.

Comments

4 Responses to “Three ways Oracle or Microsoft could go MPP”

  1. Echoes of Microsoft » Three ways Oracle and Microsoft could go MPP on October 13th, 2007 11:04 pm

    [...] unknown wrote an interesting post today onHere’s a quick excerptI’ve been argued for a while that Oracle and Microsoft are screwed in high-end data warehousing. The reason is that they’re stuck with SMP (Symmetric Multi-Processing) architectures, while Teradata, Netezza, DATAllegro, and many others … [...]

  2. Infology.Ru » Blog Archive » Microsoft покупает DATAllegro on August 27th, 2008 5:13 am

    [...] Three ways Oracle and Microsoft could go MPP [...]

  3. Exadata: Oracle finally answers the data warehouse challengers | DBMS2 -- DataBase Management System Services on September 28th, 2008 8:03 pm

    [...] Three ways Oracle or Microsoft could go MPP [...]

  4. Infology.Ru » Blog Archive » Exadata: Oracle наконец отвечает бросившим вызов в области хранилищ данных on March 31st, 2009 1:21 pm

    [...] Three ways Oracle or Microsoft could go MPP [...]

Leave a Reply




Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:

Login

Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.