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_at_post.usenet.com>
Date: Fri, 30 Apr 2004 15:28:32 +0300
Message-ID: <409245bc_at_post.usenet.com>
- Post for FREE via your newsreader at 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.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
- Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=