Invention Grant
US07788305B2 Hierarchy nodes derived based on parent/child foreign key and/or range values on parent node
有权
基于父/子外键和/或父节点上的范围值导出的层次结构节点
- Patent Title: Hierarchy nodes derived based on parent/child foreign key and/or range values on parent node
- Patent Title (中): 基于父/子外键和/或父节点上的范围值导出的层次结构节点
-
Application No.: US11939505Application Date: 2007-11-13
-
Publication No.: US07788305B2Publication Date: 2010-08-31
- Inventor: Lars E. Martinsson , Mikhail Dumay
- Applicant: Lars E. Martinsson , Mikhail Dumay
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Truong & Becker LLP
- Agent Christian A. Nichole
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Nodes of a tree are dynamically generated. A user may specify that a node should have a separate child node for each unique value that occurs in a particular column of a relational table. A user may specify that a node should have a separate child node for each range of values in a user-specified set of ranges. Child nodes of a particular node may be dynamically determined and displayed by querying one or more relational tables for records that satisfy all of the criteria that are implied by that particular node and that particular node's parents. As a result of the foregoing techniques, users are not forced to create a tree node-by-node; instead, users can specify criteria based on which a whole level of nodes should be created, and a whole level of nodes may be added to a tree based on those criteria.
Public/Granted literature
- US20090125530A1 Hierarchy Nodes Derived Based on Parent/Child Foreign Key and/or Range Values on Parent Node Public/Granted day:2009-05-14
Information query