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 > ---------------------------------------------------------