Comparison of DB2 and Oracle?

[DA Morgan]

Re: Comparison of DB2 and Oracle?

michael newport wrote:
[color=blue]
> Daniel,
>
> what do you do at the University of Washington ?
>
> nothing to do with education ?
>
> Regards
> Michael Newport[/color]

Teach databases something that might have interested you
once in your life.
--
Daniel A. Morgan
University of Washington
damorgan@x.wash ington.edu
(replace 'x' with 'u' to respond)

[Jim Kennedy]

Re: Comparison of DB2 and Oracle?


"michael newport" <michaelnewport @yahoo.com> wrote in message
news:63b202d.04 10250221.4ded17 ea@posting.goog le.com...[color=blue]
> http://tpc.org/information/other/articles/TopTen.asp
>
> The performance of databases is one issue, pricing is another. (Ingres
> is FREE)
>
> TPC results should not be used as a substitute for benchmarking of
> one's own application if performance is a critical decision criteria
>
>
> Michael[/color]
If this is the same Ingres I used awhile ago I wouldn't touch it with a ten
foot pole even if you paid me. The concurrency model sucks, start a
transaction, insert a record, lock 95% of the table if it has a primary
key - because the page locks on the index locks most of the pages. NO ONE
ELSE COULD GET ANY WORK DONE, unless you threw out the transaction model and
went to auto commit. POS.
Jim

[michael newport]

Re: Comparison of DB2 and Oracle?

Jim,

you said this before, but I have not had the problem.

Regards
Michael Newport

[michael newport]

Re: Comparison of DB2 and Oracle?

Hans,[color=blue][color=green]
> > development and maintenance costs are human factors.[/color]
>
> Yes! And they are onging.[/color]

If the analysis and /or programming is bad then these costs will be higher.
And do not forget, Oracle will charge you for a licence, this is ongoing.[color=blue]
>
> To reduce the total cost of a project over several years,
>
> Reduce development and maintenance costs,[/color]
Human.[color=blue]
> By writing and maintaining LESS code,[/color]
Human.[color=blue]
> By having more capability in the vendor's product,[/color]
The database market is saturated with capable products.
What does RMAN do that the OS does not ?
[color=blue]
> By using that capability.[/color]
Human.

[michael newport]

Re: Comparison of DB2 and Oracle?

HansF <news.hans@telu s.net> wrote in message news:<_68fd.2$d f2.0@edtnps89>. ..[color=blue]
> michael newport wrote:
>[color=green]
> >
> > So why buy Oracle when Ingres is free.[/color]
>
> If you use Oracle like you use Ingres, you are absolutely correct.[/color]

Its just a database. You use it as you need to, to do your job.
See previous post for comparisons on how to do this.
[color=blue]
> The implication is that accounting and shareholders or stakeholders (or
> wife) have not had a review of where time and money are going. Which is
> more toward keeping old technology alive than improving the business.
>[/color]
Human.
[color=blue]
> Which makes me worry about management and the viability of the organization.
> (Suggest you keep your resume polished ...)[/color]

