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

Many cases for each Fact

2 posters

Go down

Many cases for each Fact Empty Many cases for each Fact

Post  bajopalabra Fri Aug 24, 2012 11:05 am

Hello
I'm trying to do an education model
Each Student has one record (fact) for each Course (with only semi-additives, by now)

The issue is that each Course is teached by one or more Teachers

when the user (an academic authority) would query "by Course", they should get the same results for every teacher
like a 1 to many relationship...

I think I could make a junk dim with each "teacher staff", concatenating them by "," ( loosing this way quality attributes like age, etc )
I could repeat each fact several times, one for each Teacher ( which would increase an average of 3 times the space needed for the data )

Is there another possibility?

thanks!!!

bajopalabra

Posts : 12
Join date : 2012-08-24
Age : 49

Back to top Go down

Many cases for each Fact Empty Re: Many cases for each Fact

Post  murugan2012 Fri Aug 24, 2012 11:55 am

you can construct student, cource, teacher dimensions along with the bridge dimension of student-course, course-teacher to resolve the many-many relationship to handle this.

murugan2012

Posts : 5
Join date : 2012-08-22

Back to top Go down

Many cases for each Fact Empty Re: Many cases for each Fact

Post  bajopalabra Fri Aug 24, 2012 12:00 pm

ok, I didn't know about bridge dimensions, I'm going to read about it right now, thanks

bajopalabra

Posts : 12
Join date : 2012-08-24
Age : 49

Back to top Go down

Many cases for each Fact Empty Re: Many cases for each Fact

Post  bajopalabra Fri Aug 24, 2012 12:10 pm

I wonder if "bridge tables" doesn't break the star schema... does it?

bajopalabra

Posts : 12
Join date : 2012-08-24
Age : 49

Back to top Go down

Many cases for each Fact Empty Re: Many cases for each Fact

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