Partition exchange technique for operating a data warehousing system
A method and apparatus for operating a database system is provided. One or more partitions are identified from a data structure in the database system. An identifier is assigned to at least one of the partitions. An external partition is identified that is not one of the partitions that form the data structure. An identifier is determined for the external partition. The first partition is removed from the data structure by exchanging the identifier of the external partition with the identifier of the first partition in the set of partitions.
1. A method for manipulating a data structure within a database system, the method comprising:
identifying one or more partitions in a set of partitions forming the data structure, wherein a first partition of the one or more partitions is associated with an identifier;
identifying an external partition, wherein the external partition is within the database system but is not one of the partitions forming the data structure;
determining an identifier for the external partition; and
removing the first partition from the data structure by exchanging the identifier of the external partition with the identifier of the first partition.
2. The method of claim 1 , wherein the step of removing the first partition from the data structure includes associating the first partition with the identifier of the external partition, wherein the first partition is external to the data structure.
3. The method of claim 2 , wherein, after the step of removing the first partition, the method comprises archiving data contained within the first partition.
4. The method of claim 2 , wherein after the step of removing the first partition, the method includes transferring the first partition to an external computer readable storage medium.
5. The method of claim 1 , wherein the method further comprises deleting the first partition after removing the first partition from the data structure.
6. The method of claim 1 , wherein identifying an external partition includes identifying an empty partition, wherein the empty partition is external to the data structure.
7. The method of claim 6 , wherein before the step of removing the first partition, the external partition is empty.
8. The method of claim 1 , wherein the step of removing the first partition includes integrating the external partition with the data structure by exchanging the identifier of the external partition with the identifier of the first partition.
9. The method of claim 8 , wherein before the step of removing the first partition, the external partition has new data, and wherein the step of removing the first partition is performed, wherein integrating the external partition with the data structure results in replacing existing data in the first partition of the data structure with the new data in the external partition.
10. The method of claim 1 , wherein before the step of removing the first partition, the method further comprises selecting the first partition for exchange based on an attribute of the first partition.
11. The method of claim 1 , wherein before the step of removing the first partition, the method further comprises selecting the first partition by matching a partition condition of the external partition with a partition condition for the first partition.
12. The method of claim 1 , wherein before the step of removing the first partition, the method further comprises selecting the first partition, and wherein a partition condition for the external partition is different than a partition condition for the first partition.
13. The method of claim 1 , wherein before the step of removing the first partition, the external partition contains data, and wherein the step of removing the first partition is performed, wherein integrating the external partition with the data structure results in adding the new data into the data structure.
14. The method of claim 1 , wherein the method further comprises maintaining an index for the data structure, generating a new index for a new set of data, and combining the new index with the index of the data structure in conjunction with exchanging the identifier of the external partition with the identifier of the first partition.
15. A computer readable storage medium storing instructions for operating a database system, the instructions including instructions for performing the steps of:
identifying one or more partitions in a set of partitions forming the data structure, wherein a first partition of the one or more partitions is associated with an identifier;
identifying an external partition, wherein the external partition is within the database system but is not one of the partitions forming the data structure;
determining an identifier for the external partition; and
removing the first partition from the data structure by exchanging the identifier of the external partition with the identifier of the first partition.
16. The computer readable storage medium of claim 15 , wherein instructions for performing the step of removing the first partition from the data structure include instructions for associating the first partition with the identifier of the external partition, wherein the first partition is external to the data structure.
17. The computer readable storage medium of claim 16 , wherein, after instructions for performing the step of removing the first partition is executed, the computer readable storage medium comprises instructions for archiving data contained within the first partition.
18. The computer readable storage medium of claim 16 , wherein after instructions for performing the step of removing the first partition are executed, the computer readable storage medium includes instructions for transferring the first partition to an external computer readable storage medium.
19. The computer readable storage medium of claim 15 , wherein the computer readable storage medium further comprises instructions for deleting the first partition after removing the first partition from the data structure.
20. The computer readable storage medium of claim 15 , wherein instructions for performing the step of identifying an external partition include instructions for identifying an empty partition, where in the empty partition is external to the data structure.
21. The computer readable storage medium of claim 20 , wherein before instructions for performing the step of removing the first partition are executed, the external partition is empty.
22. The computer readable storage medium of claim 15 , wherein instructions for performing the step of removing the first partition include instructions for integrating the external partition with the data structure by exchanging the identifier of the external partition with the identifier of the first partition.
23. The computer readable storage medium of claim 22 , wherein before instructions for the step of removing the first partition are executed, the external partition has new data, and wherein instructions for performing the step of removing the first partition is performed, wherein integrating the external partition with the data structure results in replacing existing data in the first partition of the data structure with the new data in the external partition.
24. The computer readable storage medium of claim 15 , wherein before instructions for performing the step of removing the first partition are executed, the computer readable storage medium further comprises instructions for selecting the first partition for exchange based on an attribute of the first partition.
25. The computer readable storage medium of claim 15 , wherein before instructions for performing the step of removing the first partition are executed, the computer readable storage medium further comprises instructions for selecting the first partition by matching a partition condition of the external partition with a partition condition for the first partition.
26. The computer readable storage medium of claim 15 , wherein before instructions for performing the step of removing the first partition are executed, the computer readable storage medium further comprises instructions for selecting the first partition, and wherein a partition condition for the external partition is different than a partition condition for the first partition.
27. The computer readable storage medium of claim 15 , wherein before instructions for performing the step of removing the first partition are executed, the external partition contains data, and wherein instructions for performing the step of removing the first partition is performed, wherein integrating the external partition with the data structure results in adding the new data into the data structure.
28. The computer readable storage medium of claim 15 , wherein the computer readable storage medium further comprises instructions for maintaining an index for the data structure, generating a new index for a new set of data, and combining the new index with the index of the data structure in conjunction with exchanging the identifier of the external partition with the identifier of the first partition.