GeekInterview.com
Results 1 to 4 of 4

difference between db2 & oracle

This is a discussion on difference between db2 & oracle within the Databases forums, part of the category; hi what the difference between DB2 and Oracle? what are fetures in DB2 not in Orcale viceversa. i am beginer to db2....

  1. 06-12-2008 #1
    shreeram
    shreeram is offline Junior Member Array
    Join Date
    Jun 2008
    Answers
    1

    difference between db2 & oracle

    hi

    what the difference between DB2 and Oracle?
    what are fetures in DB2 not in Orcale viceversa.
    i am beginer to db2.

    Reply With Quote Reply With Quote
  2. 09-07-2008 #2
    ganesh.qwe
    ganesh.qwe is offline Junior Member Array
    Join Date
    Sep 2008
    Answers
    5

    Re: difference between db2 & oracle

    db2 will give more security than oracle because it is a subsystem and it will embeded with in the technology which we r using

    Reply With Quote Reply With Quote
  3. 03-08-2012 #3
    Sandhya.Kishan
    Sandhya.Kishan is offline Expert Member Array
    Join Date
    Mar 2012
    Answers
    208

    Re: difference between db2 & oracle

    Some differences are
    >DB2 is used generally at mainframe systems. Oracle is handy on distributed system.
    >Oracle directly supports a Java application server where you can deploy Java servlets while with DB2 you would need to employ a Java translator like Tomcat.
    >Oracle is Twice as Expensive as DB2

    Reply With Quote Reply With Quote
  4. 05-31-2012 #4
    amycompton
    amycompton is offline Junior Member Array
    Join Date
    May 2012
    Answers
    18

    Re: difference between db2 & oracle

    Both databases are very stable and efficient, with wide support on Windows-based and Unix-based platforms.. with some minor differences..
    -DB2 requires more Memory
    -Oracle leads DB2 in transaction Benchmark testing
    -Oracle is Twice as Expensive as DB2


    * Minimum Hardware

    Oracle 9i 128 MB RAM Minimum, 140 MB Hard Drive space Min
    DB2 v8.1 256 MB RAM Minimum, 100 MB Hard Drive space Min


    * Benchmark Testing

    Oracle beat DB2 in TPC transaction benchmarks


    * Price

    Oracle $15,000 Standard Edition, $40,000 Enterprise Edition
    DB2 $ 7,500 Standard Edition, $25,000 Enterprise Edition


    * SQL Differences

    Oracle Function-based indexes, Domain indexes
    DB2 Block indexes, Dimension block indexes

    Reply With Quote Reply With Quote
    •    Sponsored Ads


« I need some help with Microsoft Access 2003 | ques »