METHOD FOR SCHEDULING A TASK IN A DATA WAREHOUSE

• US 20120109879A1
• Filed: 12/29/2010
• Published: 05/03/2012
• Est. Priority Date: 10/28/2010
• Status: Active Grant

• Current Assignee: Micro Focus LLC (Open Text Corporation)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: DEVADOSS, Madan Gopal, Ramakrishna, Panish, Singh, Ranveer Kumar
• Granted Patent: US 8,892,505 B2
• Time in Patent Office: Days
• US Class Current: 707/602
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 9/4843 by program, e.g. task dispatcher, supervisor, operating system

Abstract

Provided is a method and system for scheduling a task in a data warehouse. A task in a data warehouse is scheduled based on selection of a report related to the data warehouse.

Claims

1. A computer-implemented method for scheduling a task in a data warehouse, comprising:

selecting a report related to the data warehouse; and

scheduling a task in the data warehouse based on the selected report.

2. A method according to claim 1, wherein scheduling a task in the data warehouse based on the selected report includes identifying a task associated with the selected report.

3. A method according to claim 2, wherein identifying the task associated with the selected report comprises:

identifying at least one business view associated with the selected report;

identifying at least one physical table associated with the identified business view; and

identifying at least one task associated with the identified physical table, wherein the identified at least one task is associated with the selected report.

4. A method according to claim 3, wherein the at least one business view associated with the selected report, the at least one physical table associated with the identified business view and the at least one task associated with the identified physical table are identified by querying a data warehouse model associated with the data warehouse.

5. A method according to claim 3, further comprising identifying sequence of task execution, in case more than one task is associated with the identified physical table.

6. A method according to claim 3, further comprising identifying any tasks dependent on the at least one task associated with the selected report.

7. A method according to claim 1, wherein the task is an ETL (extract, transfer, and load) task.

8. A method according to claim 1, wherein the task is a data warehouse task.

14. A computer program comprising computer readable means adapted to execute the method of claim 1 when said program is run on a computer system.

15. A computer program according to claim 14 embodied on a computer readable storage medium.

9. A system, comprising:

a memory for storing a data warehouse;

an input system for selecting a report related to the data warehouse; and

a processor for scheduling a task in the data warehouse based on the selected report.

10. A system according to claim 9, wherein scheduling a task in the data warehouse based on the selected report includes identifying a task associated with the selected report.

11. A system according to claim 10, wherein identifying the task associated with the selected report comprises:

identifying at least one business view associated with the selected report;

identifying at least one physical table associated with the identified business view; and

identifying at least one task associated with the identified physical table, wherein the identified at least one task is associated with the selected report.

12. A system according to claim 9, wherein the task is an ETL (extract, transfer, and load) task.

13. A system according to claim 9, wherein the task is a data warehouse task.