Comparison of DB2 and Oracle?

[michael newport]

Re: Comparison of DB2 and Oracle?

> Well, you need to get more experience with new stuff. Doing the same[color=blue]
> thing over in a different environment should give you an increased
> appreciation of what you are doing, and what you could be doing.[/color]

It did, and the similarities were all too obvious.
[color=blue][color=green][color=darkred]
> > >
> > > 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.[/color]

I agree that CA sales and marketing were bad. But Ingres the product is not.
CA also wasted time and money on speculative products like Jasmine and Opal.
Linux / Apache / PHP have taken off because they are reliable and OpenSource.
I predict the same for Ingres.
[color=blue]
> 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=green]
> > 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[/color]

Well here is a gem and its free.

Regards
Michael Newport

[Mark Townsend]

Re: Comparison of DB2 and Oracle?

michael newport wrote:
[color=blue]
>
> Linux / Apache / PHP have taken off because they are reliable and OpenSource.
> I predict the same for Ingres.
>[/color]

Linux, Apache and PHP are succesful because there is a strong developer
and user community. Ingres doesn't have this, and making something
OpenSource doesn't cause this community to automatically build.

Linux in particular benefited from the focus companies like Oracle, IBM
and others placed on it. The same level of focus is unlikely to happen
for Ingres.

[michael newport]

Re: Comparison of DB2 and Oracle?

> Linux, Apache and PHP are succesful because there is a strong developer[color=blue]
> and user community. Ingres doesn't have this, and making something
> OpenSource doesn't cause this community to automatically build.[/color]

Linux, Apache and PHP did not start off successful. They grew.

Ingres has existed for a long time, the base IS there
comp.databases. ingres
[color=blue]
> Linux in particular benefited from the focus companies like Oracle, IBM
> and others placed on it. The same level of focus is unlikely to happen
> for Ingres.[/color]

Companies focus on Linux because it is free. A huge advantage.

Oh and by the way Ingres is also free.

[michael newport]

Re: Comparison of DB2 and Oracle?

> How many OS versions of DB2 are on the market?[color=blue]
> How many OS versions of Oracle?[/color]

How many OS versions of Ingres ?[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...
> In Oracle you deal with the same architecture on every OS platform
> they support.[/color]

In Ingres you deal with the same architecture on every OS platform
they support.
[color=blue]
> 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.)[/color]

you would like Ingres then.[color=blue]
>
> at least, all databases return the data that you store,[/color]

depends on the human factor.

[Serge Rielau]

Re: Comparison of DB2 and Oracle?

Michael,

This thread is now very much off topic.
Comparison between Oracle and Ingres should be in these respective
newsgroups if you insist on having these debates.
I don't see where comp.databases. ibm-db2 is relevant here.

Cheers
Serge

[Jean-David Beyer]

Re: Comparison of DB2 and Oracle?

michael newport wrote:[color=blue][color=green]
>>Well, you need to get more experience with new stuff. Doing the same
>>thing over in a different environment should give you an increased
>>appreciatio n of what you are doing, and what you could be doing.[/color]
>
>
> It did, and the similarities were all too obvious.
>
>[color=green][color=darkred]
>>>>That's not the fault of the product. That direct and proximate
>>>>responsibil ity 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?
>>>
>>>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.[/color]
>
>
> I agree that CA sales and marketing were bad. But Ingres the product is not.
> CA also wasted time and money on speculative products like Jasmine and Opal.
> Linux / Apache / PHP have taken off because they are reliable and OpenSource.
> I predict the same for Ingres.
>[/color]
I would be curious what the advantages of Ingres might be over other free
(depending on exact usage) dbms's such as postgreSQL and MySQL. I know
that Ingres has been around since even before Oracle existed (late
1970s?). I suppose postgreSQL is a descendant of Ingres.

For desktop use, it probably matters little, though after fussing around
with a bunch of them, I chose to pay IBM for their DB2 UDB because it just
plain worked better and they seemed to follow standards (such as for
Embedded SQL) better than did Informix or postgreSQL did at the time I
tried them (mid to late 1990s).

--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ Registered Machine 241939.
/( )\ Shrewsbury, New Jersey http://counter.li.org
^^-^^ 13:05:00 up 4 days, 14:57, 3 users, load average: 5.37, 5.04, 4.59

