Question about keyword outrigger
3 posters
Page 1 of 1
Question about keyword outrigger
In the Kimball book for dimensional modelling, there is a outrigger type dimension detailed. I have something similair in my datawarehouse, where a customer can have alot of keywords attached to him or her. However there are alot of different keywords. Like a 100. If I would follow the approach in the book, that would be a keyword outrigger of 100! (100x99x98x97...) Those are all the combinations of keywords. Granted that not all combinations will occur, but alot of them will.
I thought of skipping the bridge table, and make a dimension like this
customer_keyword_dimension
So I'm like skipping the bridge table. But this means that this dimension will be n times as large as large as the customer dimension, where n is the average amount of keywords (probably 30). This is still much smaller than the bridge table approach, but still pretty large.
Is this a good approach or are there better alternatives? Would love to hear your insights
I thought of skipping the bridge table, and make a dimension like this
customer_keyword_dimension
customer id | keyword |
1 | C++ |
1 | C# |
1 | Python |
2 | Python |
3 | C# |
3 | Python |
4 | C++ |
4 | SQL |
4 | C# |
So I'm like skipping the bridge table. But this means that this dimension will be n times as large as large as the customer dimension, where n is the average amount of keywords (probably 30). This is still much smaller than the bridge table approach, but still pretty large.
Is this a good approach or are there better alternatives? Would love to hear your insights
Booma- Posts : 12
Join date : 2014-03-10
Re: Question about keyword outrigger
My understanding of outrigger dimensions is where there is a 1:1 relationship between the base dim and the outrigger e.g. a Store Dim has a "First Open Date" which links to the Date Dim as an outrigger. This is not the situation you describe in your case - which seems to be closer to the "Multivalued Skill Keyword Attributes" issue Kimball describes in Chapter 9.
I'm not clear what the issue is with using a bridge table. Your Keyword Dimension would hold 100 records and the bridge table would hold the links between the customer and the Keyword Dim. I would also normally implement this as a Customer Factless Fact table so that the link from Customer to Bridge to Keyword is via the Fact and not between Dims.
The alternative approach outlined by Kimball is to put the Keywords in a delimited list in a single field. Probably the easiest to implement and then query using SQL but trickier to present sensibly to report writers through a BI tool such as OBIEE, SSRS, etc.
I'm not clear what the issue is with using a bridge table. Your Keyword Dimension would hold 100 records and the bridge table would hold the links between the customer and the Keyword Dim. I would also normally implement this as a Customer Factless Fact table so that the link from Customer to Bridge to Keyword is via the Fact and not between Dims.
The alternative approach outlined by Kimball is to put the Keywords in a delimited list in a single field. Probably the easiest to implement and then query using SQL but trickier to present sensibly to report writers through a BI tool such as OBIEE, SSRS, etc.
nick_white- Posts : 364
Join date : 2014-01-06
Location : London
Re: Question about keyword outrigger
Common practice is to use a bridge table and a keyword dimension. The reason for this is, even if its not required now, the user may wish to add additional attributes to the keywords to provide semantic classifications to them (such as 'programming skill', 'network skill' and so on). Using the outrigger you describe does not provide an easy way to do that.
Similar topics
» Keyword dimension question
» clickstream keyword dimension
» Issue with modelling a hierarchy so the OLAP cube build is efficent
» Outrigger dimensions in Facts
» Mini-Dimensions and Type 1 Outrigger
» clickstream keyword dimension
» Issue with modelling a hierarchy so the OLAP cube build is efficent
» Outrigger dimensions in Facts
» Mini-Dimensions and Type 1 Outrigger
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum