• 1 reply
  • Latest Post - ‏2012-04-16T15:08:51Z by SystemAdmin
1 Post

Pinned topic difference b/w oracle nd DB2

‏2012-04-03T18:58:49Z |
what is the exact powerful diffrence between ORACLE and DB2???
Updated on 2012-04-16T15:08:51Z at 2012-04-16T15:08:51Z by SystemAdmin
  • SystemAdmin
    5837 Posts

    Re: difference b/w oracle nd DB2

    Hard to tell since "powerful" depends on what you mean.

    For example, a "powerful" reason could be license cost or TCO costs. IBM states that DB2 is cheaper than Oracle.

    From a Oracle developer's point of view, Oracle is more powerful than DB2 because PL/SQL packages provided by Oracle and other nice stuff like Application Express.

    If you compare DB2 Express-C with Oracle XE, definitely DB2 is better since you have up to 2 cores, 4GB of RAM and unlimited database size. Is almost Oracle Standard One edition ($5,800 per CPU) for free, the only difference is that Oracle doesn't imposes RAM limit.

    RDBMS this days are commodities so normally is a matter of preferences.

    If customer/project has enough funding, I prefer Oracle because I been using it for more than a decade; If customer/project didn't, I use Firebird because, if hasn't money for licensing, surely hasn't for administration/maintenance and DB2 needs some body to take care of.

    I'm following DB2 Express-C because I eventually will need the features (scallability, XML, replication, etc.) and very low initial cost: zero.