[Joel Garry]

Re: Comparison of DB2 and Oracle?

Mark Townsend <markbtownsend@ comcast.net> wrote in message news:<417F735E. 6080007@comcast .net>...[color=blue]
> michael newport wrote:
>[color=green]
> >
> > Linux / Apache / PHP have taken off because they are reliable and OpenSource.
> > I predict the same for Ingres.
> >[/color]
>
> Linux, Apache and PHP are succesful because there is a strong developer
> and user community. Ingres doesn't have this, and making something
> OpenSource doesn't cause this community to automatically build.[/color]

That's an interesting perspective, Mark. I agree for linux (certainly
my own interest in linux stemmed from getting away from windows
together with unix bigotry - and now that new versions don't run
[without a whole lot of work] on any of my half-dozen computers and
are suffering from bloatware, I'm not so interested for my own sake).

Apache and PHP, on the other hand, I would argue, benefitted from
having a "killer app," and some cluelessness from MS. Of course, now
that I've argued it, I have to say linux also benefitted from the
same, but subsequent to the developer interest. They all started
because of the strong developer community, but success came later.
For Apache, only a year later, taking over the high growth market that
NCSA created, but later nonetheless.
[color=blue]
>
> Linux in particular benefited from the focus companies like Oracle, IBM
> and others placed on it. The same level of focus is unlikely to happen
> for Ingres.[/color]

And so my interest in linux is now professional, rather than personal.
This is a good thing. But linux is only just now becoming successful
in the db world. Some people might still consider it the next big
thing. It's here, bleeding edge places are using it, but
mainstream... maybe all those hp/solaris job ads reflect the
forward-looking people leaving :-)

From my perspective, the only thing that can save Ingres is a killer
app. And I think anyone writing anything new would choose something
else (or db independence), unless some underemployed Ingres people
brainstormed and got lucky.

jg
--
@home.com is bogus.
I'll gladly agree to take only 25%.

http://www.signonsandiego.com/uniontrib/20041027/news_1b27lerach.html

[DA Morgan]

Re: Comparison of DB2 and Oracle?

michael newport wrote:
[color=blue]
> Hans,
>[color=green][color=darkred]
>>>developmen t 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=green]
>>To reduce the total cost of a project over several years,
>>
>> Reduce development and maintenance costs,[/color]
>
> Human.
>[color=green]
>> By writing and maintaining LESS code,[/color]
>
> Human.
>[color=green]
>> 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=green]
>> By using that capability.[/color]
>
> Human.[/color]

Many many things so rather than spouting off about things of which
you have no knowledge why don't you invest some effort and learn
about them. All you've done so far is advertise your lack of knowledge
about both Oracle and DB2.

But for starters ... incremental backup of changed blocks.
--
Daniel A. Morgan
University of Washington
damorgan@x.wash ington.edu
(replace 'x' with 'u' to respond)

[DA Morgan]

Re: Comparison of DB2 and Oracle?

michael newport wrote:
[color=blue][color=green][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]

Having stuck your foot into your mouth I was assuming you wouldn't
follow up by trying to swallow it. You claim to be a database
developer but your posts read like a first year Java newbie.
[color=blue]
> 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]

$400 is less than we spend in a week for free softdrinks for our
employees. Get a life.

--
Daniel A. Morgan
University of Washington
damorgan@x.wash ington.edu
(replace 'x' with 'u' to respond)

[DA Morgan]

Re: Comparison of DB2 and Oracle?

michael newport wrote:
[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]
>>
>>That's not the fault of the product. That direct and proximate
>>responsibilit y 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]

Had you used Ingres the customer likely would have hired a firm that
knew how to work in a real database. Your firm would have been paid $0
and you'd be unemployed.
[color=blue][color=green]
>>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.[/color]

Not once in this entire thread have Oracle Report Server (it doesn't
even exist any more) or JAVA been part of any post. Don't try to change
the subject. That is a activity best left to small children.
--
Daniel A. Morgan
University of Washington
damorgan@x.wash ington.edu
(replace 'x' with 'u' to respond)

[DA Morgan]

Re: Comparison of DB2 and Oracle?

michael newport wrote:
[color=blue]
> DA Morgan <damorgan@x.was hington.edu> wrote in message news:<109875222 6.378168@yasure >...
>[color=green]
>>michael newport wrote:
>>
>>[color=darkred]
>>>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 ?[/color]

