Path: utzoo!attcan!uunet!samsung!zaphod.mps.ohio-state.edu!maverick.ksu.ksu.edu!unmvax!bbx!tantalum!tom
From: tom@eds.com (Tom H. Meyer)
Newsgroups: comp.databases
Subject: Re: Join Contest
Message-ID: <1535@tantalum.UUCP>
Date: 17 Jul 90 15:59:17 GMT
References: <5265@plains.UUCP> <933@dgis.dtic.dla.mil>
Sender: usenet@tantalum.UUCP
Reply-To: tom@ozmium.UUCP (Tom H. Meyer)
Organization: EDS Research
Lines: 18

In article <933@dgis.dtic.dla.mil> jkrueger@dgis.dtic.dla.mil (Jon) writes:
>gus@plains.NoDak.edu writes:
>
>In fact it's difficult to design a query that
>makes sense with more than about five joins.  Try it.
>
>Jonathan Krueger    jkrueger@dtic.dla.mil   uunet!dgis!jkrueger

It is indeed difficult for human beings to create queries with lots
of joins. However, as more and more CASE tools which automatically
generate queries come into common use, you will see increasing
large joins occuring. My company, EDS, has such a case tool (INCA)
which has generated 7 way joins for one of our customers. We also
have a research project under way which routinely generates queries
with upwards of 40 joins. 

tom meyer, EDS Research               | If I don't see you in the future
tom@edsr.eds.com or ...uunet!edsr!tom | I'll see you in the pasture