Title :
Efficient cost models for spatial queries using R-trees
Author :
Theodoridis, Yannis ; Stefanakis, Emmanuel ; Sellis, Timos
Author_Institution :
Comput. Technol. Inst., Patras, Greece
Abstract :
Selection and join queries are fundamental operations in database management systems (DBMS). Support for nontraditional data, including spatial objects, in an efficient manner is of ongoing interest in database research. Toward this goal, access methods and cost models for spatial queries are necessary tools for spatial query processing and optimization. We present analytical models that estimate the cost (in terms of node and disk accesses) of selection and join queries using R-tree-based structures. The proposed formulae need no knowledge of the underlying R-tree structure(s) and are applicable to uniform-like and nonuniform data distributions. In addition, experimental results are presented which show the accuracy of the analytical estimations when compared to actual runs on both synthetic and real data sets
Keywords :
query processing; relational algebra; spatial data structures; tree data structures; visual databases; R-trees; cost models; database management systems; experimental results; join queries; nonuniform data distributions; query optimization; selection queries; spatial databases; spatial query processing; uniform data distributions; Analytical models; Cost function; Data structures; Design automation; Geographic Information Systems; Image databases; Multidimensional systems; Multimedia databases; Query processing; Spatial databases;
Journal_Title :
Knowledge and Data Engineering, IEEE Transactions on