Efficient Secondary Memory Processing of Window Queries on Spatial Data

Efficient management of spatial data is becoming more and more important, requiring very large spatial database secondary memory data representations. An important class of queries for spatial data are those which extract a subset of the data; they are called window queries. In this paper, we analyze the efficient secondary memory processing of three kinds of window queries, namely, the exist, the report, and the select queries. In particular, we show that for the three queries, both for single feature and for multiple non-overlapping features, the number of accesses is never greater than the number of pixels inside the window. More precisely, we prove that for a window of size n × n in a feature space (e.g., an image) of size T × T (e.g., pixel elements), the exist query for binary image can be answered with O(nlogr T) accesses on secondary storage, while in all the other cases, window queries on generic images can be answered with O(nlogr T + n2/r) accesses on secondary storage. We also show that for two-dimensional range searching where output size is proportional to the search space size, the proposed data structure is optimal against other data structures proposed in the literature.

[1]  Irene Gargantini,et al.  An effective way to represent quadtrees , 1982, CACM.

[2]  Donald E. Knuth,et al.  The Art of Computer Programming, Vol. 3: Sorting and Searching , 1974 .

[3]  Sridhar Ramaswamy,et al.  Indexing for Data Models with Constraints and Classes , 1996, J. Comput. Syst. Sci..

[4]  Oliver Günther,et al.  Research issues in spatial databases , 1990, SGMD.

[5]  Christos Faloutsos,et al.  Analysis of object oriented spatial access methods , 1987, SIGMOD '87.

[6]  Max J. Egenhofer,et al.  What's special about spatial?: database requirements for vehicle navigation in geographic space , 1993, SIGMOD Conference.

[7]  Oliver Günther,et al.  The design of the cell tree: an object-oriented index structure for geometric databases , 1989, [1989] Proceedings. Fifth International Conference on Data Engineering.

[8]  Charles R. Dyer The space efficiency of quadtrees , 1982, Comput. Graph. Image Process..

[9]  Hanan Samet,et al.  The Design and Analysis of Spatial Data Structures , 1989 .

[10]  Hans-Peter Kriegel,et al.  The R*-tree: an efficient and robust access method for points and rectangles , 1990, SIGMOD '90.

[11]  D. J. Abel,et al.  A B+-tree structure for large quadtrees , 1983, Comput. Vis. Graph. Image Process..

[12]  Walid G. Aref,et al.  Efficient processing of window queries in the pyramid data structure , 1990, PODS '90.

[13]  Hanan Samet,et al.  The Quadtree and Related Hierarchical Data Structures , 1984, CSUR.

[14]  Antonin Guttman,et al.  R-trees: a dynamic index structure for spatial searching , 1984, SIGMOD '84.

[15]  Jürg Nievergelt,et al.  The Grid File: An Adaptable, Symmetric Multikey File Structure , 1984, TODS.

[16]  Clifford A. Shaffer,et al.  A formula for computing the number of quadtree node fragments created by a shift , 1988, Pattern Recognit. Lett..