Efficient processing of large intersection queries on set_valued data

Wei Wang,Minfeng Xie,Guohua Liu,YinMing Pang,Baile Shi
2004-01-01
Ruan Jian Xue Bao/Journal of Software
Abstract:Set is a common data type in database system today. But there is no efficient index structure for set type data to support the queries relate to it. This paper presents a structure called Settrie. The structure is built based on the common prefix patterns in database. Unlike invert file, the sets with same value are well organized. So the size of the data accessed by a query is smaller than that of invert file. This feature will cause the improvement of the selection operation's performance. The experiments support this result. In this paper we also discuss several optimizations approaches to Settrie.
What problem does this paper attempt to address?