Re: Informix vs. Oracle

Posted in 2003

Topics: Clustering, Grid & MACH11, Java & JDBC Development, Third-Party Tools & Monitoring

Daniel Morgan — Wed, 10 Sep 2003 16:34:52 -0700 — source: Usenet: comp.databases.informix

ky wrote: >I'll ask the age old question, can anyone direct me to some Informix >vs. Oracle comparision information? I am looking for something as >concise as possible but with good content. Thanks in advance. > > I'm going to partly agree with Obnoxio in that any comparison you find will be biased based on the company that paid for it or the experience of the authors: Usually both. The other thing that is critical is that comparisons are only valid for the specific functionality being evaluated. So, for example, are you buying the RDBMS for an OLTP system? Or a data warehouse? A finance system? Which one? How many users? How large? What transaction volume? What security requirements? Web front end? What third-party tools? Do you need remote management capabilities? Clustering? Are you interested in mapping and spatial relationships? document management? XML? Java? C? Fortran? What hardware? What operating system? What experience do you and your team have? The architecture differencees between Informix and Oracle are huge and not something that can easily be glossed over unless you like to make large expensive messes? Even something as simple as the need for a specific security capability can push one in a specific direction even if the product is slower or more expensive or whatever. Every product can not be the best at everything. You've not given anyone a clue as to what your requirements really are making it hard even to point you to a biased whitepaper. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)

↪ replying to Daniel Morgan

Obnoxio The Clown — Thu, 11 Sep 2003 07:53:01 +0100 — source: Usenet: comp.databases.informix

Daniel Morgan wrote: > ky wrote: > >>I'll ask the age old question, can anyone direct me to some Informix >>vs. Oracle comparision information? I am looking for something as >>concise as possible but with good content. Thanks in advance. >> >> > I'm going to partly agree with Obnoxio in that any comparison you find > will be biased based on the company that paid for it or the experience > of the authors: Usually both. > > The other thing that is critical is that comparisons are only valid for > the specific functionality being evaluated. So, for example, are you > buying the RDBMS for an OLTP system? Or a data warehouse? A finance > system? Which one? How many users? How large? What transaction volume? > What security requirements? Web front end? What third-party tools? Do > you need remote management capabilities? Clustering? > > Are you interested in mapping and spatial relationships? document > management? XML? Java? C? Fortran? What hardware? What operating system? > What experience do you and your team have? The architecture differencees > between Informix and Oracle are huge and not something that can easily > be glossed over unless you like to make large expensive messes? > > Even something as simple as the need for a specific security capability > can push one in a specific direction even if the product is slower or > more expensive or whatever. > > Every product can not be the best at everything. You've not given anyone > a clue as to what your requirements really are making it hard even to > point you to a biased whitepaper. Oh, go on -- I want to know about all of those... :o)