104k views
4 votes
Give at least 5 indicators which help to identify systems andtables as potential de-normalizationcandidates.

1 Answer

3 votes

Answer and Explanation:

The five indicators are

  • There is existence of repeating groups which needs to be processed in a single group not individually
  • many reports exist which need to be processed online
  • tables need to processed in different way by different users at the same time
  • certain columns need very large time for the de normalization take 60% as the alarming number
  • many calculations needs to be applied to columns before queries can be answered

User Humberd
by
4.7k points