发明申请
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
摘要:
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.
信息查询
0/0