Back to results
US 8,135,666 B2Granted
Systems and methods for policy based execution of time critical data warehouse triggers
AssigneeInternational Business Machines Corporation
InventorsRajeev Gupta, Mukesh K. Mohania
Life of this patent
Estimating the term…
Abstract
Embodiments of the invention broadly contemplate systems, methods, apparatuses and program products that employ a policy based method of timely execution of triggers over a data warehouse. Embodiments of the invention utilize methods to convert a trigger condition into differential queries over data sources, to decide when to send queries to data sources, and determine to which data sources to send queries.
Claims20
An apparatus comprising:
- at least one processor;
- and
- a computer readable storage medium having computer readable program code embodied therewith and executable by the at least one processor, the computer readable program code comprising:
- computer readable program code configured to send at least one query to a data warehouse;
- computer readable program code configured to evaluate a trigger condition;
- computer readable program code configured to, responsive to a determination that the trigger condition is not satisfied by a query result obtained from the at least one query sent to the data warehouse and the trigger condition is close to being true, send at least one differential query to at least one remote data source;
- and
- computer readable program code configured to determine an aggregate query result, the aggregate query result comprising an aggregation of the query result obtained from the at least one query sent to the data warehouse and at least one query result obtained from the at least one differential query.
5 more elements
A method comprising:
- sending at least one query to a data warehouse;
- evaluating a trigger condition;
- responsive to determining that the trigger condition is not satisfied by a query result obtained from the at least one query sent to the data warehouse and the trigger condition is close to being true, sending at least one differential query to at least one remote data source;
- and
- determining an aggregate query result, the aggregate query result comprising an aggregation of the query result obtained from the at least one query sent to the data warehouse and at least one query result obtained from the at least one differential query.
2 more elements
A computer program product comprising:
- a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising:
- computer readable program code configured to send at least one query to a data warehouse;
- computer readable program code configured to evaluate a trigger condition;
- computer readable program code configured to, responsive to a determination that the trigger condition is not satisfied by a query result obtained from the at least one query sent to the data warehouse and the trigger condition is close to being true, send at least one differential query to at least one remote data source;
- and
- computer readable program code configured to determine an aggregate query result, the aggregate query result comprising an aggregation of the query result obtained from the at least one query sent to the data warehouse and at least one query result obtained from the at least one differential query.
3 more elements
Dependencies are inferred from the claim text.