Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Junk Dimension Naming

5 posters

Go down

Junk Dimension Naming Empty Junk Dimension Naming

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

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

Back to top Go down

Junk Dimension Naming Empty Re: Junk Dimension Naming

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

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

http://aginity.com

Back to top Go down

Junk Dimension Naming Empty Re: Junk Dimension Naming

Post  hang 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

Back to top Go down

Junk Dimension Naming Empty Re: Junk Dimension Naming

Post  Jeff Smith 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

Back to top Go down

Junk Dimension Naming Empty Re: Junk Dimension Naming

Post  VHF 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

Back to top Go down

Junk Dimension Naming Empty Re: Junk Dimension Naming

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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