I don't "back" a product. I work routinely in multiple products. That
I teach one relates to what the university's students want ... not what
I do.

But no one wants to learn Ingres. It is a decaying corpse that CA has
attempted to bury at sea. If you want to work with a real open-source
database the clear choice is MySQL.

--
Daniel A. Morgan
University of Washington
damorgan@x.wash ington.edu
(replace 'x' with 'u' to respond)

[DA Morgan]

Re: Comparison of DB2 and Oracle?

michael newport wrote:
[color=blue]
> I agree that CA sales and marketing were bad. But Ingres the product is not.
> CA also wasted time and money on speculative products like Jasmine and Opal.
> Linux / Apache / PHP have taken off because they are reliable and OpenSource.
> I predict the same for Ingres.[/color]

And exactly why doesn't your "critical" understanding of the marketplace
indicate anything about MySQL, PostgreSQL, Firebird, and all of the
other open-source code bases? You are a religious zealot pushing
neolithic technology likely because it is all you know.

There is not a chance in 1000 that it will ever have 1/2 the marketshare
of MySQL which is the only serious open-source competitor to Oracle and
DB2.
--
Daniel A. Morgan
University of Washington
damorgan@x.wash ington.edu
(replace 'x' with 'u' to respond)

[DA Morgan]

Re: Comparison of DB2 and Oracle?

michael newport wrote:
[color=blue][color=green]
>>Linux, Apache and PHP are succesful because there is a strong developer
>>and user community. Ingres doesn't have this, and making something
>>OpenSource doesn't cause this community to automatically build.[/color]
>
>
> Linux, Apache and PHP did not start off successful. They grew.
>
> Ingres has existed for a long time, the base IS there
> comp.databases. ingres[/color]

The "base" is database developers not people that write kernel code in
C. They will all die of old age before they figure out how to give the
Ingres kernel capabilities that were in Oracle 8i.
[color=blue][color=green]
>>Linux in particular benefited from the focus companies like Oracle, IBM
>>and others placed on it. The same level of focus is unlikely to happen
>>for Ingres.[/color]
>
>
> Companies focus on Linux because it is free. A huge advantage.[/color]

Nonsense. Absolute ignorant nonsense. I consult for a division of The
Boeing company. The cost of an operating system compared to the total
cost of an application is so small as to be invisible. Do you really
think we are going to build a $15,000,000 system and worry about the
lousy few hundred or few thousand dollars for the O/S?

We chose Linux because it gave us better performance, in lab tests with
our application than did Win2K, WinXP, Solaris 2.9 and HP/UX 11i.

You really are out of touch with reality.
[color=blue]
> Oh and by the way Ingres is also free.[/color]

Oh and by the way ... we really don't give a damn. And neither
does anyone else.
--
Daniel A. Morgan
University of Washington
damorgan@x.wash ington.edu
(replace 'x' with 'u' to respond)

[DA Morgan]

Re: Comparison of DB2 and Oracle?

Serge Rielau wrote:
[color=blue]
> Michael,
>
> This thread is now very much off topic.
> Comparison between Oracle and Ingres should be in these respective
> newsgroups if you insist on having these debates.
> I don't see where comp.databases. ibm-db2 is relevant here.
>
> Cheers
> Serge[/color]

I agree. I am kill-filing this thread. Newport is just trolling and I
am tired of responding to a neolithic fanatic. You'll so no more on
this from me.
--
Daniel A. Morgan
University of Washington
damorgan@x.wash ington.edu
(replace 'x' with 'u' to respond)

[michael newport]

Re: Comparison of DB2 and Oracle?

> Not once in this entire thread have Oracle Report Server (it doesn't[color=blue]
> even exist any more) or JAVA been part of any post. Don't try to change
> the subject. That is a activity best left to small children.[/color]

[color=blue]
> Daniel,
>
> in Ingres I wrote 4GL, in Oracle I write PL/SQL[/color]

Because you don't know how to write Java in the database?
[color=blue]
> in Ingres I wrote SQL, in Oracle I write SQL[/color]

Because you don't know how to write Java in the database?


Daniel,
it seems that you have short term memory loss,

it also seems that you have never used Ingres.

Regards
Michael Newport