Cube Database Design Help

Last Post 15 Jan 2008 10:40 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
kjmcsd
New Member
New Member

--
15 Jan 2008 08:01 AM
First, I'm in the process of redesigning a cube in AS 2005. Does anyone know of any good books, websites or anything that could help a beginner? Just to fill you in a little. Some of the data that the cube would use would be updated daily and from what I read so far is that the database does not need to be fully denormalized. Like I said, I'm a beginner.
SQLUSA
New Member
New Member

--
15 Jan 2008 10:40 AM
That is correct, star schema is generally not normalized uses FLAT dimension tables.

SNOWFLAKE schema is generally associated with 3NF data warehouse design.

If you are concerned with performance, stick with the STAR schema.

The brunt of the work is designing the dimension tables (fact table design is simple), and populating the fact tables. Once you've done that, the real fun begins with OLAP cubes.


Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/orderbusiness...elligence/ The Best SQL Server 2005 Training in the World!


Acceptable Use Policy
---