Toward an accurate analysis of range queries on spatial data

IEEE Transactions on Knowledge and Data Engineering

Volumn 15, Issue 2, 2003, Pages 305-323

  An, Ning ^a   Jin, Ji ^a   Sivasubramaniam, Anand ^a,b  

^a The Pennsylvania State University   (United States)

^b IEEE   (United States)

Author keywords

Histogram based estimation; Node access estimation; R trees; Range query; Selectivity estimation; Spatial data

Indexed keywords

COSTS; ERROR ANALYSIS; INFORMATION ANALYSIS; QUERY LANGUAGES; TREES (MATHEMATICS);

NODE ACCESS ESTIMATION;

DATA STRUCTURES;

EID: 0037341265     PISSN: 10414347     EISSN: None     Source Type: Journal    
DOI: 10.1109/TKDE.2003.1185836     Document Type: Article

References (35)

1. N. An, R. Lu, L. Qian, A. Sivasubramaniam, and T. Keefe, "Storing Spatial Data on a Network of Workstations," Cluster Computing, The J. Networks, Software Tools & Applications: Special Issue on I/O in Shared-Storage Clusters, vol. 2, no. 4, pp. 259-270, 1999.
2. S. Acharya, V. Poosala, and S. Ramaswamy, "Selectivity Estimation in Spatial Databases," Proc. 1999 ACM SIGMOD Int'l Conf. Management of Data, pp. 13-24, May 1999
3. W.G. Aref and H. Samet, "Optimization for Spatial Query Processing," Proc. 17th Int'l Conf. Very Large Data Bases, pp. 81-90, Sept. 1991.
4. W.G. Aref and H. Samet, "A Cost Model for Query Optimization Using R-Trees," Proc. ACM GIS Workshop, pp. 60-67, 1994.
5. A. Belussi and C. Faloutsos, "Estimating the Selectivity of Spatial Queries Using the 'Correlation' Fractal Dimension," Proc. 21th Int'l Conf. Very Large Data Bases, pp. 299-310, Sept. 1995.
6. N. Beckmann, H.P. Kriegel, R. Schneider, and B. Seeger, "The R*-Tree: An Efficient and Robust Access Method for Points and Rectangles," Proc. 1990 ACM-SIGMOD Conf., June 1990.
7. R. Finkel and J. Bentley, "Quad Trees: A Data Structure for Retrieval on Composite Keys," Acta Informatica, vol. 4, pp. 1-9, 1974.
8. C. Faloutsos and I. Kamel, "Beyond Uniformity and Independence: Analysis of R-Trees Using the Concept of Fractal Dimension," Proc. 13th ACM SIGACT-SIGMOD-SIGART Symp. Principles of Database Systems, pp. 4-13, June 1994.
9. C. Faloutsos, T.K. Sellis, and N. Roussopoulosand, "Analysis of Object Oriented Spatial Access Methods," Proc. 1987 ACM-SIGMOD Conf., pp. 426-439, Dec. 1987.
10. J.G. Griffiths, "An Algorithm for Displaying a Class of Space-Filling Curves," Software - Practice and Experience (SPE), vol. 16, pp. 403-411, 1986.
11. A. Gutman, "R-Trees: A Dynamic Index Structure for Spatial Searching," Proc. 1984 ACM-SIGMOD Conf., June 1984.
12. A. Henrich, H.W. Six, and P. Widmayer, "The LSD Tree: Spatial Access to Multidimensional Point and Non-Point Data," Proc. 15th Int'l Conf. Very Large Databases (VLDB), pp. 45-53, Aug. 1989.
13. H.V. Jagadish, "Linear Clustering of Objects with Multiple Atributes," Proc. 1990 ACM SIGMOD Int'l Conf. Management of Data, pp. 332-342, May 1990.
14. J. Jin, N. An, and A. Sivasubramaniam, "Analyzing Range Queries on Spatial Data," Technical Report CSE-99-005, Dept. of Computer Science and Engineering, The Pennsylvania State Univ., June 1999.
15. J. Jin, N. An, and A. Sivasubramaniam, "Analyzing Range Queries on Spatial Data," Proc. IEEE Int'l Conf. Data Eng., pp. 525-534, Mar. 2000.
16. J. Jin, "Techniques for Analyzing Range Queries on R-Trees," master's thesis, Dept. of Computer Science & Eng., Penn State Univ., May 1999.
17. I. Kamel and C. Faloutsos, "On Packing R-Trees," Proc. 2nd ACM Int'l Conf. Information and Knowledge Management, pp. 490-499, Nov. 1993.
18. S.T. Leutenegger and M.A. Lopez, "The Effect of Buffering on the Performance of R-Trees," Proc. 14th Int'l Conf. Data Eng., pp. 164-171, Feb. 1998.
19. R.W. Marx, "The TIGER System: Automating the Geographic Structure of the United States Census," Government Publications Rev., vol. 13, pp. 181-201, 1986.
20. D.J. Mavriplis, "An Advancing Front Delaunay Triangulation Algorithm Designed for Robustness," J. Computational Physics, pp. 90-101, 1995.
21. M. Muralikrishna and D.J. DeWitt, "Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries," Proc. 1988 ACM SIGMOD Int'l Conf. Management of Data, pp. 28-36, June 1988.
22. J. Nievergelt, H. Hinterberger, and K.C. Sevcik, "The Grid File: An Adaptable, Symmetric Multikey File Structure," Proc. Int'l Workshop Graph Theoretic Concepts in Computer Science, vol. 9, no. 1, pp. 38-71, Mar. 1984.
23. G. Proietti and C. Faloutsos, "I/O Complexity for Range Queries on Region Data Stored Using an R-Tree," Proc. 15th Int'l Conf. Data Eng., pp. 628-635, Mar. 1999.
24. V. Poosala, "Histogram-Based Estimation Techniques in Databases," PhD thesis, Univ. of Wisconsin-Madison, 1997.
25. Int'l Research Inst. For Climate Prediction, IRI/LDEO Climate Data Library, http://ingrid.ldgo.columbia.edu/.
26. B. Pagel, H.-W. Six, H, Toben, and P. Widmayer, "Towards an Analysis of Range Query Performance in Spatial Data Structures," Proc. 12th ACM SIGACT-SIGMOD-SIGART Symp. Principles of Database Systems, pp. 214-221, May 1993.
27. N. Roussopoulos and D. Leifker, "Direct Spatial Search on Pictorial Databases Using Packed R-Trees," Proc. 1985 ACM SIGMOD Int'l Conf. Management of Data, pp. 17-31, May 1985.
28. J.T. Robinson, "The K-D-B-Tree: A Search Structure for Large Multidimensional Dynamic Indexes," Proc. 1981 ACM-SIGMOD Conf., pp. 10-18, Apr. 1981.
29. H. Samet, "Spatial Data Structures," Modern Database Systems, pp. 361-385, 1995.
30. G.P. Shapiro and C. Connel, "Accurate Estimation of the Number of Tuples Satisfing a Condition," Proc. 1984 ACM-SIGMOD Conf., pp. 256-276, June 1984.
31. S. Shekhar, S. Chawla, S. Ravada et al. "Spatial Databases - Accomplishments and Research Needs," IEEE Trans. Knowledge and Data Eng., vol. 11, no. 1, pp. 45-55, 1999.
32. T.K. Sellis, N. Roussopoulos, and C. Faloutsos, "The R+-Tree: A Dynamic Index for Multi-Dimensional Objects," Proc. 13th Int'l Conf. Very Large Data Bases, pp. 507-518, Sept. 1987.
33. Y. Theodoridi and D. Papadias, "Range Queries Involving Spatial Relations: A Performance Analysis," Proc. COSIT '95, pp. 537-551, Sept. 1995.
34. Y. Theodoridi and T.K. Sellis, "A Model for the Prediction of R-Tree Performance," Proc. 15th ACM SIGACT-SIGMOD-SIGART Symp. Principles of Database Systems, pp. 161-171, June 1996.
35. Y. Theodoridis, E. Stefanakis, and T. Sellis, "An Efficient Cost Model for Spatial Queries Using R-Trees," Technical Report KDBSLAB-TR-97-01, Dept. Electrical and Computer Eng., Computer Science Division, Nat'1 Technical Univ. of Athens, Feb. 1997.