Results 1 to 4 of 4

Thread: difference between db2 & oracle

  1. #1
    Junior Member
    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.


  2. #2
    Junior Member
    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


  3. #3
    Expert Member
    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


  4. #4
    Junior Member
    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact