×

Hierarchy nodes derived based on parent/child foreign key and/or range values on parent node

  • US 9,400,814 B2
  • Filed: 07/27/2010
  • Issued: 07/26/2016
  • Est. Priority Date: 11/13/2007
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method comprising steps of:

  • receiving user-specified criteria comprising a first column of a first database table stored in a database, and a set of user-specified ranges comprising two or more user-specified ranges for values of the first column;

    in response to receiving the user-specified criteria, adding, to a tree structure, a first new subtree comprising a first set of nodes, wherein each node in the first set of nodes corresponds to a particular user-specified range of the set of user-specified ranges for the first column;

    displaying the tree structure with the first new subtree;

    after displaying the tree structure with the first new subtree, receiving additional user input identifying a user-selected node of the first set of nodes that corresponds to a particular range of the set of user-specified ranges;

    in response to receiving the additional user input identifying the user-selected node after displaying the tree structure with the first new subtree, identifying records in the database that match the particular range corresponding to the user-selected node, generating a second set of nodes based on a set of second field values for a second column of the identified records, and adding, to the tree structure, a second new subtree that descends from the user-selected node, the second new subtree comprising the second set of nodes;

    after adding the second new subtree to the tree structure, displaying, in the tree structure, the second new subtree;

    wherein the hierarchical parent-child relationship between the second set of nodes and the user-selected node of the first set of nodes is not generated or stored before the additional user input identifying the user-selected node is received;

    wherein the steps are performed by one or more computing devices.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×