Data transition in highly parallel database management system

1. A method for execution by one or more processing units of a database management system, the method comprising:

determining, by the one or more processing units, to transition a collection of data from storage in a set of first temperature storage nodes of the database management system to storage in a set of second temperature storage nodes of the database management system based on one or more criteria associated with the collection of data, wherein each first temperature storage node of the set of first temperature storage nodes is paired with a corresponding second temperature storage node of the set of second temperature storage nodes to form a set of parallel node pairs;

transitioning storage of the collection of data, in parallel, by each parallel node pair of the set of parallel node pairs, from storage in the set of first temperature storage nodes to storage in the set of second temperature storage nodes;

determining the collection of data has been stored in the set of second temperature storage nodes; and

deleting the collection of data in the set of first temperature storage nodes.

2. The method of claim 1 , wherein a criterion of the one or more criteria comprises:

a data transition rule.

3. The method of claim 1 , wherein a criterion of the one or more criteria comprises:

an age of the collection of data.

4. The method of claim 3 , wherein the determining to transition the collection of data comprises:

determining the age of the collection of data exceeds an age threshold.

5. The method of claim 1 , wherein a criterion of the one or more criteria comprises:

a least recently used criterion.

6. The method of claim 1 , wherein a criterion of the one or more criteria comprises:

a data access pattern.

7. The method of claim 6 further comprises:

periodically determining whether the data access pattern compares unfavorably to a data access pattern threshold; and

when determining the data access pattern compares unfavorably to the data access pattern threshold, determining to perform the transition.

8. The method of claim 1 , wherein the determining the collection of data has been stored comprises:

receiving a confirmation of a successful write from the set of second temperature storage nodes.

9. The method of claim 1 , wherein the transitioning storage of the collection of data in parallel is via remote direct memory access links.

10. The method of claim 1 further comprises:

prior to the determining to transition:

determining the collection of data is of a first temperature, wherein the first temperature indicates an expected access rate of the collection of data is above a first access rate threshold; and

storing the collection of data in the set of first temperature storage nodes.

11. The method of claim 1 further comprises:

determining, by the one or more processing units, to transition the collection of data from storage in the set of second temperature storage nodes to storage in a set of third temperature nodes of the database management system based on the one or more criteria associated with the collection of data, wherein each second temperature storage node of the set of second temperature storage nodes is paired with a corresponding third temperature storage node of the set of third temperature storage nodes to form a second set of parallel node pairs; and

transitioning storage of the collection of data in parallel, by each second parallel node pair of the second set of parallel node pairs, from storage in the set of second temperature storage nodes to storage in the set of third temperature storage nodes.

12. The method of claim 11 further comprises:

determining to transition the collection of data from storage in the set of third temperature storage nodes to storage in a set of fourth temperature nodes based on the one or more criteria associated with the collection of data, wherein each third temperature storage node of the set of third temperature storage nodes is paired with a corresponding fourth temperature storage node of the set of fourth temperature storage nodes to form a third set of parallel node pairs; and

transitioning storage of the collection of data in parallel, by each third parallel node pair of the third set of parallel node pairs, from storage in the set of third temperature storage nodes to storage in the set of fourth temperature storage nodes.

13. The method of claim 12 , wherein storage devices of the set of second temperature storage nodes comprise non-volatile random access memory.

14. The method of claim 12 , wherein storage devices of the set of third temperature storage nodes comprise serial advanced technology attachment (SATA) solid state drives (SSD) memory.

15. The method of claim 12 , wherein storage devices of the set of fourth temperature storage nodes comprise archival storage devices.

16. The method of claim 1 , wherein storage devices of the set of first temperature storage nodes comprise dynamic random access memory.

17. The method of claim 1 , wherein storage devices of the set of first temperature storage nodes comprise flash memory.

18. The method of claim 17 , wherein storage devices of the set of second temperature storage nodes comprise non-volatile random access memory.