Need help on 3rd normal form and dimentional modeling(star & snowflake schema) for TERADATA

UDA
Enthusiast

Need help on 3rd normal form and dimentional modeling(star & snowflake schema) for TERADATA

Need help on

how teradata will support for 3rd normal form and dimentional modeling(star & snowflake schema).

and what is the difference between 3 NF and dimentional modeling?

3 REPLIES

Re: Need help on 3rd normal form and dimentional modeling(star & snowflake schema) for TERADATA

To keep it simple:Dimension modelling is intended for more select operations, hence redundancy is allowed and need not be normalised

Where as OLTP systems are intended for faster insert/updates hence to avoid redundancy they need to be under 3NF

Re: Need help on 3rd normal form and dimentional modeling(star & snowflake schema) for TERADATA

Hi

This page on my Database Answers Web Site discusses different types of Data Models and shows examples of  3rd Normal Form and Dimensional Models :-

http://www.databaseanswers.org/types_of_data_models.htm

The 3NF follows the original rules of Ted Codd, which are summarised on this page :-

http://www.databaseanswers.org/codds_normal_forms.htm

One benefit of following the Teradata Best Practice of having 3NF Data Warehouse is that it helps to guarantee a 'Single View of the Truth'.

On the other hand, a Dimension Model, whether star or snowflake, is designed with Dimensions and Facts.

Dimensions are things like Time Periods, Locations and Products.

Facts are totals, averages, percentages and so on.

HTH

Barry Williams

Principal Consultant

Database Answers Ltd.

London, England

Teradata Employee

Re: Need help on 3rd normal form and dimentional modeling(star & snowflake schema) for TERADATA