Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data 2005
DOI: 10.1145/1066157.1066196
|View full text |Cite
|
Sign up to set email alerts
|

Online B-tree merging

Abstract: Many scenarios involve merging of two B-tree indexes, both covering the same key range. Increasing demand for continuous availability and high performance requires that such merging be done online, with minimal interference to normal user transactions. In this paper we present an online B-tree merging method, in which the merging of leaf pages in two B-trees are piggybacked lazily with normal user transactions, thus making the merging I/O efficient and allowing user transactions to access only one index instea… Show more

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...
1
1
1
1

Citation Types

0
7
0

Year Published

2009
2009
2020
2020

Publication Types

Select...
3
3
1

Relationship

0
7

Authors

Journals

citations
Cited by 11 publications
(7 citation statements)
references
References 22 publications
0
7
0
Order By: Relevance
“…Two old papers Two recent papers One old and one recent paper [11] and [18] [25] and [39] [2] and [30] Similarity measures [12] and [30] [5] and [6] [24] and [32] [15] and [29] [5] and [40] [33] and [37] [31] and [33] [6] and [40] [7] and [29] Table 5, the highest-scoring papers by C-Rank are mostly related to clustering. The results show that CRank can provide a set of papers similar to the paper under consideration.…”
Section: Top 10 Rankingsmentioning
confidence: 99%
See 1 more Smart Citation
“…Two old papers Two recent papers One old and one recent paper [11] and [18] [25] and [39] [2] and [30] Similarity measures [12] and [30] [5] and [6] [24] and [32] [15] and [29] [5] and [40] [33] and [37] [31] and [33] [6] and [40] [7] and [29] Table 5, the highest-scoring papers by C-Rank are mostly related to clustering. The results show that CRank can provide a set of papers similar to the paper under consideration.…”
Section: Top 10 Rankingsmentioning
confidence: 99%
“…We also show that C-Rank properly computes the similarity score in all three cases. For demonstration purposes, we select ( [11,18]), ( [12,30]), ( [15,29]) and ( [31,33]) as pairs of old but similar papers, ( [25,39]), ( [5,6]), ( [5,40]), and ( [6,40]) as pairs of recent but similar papers, and ( [2,30]), ( [24,32]), ( [33,37]), and ( [7,29]) as pairs of an old paper and a recent one that are similar. Table 6 shows the result of this case analysis.…”
Section: Failure Of Existing Similarity Measuresmentioning
confidence: 99%
“…Sun et al use laziness for online merging of B-trees [17], which is a special case of our approach. The idea is to let merge operations piggyback on user transactions to reduce I/O operations.…”
Section: Related Workmentioning
confidence: 99%
“…Typically, the incremental reorganization executes as part of a user's transaction. An alternative is to reorganize in a separate system transaction and to have the user transaction wait for the system transaction [Sun et al 2005;Sun 2005, pp. 89-111].…”
Section: The Process That Reorganizesmentioning
confidence: 99%
“…Sun [2005, pp. 89-111] and Sun et al [2005] describe such merging. Because the indexes have the same key range, the merging cannot just attach them to each other.…”
Section: Merging Of Indexesmentioning
confidence: 99%