Archives of the TeradataForum

Message Posted: Tue, 20 Mar 2001 @ 21:43:25 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Why not use star schema

From:		Patrick Logan

James Judge wrote:

A good 3NF schema modeled on how the business functions will most likely be independent of any source schema model; but all the more efficient to source if they actually matched. The reasons for a "star schema" are still valid for user (application) interpretation; whether or nor it is logically or physically implemented.

Thanks. When would you choose to implement a source-independent 3NF vs. a source-independent dimensional model?

In particular if your goals are:

* Make the model as simple as possible for the end user to understand.

* Make the model as adaptable as possible to end user tools.

* Accomodate as much as possible differences and changes in source systems.

-PDL


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2001 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec

Last Modified: 15 Jun 2023