Re: V�hody Oraclu v��i Informixu
English please.... -- ======================================================== == Claassen Arvid ========== Antwerp University ======== === Dorpsstraat 17 ======== 2nd Lic Comp. Sciences. ==== ==== B-2070 Burcht ======= arvid.claassen@uia.ua.ac.be = ===== Belgium =========== 0032-3-252.91.79 (TEL/FAX)==== ======================================================== Veverka Martin <Martin.Veverka@tconsult.cz> schreef in artikel <912356AFCBCFD111BE260060972F435F106107@treska.tconsult.cz>... > 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 > > --------------------------------------------------------- > >