Ncr Corporation

Hyperion Solutions Corporation

Hyperion Solution Corporation

Vijayakumar Anjur

Ambuj Shatdal

The present invention introduces the concept of a super-trigger to allow for multi-level hierarchical triggers in a database application. The super-trigger may be created by identifying one or more triggers as sub-triggers, and defining a condition in the super-trigger, the result of the condition depending from a result of one or more of the sub-triggers. Upon execution, information may be retrieved regarding a result for each of the sub-triggers. The condition may then be evaluated using these results, and an action may be performed if the condition is met.

Hierarchical triggers for database

Sampling may be supported in a multidimensional database by integrating it into metadata and/or data navigation requests. Additionally, biasing may be introduced to allow a user to focus results.

Sampling in a multidimensional database

A stratified sampling mechanism is provided in a database system. The stratified sampling mechanism includes defining a clause in a query that indicates stratified sampling is desired. Data from a source table is stratified into different subgroups based on stratification conditions in the query. Sampling is performed within each subgroup.

Growing community of inventors

Sunnyvale, CA, United States of America

Vijayakumar Anjur