Re: Help with database query tool

Subject: Help with database query tool
From: 131W10000-RobinsonB, brucer_at_abacus.dr.att.com Date: Tue, 25 Oct 1994 23:04:58 GMT
In article <Cy944A.844_at_bigtop.dr.att.com> 131W10000-RobinsonB, brucer_at_abacus.dr.att.com writes:
[extensive details deleted]

It sounds like what you are looking for is a query tool that can allow the users to easily select what columns they want to see and then have the tool generate SQL to get the data without having to join a bunch of tables that are not needed. If I understood you correctly then you should take a look at GQL from Andyne Computing. This was the only product we found that allowed us to pre-define how the joins between tables were to occur but that didn't require us to set up every possible combination of tables and joins that the users could conceivably need. Only those tables necessary to get at the requested data are joined during the query.

Essentially, you build a database diagram that looks like a simple E-R model. The users then use this diagram to access the database. Results are returned to the desktop where further manipulation can happen within GQL or you can export the data into other tools, like Excel. GQL support ASCII files for this transfer, or direct transfer into the tool via several methods (such as Publish and Subscribe in the Mac world).

It might be worth a look. Andyne can be reached at

Andyne Computing Ltd
544 Princess St.
Suite 202
Kingston, Ontario
Canada
K7L 1C7
613-548-4355

I don't work for them. We're just a very satisfied customer.

Dennis Weatherly
Mentor Graphics Corp
dennis_weatherly_at_mentorg.com Received on Fri Oct 28 1994 - 21:10:27 CET