Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: VIEWS compared to Nodes as Windows into data

Re: VIEWS compared to Nodes as Windows into data

From: x <x-false_at_yahoo.com>
Date: Fri, 30 Apr 2004 15:28:32 +0300
Message-ID: <409245bc@post.usenet.com>

"Dawn M. Wolthuis" <dwolt_at_tincat-group.com> wrote in message news:c6r0tc$9f5$1_at_news.netins.net...
> "Dawn M. Wolthuis" <dwolt_at_tincat-group.com> wrote in message
> news:c6m06j$r1h$1_at_news.netins.net...

> <snip>
> Is this an accurate perspective on SQL VIEWS? Are there "extra" VIEWS,
more
> portals into the data, or whatever, created simply for performance
reasons?

> Is there a DBMS that provides a better top level "data catalog" that
doesn't
> include performance issues mixed with what data values you can "shop for"
> (query)?

Look at CREATE SCHEMA in SQL92 standard and CREATE SYNONYM in some SQL DBMSs.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Fri Apr 30 2004 - 07:28:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US