RE: Why is Oracle unaffordable?

Sql*server is "nice", but it doesn't have a lot of the fault tolerance and 
features of Oracle.


Can you expand on this idea? what fault tolerant features distinguish the two?

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Goulet, Richard
Sent: Monday, November 08, 2010 6:51 AM
To: RP Khare; oracle-l@xxxxxxxxxxxxx
Subject: RE: Why is Oracle unaffordable?

Rohit,

    It has been used for that purpose too, matter of fact I don't think that 
any current db hasn't been tried as an embedded db at one time or the other.  
Some worked well in a particular application some didn't.  Depends on your 
definition of "works well".  Personally I would not use Oracle as an embedded 
DB.

    On the other hand, what Oracle costs has been debated for a number of 
years.  Oracle XE is the latest response to that complaint and I think it is 
very well received in the market place, like Microsoft SQL*Server CE.  As for 
having a "high paid" dba around to maintain Oracle, you might get away without 
having one, but you should have someone you can call on when Murphy strikes.  
Seems we had a similar situation with a SQL*Server install on a "retired" 
desktop the other day, expanded the transaction log to the point where the 
available space on the disk drive was zero.  As the boss says, anyone can run 
setup.



Dick Goulet
Senior Oracle DBA


________________________________
From: RP Khare [mailto:passionate_programmer@xxxxxxxxxxx]
Sent: Monday, November 08, 2010 9:20 AM
To: Goulet, Richard; oracle-l@xxxxxxxxxxxxx
Subject: RE: Why is Oracle unaffordable?
Dick,


What about BerkelyDB? I think it is meant to be an embedded DB?

________________________________
Subject: RE: Why is Oracle unaffordable?
Date: Mon, 8 Nov 2010 09:14:09 -0500
From: Richard.Goulet@xxxxxxxxxxx
To: passionate_programmer@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Rohit,

    There is an old saying that "one gets what one pays for".  That goes for 
database software as well.  Sql*server is "nice", but it doesn't have a lot of 
the fault tolerance and features of Oracle.  MySql is a toy that got promoted 
to something it was never designed for.  BerkelyDB is similar, it was designed 
for small projects, but then got promoted to larger things.  DB2 and Oracle are 
"similar" in robustness though feature sets are different as well as packaging. 
 PostgreSql is somewhere between Oracle and SQL*Server, though a lot closer to 
Oracle.

    The bottom line is that a db is dependant on what you the developer want.  
If your looking for an imbedded DB, then I suggest you try a Google search, or 
possibly a visit to your local bookstore.   I will agree that as an embedded db 
Oracle is a poor choice and there are a number of better ones out there, but 
many lack the recoverability, flexibility, and possibly ACID compliance of 
Oracle, but then maybe you don't need that.  We have one application designed 
to reside on a laptop that uses the Java Based Apache Derby database which is 
open source.  Fits nicely on a 8GB memory stick.

Dick Goulet
Senior Oracle DBA


________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of RP Khare
Sent: Monday, November 08, 2010 4:31 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Why is Oracle unaffordable?
Hi,

I don't want to initiate a religious war. I have been using MySQL since last 
two years in production environment. I used SQL Server Express and Oracle 
Express before. I have no complaints with either of the databases, except that 
Oracle is over expensive and the architecture is unnecessarily complicated. I 
want to know whether the complexity of the Oracle architecture and its ever 
demanding need for a dedicated DBA is worth paying or not.  If you are an 
Oracle disciple, I don't want to hurt you and my views here are totally 
unbiased.

I need an embedded database for a shrink-wrapped application. I looked around 
for the alternatives. I read about SQL Server CE, SQL Anywhere and BerkleyDB. I 
want to try BerkleyDB, but the prices are too high. You could afford and 
enterprise class IBM DB2 or Sybase Adaptive Server or SQL Server with a far 
lesser amount.


Oracle is a good product but it is beyond the reach of customers other than big 
giants who pump in too much money just to keep those DBAs happy, who sit around 
that black dump command line screen. Why it can't be GUI and simple and 
affordable?


...............
Rohit.








Other related posts: