发明申请
US20110119283A1 TECHNIQUES FOR EFFICIENT QUERIES ON A FILE SYSTEM-LIKE REPOSITORY
有权
对文件系统类似报告的有效查询的技术
- 专利标题: TECHNIQUES FOR EFFICIENT QUERIES ON A FILE SYSTEM-LIKE REPOSITORY
- 专利标题(中): 对文件系统类似报告的有效查询的技术
-
申请号: US12618356申请日: 2009-11-13
-
公开(公告)号: US20110119283A1公开(公告)日: 2011-05-19
- 发明人: Asha Tarachandani , Bhushan Khaladkar , Sam Idicula , Adiel Yoaz , Nipun Agarwal
- 申请人: Asha Tarachandani , Bhushan Khaladkar , Sam Idicula , Adiel Yoaz , Nipun Agarwal
- 申请人地址: US CA REDWOOD SHORES
- 专利权人: ORACLE INTERNATIONAL XORPORATION
- 当前专利权人: ORACLE INTERNATIONAL XORPORATION
- 当前专利权人地址: US CA REDWOOD SHORES
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
Techniques are provided to achieve performance improvements for path-based access to hierarchical data and for utilizing an extensible indexing framework. Extensible operators may be optimized by evaluating the operators using functions native to the database system instead of using functions defined through an extensible indexing mechanism. Furthermore, the database system may resolve a resource path of a query when the query is compiled, and may store the mapping of the resource path to one or more resources in a cursor for the query execution plan to avoid resolving the resource path each time the cursor is used to run the query. The cursor may be made dependent on the one or more resources to which the resource path refers at compile time. This takes advantage of the observation that the mapping of the resource path to particular resources rarely changes between evaluations of a particular query.