초록 ▼

A method and system are provided for dynamically relating tables in a federated database based upon a data manipulation language in a query transaction. After the start of a transaction has been detected, a data manipulation language from the transaction is extracted and evaluated to determine the t

A method and system are provided for dynamically relating tables in a federated database based upon a data manipulation language in a query transaction. After the start of a transaction has been detected, a data manipulation language from the transaction is extracted and evaluated to determine the table(s) and column(s) referenced by the transaction language. The data relation output unit determines the relationship(s) between the extracted table(s) and column(s) in real-time and conveys this information through a visual display.

대표청구항 ▼

I claim: 1. A method for relating tables in a database comprising:a federated server receiving 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 elements associated with differ

I claim: 1. A method for relating tables in a database comprising:a federated server receiving 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 elements associated with different databases forming a federated database;analyzing said data manipulation language in gathered statement, including:establishing a relationship between data elements referred to in said statement that are associated with the different databases in real-time, and if said query transaction includes a sub query, executing said sub query, andestablishing a relationship between 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;clarifying characteristics of relationships of said data elements based on structure of said data manipulation language and content of said query transaction; andclassifying said characteristics; and conveying said classified characteristics in a display format.