• DocumentCode
    1336115
  • Title

    Efficient cost models for spatial queries using R-trees

  • Author

    Theodoridis, Yannis ; Stefanakis, Emmanuel ; Sellis, Timos

  • Author_Institution
    Comput. Technol. Inst., Patras, Greece
  • Volume
    12
  • Issue
    1
  • fYear
    2000
  • Firstpage
    19
  • Lastpage
    32
  • 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;
  • fLanguage
    English
  • Journal_Title
    Knowledge and Data Engineering, IEEE Transactions on
  • Publisher
    ieee
  • ISSN
    1041-4347
  • Type

    jour

  • DOI
    10.1109/69.842247
  • Filename
    842247