Scheduling for data warehouse ETL processing and data mining execution
First Claim
1. A method for providing flexibility in scheduling control for an extract, transfer, and load (“
- ETL”
) scheduler in a data warehouse system, the method comprising;
extracting from a computer memory of the data warehouse system a dependent condition for a scheduled ETL processing step of the ETL scheduler;
extracting from computer memory related ETL data for the dependent condition;
determining whether the ETL data satisfies the dependent condition; and
executing the scheduled step if the ETL data satisfies the dependent condition.
2 Assignments
0 Petitions
Accused Products
Abstract
Providing flexibility in scheduling control for an extract, transfer, and load (“ETL”) scheduler in a data warehouse system, including extracting from a computer memory of the data warehouse system a dependent condition for a scheduled ETL processing step of the ETL scheduler, extracting from computer memory related ETL data for the dependent condition, determining whether the ETL data satisfies the dependent condition, and executing the scheduled step if the ETL data satisfies the dependent condition. A sub-scheduler typically is implemented as an interface between an ETL scheduler and external programs without modification of the ETL scheduler. In typical embodiments, an ETL scheduler includes a multiplicity of scheduled ETL processing steps, and computer memory of a data warehouse system includes dependent conditions for at least one of the scheduled ETL processing steps and ETL data related to at least one dependent condition.
-
Citations
24 Claims
-
1. A method for providing flexibility in scheduling control for an extract, transfer, and load (“
- ETL”
) scheduler in a data warehouse system, the method comprising;extracting from a computer memory of the data warehouse system a dependent condition for a scheduled ETL processing step of the ETL scheduler; extracting from computer memory related ETL data for the dependent condition; determining whether the ETL data satisfies the dependent condition; and executing the scheduled step if the ETL data satisfies the dependent condition. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
- ETL”
-
9. A system for providing flexibility in scheduling control for an extract, transfer, and load (“
- ETL”
) scheduler in a data warehouse system, the system comprising;means for extracting from a computer memory of the data warehouse system a dependent condition for a scheduled ETL processing step of the ETL scheduler; means for extracting from computer memory related ETL data for the dependent condition; means for determining whether the ETL data satisfies the dependent condition; and means for executing the scheduled step if the ETL data satisfies the dependent condition. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
- ETL”
-
17. A computer program product for providing flexibility in scheduling control for an extract, transfer, and load (“
- ETL”
) scheduler in a data warehouse system, the computer program product comprising;a recording medium; means, recorded on the recording medium, for extracting from a computer memory of the data warehouse system a dependent condition for a scheduled ETL processing step of the ETL scheduler; means, recorded on the recording medium, for extracting from computer memory related ETL data for the dependent condition; means, recorded on the recording medium, for determining whether the ETL data satisfies the dependent condition; and means, recorded on the recording medium, for executing the scheduled step if the ETL data satisfies the dependent condition. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24)
- ETL”
Specification