DocumentCode
416102
Title
Making the pyramid technique robust to query types and workloads
Author
Zhang, Rui ; Ooi, Beng Chin ; Tan, Kian-Lee
Author_Institution
Dept. of Comput. Sci., Nat. Univ. of Singapore, Singapore
fYear
2004
fDate
30 March-2 April 2004
Firstpage
313
Lastpage
324
Abstract
The effectiveness of many existing high-dimensional indexing structures is limited to specific types of queries and workloads. For example, while the Pyramid technique and the iMinMax are efficient for window queries, the iDistance is superior for kNN queries. We present a new structure, called the P+-tree, that supports both window queries and kNN queries under different workloads efficiently. In the P+-tree, a B+-tree is employed to index the data points as follows. The data space is partitioned into subspaces based on clustering, and points in each subspace are mapped onto a single dimensional space using the Pyramid technique, and stored in the B+ -tree. The crux of the scheme lies in the transformation of the data which has two crucial properties. First, it maps each subspace into a hypercube so that the Pyramid technique can be applied. Second, it shifts the cluster center to the top of the pyramid, which is the case that the Pyramid technique works very efficiently. We present window and kNN query processing algorithms for the P+-tree. Through an extensive performance study, we show that the P+-tree has considerable speedup over the Pyramid technique and the iMinMax for window queries and outperforms the iDistance for kNN queries.
Keywords
database indexing; query processing; statistical analysis; tree data structures; tree searching; trees (mathematics); Pyramid technique; data transformation; iMinMax; indexing structure; kNN query processing algorithm; window queries; Biomedical imaging; Clustering algorithms; Computer science; Data analysis; Geographic Information Systems; Hypercubes; Indexing; Multidimensional systems; Query processing; Robustness;
fLanguage
English
Publisher
ieee
Conference_Titel
Data Engineering, 2004. Proceedings. 20th International Conference on
ISSN
1063-6382
Print_ISBN
0-7695-2065-0
Type
conf
DOI
10.1109/ICDE.2004.1320007
Filename
1320007
Link To Document