Patent ID: 8019771
Filing Date: 2011-09-13
Classification: G06F

Abstract:
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, and establishing 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; and classifying said characteristics; and conveying said classified characteristics in a display format.