What is data sparsity and how it effect on aggregation?

Interview Candidate
Dec 29th, 2005
1
13820

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

SC

Mar 9th, 2006

Data sparsity is term used for how much data we have for a particular dimension/entity of the model.
It affects aggregation depending on how deep the combination of members of the sparse dimension make up. If the combination is a lot and those combinations do not have any factual data then creating space to store those aggregations will be a waste as a result, the database will become huge.