Two Years to Integrate DatAllegro? I Doubt It - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
Commentary
7/25/2008
10:29 AM
Doug Henschen
Doug Henschen
Commentary
Connect Directly
LinkedIn
Twitter
RSS
E-Mail
50%
50%

Two Years to Integrate DatAllegro? I Doubt It

Talking to Fausto Ybarra, Microsoft's director of SQL Server product management, I certainly didn't get the idea that the integration of DatAllegro's software for shared-nothing, massively parallel processing (MPP) with Microsoft SQL Server will take an eternity... Stuart Frost and independent Curt Monash also say it's a "straigtforward" proposition, and I believe them.

In my interview of Fausto Ybarra, Microsoft's director of SQL Server product management, I certainly didn't get the idea (suggested in these separate posts by Seth Grimes and Mark Madsen) that the integration of DatAllegro's software for shared-nothing, massively parallel processing (MPP) will take an eternity. Granted, Ybarra wouldn't comment on timing and said details won't be forthcoming until the October Microsoft BI Conference. But he did say Microsoft chose DatAllegro over other products considered specifically because it was the best fit, architecturally, and would be the easiest product to integrate.As for other alternatives, Stuart Frost, the CEO of DatAllegro, said this when I asked him (on Wednesday night, before this whole debate emerged) "why wouldn't Microsoft choose Dataupia, a company that already boast SQL Server compatibility?": "Dataupia is more of a bolt-on to SQL Server because they're not using it as the actual engine. It fits on the back end of the database and helps it run faster for certain queries - kind of like a hardware accelerator."

Frost explained that DatAllegro built its architecture around standard databases from the start, knowing that the most likely exit for the company would be an acquisition. "We turn sets of standard Ingres servers into a massively parallel database," he said. "We haven't done anything to Ingres, apart from tuning it for the workload, but we have managed to wrap tightly around it without hooking into the database itself."

Okay, so you have to consider the source; Stuart Frost is obviously going to champion this deal and paint DatAllegro as the best choice. But then there's this opinion from independent analyst Curt Monash, who has been writing on this topic for quite a while in his blog, DBMS2. "DatAllegro was one of the best fits for either Microsoft or Oracle," says Monash. "The architecture basically builds an MPP data warehouse using a regular OLTP, general-purpose DBMS as a subsystem. There are two query optimizers. There's the DatAllegro query optimizer, which ships off SQL to the nodes where Ingres does its optimization for each node. This means it should be straightforward to swap out Ingres for SQL Server."

I'm no database developer, but as a journalist, I was schooled to trust that when three different sources tell you something, it's reliable information. Thus, I'll be surprised if it takes longer than a year (eighteen months, outside) to integrate DatAllegro, and I'm guessing it shows up in a SQL Server 2008 service pack or point release of some sort.Talking to Fausto Ybarra, Microsoft's director of SQL Server product management, I certainly didn't get the idea that the integration of DatAllegro's software for shared-nothing, massively parallel processing (MPP) with Microsoft SQL Server will take an eternity... Stuart Frost and independent Curt Monash also say it's a "straigtforward" proposition, and I believe them.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

News
How SolarWinds Changed Cybersecurity Leadership's Priorities
Jessica Davis, Senior Editor, Enterprise Apps,  5/26/2021
Commentary
How CIOs Can Advance Company Sustainability Goals
Lisa Morgan, Freelance Writer,  5/26/2021
Slideshows
IT Skills: Top 10 Programming Languages for 2021
Cynthia Harvey, Freelance Journalist, InformationWeek,  5/21/2021
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Slideshows
Flash Poll