Home » Comment » Currently Reading:

Open source server-based databases – a viable economic choice?

February 2, 2010 Comment

The choice of server-based databases has never been so interesting! As a champion of the open source movement Jonathan Westlake continually speculates about the open source database market and 2009 was particularly rich with events.

I use a number of open source offerings for my various University database modules but primarily the MySQL database for teaching/advising on server-based database development and administration. The appeal is the low cost approach and the use of MySQL as part of a Linux, Apache, MySQL, PHP (LAMP) platform where the database supports a web front end.

More recently, I have also looked at the PostgreSQL and Firebird open source alternatives (links at the end of this column) as an alternative to MySQL given the uncertainty over MySQL’s future. MySQL can be considered as an enterprise database as it has most the administration features (eg transaction handling such as rollback) common in proprietary products such as Oracle.

During 2009 we have had the added spice in that MySQL may now come under the umbrella of Oracle via the impending takeover of Sun Microsystems (awaiting European approval as at 14th Dec, 2009). Recent statistics indicate that open source server-based database use is rising and based on my personal experience I suggest the pros and cons include the following:

Pro

- Zero licence costs;

- Reduced maintenance charges;

- Open source products are now well established;

- MySQL often offered for web-hosting accounts.

Cons

- Mission critical or non-mission critical usage? Should an open source product be used for mission critical applications?

In conclusion, is MySQL now under threat from Oracle? Recent news suggests that Oracle has made reassurances about the future of MySQL as part of gaining final approval for the takeover of Sun from the European Commission.

Perhaps Oracle and MySQL (and any other open source database offerings) are different ‘horses for courses’ and as such represent choice for a business looking to service their database needs across their IT infrastructure.  The future of the server database market has never been more competitive and hopefully the European Commission will ensure that the choice remains with the business user and no one database vendor dominates.

www.staffs.ac.uk

Subscribe to the newsletter:

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Sign up for our Email Newsletter

Our Sponsors

Stay Connected

Bookmark and Share

Video

Features:

Doing more with less

August 16, 2010

Doing more with less

As the public sector cuts start to bite across the board, VitAL Magazine editor Matt Bailey speaks to West Lancashire Borough Council chief executive Bill Taylor MBE and finds out what one council in North West England can do with its IT in order to meet the challenge. It is certainly a time of upheaval, [...]

Greening the enterprise

August 16, 2010

Greening the enterprise

Kevin T McDonald, Washington USA-based senior information technology analyst and cloud strategist for ICF International Inc offers his perspective and strategies for greening your business. The planet has entered a new era where everything is on-demand. The public and private sectors are all in, with YouTube videos explaining everything, from how to play jacks to [...]

Entering the cloud

August 16, 2010

Entering the cloud

A timely and detailed guide as to how to embark on a cloud project, what to consider and how far to commit. John Rollason of NetApp heads into the cloud. Cloud computing is a reality, and it’s a force that I believe IT professionals need to come to terms with quickly. The economic motivation for [...]

What to do when you’ve been hacked

August 16, 2010

What to do when you’ve been hacked

As recent news reports prove, the problem of hacking is not going away, if anything it is increasing. Steve Smith, managing director of Pentura offers advice on what to do if you’ve been hacked. When your business discovers it has been hacked there are different mentalities on how to deal with it; for the Private [...]