Re: Databases and Instances

PMJI I work with Oracle, Informix and MS-SS. From my perspective, essentially what is being addresssed is that Oracle has tablespaces while the others, as I understand it, have databases.

What I hear you asking for is for owner smith to have two tables name wesson, one in a database named oils, the other in a database named guns. But both databases are in the same instance of, say, MS SQL-  You end up addressing the tables as smith.oils.wesson and smith.guns.wesson.

In Oracle, you can achieve the same split by have smith own a table named wesson, stored in partitions oil and guns based on a product key. Oil and Guns would be separate tablespaces. Orace would address the table as Smith.Wesson, differentiating by product key. You then don't have to worry about partition.

The difference is more one of naming convention and kindness to programmers (lenght of table name) than technology.

I would argue that Oracle's approach gives you better enterprise data consistency and integrity (single database), but it is debatable.

In article <38e484b3.2785938_at_news-server>, 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:
>
> >
> >No, Oracle is way behind the times on this. Informix and DB2 give you
> >multiple databases (with multiple schemas therein) per instance, and
> >Sybase and SQL Server give multiple databases per instance. Only
> >Oracle is still stuck in the mud on this one ... and their
> >architecture won't be easily changed to keep up with the others.
> >
>
> 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.
>
> 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.
>
> Cheers
> Nuno Souto
> nsouto_at_nsw.bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Before you buy.