首页>
外国专利>
Dynamic selection of optimal grouping sequence at runtime for grouping sets, rollup and cube operations in SQL query processing
Dynamic selection of optimal grouping sequence at runtime for grouping sets, rollup and cube operations in SQL query processing
展开▼
机译:在运行时动态选择最佳分组顺序,以进行SQL查询处理中的分组集,汇总和多维数据集操作
展开▼
页面导航
摘要
著录项
相似文献
摘要
A method, apparatus, and article of manufacture for optimizing a query in a computer system. Grouping operations are optimized during execution of the query in the computer system by: (1) translating the grouping operations into a plurality of levels, wherein each of the levels is comprised of one or more grouping sets with the same number of grouping expressions; (2) deriving the grouping sets on a level-by-level basis, wherein the grouping sets in a base level are obtained from the database and the grouping sets in a next one of the levels are derived by selecting as an input a smallest one of the grouping sets in a previous one of the levels with which it has a derivation relationship; and (3) combining the derived grouping sets into an output for the query.
展开▼