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
fDate :
30 March-2 April 2004
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;
Conference_Titel :
Data Engineering, 2004. Proceedings. 20th International Conference on
Print_ISBN :
0-7695-2065-0
DOI :
10.1109/ICDE.2004.1320007