RE: Informix vs. Oracle

Hi, it seems that Martin is not about to translate his message so this is my attempt. I don't know Oracle at all but it sounds interesting (and the Czech original is much better than this translation :-) Vasek Martin wrote: We migrate from Informix to Oracle and find that Oracle has great advantages. 1. Oracle's stored procedure language PL/SQL is much more powerfull and run-time effective than Informix's SPL. 2. The area of transactions and simultaneous accesses is much better solved in Oracle: - Oracle has so called mutiversion records; it means that every of simultaneous transactions has its own version of data. If transaction B is trying to read a record being modificated by transaction A at the same time then B will get the original version of data. In Informix B has to wait for unlocking (the end of transaction A). Informix's solution leads to worse throughput and response time. - Informix misses the isolation level 'SERIALIZABLE' defined in SQL92. This isolation level simplifies a OLTP application developing in Oracle compared with Informix. 3. Oracle keeps SQL92 in a higher degree. > -----Original Message----- > From: Veverka Martin > Posted At: Monday, August 10, 1998 10:31 AM > Posted To: comp.databases.informix > Conversation: Informix vs. Oracle > Subject: V'hody Oraclu v''i Informixu > > My tak' p'ech'z'me z Informixu na Oracle a zji''ujeme, 'e Oracle > m' oproti Informixu zna'n' v'hody. > > 1. Jazyk ulo'en'ch procedur Oraclu PL/SQL je daleko daleko mocn'j'' > a jeho prov'd'n' v'kon'j'' ne' SPL v Informixu. > > 2. Oracle m' daleko l'pe vy'e'enu problematiku transakc' a > konkuren'n'ho p''stupu > - Oracle disponuje tzv. multiverzn'mi z'znamy, co' znamen', 'e ka'd' > sou'asn' b''c' > transakce m' svou vlastn' verzi dat. Kdy' transakce A aktualizuje > z'znam a transakce B se > pokus' z'znam ''st, z'sk' p'vodn' verzi dat. V Informixu by transakce > B 'ekala na odem'en' > z'znamu transakc' A, co' znamen' jej' ukon'en'. Propustnost syst'mu i > doba odezvy jsou tak > p'i pou'it' Informixu sn''eny. > - V Informixu chyb' izola'n' 'rove' SERIALIZABLE, jak ji definuje > standard SQL92. Tato 'rove' > zjednodu'uje tvorbu OLTP aplikac' v Or'clu v''i Informixu. > > 3. Oracle o n'co l'pe ct' ANSI standard SQL92 > > Martin Veverka > TurboConsult s.r.o. > > > -----P'vodn' zpr'va----- > Od: hause011@garnet.tc.umn.edu (Steven Hauser) > [SMTP:hause011@garnet.tc.umn.edu] > Vystaveno na: 4. srpna 1998 18:57 > Vystaveno v: comp.databases.informix > Konverzace: Informix vs. Oracle > P'edm't: Re: Informix vs. Oracle > > Going from Informix to Oracle is a painful experience. Oracle > has a > collection of old utilities that are clearly cobbled together > scraps > of code. SQL optimizer analysis is one example utility that > Oracle sucks at. > > Informix has a cleaner architecture that has a better mental > model of > how things are happening. > > In my experience, if a goal is performance an Informix > installation will achive > it easier and scale better than the arcane 'tuning' needed with > Oracle. > -- > > --------------------------------------------------------- > Steven Hauser, hause011@tc.umn.edu > Phone: (612)626-7135 > Fax: (612)625-6853 > ---------------------------------------------------------