The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Oct. 11, 2011
Filed:
May. 01, 2008
Robert J. Bestgen, Rochester, MN (US);
David G. Carlson, Rochester, MN (US);
Robert V. Downer, Rochester, MN (US);
Shantan Kethireddy, Rolling Meadows, IL (US);
Robert J. Bestgen, Rochester, MN (US);
David G. Carlson, Rochester, MN (US);
Robert V. Downer, Rochester, MN (US);
Shantan Kethireddy, Rolling Meadows, IL (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A process combines multiple grouping sets into single rollup sets with depth lists defining the levels of grouping that must be performed. Grouping sets are identified that are contained within other sets and combined into single rollups with depth lists. Cube aggregation conversion to rollup aggregation is provided for optimizing database query processing. Natural sets of rollup hierarchies within a cube are recognized and the cube is converted into those rollup hierarchies. Once converted, the rollup aggregation is performed to significantly reduce required processing.