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.