Patent ID: 7707144
Filing Date: 2010-04-27
Classification: G06F,Y10S

Abstract:
1. A method in a computing system for processing a distinct count query, wherein the computing system comprises a processor coupled to a memory and the method comprises: receiving a query requesting a distinct count of a detail table, wherein identifying an aggregate table corresponding to the detail table; determining, using the processor, whether rows of the identified aggregate table contain (1) identifiers of the specified type or (2) counts each indicating a number of unique identifiers of the specified type occurring in the detail table for different combinations of dimension values, each dimension value at a particular level of its dimension; if the rows of the identified aggregate table contain identifiers of the specified type: if the rows of the identified aggregate table contain counts each indicating a number of unique identifiers of the specified type occurring in the detail table for different combinations of dimension values, each dimension value at a particular level of its dimension: