Invention Grant
- Patent Title: Determining database relationships through query monitoring
- Patent Title (中): 通过查询监控确定数据库关系
-
Application No.: US10961735Application Date: 2004-10-08
-
Publication No.: US08135691B2Publication Date: 2012-03-13
- Inventor: Mahdad Majd , John Matthew Santosuosso
- Applicant: Mahdad Majd , John Matthew Santosuosso
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Martin & Associates LLC
- Agent Derek P. Martin
- Main IPC: G06F7/00
- IPC: G06F7/00

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.
Public/Granted literature
- US20060080287A1 Apparatus and method for determining database relationships through query monitoring Public/Granted day:2006-04-13
Information query