Re: Comparison of DB2 and Oracle?
Date: Fri, 22 Oct 2004 18:04:42 -0700
Message-ID: <1098493428.268975_at_yasure>
michael newport wrote:
> correction you thought that you had made your point...
>
> You can also use JAVA on Ingres.
>
> 1. Security model – same
> 2. Scalability - same
> 3. Performance - same
hardly
hardly
hardly
And if you disagree feel free to point me to the benchmarks that prove otherwise. Last time I looked at Ingres it had nothing even remotely approaching FGA and FGAC capabilities.
> 4. Shared Everything Architecture - equivalent
Nonsense.
> 5. RAC - equivalent
Pure rubbish. You need to get back on your medication. ;-)
> 6. DataGuard - equivalent
Send a link.
> 7. RMAN - equivalent
Not in your wildest imagination.
> 28. TAF (transparent application failover) - equivalent
Sorry but my contacts at CA say no such technology exists.
> 8. User defined indexes - same
Provide a link or demonstrate the Ingres syntax.
> 9. User defined operators - same
Provide a link or demonstrate the Ingres syntax.
> 10. User defined locking - nice but never needed
Your loss.
> 11. Domain indexes - nice but never needed
Your loss. But then you don't have full-text indexing as in Oracle Text and InterMedia so why have the domain indexes when you don't have the technology to use them.
> 14. Function based indexes - nice but never needed
Your loss.
> 16. User defined data types - same
In your dreams.
> 17. Partitioning and Subpartitioning - same
Nonsense.
> 18. Global Temporary Tables - same
Nonsense.
> 19. External Tables - same
Nonsense.
> 20. Index Organized Tables - same
Nonsense.
> 21. Enterprise level support 7x24x365 - same
For free. You've really got to stop smokin' that stuff.
> 22. Books at Amazon.com
> (Oracle 27,707 hits, DB2 1,955 hits, Ingres 0 hits if refering to
> your product)
> 23. Jobs at Dice.com
> (Oracle 8,097 jobs, DB2 1,779 jobs, Ingres 18 jobs)
> 24. Jobs at Monster.com
> 25. Jobs at Hotjobs.com
>
> I agree that Oracle wins on the job front but that will change.
> Would you rather keep your job and use Ingres ? or
> keep Oracle and have your job outsourced to India ?
More jobs for MySQL than Ingres. More jobs for PostgreSQL than Ingres.
My jobs not in danger. And if it was there are 8,097 possibilities for
me. You get to choose from 18. And it is no secret I will get paid
tens of thousands of dollars more each year with Oracle or DB2 than you
will with you open source (because we couldn't sell it to anyone) database.
>
> 26. Packages - like programs ?
You made up your answers to previous questions when you had no idea what the technology was so why ask a question now?
> 27. Native compilation into C of PL/SQL – never needed this
Apparently you've never built a real RDBMS application with tens of thousands of simultaneous users runnign 7x24x365. Perhaps Ingres is the right tool for you.
> 29. A prayer the product will still exist in 10 years. –
> now that Ingres is Open Source it will still be here, why,
>
> because its free
>
> for the few things that Ingres does not have, Oracle is not worth the money ??
>
> I know I have made my point !
>
> Regards
> Michael Newport
In a world with multiple open-source products only the best will survive. A category in which, alas, Ingres is not a player. The only reason Ingres is open-source is CA couldn't sell it. It has no real community support and will perish. Well no doubt there is someone out there using Advanced Revelation, RPG II, dBASE 4, etc. But they really are not players and that is where Ingres is going. Even FoxPro, as pathetic as Microsoft's marketing is, does better than Ingres.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sat Oct 23 2004 - 03:04:42 CEST