ALLOCATING RESOURCES IN A DATA WAREHOUSE

• US 20110167033A1
• Filed: 01/05/2010
• Published: 07/07/2011
• Est. Priority Date: 01/05/2010
• Status: Abandoned Application

• Current Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Original Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Inventors: FRADIN, Lionel, BASHOR, Todd, STRELITZ, David
• Application Number:
  US12/652,424
• Publication Number:
  US 20110167033A1
• Time in Patent Office: Days
• US Class Current: 707/602
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures

Abstract

Systems, methods and computer-readable storage media are provided for allocating resources in a data warehouse. A table of resources may be retrieved from the data warehouse, the table including a plurality of records, each record having data that describes a resource to be allocated. A first resource described in a first record of the table of resources may be reserved pursuant to a first rule of a first stage. The first resource may then be allocated into one or more records of a working allocation table pursuant to the first rule.

Claims

1. A method of allocating resources in a data warehouse, comprising:

retrieving from the data warehouse a table of resources, the table including a plurality of records, each record having data that describes a resource to be allocated;

reserving a first resource described in a first record of the table of resources pursuant to a first rule of a first stage; and

allocating the first resource into one or more records of a working allocation table pursuant to the first rule.

2. The method of claim 1, further comprising:

reserving a second resource described in a second record of the table of resources pursuant to the first rule;

allocating the second resource into one or more records of the working allocation table pursuant to the first rule.

3. The method of claim 1, further comprising storing an identifier associated with the first record in an allocation reservation table to indicate that the first resource has been allocated.

4. The method of claim 1, further comprising reallocating a resource described in a record of the working allocation table pursuant to a rule of a second stage.

5. The method of claim 1, further comprising reallocating a resource described in a record of the working allocation table into one or more new records of the working allocation table pursuant to a rule of a second stage.

6. The method of claim 1, further comprising writing data from the working allocation table back into the data warehouse.

7. The method of claim 6, wherein writing data from the working allocation table back into the data warehouse further includes writing data from records of the working allocation table that were created in a final stage of a series of stages that includes the first stage.

8. The method of claim 6, wherein writing data from the working allocation table back into the data warehouse further includes providing data from the working allocation table to an extract, transform and load process.

9. The method of claim 2, further comprising outputting a sum of the first resource and the second resource prior to allocating the first or second resource into one or more records of the working allocation table.

10. The method of claim 1, further comprising outputting progress of allocating the first resource into one or more records of the working allocation table.

11. A computer-readable storage medium having computer-executable instructions for allocating resources in a data warehouse, the instructions causing a computer to perform steps comprising:

retrieving from the data warehouse a table of resources, the table including a plurality of records, each record having data that describes a resource to be allocated;

reserving a first resource described in a first record of the table of resources pursuant to a first rule of a first stage; and

allocating the first resource into one or more records of a working allocation table pursuant to the first rule.

12. The computer-readable storage medium of claim 11, further including computer-executable instructions for:

reserving a second resource described in a second record of the table of resources pursuant to the first rule;

allocating the second resource into one or more records of the working allocation table pursuant to the first rule.

13. The computer-readable storage medium of claim 11, further including computer-executable instructions for storing an identifier associated with the first record in an allocation reservation table to indicate that the first resource has been allocated.

14. The computer-readable storage medium of claim 11, further including computer-executable instructions for reallocating a resource described in a record of the working allocation table pursuant to a rule of a second stage.

15. The computer-readable storage medium of claim 11, further including computer-executable instructions for reallocating a resource described in a record of the working allocation table into one or more new records of the working allocation table pursuant to a rule of a second stage.

16. The computer-readable storage medium of claim 11, further including computer-executable instructions for writing data from the working allocation table back into the data warehouse.

17. The computer-readable storage medium of claim 16, wherein writing data from the working allocation table back into the data warehouse further includes writing data from records of the working allocation table that were created in a final stage of a series of stages that includes the first stage.

18. The computer-readable storage medium of claim 12, further including computer-executable instructions for outputting a sum of the first resource and the second resource prior to allocating the first or second resource into one or more records of the working allocation table.

19. The computer-readable storage medium of claim 11, further including computer-executable instructions for outputting progress of allocating the first resource into one or more records of the working allocation table.

20. A system for allocating resources, comprising:

a source database;

a data warehouse configured to retrieve a table of resources from the source database, the table including a plurality of records, each record having data that describes a resource to be allocated;

an allocation engine configured to;

reserve a first resource described in a first record of the table of resources pursuant to a rule of a first stage;

allocate the first resource into one or more records of a working allocation table pursuant to the rule;

store an identifier associated with the first record in an allocation reservation table to indicate that the first resource has been allocated; and

reallocate a resource described in a record of the working allocation table pursuant to a rule of a second stage.