发明申请
US20080222087A1 System and Method for Optimizing Query Access to a Database Comprising Hierarchically-Organized Data
审中-公开
用于优化对包含分层有组织数据的数据库的查询访问的系统和方法
- 专利标题: System and Method for Optimizing Query Access to a Database Comprising Hierarchically-Organized Data
- 专利标题(中): 用于优化对包含分层有组织数据的数据库的查询访问的系统和方法
-
申请号: US11383481申请日: 2006-05-15
-
公开(公告)号: US20080222087A1公开(公告)日: 2008-09-11
- 发明人: Andrey Balmin , Tom Eliaz , Guy M. Lohman , David E. Simmen , Chun Zhang
- 申请人: Andrey Balmin , Tom Eliaz , Guy M. Lohman , David E. Simmen , Chun Zhang
- 申请人地址: US NY Armonk
- 专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人地址: US NY Armonk
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
An cost based optimizer optimizes access to at least a portion of hierarchically-organized documents, such as those formatted using eXtensible Markup Language (XML), by estimating a number of results produced by the access of the hierarchically-organized documents. Estimating the number of results comprises computing the cardinality of each operator executing query language expressions and further computing a sequence size of sequences of hierarchically-organized nodes produced by the query language expressions. Access to the hierarchically-organized documents is optimized using the structure of the query expression and/or path statistics involving the hierarchically-organized data. The cardinality and the sequence size are used to calculate a cost estimation for execution of alternate query execution plans. Based on the cost estimation, an optimal query execution plan is selected from among the alternate query execution plans.
信息查询