Method for dynamically finding relations between database tables
First Claim
Patent Images
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; and
classifying said characteristics; and
conveying said classified characteristics in a display format.
4 Assignments
0 Petitions
Accused Products
Abstract
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.
-
Citations
18 Claims
-
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. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. 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. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. 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. - View Dependent Claims (14, 15, 16, 17, 18)
-
Specification