Merced Systems, Inc.

Nice Systems Technologies Inc.

Robert Todd Hunter, Iii

Todd O Dampier

William Banks Shulman

A method/system considers the phenomenon of slowly changing dimensions in the process of reporting on facts of a collection of facts organized as, or otherwise accessible according to, a dimensionally-modeled fact collection. A report query specifies a temporal mode, and the specified temporal mode is processed to determine a time extent descriptor (e.g., in view of at least one of a context, in which the report query is made, and at least one dimension coordinate constraint). A processed result of querying the dimensionally-modeled fact collection includes appropriate indications of dimension coordinates in view of the time information from the time extent descriptor.

Temporal extent considerations in reporting on facts organized as a dimensionally-modeled fact collection

A received report query specifies a dimension coordinate constraint and an associated grain for the dimension coordinate constraint. At least one query is generated to the dimensionally-modeled fact collection. A result of providing the at least one query to the dimensionally-modeled fact collection is processed. The processed result includes an indication of every dimension coordinate satisfying the dimension coordinate constraint and having a particular value at the associated grain, and the processed result further includes facts of the dimensionally-modeled fact collection that are specified by at least one other dimension coordinate indicated by the processed result having the particular value at the associated grain and not satisfying the dimension coordinate constraint.

Growing community of inventors

San Francisco, CA, United States of America

Robert Todd Hunter, Iii