July 24, 2008

DATAllegro could provide Microsoft with a true enterprise data warehouse sooner than you think

Jim Ericson of DM Review emailed the excellent questions:

Does DATAllegro give MSFT full-service high end data warehousing capability? If not, what is missing?

My quick answers are:

Both are largely a matter of product maturity, and as a young company DATAllegro isn’t quite there yet.

That said, integration with Microsoft SQL Server is apt to be a big help in addressing both issues. This seems pretty obvious in the case of feature support – if the features already are integrated with SQL Server, and SQL Server is integrated with DATAllegro, then a kind of transitivity should entail, in which most of the features quickly work well with DATAllegro/SQL Server too.

And I think this optimistic scenario will hold true for multi-user concurrency as well. I don’t know whether DATAllegro can do a good job for more than a dozen or two concurrent users today, but even if it can’t, the natural next-generation iteration of that would be good support for a few hundred. But suppose an enterprise wants to put 1000s or even 10s of 1000s of users on a data warehouse at once. It almost certainly will want to do so against a database of fairly limited size, probably no larger than the couple of terabytes SQL Server does an OK job on today. And DATAllegro has done some work to make hub-spoke architectures pretty simple to implement, allowing one to split out a data mart for demanding access while keeping it synchronized automagically with the main data warehouse.

Thus, I think that within a couple releases, only a few enterprises will be unsatisfied with the enterprise data warehouse capabilities of the Microsoft/DATAllegro combination.

Comments

One Response to “DATAllegro could provide Microsoft with a true enterprise data warehouse sooner than you think”

  1. Infology.Ru » Blog Archive » Microsoft покупает DATAllegro on August 14th, 2008 3:58 pm

    [...] Why DATAllegro could provide Microsoft with a true enterprise data warehouse sooner than you think [...]

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.