Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
X-Factor
Constraint Violating Yak Guru
392 Posts |
 Posted - 2008-03-20 : 13:48:33
|
| Hi there,Lets say I have some video channels (such as the Sci-Fi channel) and videos from the channels play on different web domains in a video player. So a video play can be defined using three dimensions - its channel, web domain and the title's name.Now lets say I'm tracking the playing of these titles. I get one track per title play and I want to add a db row for each dimension where each dimension has its own table.e.g. X-Files Episode 1, Sci-Fi Channel on bbc.co.uk.Now I don't think that any one of these dimensions has precedence over any over. I don't think they represent a hierarchy. The title might appear on other channels and the channel might be syndicated such that it appears on other domains.So when tracking a title, I need one row in each table and I need a join table between the tables to link up the different dimensions of the title play. The question is, which join tables should I use?I might have a join table between Channels and Domains and another between Domains and Titles. But then if I wanted to all titles shown on a particular Channel I would have to join three tables together. I could also put a join table between Titles and Domains but then I'd have redundent data.So, given the lack of hierarchy, how do I choose what joins to what?Hope this makes sense!XF. |
|
|
|
|
|
What joins to what?