Re: Comparison of DB2 and Oracle?
Date: Thu, 21 Oct 2004 18:32:57 -0700
Message-ID: <1098408725.257338_at_yasure>
Comments in-line.
michael newport wrote:
> Daniel,
>
> in Ingres I wrote 4GL, in Oracle I write PL/SQL
Because you don't know how to write Java in the database?
> in Ingres I wrote SQL, in Oracle I write SQL
Because you don't know how to write Java in the database?
> in Ingres I ran an overnight batch from a Unix cron job, in Oracle I
> schedule a dbms_job
Or dbms_scheduler
Or UNIX cron job
Or AppWorx
Or any one of a large number of other possible solutions.
> in Ingres my results went to a database table, in Oracle my results go
> to a database table
I'm impressed.
> in Ingres I wrote a user parameterized report, in Oracle I write a
> user parameterized report
Similarly impressed.
> in Ingres I ran the report with a system call, in Oracle I use Oracle
> Reports server (with all its nasty bugs)
Then you made a horrible choice of reporting software.
> Ingres is free, Oracle is not
>
> did I miss something ?
>
> Regards
> Michael Newport
What did you miss?
- Security model
- Scalability
- Performance
- Shared Everything Architecture
- RAC
- DataGuard
- RMAN
- User defined indexes
- User defined operators
- User defined locking
- Domain indexes
- Reverse-key indexes
- Compressed indexes
- Function based indexes
- Sequences
- User defined data types
- Partitioning and Subpartitioning
- Global Temporary Tables
- External Tables
- Index Organized Tables
- Enterprise level support 7x24x365
- Books at Amazon.com (Oracle 27,707 hits, DB2 1,955 hits, Ingres 0 hits if refering to your product)
- Jobs at Dice.com (Oracle 8,097 jobs, DB2 1,779 jobs, Ingres 18 jobs)
- Jobs at Monster.com
- Jobs at Hotjobs.com
- Packages
- Native compilation into C of PL/SQL
- TAF (transparent application failover)
- A prayer the product will still exist in 10 years.
I think I've made my point.
If you want a more valid comparison ... compare Ingres to MySQL, PostgreSQL, Firebird, 3x5 cards. The difference will still be more books, more jobs, and more chance it will survive 5 years.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Fri Oct 22 2004 - 03:32:57 CEST