Re: Databases and Instances

On Fri, 31 Mar 2000 11:23:57 GMT, nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto) wrote:

>On Thu, 30 Mar 2000 23:27:55 GMT,
>granta_at_nospam.student.canberra.edu.au (Fuzzy) wrote:
>
>Are you on fumes or what? First of all, what do you call a "database"
>in Informix and DB2? EXACTLY what, not some nebulous concept.

Wow, you're touchy today, Nuno.

This is just thinking off the top of my head, but a database would include it would include
- Complete independent set of data structures (i.e. tablespaces, dbspaces) - not tied to any other part of the instance

- Independent system catalog
- Independent set of schemas
- Independent configuration of performance and tuning params
- etc.

Gee, let me see. Nope, Oracle flunks ALL OF THOSE!!!!! DB2 has them all! (Not that I dislike Oracle, or am blind to DB2's problems, just making my point).

>I think if you sit back a bit and breath deep, you'll find that it's
>PRECISELY Sybase et all and Informix who were behind the times on this
>and only recently caught up.

I'm not interested in what they used to do ... we're talking about right now. The other DBs I mentioned have it, and Oracle doesn't. I think you'll find that's what I said. I also don't see you arguing my point that Oracle won't be able to change this in a hurry.

<mmm ... I haven't had this much fun in ages>

Ciao
Fuzzy
:-)   Received on Mon Apr 03 2000 - 00:00:00 CDT