views:

38

answers:

0

I'm looking for a tool that can read multiple SQL queries and aggregate the data dependencies an relationships.

For example if I have 20 queries that start with "Select * from employees" I'd expect to see the employees table weighted at the top.

I imagine there has to be some data warehousing tool or other product out there to analyze what types of queries are run provide data relationships,groupings, etc.

I imagine this is some sort of data warehousing tool. Preferably something that would work with a DB2 database and read a some ANSI SQL statements we've collected over a period of time.

Thanks.