From: "x" Newsgroups: comp.databases.theory References: Subject: Re: VIEWS compared to Nodes as Windows into data Date: Fri, 30 Apr 2004 15:28:32 +0300 Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 NNTP-Posting-Host: 81.196.98.200 X-Original-NNTP-Posting-Host: 81.196.98.200 Message-ID: <409245bc@post.usenet.com> X-Trace: post.usenet.com 1083327932 81.196.98.200 (30 Apr 2004 07:25:32 -0500) Organization: Usenet.com http://www.usenet.com 100,000+ UNCENSORED Newsgroups. The #1 Usenet Service on the Planet! X-Comments: This message was posted through Usenet.com's, FREE publicly accessible Usenet Server - "post.usenet.com" X-Comments2: IMPORTANT: Usenet.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!! X-Report: Please report illegal or inappropriate use to X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS) Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!atl-c02.usenetserver.com!news.usenetserver.com!feed5.newsreader.com!newsreader.com!news-out2.nntp.be!local!post.usenet.com!not-for-mail Xref: newssvr20.news.prodigy.com comp.databases.theory:26098 **** Post for FREE via your newsreader at post.usenet.com **** "Dawn M. Wolthuis" wrote in message news:c6r0tc$9f5$1@news.netins.net... > "Dawn M. Wolthuis" wrote in message > news:c6m06j$r1h$1@news.netins.net... > > 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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=