amchoo_vr

 Profile Answers by amchoo_vr 

• Jan 2nd, 2008

 

A join path is a  series of joins  that a query can  use to access data in the  tables linked by the joins.
Join path problem arises due to limited  way that lookup and  fact tables are related  in a  relational database.Three major join path problems are:
1. Loop
2. Chasm Trap
3. Fan Trap

This can be resolved by using aliases.

vams_gk

 Profile Answers by vams_gk 

• Apr 8th, 2008

 

we have a multiple options to solve join problem
creation alias tables for loop resolve
detect contexts
traps:
 chasam trap(m:1:m)
fantraps(1:m||)

muralikrishna1982

 Profile Answers by muralikrishna1982 Questions by muralikrishna1982

• Aug 27th, 2008

 

the join path problems areee loops, chasmtraps, fantraps..
these can be solved by using

1) visualising analysis of schema
2) by  using aliases
3) by using contexts

venkatesh

• Dec 26th, 2014

 

JOIN PATH PROBLEMS

1)LOOPS
2)TRAPS

Loops can be resolved using 1)alias(can completely solve loops)
2)contexts(can only cover loop,not completely solve the loop)
Traps can be solved by using

1)chasm trap
2)fan trap