Many cases for each Fact

View previous topic View next topic Go down

Many cases for each Fact

Post  bajopalabra on 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 : 42

View user profile

Back to top Go down

Re: Many cases for each Fact

Post  murugan2012 on 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

View user profile

Back to top Go down

Re: Many cases for each Fact

Post  bajopalabra on 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 : 42

View user profile

Back to top Go down

Re: Many cases for each Fact

Post  bajopalabra on 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 : 42

View user profile

Back to top Go down

Re: Many cases for each Fact

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