Capacity management for trees under multi-version concurrency control
Capacity management is provided for a plurality of search trees under multi-version concurrency control. A non-volatile memory includes a plurality of chunks that are fixed-sized blocks of the non-volatile memory, each chunk including at least one page. The non-volatile memory stores the plurality of search trees, each search tree having elements including a tree root, a tree node and a tree leaf. Each element of the tree is at a different level of the search tree: a first level including the tree root, a second level including the tree node, and a third level including the tree leaf. The plurality of chunks includes a number of chunk types, each chunk type for storing the element from a different level of the search tree, such that elements from different levels are stored in separate chunks.
1. A system for capacity management for a plurality of search trees under multi-version concurrency control, the system comprising:
a non-volatile memory including a plurality of chunks that are fixed-sized blocks of the non-volatile memory, each chunk including at least one page; and
a processor coupled to the non-volatile memory,
wherein the non-volatile memory stores the plurality of search trees, each search tree having elements including a tree root, a tree node and a tree leaf, each element being at a different level of the search tree, a first level including the tree root, a second level including the tree node, and a third level including the tree leaf,
wherein the plurality of chunks include a number of chunk types, the number of chunk types based on a size of the at least one page, each chunk type for storing elements from one or more different levels of the search tree, such that each chunk type stores elements from different levels as other chunk types,
wherein the number of chunk types include a first chunk type for storing the tree root at the first level, a second chunk type for storing the tree node at the second level, and a third chunk type for storing the tree leaf at the third level, the tree root having at least two tree leaves connected directly below the tree root, the tree node or the second level comprising a single level.
2. The system of claim 1 wherein the number of chunk types include a first chunk type for storing the tree root or the tree node and a second chunk type for storing the tree leaf.
3. The system of claim 1 wherein the number of chunk types is further based on a probability of an update being performed on the search tree.
4. The system of claim 1 wherein the number of chunk types is further based on a size of one of the plurality of chunks.
5. The system of claim 1 wherein a probability that one of the elements of the search tree will be updated decreases as the search tree is traversed from the first level including the tree root to the third level including the tree leaf.
6. The system of claim 1 wherein a lifetime of one of the elements of the search tree increases as the search tree is traversed from the first level including the tree root to the third level including the tree leaf.
7. The system of claim 1 , wherein each of the plurality of search trees is a B+ trees.
8. A method of capacity management for a plurality of search trees under multi-version concurrency control, the method comprising:
storing a plurality of search trees on a non-volatile memory including a plurality of chunks that are fixed-sized blocks of the non-volatile memory, each chunk including at least one page,
wherein each search tree has elements including a tree root, a tree node and a tree leaf, each element being at a different level of the search tree, a first level including the tree root, a second level including the tree node, and a third level including the tree leaf,
wherein the plurality of chunks includes a number of chunk types, the number of chunk types based on a size of the at least one page, each chunk type for storing elements from one or more different levels of the search tree, such that each chunk type stores elements from different levels as other chunk types, and
wherein the number of chunk types include a first chunk type for storing the tree root at the first level, a second chunk type for storing the tree node at the second level, and a third chunk type for storing the tree leaf at the third level, the tree root having at least two tree leaves connected directly below the tree root, the tree node or the second level comprising a single level.
9. The method of claim 8 wherein the number of chunk types include a first chunk type for storing the tree root and the tree node and a second chunk type for storing the tree leaf.
10. The method of claim 8 wherein the number of chunk types is further based on at least one of a probability of an update being performed on the search tree, and a size of one of the plurality of chunks.
11. The method of claim 8 wherein a probability that one of the elements of the search tree will be updated decreases as the search tree is traversed from the first level including the tree root to the third level including the tree leaf.
12. The method of claim 8 wherein a lifetime of one of the elements of the search tree increases as the search tree is traversed from the first level including the tree root to the third level including the tree leaf.
13. A non-transitory computer-readable storage medium storing computer-executable instructions, the instructions causing a machine to execute a process of capacity management for a plurality of search trees under multi-version concurrency control, the process comprising:
storing a plurality of search trees on a non-volatile memory including a plurality of chunks that are fixed-sized blocks of the non-volatile memory, each chunk including at least one page,
wherein each search tree has elements including a tree root, a tree node and a tree leaf, each element being at a different level of the search tree, a first level including the tree root, a second level including the tree node, and a third level including the tree leaf,
wherein the plurality of chunks includes a number of chunk types, the number of chunk types based on a size of the at least one page, each chunk type for storing elements from one or more different levels of the search tree, such that each chunk type stores elements from different levels as other chunk types, and
wherein the number of chunk types include a first chunk type for storing the tree root at the first level, a second chunk type for storing the tree node at the second level, and a third chunk type for storing the tree leaf at the third level, the tree root having at least two tree leaves connected directly below the tree root, the tree node or the second level comprising a single level.
14. The non-transitory computer-readable storage medium of claim 13 wherein the number of chunk types include a first chunk type for storing the tree root and the tree node and a second chunk type for storing the tree leaf.
15. The non-transitory computer-readable storage medium of claim 13 wherein the number of chunk types is further based on at least one of a probability of an update being performed on the search tree, and a size of one of the plurality of chunks.
16. The non-transitory computer-readable storage medium of claim 13 wherein a probability that one of the elements of the search tree will be updated decreases going from the first level including the tree root to the third level including the tree leaf.
17. The non-transitory computer-readable storage medium of claim 13 wherein a lifetime of one of the elements of the search tree increases going from the first level including the tree root to the third level including the tree leaf.