Re: partitioning

From: Mark Rosenbaum <mjr_at_netcom.com>
Date: 1997/04/18
Message-ID: <mjrE8u4uK.C7n@netcom.com>#1/1

In article <33579697.5DBD_at_citicorp.com>, Rachel Carmichael <rachel.carmichael_at_citicorp.com> wrote:
>I'm just getting started with a new project for a data warehouse which
>will be about 200GB by the time we're done. We'll be using 7.3 on
>HP-UX.... anyone have any advice on how to partition the database? Any
>suggestions on books/websites/papers where I can get some information?
>
>Thanks
>
>Rachel Carmichael
>email rachel.carmichael_at_citicorp.com

Rachel,

There is getting to be quite a bit of info available for Data Warehouses these days (both in book and on the web)

Two must reads are

Building the Data Warehouse	W. H. (Bill) Inmon	0-471-56960-7
The Data Warehouse Toolkit	Ralph Kimball		0-471-15337-0

You might also try the web sites for redbrick & microstrategies.

You will want to pay close attention to star schemas and time sequenced data. These are not an end all be all but rather a good starting place.

Mark Rosenbaum			Otey-Rosenbaum & Frazier, Inc.
mjr_at_netcom.com			Consultants in High Performance and
(303) 727-7956			Scalable Computing and Applications
POB 1397			ftp://ftp.netcom.com/pub/mj/mjr/resume/

Boulder CO 80306 Received on Fri Apr 18 1997 - 00:00:00 CDT