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:
stave offI 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
the interest in MS SQL. Given the budget pressures at manyorganizations,
I'm surprised we don't hear more about this alternative.transactionnal
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
applications also.<mailto:[EMAIL PROTECTED]>
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]
-- 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).