Re: Informix vrs Oracle 7.0.x or 7.1.x

In <2tfedc$5cs@marlin.ssnet.com>, jminnich@bugaboo.ssnet.com (Joe Minnich) writes: >How does informix compare to Oracle 7. We are currently >beginning an evaluation. Feedback would be greatly >appreciated. > Informix-OnLine 6.0 and 7.0 (7.0 is currently only for Sequent) This is probably one of the strongest database systems ever build. Advantages: - Real PDQ - Extreme fast (best TPC-C benchmarks ever) - Best technology today and for the future (especially with Informix-OnLine 7.0) - Client/Server facility already build-in (no additional costs) (STAR and NET are embedded) - DRDA facility (for DB2 /MVS hosts) - ODBC support - Future upwards compatibility (upwards compatible with 7.0 and further) Disadvantages: - Limited number of Graphic point tools available. - Limited number of Gateways available. - Limited CASE support (but growing very fast). - Limited Novell NetWare support (only version OnLine 4.11) - 4GL is clumsy on GUI (this will change rapidly with Object Oriented 4GL) Oracle 7 & 7.1: (Oracle 7.1 is the PDQ version of 7.0) Advantages: - Industry accepted DBMS - Major CASE vendors supports Oracle - A lot of gateways available - A lot of DBA tools available (due lack of good Oracle's own DBA tools) - ODBC support - Full Novell NetWare support (Oracle is committed to support it) - A lot of experienced Oracle programmers/software houses in the field Disadvantages: - Not real PDQ - Sometimes slower than Oracle 6 (!) - Sometimes difficult DB administration - You require additional software for Client/Server applications. - Compatibility issues (the version number must match, otherwise...) - Oracle centric (not very 'open' to other vendors) Regards, Rony