Re: VIEWS compared to Nodes as Windows into data

• 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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=