Date: Fri, 16 Oct 1998 11:47:02 -0400
Reply-To: CHUCK MAKINSON <clmakinson@GOODYEAR.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: CHUCK MAKINSON <clmakinson@GOODYEAR.COM>
Subject: Re: SPDS vs SQL Server vs Oracle - question
Content-Type: text/plain; charset=iso-8859-1
It sounds like you have data warehouse (a collection of datasets stored in one
place) not an actual DATA WAREHOUSE built using the SAS/D.W. product. The D.W.
product makes it easy to manage and maintain views or tables of the operational
data in a Star Schema or other denormalized formats optimized for user access.
In most cases a query against normalized RMDS data, particularly if joins are
involved, will be slow in comparison to D.W. structured data regardless of the
choice of Oracle, SQL Server, etc. The tradeoff will be additional space and
refresh frequency requirements.