Specific Dimensions for
the Clickstream
Before we design specific clickstream data marts, let’s collect together as many
dimensions as we can think of that may have relevance in a clickstream envi
-
ronment. Any single dimensional schema will not use all the dimensions at
once, but it is nice to have a portfolio of dimensions waiting to be used. The
complete list of dimensions for a Web retailer could include:
All the dimensions in the list, except for the last four, are familiar data ware
-
house dimensions, most of which we have used already in earlier chapters of
this book. The last four, however, are the unique dimensions of the clickstream
and warrant some careful attention. We’ll also provide preliminary sizing esti
-
mates to give a sense of their magnitude.