Junk Dimension Naming
5 posters
Page 1 of 1
Junk Dimension Naming
What do you call your junk dimensions? Do you use "junk" in the dimension name? Junk implies garbage so I don't like using it. Most dimensions are easily named since they represent a single person, place, thing, concept, or event. Junk dimension contents are like a pot luck dinner.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Junk Dimension Naming
Well, since its pot-luck, how about 'casserole' or '7 layer bean dip'?
I just try to use something that fits. I agree 'junk' isn't one you should use... users have no sense of humor. Heck, even Ralph uses 'mini-dimension' in recent books... I hate that term... its just too PC.
I just try to use something that fits. I agree 'junk' isn't one you should use... users have no sense of humor. Heck, even Ralph uses 'mini-dimension' in recent books... I hate that term... its just too PC.
Re: Junk Dimension Naming
I like the concept of junk dimension but not the name. I am working on a BI project managing student information for all public schools. Therefore my junk dimension is collection of low cardinality demographic attributes about students so it's called DimStudentDemographic. Profile could be another choice if I need to include something more general. However anything is better than DimStudentJunk.
In my experience, not many people like the concept of junk dimension, maybe because of the name, or its unusual handling uncomfortable to traditional data modellers. Name is a powerful factor when you try to defend something that others try to get rid of.
I'd love to use some other name instead of junk dimension, even just to refer to the concept, but am not sure if the term mini-dimension can be used interchangeably in all cases. Mini-dimension seems to be a dimension with a group of low cardinality attributes extracted out of a large or rapidly changing main dimension, and both dimension keys appear as FK in fact table to reflect their correlation. Whereas junk dimension can be a bucket of related or unrelated low cardinality attributes that can be de-normalised into a single dimension instead of many discreet small dimensions.
In my experience, not many people like the concept of junk dimension, maybe because of the name, or its unusual handling uncomfortable to traditional data modellers. Name is a powerful factor when you try to defend something that others try to get rid of.
I'd love to use some other name instead of junk dimension, even just to refer to the concept, but am not sure if the term mini-dimension can be used interchangeably in all cases. Mini-dimension seems to be a dimension with a group of low cardinality attributes extracted out of a large or rapidly changing main dimension, and both dimension keys appear as FK in fact table to reflect their correlation. Whereas junk dimension can be a bucket of related or unrelated low cardinality attributes that can be de-normalised into a single dimension instead of many discreet small dimensions.
hang- Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia
Re: Junk Dimension Naming
I tend to use "Attribute" in the name of Junk dimensions, as in d_claim_attribute, d_member_attribute, etc.
Jeff Smith- Posts : 471
Join date : 2009-02-03
Re: Junk Dimension Naming
How about "Miscellaneous Dimension" as an alternative term without the negative connotation of "junk"?
VHF- Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US
Similar topics
» bridge table and junk dimension on customer dimension (bank/credit union)
» modelling Product dimension for Pizza outlet
» Naming conventions for fact and dimension table
» Should I use a degenerate dimension or create a junk dimension?
» Should this be a degenerate dimension or a junk dimension?
» modelling Product dimension for Pizza outlet
» Naming conventions for fact and dimension table
» Should I use a degenerate dimension or create a junk dimension?
» Should this be a degenerate dimension or a junk dimension?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum