RE: Informix vs. Oracle
PS. Off the subject ... Did you know that the Star index, that runs on the star scheme structure, has been patented by Redbrick, and cannot be used by anyone else. Oracle tried to copy Redbrick on this, and when it comes to star schemas, is still faster than the other DBMS's, but like you say, they all have pros and cons - I am also an Informix man. Very good technology (Redbrick that is). -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Wednesday, September 10, 2003 6:47 PM To: informix-list@iiug.org Subject: Re: Informix vs. Oracle 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. Such comparisons are inevitably biased because the people running it will not know enough about each product to let them shine. I know all the ones I've seen from Oracle shops have holes the size of lorries in their understanding of Informix, and vice-versa. Besides, both products have generally got ways of addressing most problems. I personally believe that IDS is more elegant architecturally and in solving OR issues than any other database, and it has better APIs, but Oracle is more widely supported. You probably need to do things like evaluate local support (I still find Informix support unbeatable, despite IBM's best efforts :o), costs, support for your specific requirements, etc. I think apart from indexing APIs (where IDS has the edge) and star schema support (where I think Oracle has an edge -- in the brochures, anyway!) most problems can be solved by both. I really wouldn't trust a comparison unless I'd done it myself, and I certainly wouldn't expect you to trust one that I'd done. sending to informix-list
Dirk Moolman wrote: >PS. Off the subject ... Did you know that the Star index, that runs on the star scheme structure, has been patented by Redbrick, and cannot be used by anyone else. Oracle tried to copy Redbrick on this, and when it comes to star schemas, is still faster than the other DBMS's, but like you say, they all have pros and cons - I am also an Informix man. > >Very good technology (Redbrick that is). > > ><snipped> > They'd better have very good attorney's too if they think they are going to enforce that patent. They'll have to sue every Fortune 500 company in America. And I've no doubt evrey other large organization in every other country too. I think the US Patent Office needs to stop taking psychotropic drugs. People, myself included, were building these things before Redbrick existed. If they try enforcement ... they deserve all the respect usually reserved for SCO and RIAA. -- 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)
Dirk Moolman wrote: > > PS. Off the subject ... Did you know that the Star index, that runs on > the star scheme structure, has been patented by Redbrick, and cannot be > used by anyone else. Oracle tried to copy Redbrick on this, and when it > comes to star schemas, is still faster than the other DBMS's, but like you > say, they all have pros and cons - I am also an Informix man. > > Very good technology (Redbrick that is). Not Informix, though? :o)
Daniel Morgan wrote: > Dirk Moolman wrote: > >>PS. Off the subject ... Did you know that the Star index, that runs on >>the star scheme structure, has been patented by Redbrick, and cannot be >>used by anyone else. Oracle tried to copy Redbrick on this, and when it >>comes to star schemas, is still faster than the other DBMS's, but like you >>say, they all have pros and cons - I am also an Informix man. >> >>Very good technology (Redbrick that is). >> >> >><snipped> >> > They'd better have very good attorney's too if they think they are going > to enforce that patent. They'll have to sue every Fortune 500 company in > America. And I've no doubt evrey other large organization in every other > country too. > > I think the US Patent Office needs to stop taking psychotropic drugs. > People, myself included, were building these things before Redbrick > existed. If they try enforcement ... they deserve all the respect > usually reserved for SCO and RIAA. I think you might have missed the point: RedDick didn't patent star schemas, just a particular indexing technology that supports it. Having said that, I fully agree what you said about USPO... :-)