Normalizing Tables

Being a columnar database supporting JOINS, the question 'whether  to normalize or not to normalize DB tables' becomes less critical.

Nevertheless, use the following guidelines when designing your tables structure:

Normalization of fact/dimension tables (when ratio is 1:N) will help reduce column & row sizes. It would benefit in terms of both storage and GPU utilization and is especially important in cases of large text fields (Varchars & Nvarchar with length > 10) that hold data with low uniqueness. For example :

  • Country name

  • Company name

  • Device name

  • Store name

  • Operator name (.etc)

  

  • 131
  • 14-Aug-2017
  • 477 Views