Browse Prior Art Database

Hierarchical Display Of Group Discovery Relationships In A Relational Database System Disclosure Number: IPCOM000203884D
Publication Date: 2011-Feb-08
Document File: 6 page(s) / 91K

Publishing Venue

The Prior Art Database


Disclosed is a method for improving the group (of related tables) discovery and relationship identification process implemented with Database Relationship Analyzer (DRA). The invention utilizes a tree-based view to display the tables that make up the groups, thus enabling the user to quickly see the hierarchical structure of the discovered relationships. The system employs a specific algorithm to build a directed graph which determines the hierarchical structure. A choice of layout options is provided for the user to view the relationships among the tables in multiple ways.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 25% of the total text.

Page 01 of 6

Hierarchical Display Of Group Discovery Relationships In A Relational Database System

IBM Optim* Database Relationship Analyzer (DRA) is a tool that analyzes user databases to discover relationships among database tables. The related tables are presented as groups

which are available for a user to examine and use with other tools

where knowing the relationships among the database tables is useful. Group discovery

in DRA is based on information from multiple sources, including the database catalog and Structured Query Language (SQL) trace logs. The user can configure the specific sources of information to use during a given group discovery run.

As a result, the kinds

of relationships between the tables can vary depending on the sources of the relationships or other user-specified discovery parameters. Of particular interest to the user is finding table-to-table relationships that have column-based information linking the tables.

DRA enables users to run repeated, iterative group discoveries on their databases. The results of these discoveries,

which are made up of one or more groups of related

After a group discovery has been run, DRA enables

users to examine the results of the group discovery run by selecting a menu option on the version to display the group discovery results for that version.

Because a version can consist of many groups, possibly involving hundreds or even thousands of tables and relationships, a method is needed to efficiently present the discovery results that enables the user to review and analyze them before deciding

whether to use the results as is or to alternatively modify the group discovery

configuration so that the results from a subsequent discovery run are different. Users can modify the group discovery configuration, for example, by utilizing other relationship sources or by excluding or including other tables or relationships not used in the last run.

The challenge with presenting the group discovery results, then, is in finding a way to present a large amount of information in a way that enables the user to see the hierarchy of the related tables at a glance,

while still being able to see detailed

Additionally, since users are primarily interested

in table-to-table relationships that are column-based, a method is needed which presents those relationships for which column information is available separately from those for which column-based information is not available. Users might want to modify the group discovery configuration based on reviewing the current group discovery results; therefore, a method to directly modify the group discovery configuration from

within the view that displays the results helps the user to efficiently utilize the analysis of

the current results to produce desired changes in a subsequent group discovery run.

The disclosed solution utilizes a tree-based view to display the tables in the groups that are found during the run of the user's group discovery configuration, th...