Junk Dimension Naming

View previous topic View next topic Go down

Junk Dimension Naming

Post  BoxesAndLines on Thu Sep 16, 2010 10:13 am

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Junk Dimension Naming

Post  ngalemmo on Thu Sep 16, 2010 12:44 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Junk Dimension Naming

Post  hang on Sat Sep 18, 2010 5:42 am

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.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

View user profile

Back to top Go down

Re: Junk Dimension Naming

Post  Jeff Smith on Wed Sep 22, 2010 1:16 pm

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

View user profile

Back to top Go down

Re: Junk Dimension Naming

Post  VHF on Wed Sep 29, 2010 3:43 pm

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

View user profile

Back to top Go down

Re: Junk Dimension Naming

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum