Query- adaptive data space partitioning using variable-size storage clusters

  • Gisbert Dröge
  • Hans-Jörg Schek
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 692)


All spatial access methods decompose the data space into a number of subspaces or cells. The size of a cell is determined by the capacity of a single disk page. Here we present considerations on data space partitions which use large multi-page storage clusters of variable size rather than single pages. Its main motivation is given by real complex geographical objects ranging from 100 Bytes to 10 KBytes in storage size. For such objects it does not make sense to insist on the one-page-per-cell paradigm. The problem of determining “good” multi-page storage clusters is attacked by introducing a cost model. In the ideal case an expected query is satisfied by accessing only one storage cluster of appropriate size. To get near to this optimum we adapt the data space partition to query ranges. We call this approach a query driven partitioning strategy. Initial evaluation studies show the feasibility of this approach.


Geographic Information System Data Space Spatial Object Adaptation Step Minimal Bound Rectangle 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Gisbert Dröge, Hans-Jörg Schek, and Andreas Wolf. Extensibility in DASDBS. Informatik Forschung und Entwicklung, 5:162–176, 1990. (in German).Google Scholar
  2. 2.
    Andrew U. Frank. Properties of Geographic Data: Requirements for Spatial Access Methods. In Oliver Günther and Hans-Jörg Schek, editors, Advances in Spatial Databases, 2nd Symposium, SSD '91, LNCS 525, pages 225–234. Springer-Verlag, August 1991.Google Scholar
  3. 3.
    O. Günther and A. Buchmann. Research Issues in Spatial Databases. ACM SIGMOD RECORD, 19(4):61–68, December 1990.Google Scholar
  4. 4.
    Oliver Günther. The Design of the Cell Tree: An Object-Oriented Index Structure for Geometric Databases. In Proc. of the 5th IEEE Int. Conf. on Data Engineering, pages 598–605, February 1989.Google Scholar
  5. 5.
    Oliver Günther and Hartmut Noltemeier. Spatial Database Indices for Large Extended Objects. In Proc. of the 7th IEEE Int. Conf. on Data Engineering, pages 520–526, April 1991.Google Scholar
  6. 6.
    A. Guttman. R-trees: A Dynamic Index Structure for Spatial Searching. ACM SIGMOD Proceedings of Annual Meeting, 14(2):47–57, June 1984.Google Scholar
  7. 7.
    Dagmar Horn, Hans-J. Schek, Walter Waterfeld, and Andreas Wolf. Spatial Access Paths and Physical Clustering in a Low-Level Geo-Database System. In Geological Survey of Lower Saxony, editor, Construction of Geoscientific Maps derived from Databases, Geologisches Jahrbuch, pages 123–138, 1988.Google Scholar
  8. 8.
    Hans-Peter Kriegel, Holger Horn, and Michael Schiwietz. The Performance of Object Decomposition Techniques for Spatial Query Processing. In O. Günther and H.-J. Schek, editors, Advances in Spatial Databases, 2nd Symposium, SSD '91, Proceedings, number 525 in LNCS, pages 257–276. Springer Verlag, August 1991.Google Scholar
  9. 9.
    Hans-Peter Kriegel, Michael Schiwietz, Ralf Schneider, and Bernhard Seeger. Performance Comparison of Point and Spatial Access Methods. In A. Buchmann, O. Günther, T.R. Smith, and Y.-F. Wang, editors, Design and Implementation of Large Spatial Databases, First Symposium, SSD '89, Proceedings, LNCS 409, pages 89–114. Springer Verlag, July 1989.Google Scholar
  10. 10.
    David B. Lomet. Partial Expansions for File Organizations. ACM Trans. on Database Systems, 12(1):65–84, March 1987.Google Scholar
  11. 11.
    Hongjun Lu, Beng Chin Ooi, Ashvin D'Souza, and Chee Chin Low. Storage Management in Geographic Information Systems. In Oliver Günther and Hans-Jörg Schek, editors, Advances in Spatial Databases, 2nd Symposium, SSD '91, LNCS 525, pages 451–470. Springer-Verlag, August 1991.Google Scholar
  12. 12.
    J. Nievergelt, H. Hinterberger, and K.C. Sevcik. The Grid File: An Adaptable, Symmetric Multikey File Structure. ACM Trans. on Database Systems, 9(1):38–71, March 1984.Google Scholar
  13. 13.
    Joseph O'Rourke and JR. Kenneth R. Sloan. Dynamic Quantization: Two Adaptive Data Structures for Multidimensional Spaces. IEEE Trans. on Pattern Analysis and Machine Intelligence, 6(3):266–280, May 1984.Google Scholar
  14. 14.
    John T. Robinson. The K-D-B-Tree: A Search Structure for Large Multidimensional Dynamic Indexes. In Proc. of ACM SIGMOD Conf., pages 10–18, 1981.Google Scholar
  15. 15.
    Hanan Samet. The Design and Analysis of Spatial Data Structures. Addison Wesley, 1990.Google Scholar
  16. 16.
    H.-J. Schek and W. Waterfeld. A Database Kernel System for Geoscientific Applications. In Second International Symposium on Spatial Data Handling, Proceedings, pages 273–288. International Geographical Union IGU, Commission on Geographical Data Sensing and Processing, July 1986.Google Scholar
  17. 17.
    Hans-Jörg Schek, H.-Bernhard Paul, Marc H. Scholl, and Gerhard Weikum. The DASDBS Project: Objectives, Experiences and Future Prospects. IEEE Transactions on Knowledge and Data Engineering, 2(1), March 1990.Google Scholar
  18. 18.
    Gerhard Weikum. Set-Oriented Disk Access to Large Complex Objects. In Proc. of the 5th IEEE Int. Conf. on Data Engineering, pages 426–433, February 1989.Google Scholar
  19. 19.
    Gerhard Weikum, Bernd Neumann, and Hans-Bernd Paul. Design and Realization of a Set-Oriented Page Server Interface to Support Efficient Access to Complex Objects. In H.-J. Schek and G. Schlageter, editors, Proc. of the GI Conf. on Database Systems in Office Automation, Engineering and Scientific Applications, Informatik Fachberichte 136, pages 212–230. Springer, April 1987. (in German).Google Scholar
  20. 20.
    Andreas Wolf. The DASDBS GEO-Kernel, Concepts, Experiences, and the Second Step. In Alejandro P. Buchman, Oliver Günther, Terry R. Smith, and Yuan-F. Wang, editors, Design and Implementation of Large Spatial Databases, First Symposium SSD '89, Proceedings, LNCS 409, pages 67–88. Springer Verlag, July 1989.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1993

Authors and Affiliations

  • Gisbert Dröge
    • 1
  • Hans-Jörg Schek
    • 1
  1. 1.Information Systems-DatabasesETH ZürichZürichSwitzerland

Personalised recommendations