Method for dynamically finding relations between database tables

A computer system comprising:

• a server, having a processor, in communication with a federated database in storage media, said server comprising:
• a status management unit to detect start and end of a query transaction;
• a data processing unit to extract data manipulation language in each query statement within said transaction and to analyze said language, said data manipulation language referring to tables and columns, wherein said tables and columns are associated with different databases forming the federated database and said language analysis includes establishing a relationship between data elements in multiple input statements in one client session;
• a data relation output unit to establish a relationship among extracted tables and columns in real-time, and if said query transaction includes a sub query, executing said sub query;
• and
• said data relation output unit to clarify characteristics of said established relationship based on structure of said data manipulation language and content of said query transaction, and classify said characteristics, and to convey said classified characteristics in a visual display.

An article comprising:

• a computer readable data storage medium;
• instructions in said medium to receive queries within a transaction, said queries provided by gathering data manipulation language for each input statement in a query transaction, wherein said statement refers to data elements associated with different databases forming a federated database;
• instructions in said medium to analyze said data manipulation language in said gathered statement, including:
• establishing a relationship between the data elements referred to in said statement that are associated with different databases in real-time, and if said query transaction includes a sub query, executing said sub query, and
• establishing a relationship between the data elements in multiple input
• statements in one client session by extracting table name and column name data used in said transaction associated with said input statement;
• instructions in said medium to clarify characteristics of relationships of said data elements based on structure of said data manipulation language and content of said query transaction;
• instructions in said medium to classify said characteristics;
• and instructions in said medium to convey said classified characteristics in a display format.