Re: [SQL] Warehouse Schema

2006-05-25 Thread Richard Huxton
Worky Workerson wrote: I'm developing a schema for a large data warehouse (10 billion records) and had a couple of questions about how to optimize it. My biggest question is on the design of the fact table and how much normalization I should actually do of the data. As much as you can and st

[SQL] Warehouse Schema

2006-05-24 Thread Worky Workerson
I'm developing a schema for a large data warehouse (10 billion records) and had a couple of questions about how to optimize it.  My biggest question is on the design of the fact table and how much normalization I should actually do of the data.  The data is going to be keyed by IP address, stored