Sort-based query-adaptive loading of R-trees

作者: Daniar Achakeev , Bernhard Seeger , Peter Widmayer

DOI: 10.1145/2396761.2398577

关键词:

摘要: Bulk-loading of R-trees has been an important problem in academia and industry for more than twenty years. Current algorithms create without any information about the expected query profile. However, profiles are extremely useful design efficient indexes. In this paper, we address deficiency present query-adaptive building optimally designed a given Since optimal R-tree loading is NP-hard (even tuning structure to profile), provide efficient, easy implement heuristics. Our sort-based consist two steps: First, sorting orders identified resulting better those obtained from standard space-filling curves. Second, order, propose dynamic programming algorithm generating linear runtime. experimental results confirm that our generally significantly ones algorithms, even when profile unknown.

参考文章(28)
Ludger Becker, Hannes Partzsch, Jan Vahrenhold, Query Responsive Index Structures Geographic Information Science. pp. 1- 19 ,(2008) , 10.1007/978-3-540-87473-7_1
Peter Widmayer, Jochen Van den Bercken, Bernhard Seeger, A Generic Approach to Bulk Loading Multidimensional Index Structures very large data bases. pp. 406- 415 ,(1997)
David J. DeWitt, Jie-Bing Yu, Jignesh M. Patel, Jun Luo, Navin Kabra, Client-Server Paradise very large data bases. pp. 558- 569 ,(1994)
Bruno Becker, Paolo Giulio Franciosa, Stephan Gschwind, Thomas Ohler, Gerald Thiemt, Peter Widmayer, Enclosing many boxes by an optimal pair of boxes STACS 92. pp. 475- 486 ,(1992) , 10.1007/3-540-55210-3_206
Yannis E. Ioannidis, Viswanath Poosala, Selectivity Estimation Without the Attribute Value Independence Assumption very large data bases. pp. 486- 495 ,(1997)
Nick Koudas, H. V. Jagadish, Torsten Suel, Kenneth C. Sevcik, Viswanath Poosala, S. Muthukrishnan, Optimal Histograms with Quality Guarantees very large data bases. pp. 275- 286 ,(1998)
J. A. Orenstein, T. H. Merrett, A class of data structures for associative searching Proceedings of the 3rd ACM SIGACT-SIGMOD symposium on Principles of database systems - PODS '84. pp. 181- 190 ,(1984) , 10.1145/588011.588037
Bernd-Uwe Pagel, Hans-Werner Six, Heinrich Toben, Peter Widmayer, Towards an analysis of range query performance in spatial data structures Proceedings of the twelfth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems - PODS '93. pp. 214- 221 ,(1993) , 10.1145/153850.153878
Nick Roussopoulos, Daniel Leifker, Direct spatial search on pictorial databases using packed R-trees international conference on management of data. ,vol. 14, pp. 17- 31 ,(1985) , 10.1145/318898.318900
Lars Arge, Mark De Berg, Herman Haverkort, Ke Yi, The priority R-tree: A practically efficient and worst-case optimal R-tree ACM Transactions on Algorithms. ,vol. 4, pp. 9- ,(2008) , 10.1145/1328911.1328920