Determining database relationships through query monitoring
AssigneeInternational Business Machines Corporation
InventorsMahdad Majd, John Matthew Santosuosso
Life of this patent
Estimating the term…
Abstract
An apparatus and method monitor database queries and allow determining database relationships from the analysis of the database queries. The database relationships are inferred from the analysis of the database queries. The result sets of queries are analyzed to determine if any relationships between the columns specified in the queries may be inferred. In one embodiment, when a relationship between columns is discovered from analyzing query results, a system administrator is notified. In another embodiment, the relationship is stored so it may be retrieved and viewed at a later time by the system administrator.
Claims1
A computer-implemented method for determining at least one relationship in a database, the method comprising the steps of:
- (A) a user setting a value for a monitor window that specifies a time period that identifies a number of queries in a database application to analyze, wherein the monitor window is a sliding window that advances as the database application executes;
- (B) analyzing results of the database application executing the plurality of queries to the database in the monitor window;
- and
- (C) determining from the analyzed results in step (B) at least one relationship in the database that is defined by data residing in the database and that is not specified in a defined schema for the database between a first column in a first table and a second column in a second table in the database.
Dependencies are inferred from the claim text.