Invention Grant
- Patent Title: System and method for querying data for implicit hierarchies
- Patent Title (中): 用于查询隐式层次结构数据的系统和方法
-
Application No.: US10449946Application Date: 2003-05-30
-
Publication No.: US07801913B2Publication Date: 2010-09-21
- Inventor: Saurabh Shrivastava , Uppili Srinivasan
- Applicant: Saurabh Shrivastava , Uppili Srinivasan
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Vista IP Law Group, LLP.
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
A method, system, and article of manufacture for querying an implicit hierarchy is disclosed. According to one approach, implicit hierarchies can be queried by accessing the relevant catalog tables for the attribute relevant to the query. Each identified entry in the relevant catalog table is followed through its implied hierarchical chains until all relevant entries have been identified. The catalog table containing the normalized form of the DN for each user can be consulted to identify the entry identifier for each entry corresponding to implicit hierarchy being queried, which can be searched in the appropriate catalog table to search the chain of entries for the implied hierarchy. In an approach, one or more templates may be used to generate a query language statement to perform the query upon the implicit hierarchy.
Public/Granted literature
- US20040243576A1 System and method for querying data for implicit hierarchies Public/Granted day:2004-12-02
Information query