oracle is still the only one out there that has multi-version read consistency? I thought postre-gre sql had it? anyone else? everyone has row level locking right? > > From: Mogens N�rgaard <[EMAIL PROTECTED]> > Date: 2003/09/08 Mon AM 01:09:25 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: DB2 has a foot in the door > > Cost is the easy one. They run comparable to Microsoft or thereabout. > They have various options I haven't looked at yet, that might make them > more expensive than that. The DB2 on mainframes and the DB2 on Unix, for > instance, were written by different teams. Which might explain why they > didn't port the time-based instrumentation from the mainframe > environment to the Unix port. So yeah, you probably can't just take code > and move it. They have a pretty good porting tool between Oracle and > DB2, though. We thought that was rather neat when we ran it against one > of our customer's database definitions. The PL/SQL conversion came out > alright, too, although there of course are things they can't do and vice > versa. > > Broadly speaking, I think you can divide the databases of the world into > three categories: > > 1. Oracle, with very good locking strategies, very good read consistency > model, very good performance measurement instrumentation (time-based). > 2. Other relational databases such as DB2, Sybase, SQL Server, Informix, > etc. where they all share the same (to us Oracle-techies) strange > locking philosophy, the same consistency model where you have to code > more, and no wait-interface. > 3. The rest. > > re 2: The locking philosophy difference means that you can still have > readers block writers and writers block readers, unless you specifically > handle how to do it on the transactional level. This explains why > cloning databases for reporting purposes is so popular with other > databases compared to the Oracle world :). > > IBM has pointed out in various whitepapers something which to us doesn't > make sense, but which might make sense to others: If you want to have a > portable application, you should probably choose one of the category II > databases, since they're all pretty much alike in their behaviour on the > important aspects of locking and read consistency. If you have to go to > or from Oracle to or from another database, you'd have to change code a > good deal or live with non-optimal conditions after the migration. > > Mogens > > > Tom Ryan wrote: > > >have you used DB2? How does it compare to Oracle? Ive seen tom kyte write > >that each platform that DB2 runs on is in essence a different database and > >you cant take code from one platform and move it to another. > > > >are the features comparable? what about cost? > >----- Original Message ----- > >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > >Sent: Sunday, September 07, 2003 8:54 AM > > > > > > > > > >>VERY interesting. They refused to do site licensing at a 20000 > >>installation here. Thank you for this tip. > >> > >>Rachel Carmichael wrote: > >> > >> > >> > >>>Oracle does site licensing... but only if you are a very very large > >>>corporation. Citibank (when I worked there) had one. The company I work > >>>for now has one. > >>> > >>>So I don't ask "do we have a license" when I want to install a new > >>>version of Oracle, even if it is a new platform > >>> > >>>One of the few things that is easier working in a rigid corporate > >>>environment > >>> > >>> > >>>--- Mogens_N�rgaard <[EMAIL PROTECTED]> wrote: > >>> > >>> > >>> > >>> > >>>>There's one thing that IBM can do, which Microsoft and Oracle can't > >>>>offer: They do site licenses as well as cpu and user licensing. That > >>>>just gives them an incredible advantage to management and others who > >>>>can > >>>>stop thinking about whether they should buy another server, move > >>>>stuff > >>>> > >>>> > >>>>from one server to the other, etc. I can't believe Oracle and > >>> > >>> > >>>>Microsoft > >>>>are not doing it (I think I can guess, but it's still not good). > >>>> > >>>>Mladen Gogala wrote: > >>>> > >>>> > >>>> > >>>> > >>>> > >>>>>I believe that the answer to Stephane's question is obvious: > >>>>>Oracle 10g will cost 10 grands/ CPU. That's where the letter "g" > >>>>>is coming from. > >>>>> > >>>>>-- > >>>>>Mladen Gogala > >>>>>Oracle DBA > >>>>> > >>>>> > >>>>> > >>>>>-----Original Message----- > >>>>>DENNIS WILLIAMS > >>>>>Sent: Friday, September 05, 2003 5:30 PM > >>>>>To: Multiple recipients of list ORACLE-L > >>>>> > >>>>> > >>>>>Stephane > >>>>> We've been very excited about Oracle Standard Edition. Helped > >>>>> > >>>>> > >>>>> > >>>>> > >>>>stave off > >>>> > >>>> > >>>> > >>>> > >>>>>the interest in MS SQL. Given the budget pressures at many > >>>>> > >>>>> > >>>>> > >>>>> > >>>>organizations, > >>>> > >>>> > >>>> > >>>> > >>>>>I'm surprised we don't hear more about this alternative. > >>>>> > >>>>>Dennis Williams > >>>>>DBA, 80%OCP, 100% DBA > >>>>>Lifetouch, Inc. > >>>>>[EMAIL PROTECTED] > >>>>> > >>>>> > >>>>>-----Original Message----- > >>>>>Sent: Friday, September 05, 2003 4:09 PM > >>>>>To: Multiple recipients of list ORACLE-L > >>>>> > >>>>> > >>>>>Hi all, > >>>>> > >>>>>We're an Oracle shop, over 140 Oracle instances. > >>>>>Today, architecture has chosen IBM DB2 for BI projects. > >>>>>The next step I guessed will be to choose DB2 for the new > >>>>> > >>>>> > >>>>> > >>>>> > >>>>transactionnal > >>>> > >>>> > >>>> > >>>> > >>>>>applications also. > >>>>> > >>>>>IBM offers DB2 at 25% less than Oracle. > >>>>> > >>>>>I wonder if Oracle 10G will come with a new pricing structure ? > >>>>> > >>>>> > >>>>>Stephane Paquette > >>>>>Administrateur de bases de donnees > >>>>>Database Administrator > >>>>>Standard Life > >>>>>www.standardlife.ca > >>>>>Tel. (514) 499-7999 7470 and (514) 925-7187 > >>>>>[EMAIL PROTECTED] > >>>>> > >>>>> > >>>>> > >>>>> > >>>><mailto:[EMAIL PROTECTED]> > >>>> > >>>> > >>>> > >>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>-- > >>>>Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>>>-- > >>>>Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > >>>> INET: [EMAIL PROTECTED] > >>>> > >>>>Fat City Network Services -- 858-538-5051 http://www.fatcity.com > >>>>San Diego, California -- Mailing list and web hosting services > >>>>--------------------------------------------------------------------- > >>>>To REMOVE yourself from this mailing list, send an E-Mail message > >>>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >>>>the message BODY, include a line containing: UNSUB ORACLE-L > >>>>(or the name of mailing list you want to be removed from). You may > >>>>also send the HELP command for other information (like subscribing). > >>>> > >>>> > >>>> > >>>> > >>>__________________________________ > >>>Do you Yahoo!? > >>>Yahoo! SiteBuilder - Free, easy-to-use web site design software > >>>http://sitebuilder.yahoo.com > >>> > >>> > >>> > >>> > >>-- > >>Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>-- > >>Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > >> INET: [EMAIL PROTECTED] > >> > >>Fat City Network Services -- 858-538-5051 http://www.fatcity.com > >>San Diego, California -- Mailing list and web hosting services > >>--------------------------------------------------------------------- > >>To REMOVE yourself from this mailing list, send an E-Mail message > >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >>the message BODY, include a line containing: UNSUB ORACLE-L > >>(or the name of mailing list you want to be removed from). You may > >>also send the HELP command for other information (like subscribing). > >> > >> > >> > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). >
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
