Re: database concept - Sybase vs. Oracle

In <54s56l$n2k_at_nntp1.u.washington.edu>, lesliet_at_u.washington.edu (L. Tseng) writes:
>I am interested in gathering info on how Oracle DBAs handle
>database vs Sybase DBAs.
>
>In Sybase, creating a database is an easy task and all databases share the
>same memory space. In Oracle, the schema seems more like the "database"
>concept in Sybase. I wonder if Oracle DBAs actually create database
>or instance all the time to deal different applications.
>
>-Leslie
>

From what I've read, the Sybase concept appears to be somewhat akin to that of DB2 which *is* different to Oracle.

In DB2(/MVS, at least), there is a difference between each of Data Base, Account/User, and object Owner. DB2's Catalog can capture that a Table, for example, is part of Data Base FredDB and owned by FredDBA, even though it was created by BarryJJ.

In Oracle, a single User/Account concept is overloaded in a struggle to satisfy all 3 concepts. I (BarryJJ) can create an object owned by FredDBA... but, after creation, the only evidence that I created it is that I (as well as Owner FredDBA) am automatically GRANTed all object privileges ... although I *don't* get the privilege to GRANT to others in turn!

If you use the ANSI CREATE SCHEMA construct, the Schema name is mapped as the Owner of the schema object(s).

When you mention Data Base, Oracle folk are more likely to think of the running server instance. This is more akin to DB2's SubSystem. Each supports running of multiple, independent data base services - whereas my understanding is that, with Sybase, there is only one such service running in a system?

Anyway, since Oracle doesn't separate the concept of Data Base and Owner within a running instance, folk will typically put up another, separate running instance and achieve a Data Base separation that way. Creating a new Data Base by creating a new running instance while not difficult *is* time consuming and somewhat initially clumsy compared to the alternative in DB2 at least.

Barry Johnson - BarryJJ_at_IBM.Net Received on Sat Nov 02 1996 - 00:00:00 CST