Duplicate Elimination in Space-partitioning Tree Indexes

Space-partitioning trees, like the disk-based trie, quadtree, kd-tree and their variants, are a family of access methods that index multi-dimensional objects. In the case of indexing non-zero extent objects, e.g., line segments and rectangles, space-partitioning trees may replicate objects over multiple space partitions, e.g., PMR quadtree, expanded MX-CIF quadtree, and extended kd-tree. As a result, the answer to a query over these indexes may include duplicates that need to be eliminated, i.e., the same object may be reported more than once. In this paper, we propose generic duplicate elimination techniques for the class of space-partitioningtrees in the context of SP-GiST; an extensible indexing framework for realizing space-partitioning trees. The proposed techniques are embedded inside the INDEX-SCAN operator. Therefore, duplicate copies of the same object do not propagate in the query plan, and the elimination process is transparent to the end-users. Two cases for the index stru...

• Type: Conference
• Year: 2007
• Where: SSDBM
• Authors: Mohamed Y. Eltabakh, Mourad Ouzzani, Walid G. Aref
• Keywords: Database, Duplicate Elimination, Index Multi-dimensional Objects, Space-partitioning Trees, SSDBM 2007