Human.
[color=blue]
> Simplest example I can think of - Catalog the CD library & make it
> accessible using browsers:
>
> - Get Oracle DB (list price personal = US$400)
> - Install DB (1 hour, 'cause I read the instructions)
> - Install free HTML DB from companion disk (1 hour)
> - use HTML DB to create tables, Web pages (1 hour)
> for a tutorial, see http://www.oracle.com/technology/obe/index.html
>
> Steps in Ingres? Unless something sigificant has changed in the past 7
> years (last time I looked at it seriously) I suspect it takes a few
> additional pieces of software, including PERL ('cause we want to stay
> free), and a few additional hours.
>
> Of course, you _could_ use Oracle the same way as Ingres and code the
> solution in PERL or otherwise. But my wife prefers I send time with her
> instead of the computer, and these days I prefer to listen to the CDs than
> to code the catalog. (I listened when they said 'get a life' <g>)[/color]

Yes Ingres has changed significantly in the last 7 years.
It is also free.
That is $400 dollars saved.
Now imagine if you were a large company.

[michael newport]

Re: Comparison of DB2 and Oracle?

DA Morgan <damorgan@x.was hington.edu> wrote in message news:<109875219 3.942650@yasure >...[color=blue]
> michael newport wrote:
>[color=green]
> > I am now (1 year) working with Oracle and my work involves doing the
> > same stuff that I did with Ingres (see previous post).[/color]
>
> That's not the fault of the product. That direct and proximate
> responsibility falls on you for being a dinosaur. How much code have
> you implemented with bulk binding? How much with the model clause?
> How much with analytic functions? How many materialized views with
> refresh logs?[/color]

its answers the users needs.
and it was written by the dealine.
which meant my company got paid.
although some of this money was then sent to Oracle to pay for the
licence.
if we had used Ingres we could have done the same job for less, or
increased our profits.
[color=blue]
>
> Why not just admit that you have reached the point in your life
> where you want technology to stop and let you keep doing what you
> did in neolithic times.[/color]

If you are talking about Oracle report server, I will agree with you.
if you are talking about JAVA then you need to thank SUN not Oracle.
But technology for its own sake is a waste of money.

[michael newport]

Re: Comparison of DB2 and Oracle?

DA Morgan <damorgan@x.was hington.edu> wrote in message news:<109875222 6.378168@yasure >...[color=blue]
> michael newport wrote:
>[color=green]
> > Daniel,
> >
> > what do you do at the University of Washington ?
> >
> > nothing to do with education ?
> >
> > Regards
> > Michael Newport[/color]
>
> Teach databases something that might have interested you
> once in your life.[/color]

I am still interested, which is why we are having this discussion.
But rather than back a product because it has a particular brand,
I prefer a more realistic discussion of experience.

Have you ever used Ingres ?

[HansF]

Re: Comparison of DB2 and Oracle?

michael newport wrote:
[color=blue]
> HansF <news.hans@telu s.net> wrote in message
> news:<_68fd.2$d f2.0@edtnps89>. ..[color=green]
>> michael newport wrote:
>>[color=darkred]
>> >
>> > So why buy Oracle when Ingres is free.[/color]
>>
>> If you use Oracle like you use Ingres, you are absolutely correct.[/color]
>
> Its just a database. You use it as you need to, to do your job.
> See previous post for comparisons on how to do this.
>[color=green]
>> The implication is that accounting and shareholders or stakeholders (or
>> wife) have not had a review of where time and money are going. Which is
>> more toward keeping old technology alive than improving the business.
>>[/color]
> Human.
>[color=green]
>> Which makes me worry about management and the viability of the
>> organization. (Suggest you keep your resume polished ...)[/color]
>
> Human.
>[/color]

What you consider Human, I consider time diverted _from_ Human activity such
as spending time with my wife and family. Instead, I'd be coding to
account for those pieces missing. After all, per your previous post it's
just a database, so we wouldn't want to get any benefit from that would we?

Been there, done that. Prefer the family.
[color=blue][color=green]
>> Of course, you _could_ use Oracle the same way as Ingres and code the
>> solution in PERL or otherwise. But my wife prefers I send time with her
>> instead of the computer, and these days I prefer to listen to the CDs
>> than
>> to code the catalog. (I listened when they said 'get a life' <g>)[/color]
>
> Yes Ingres has changed significantly in the last 7 years.
> It is also free.
> That is $400 dollars saved.
> Now imagine if you were a large company.[/color]

Totally forgetting the cost of programming and maintenance again, aren't
you? Selective memory and bad logic don't make the added time and cost of
unnecessary development go away. And a big company needs to pay it's
people.

Remember that the run-on cost of development and maintenance kills many more
projects than the cost of purchased software or hardware. Which gets
people fired. Which, I guess is Human as well.

And yet, I do understand what you are saying. Having used both
OpenOffice.org and MS Office, I have never needed the full capability of MS
Word or Excel and have standardized my home and business on OO.org.
There's nothing missing, so I don't need to code for the stuff I'm missing.
In such an environment iff it's been properly thought out, go for 'good
enough'. (And remember MySQL & PostgreSQL!)

Note that I'm also a big believer in FOSS. All my personal and corp
machines, except one, are GNU/Linux based. Allows me to put the money and
effort where it belongs. Which I can only do by careful, not religious,
analysis.

And IMO, based on my analysis, Ingres is behind the times in the commercial
rdbms market, and (although it has a few decent capabilities) behind the
times in the FOSS market as well. My prediction is that the MySQL group
will look at the capabilities and legally subsume the good stuff, to add it
to the already superior product.


I suspect you are going to respond and, since I have a family to get back
to, that means you will get the last word. Make it a good one. Then you
can get back to your religion (and spend your time coding). <g>

/Hans

[Yukonkid]

Re: Comparison of DB2 and Oracle?

"Rhino" <rhino1@NOSPAM. sympatico.ca> wrote in message news:<33xcd.373 $JG5.58933@news 20.bellglobal.c om>...[color=blue]
> One of my friends, Scott, is a consultant who doesn't currently have
> newsgroup access so I am asking these questions for him. I'll be telling him
> how to monitor the answers via Google Newsgroup searches.
>
> Scott has heard a lot of hype about DB2 and Oracle and is trying to
> understand the pros and cons of each product. I'm quite familiar with DB2
> but have never used Oracle so I can't make any meaningful comparisons for
> him. He does not have a lot of database background but sometimes has to
> choose or recommend a database to his clients.
>
> Scott has enough life-experience to take the marketing information produced
> by IBM and Oracle with a grain of salt and would like to hear from real
> DBAs, especially ones who are fluent with both products, for their views on
> two questions:
>
> 1. What are the pros and cons of the current releases of DB2 and Oracle?
>
> 2. What other sources of *independent* information are available to help
> someone new to databases choose between DB2 and Oracle?
>
> This is *not* a troll and we don't want to start a flame war! Scott just
> want some honest facts to help him decide which product is best at which
> jobs.[/color]


Hi,

without going into much religious talking, ask yourself:

How many OS versions of DB2 are on the market?
How many OS versions of Oracle?

For DB2 you find different databases for quite every platform (OS 390,
UNIX, AIX, mainframe...) - name it. For every problem they have a
database - incompatible between each other...
In Oracle you deal with the same architecture on every OS platform
they support.

Some of the things I like in Oracle

* a lot of features to select from (Oracles index types i.e.)
* the shared sql approach
* multi-versioning and read consistency implementation (SELECT without
being blocked by writes i.e.)

yk






at least, all databases return the data that you store,

[Serge Rielau]

Re: Comparison of DB2 and Oracle?

Argh.... I finally break radio silence here....

Yukonkid wrote:[color=blue]
> For DB2 you find different databases for quite every platform (OS 390,
> UNIX, AIX, mainframe...) - name it. For every problem they have a
> database - incompatible between each other...[/color]
OS390 < mainframe
AIX < Unix..
do you know what you are talking about?

There are three code bases:
DB2 for Linux, Unix, Windows
DB2 for z/OS
DB2 for AS/400

Oracle does not exist on AS/400 (through no fault of it's own...)
Oracle does virtually not exist on z/OS (low single digit market share,
could it be a separate codebase is required to be successful? ;-))

So if you want to deploy on i/Series or z/Series you look at DB2 and
ONLY DB2. No Oracle in the game.

If you want to deploy _anywhere_else_ DB2 competes with exactly _one_
codebase:
DB2 for Linux, Unix, Windows

Cheers
Serge

[HansF]

Re: Comparison of DB2 and Oracle?

michael newport wrote:
[color=blue]
> And do not forget, Oracle will charge you for a licence, this is ongoing.[/color]

Aaah ... the ongoing license fee myth! (#83?) Sadly incorrect, just as your
other myths.


Oracle charges once for a perpetual license. An Oracle license allows you to
use it forever if you wish (which is why there are still sites using
Oracle6).


You can, if you wish, get support for a license. That is annual, and
provides unlimited support calls. Quite different from licensing.

<heavy sigh>

[Joel Garry]

Re: Comparison of DB2 and Oracle?

michaelnewport@ yahoo.com (michael newport) wrote in message news:<63b202d.0 410260032.6d1b9 a7b@posting.goo gle.com>...[color=blue]
> DA Morgan <damorgan@x.was hington.edu> wrote in message news:<109875219 3.942650@yasure >...[color=green]
> > michael newport wrote:
> >[color=darkred]
> > > I am now (1 year) working with Oracle and my work involves doing the
> > > same stuff that I did with Ingres (see previous post).[/color][/color][/color]

Well, you need to get more experience with new stuff. Doing the same
thing over in a different environment should give you an increased
appreciation of what you are doing, and what you could be doing.
[color=blue][color=green]
> >
> > That's not the fault of the product. That direct and proximate
> > responsibility falls on you for being a dinosaur. How much code have
> > you implemented with bulk binding? How much with the model clause?
> > How much with analytic functions? How many materialized views with
> > refresh logs?[/color]
>
> its answers the users needs.
> and it was written by the dealine.
> which meant my company got paid.
> although some of this money was then sent to Oracle to pay for the
> licence.
> if we had used Ingres we could have done the same job for less, or
> increased our profits.[/color]

I used to work for a vendor of a product that worked on multiple
databases, including Ingres. They dropped Ingres support due to lack
of interest from potential customers. Are you sure whoever paid your
company would have been interested with Ingres? Many products are
considered more desireable simply because they are more expensive.
Stupid, true, but the way of the world.

I do recall one banking customer had a problem because their currency
was so inflated Ingres couldn't handle the number of bits in the
numbers.
[color=blue]
> But technology for its own sake is a waste of money.[/color]

I would agree with that, except out of all the useless flak sometimes
a gem comes, and sometimes a critical mass is created to actually
improve things.

jg
--
@home.com is bogus.
Did I say critical mass?

http://www.nuclearspace.com.nyud.net:8090/A_PWrussview_FINX.htm

[HansF]

Re: Comparison of DB2 and Oracle?

JEDIDIAH wrote:
[color=blue]
>
> These products have a reason for being because each product represents
> a specialization in it's own right. If given the choice between a
> specialist product such as MQ over some element of Oracle bundleware, I
> would be inclined to go for the IBM product simply because I know that I
> can count on it to be a discrete component that isn't going to be
> unecessarily tied to another Oracle product.[/color]

LOL.

I have been called in after-the-fact in several situations that took that
attitude. (By the way - WebSphere has subsumed MQ Series. You were saying
about Bundleware?)

In each and every case, vendor's response was "well it wouldn't happen if
you used 'our' DB".

In each and every case, the solution was to take advantage of the selected
DB's capabilities instead of reinventing a bolt-on.

And in each and every case, the customer paid heavily for the software - in
one case they added $10M to the bill to have 'vendor X's queueing solution'
instead of using the freely supplied Oracle AQ (which did the same thing).

Smart - wot?

If YOUR organization has extra money to do these kinds of things, please let
me know. I have a few unnecessary solutions I could recommend.

'nuff said!
/Hans

[Yukonkid]

Re: Comparison of DB2 and Oracle?

"Rhino" <rhino1@NOSPAM. sympatico.ca> wrote in message news:<33xcd.373 $JG5.58933@news 20.bellglobal.c om>...[color=blue]
> One of my friends, Scott, is a consultant who doesn't currently have
> newsgroup access so I am asking these questions for him. I'll be telling him
> how to monitor the answers via Google Newsgroup searches.
>
> Scott has heard a lot of hype about DB2 and Oracle and is trying to
> understand the pros and cons of each product. I'm quite familiar with DB2
> but have never used Oracle so I can't make any meaningful comparisons for
> him. He does not have a lot of database background but sometimes has to
> choose or recommend a database to his clients.
>
> Scott has enough life-experience to take the marketing information produced
> by IBM and Oracle with a grain of salt and would like to hear from real
> DBAs, especially ones who are fluent with both products, for their views on
> two questions:
>
> 1. What are the pros and cons of the current releases of DB2 and Oracle?
>
> 2. What other sources of *independent* information are available to help
> someone new to databases choose between DB2 and Oracle?
>
> This is *not* a troll and we don't want to start a flame war! Scott just
> want some honest facts to help him decide which product is best at which
> jobs.[/color]


Hi,

without going into much religious talking, ask yourself:

How many OS versions of DB2 are on the market?
How many OS versions of Oracle?

For DB2 you find different databases for quite every platform (OS 390,
UNIX, AIX, mainframe...) - name it. For every problem they have a
database - incompatible between each other...
In Oracle you deal with the same architecture on every OS platform
they support.

Some of the things I like in Oracle

* a lot of features to select from (Oracles index types i.e.)
* the shared sql approach
* multi-versioning and read consistency implementation (SELECT without
being blocked by writes i.e.)

yk






at least, all databases return the data that you store,

[michael newport]

Re: Comparison of DB2 and Oracle?

I have a free database that I can recommend.

Ingres.

Regards

Michael Newport