The Channel logo


By | Philip Howard 24th March 2005 15:23

Ingres and Open Source - a success story

Robustness, performance, scalability

I have espoused the cause of Ingres for some time and, especially, I have commended Computer Associates' decision to take the Ingres database into the open source community.

Now, I dare say that at some point CA will tell me all about its "open source challenge" and how successful that has been in developing new facilities for Ingres. And they will also tell me about how many downloads there have been (though I am cynical about the utility of such a figure). But this article is about one company, Datallegro, which has adopted Ingres as its database.

Datallegro is a vendor in the data warehouse space that develops and markets an appliance–based solution. That is, a combination of hardware and software similar in concept (if not in method) to that which underpinned the original development of Teradata. The company is headed up by Stuart Frost, who was the founder and CEO of Select Software and subsequently chairman of Avellino.

Datallegro is an open source based product to the extent that it runs on Linux and uses Ingres as its database. However, it wasn't always like that. Originally, it was developed using MySQL. For performance reasons, this was quite quickly replaced with PostgreSQL. Bear in mind that at this time, Ingres was not available as an open source product. When it became available, Datallegro evaluated Ingres and rapidly made the decision to jump ship from PostgreSQL to Ingres (not too difficult, as they share common origins). This says quite a lot about the relative robustness, performance, scalability, and so on of MySQL versus PostgreSQL versus Ingres.

You would not normally mention Ingres and data warehousing in the same breath, yet Datallegro has tuned the product up to the extent that it is offering one of the best (the best if you listen to Datallegro, but I'll hedge my bets until some benchmarks have been published) price/performance offerings on the market.

The key to this is that the core functionality and the architecture were already in place within Ingres (not to mention flexibility), on which Datallegro has been able to build. What is more, it is clear from talking to Datallegro, just how committed CA is to open source.

Stuart Frost is extremely complimentary about the help that CA has provided throughout the company's developments, describing it in superlative terms. That is good to hear and should be music to the ears of any other companies thinking of taking on major developments in conjunction with CA and Ingres. ®

© 2005

Related stories

Mixed blessings for Informix users
Sun could quell database hunger with Unify buy
Ingres: the forgotten database

alert Send corrections


Frank Jennings

What do you do? Use manual typwriters or live in a Scottish croft? Our man advises
A rusty petrol pump at an abandoned gas station. Pic by Silvia B. Jakiello via shutterstock

Trevor Pott

Among other things, Active Directory needs an overhaul
Baby looks taken aback/shocked/affronted. Photo by Shutterstock

Kat Hall

Plans for 2 million FTTP connections in next four years 'not enough'
Microsoft CEO Satya Nadella


Suit-and-tie-wearing man tries to meditate, take deep breaths in faux yoga pose. Photo by Shutterstock
Emotional intelligence, not tech skills, is the way to woo suits
League of gentlemen poster - Tubbs and Edward at the local shop. Copyright BBC
One reselling man tells his tale of woe