Huge table meets star schema

View previous topic View next topic Go down

Huge table meets star schema

Post  ObjectiveC on Wed Apr 27, 2011 5:34 pm

Hello everyone,

I have a general question.

I was wondering if it's acceptable to combine a star-schema with one or more huge table(s). Where those huge tabels would be a plain dimension like dim_huge_x and a fact_table would be just a fact_table.

So I was thinking of a design like this:

dim_date -> fact_table
dim_time -> fact_table
dim_person -> fact_table
dim_huge_x -> fact_table
etc...


What are your thoughts on this ?

ObjectiveC

Posts : 25
Join date : 2011-03-18

View user profile

Back to top Go down

Re: Huge table meets star schema

Post  ngalemmo on Wed Apr 27, 2011 5:38 pm

I don't follow... do you mean to say derive a big flat dimension by denormaling all related dimensions into one table... creating a schema made up of one fact and one dimension table?

I wouldn't do that... performance would be terrible.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Huge table meets star schema

Post  ObjectiveC on Thu Apr 28, 2011 2:19 am

ngalemmo wrote:I don't follow... do you mean to say derive a big flat dimension by denormaling all related dimensions into one table... creating a schema made up of one fact and one dimension table?

I wouldn't do that... performance would be terrible.

I mean derive a big flat dimension by denormaling some dimensions, not all. So that way you will have a normal star schema, but with one or two big flat dimensions.

ObjectiveC

Posts : 25
Join date : 2011-03-18

View user profile

Back to top Go down

Re: Huge table meets star schema

Post  ngalemmo on Thu Apr 28, 2011 8:37 am

It really depends. If you mean creating a junk dimension for a handful of low cardinality codes and descriptions, fine.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Huge table meets star schema

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