20 Nov 2006
Open source databases can save enterprises up to 60 per cent over proprietary products, according to data collected by Forrester Research.
Noel Yuhanna, a senior analyst at Forrester covering database management systems, estimated that average savings on the total cost of ownership are about 50 per cent. The data is based on surveys and customer interviews.
Open source databases such as Enterprise DB, Ingres and MySQL do not carry licence fees, and management tools tend to be less expensive than for proprietary databases from Oracle, Microsoft and IBM.
Open source offerings especially outshine their proprietary competitors in low-end applications with databases of less than 200GB in size.
"Eighty per cent of the applications typically use only 30 per cent of the features found in commercial databases," Yuhanna told vnunet.com. "The open source databases deliver those features today."
But the open source databases generally lack the features for mission critical applications, trailing behind their proprietary peers in security, uptime, performance and features such as XML support.
Enterprise applications from Oracle and SAP also do not support open source databases today, but Yuhanna expects that to change "within a couple of years".
Open source database vendors typically do not position their products as low-cost alternatives.
Dave Dargo, chief technology officer at Ingres, said earlier this year in an interview with vnunet.com that the company is looking at new ways to deliver and deploy software rather than trying to compete with Oracle on price.
But customers still consider price as the primary benefit of open source, according to Yuhanna.
"The number one reason why any customer would choose an open source database is cost. That still holds true today," he said.
But the low price is also enabling companies to set up new projects that would previously have been too expensive, such as data mining of log files and setting up data repositories.
In an attempt to fend off the competition from low-cost open source databases, Oracle launched a free database last year that is essentially a scaled down version of its enterprise grade Oracle Database 10g.
The application targets test deployments for developers and students rather than enterprises.
Latest stories from Open Source
Related articles
Related jobs
Poll
What is the most important IT priority for your company this year?
Hands on with the highly anticipated Android 4.0 Ice Cream Sandwich hybrid tablet
Connect with V3.co.uk
This paper focuses on a series of best practices and techniques for development teams looking to improve their software development processes
Why good data management at all levels is essential in the modern business (video, 6mins)
/ Corporate Account Manager / Management Consultant...
Prince 2 Project Management Professional, Client Facing...
Solution Architect / Technical Project Manager / Corporate...
Solution Architect / Technical Project Manager / Corporate...
Keep up to date with the latest products, services and technologies from the world's leading IT companies. IThound.com brings you over 2,000 white papers, case studies and analyst reports.
Do you agree?
60% cheaper for who...
I don't see how it would necessarily be cheaper in most cases, unless you operate on a shoe string and can't afford support or license fees, or run a technology company were your IT guys are spending time coding to make up for all the missing features. The article claims that open source DB's are more economical for lower-end applications. Low-end Oracle or SQL Server licenses, which is probably the equivalent here, cost around 4k/chip with about 1k for annual support. Gold support for EnterpriseDB is 3k, so basically in a 3 year comparison: pay 9k for EntDB or 7-9k for an Oracle or SQL Server license. The only scenario where I see true economic advantage is when a company just needs basic DB features and uses lots of CPU's... as proprietary "enterprise edition" level DB's will cost more. Also, keep in mind that you still have to pay a DBA, a developer, buy servers and storage. License cost is a small fraction of the overall cost of a RDBMS. I've seen companies spend millions on high end storage and comparatively a miniscule sum on low-end Oracle DB's simply b/c they had no ILM strategy.
Posted by: Dominik Zynis 29 Dec 2006
Yepper
PostgreSQL - free for enterprise. EnterpriseDB - not free, but much easier to convert from Oracle too and you've got somebody to yell at when in trouble. MySQL - not free for enterprise. Read the license. Fire whaterver (isnt' that the old borland thing) - not as good as PostgreSQL, study the guts of the two to learn why. Here's a tip, look at scalability stuff, like management of memory/cpu's/drives, queries (ANSI support), indexing, fault tolerance, parallel servers, back up strategies, triggers, stored procedures, should I keep going?
Posted by: Chicago Kahuna 11 Dec 2006
No license fees for MySQL ?
MySQL as license fees. There are just a few OS databases enterprise-ready that are free for any use. A good example is Firebird.
Posted by: Artur 24 Nov 2006
About Ingres
Not so long ago, Ingres would have been one of those proprietary databases providing features that open source didn't have - now it's one of the open source databases that can't compete in mission critical applications. So.... which is it? Can't be both... It also seems to me that PostgreSQL isn't mentioned and gets short shrift.
Posted by: David 23 Nov 2006
Max DB is a joke
RE: More Linux MySQL isn't even developing MaxDB. Instead it took al the database's nice features and put it in long term storage. Nobody is deploying it for new applications anymore.
Posted by: pete 22 Nov 2006
Correction
I do not wish to indulge in flame wars, but couldn't help correcting: EnterpriseDB is a proprietary "fork" of PostgreSQL, It's a "parallel". EDB adds features on top of PGSQL features, always maintaining compatability with latest PostgreSQL. You can have access to PostgreSQL source code, but not to EnterpriseDB source code. Posted by: Christopher Browne, 21 Nov 2006 You can get the source code if you opt for a Platinum technical support package.
Posted by: Gurjeet Singh 22 Nov 2006
EnterpriseDB is *not* Open Source
Even though it is built on top of PostgreSQL (which is licensended under the BSD License), EnterpriseDB contains proprietary extensions which are not available as Open Source Software. So calling EnterpriseDB an OSS RDBMS is simply misguiding.
Posted by: OSSAdvocate 22 Nov 2006
Just like to add Firebird & Fyracle into the mix
Firebird is not mentioned in the article as an opensource database. It has an Oracle emulator (fyracle), allowing OS Compiere (sp) CRM package to hook up as if it were talking to Oracle. Lots of vertical market companies are using FB. Features: Triggers, record versioning, writers do not block reads and reads don't block writes, live backup, stored procs.....
Posted by: Jason Chapman 21 Nov 2006
But do they have all the features I need.
The question is not "Do I need all those features?" the question is "Does it have all the features I need?" Do all users not use the same 30% group of features? I doubt it.
Posted by: Steve Holle 21 Nov 2006
Where's the Beef??
Pretty weak; as is usual for this sort of article. No real details on how they counted the support costs. Also (as common in these articles) NO CASE STUDY of an enterprise-critical implementation with specifics on who provided 24x7x365 support; along with how much it cost, and anecdotes of when the support was used, how responsive the company was, and how good the tech actually was. NO large company will take FOSS DB's seriously until ther e are some stable support options available.
Posted by: Anon 21 Nov 2006
Get the facs right!!!
SAP does support a open source database. It's called MaxDB and it's 100% open source. Have a look at http://www.mysql.com/products/maxdb/
Posted by: More Linux 21 Nov 2006
EnterpriseDB not "Open Source"
EnterpriseDB is a proprietary "fork" of PostgreSQL, which definitely is "open source." You can have access to PostgreSQL source code, but not to EnterpriseDB source code.
Posted by: Christopher Browne 21 Nov 2006