PostgreSQL | BigDataOnCloud + FreeDB2

Top 3 ways to return TOP 10 rows by an SQL query

Limiting amount of data returned by a database to an application is probably the easiest and the most effective way to improve performance your application. DB2 provides 3 ways of accomplishing this. You can use DB2 SQL FETCH FIRST n ROWS syntax. You can use SQL syntax of another DBMS like MySQL, Oracle or Sybase, or you can do this in a database independent way by using the capabilities provided by the database API you are using in your application code. [...]

Read …

Oracle kills Virtual Iron. Is MySQL next?

You can wait and see if Oracle will put MySQL on death row like it just did with Virtual Iron, or you can get ahead of the curve and start to plan for the alternatives like getting in touch with alternative MySQL support providers or take a look at DB2 Express-C and see if that is the right way for you to go. [...]

Read …

IBM may open source DB2

“IBM may open source DB2″ is the headline headline in today’s article by Tom Espiner on ZDNet.co.uk. The article is based on the interview with Chris Livesey, IBM UK director of information management. I posted a comment on the article but I figured I’d provide a more complete explanation here in the blog.

Before I get in to the details, I wanted to just reemphasize that what you are reading here is NOT an official IBM position but an opinion that is mine and mine alone.

If you follow this blog than you already know that that [...]

Read …