Patent ID: 8185563

Claim:
A computer-implemented method for visualizing the structure of data in a database via a plurality of reusable parametric queries and a plurality of graphical nodes at a visualization computer having a graphical user interface (“GUI”), each reusable parametric query comprising a partial query specification, an output field, and an input parameter, each graphical node corresponding to an instance of a reusable parametric query and comprising graphical controls corresponding to the partial query specification of the query instance, the input parameter of the query instance, and one or more result rows of the query instance, the method comprising: defining, by the visualization computer, a child reusable parametric query and a parent reusable parametric query comprising a linkage indication indicating a reusable linkage linking the output field of said parent reusable parametric query to the input parameter of said child reusable parametric query; obtaining, by the visualization computer, a parent-parameter value for the input parameter of an instance of said parent reusable parametric query (“parent instance”), said parent-parameter value completing the partial query specification of said parent instance; executing, by the visualization computer, said parent instance according to said parent-parameter value to obtain a plurality of parent-result rows, each comprising a data element corresponding to the output field of said parent instance; displaying in the GUI a parent graphical node corresponding to said parent instance; and for each of said plurality of parent-result rows, performing, by the visualization computer, an explosion operation comprising: linking the output field of said parent reusable parametric query to the input parameter of said child reusable parametric query; obtaining a child-parameter value according to the linked output field of the current parent-result row, said child-parameter value completing the partial query specification of said current child instance; automatically executing said current child instance to obtain at least one child-result row; and displaying in the GUI a current-child graphical node corresponding to said current child instance, and a graphical linkage control indicating linkage between said current parent-result row and said current-child graphical node.