Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bi-modal joins - URGENT HELP

Status
Not open for further replies.

chidi

Technical User
Mar 24, 2003
42
NG
Can anyone please tell me what Bi-modal joins mean?
If necessary, can you please give me an example?
Thank you in advance.
chidi
 
Are you talking about joining tables from two models together over one database?
 
I've never heard "bimodal" in connection with SQL, although there are naturally some gaps in my knowledge. Could you give us some more detail? In what context was the term used?

I've heard "bimodal" used in statistics. It's a distribution that goes contrary to the normal Gaussian distribution in which observations are clustered in predictable patterns around an average value.

In a bimodal distribution there is no clustering around the mean. Instead there are two independent peaks that are widely separated by a region which has very few observations. An example might be a charismatic dictator like Adolf Hitler. There were millions of Germans who admired him, but millions more who loathed him for the mass murderer he was. There was very little middle ground of people who were neutral.

As far as I know, there is no relevance to SQL in statistical meaning of "bimodal".
 
Wow!
This is very interesting indeed!
I am glad to know you guys do not leave any questions unattended because it has been 7 months and two former employers since this question was posed.
But I am still impressed someone is taking a stab at this with serious historical perspective.
Karluk you are briliant and I will print a copy of this for revisiation to history land.
witchblade, yes, it has to do with something like your response and quite frankly till today, I still do not know what it means.
Now I have got motivation to dig into it more.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top