发明申请
US20050240624A1 Cost-based optimizer for an XML data repository within a database
有权
数据库中XML数据存储库的基于成本的优化器
- 专利标题: Cost-based optimizer for an XML data repository within a database
- 专利标题(中): 数据库中XML数据存储库的基于成本的优化器
-
申请号: US10830211申请日: 2004-04-21
-
公开(公告)号: US20050240624A1公开(公告)日: 2005-10-27
- 发明人: Fei Ge , Sivasankaran Chandrasekar , Nipun Agarwal , Ravi Murthy , Eric Sedlar
- 申请人: Fei Ge , Sivasankaran Chandrasekar , Nipun Agarwal , Ravi Murthy , Eric Sedlar
- 申请人地址: US CA REDWOOD SHORES
- 专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人地址: US CA REDWOOD SHORES
- 主分类号: G06F17/00
- IPC分类号: G06F17/00 ; G06F17/30
摘要:
Cost-based optimizer functionality for an XML database repository provides means for optimizing the execution of database queries that access XML resources in the database repository. Statistics about XML resources that are stored in the database repository are gathered, stored and utilized by a query optimizer to compute computational costs associated with each of multiple methods of accessing particular XML resources requested in a database query. Hence, the optimizer is able to select the most efficient query execution plan based on the costs of possible access paths. In one embodiment, specific statistics about the hierarchical structure of XML resources stored in the XML database repository are gathered, stored in a relational table in the database management system, and used to compute the selectivity of query predicates and the index cost associated with traversing one or more indexes to access requested XML resources.