Making the Pyramid Technique Robust to Query Types and Workloads

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. In this paper, 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 effici...

• Type: Conference
• Year: 2004
• Where: ICDE
• Authors: Rui Zhang 0003, Beng Chin Ooi, Kian-Lee Tan
• Keywords: Database, ICDE 2004, KNN Queries, Pyramid Technique, Window Queries