Abstract
The major goal of spatial access methods in query optimization is to deliver the exact or a minimal superset of the result set and to perform this task at minimal cost. We present a clustering spatial access method that directly delivers exact result sets. Minimal cost is guaranteed through a cost-based adaptation strategy that dynamically determines and realizes storage clusters best suited for a set of spatial range queries.
We introduce a tessalation of the data space which allows irregular, arbitrary small and large patches. Such patches can be adapted to query ranges in order to answer queries at minimal cost. The adaptation cost is kept small by performing only local repartitioning. Thus only a small number of neighbouring patches are merged or split during an adaptation step. The directory part has to be simple to perform range queries at minimal cost and to allow frequent adaptation updates at moderate cost. An implementation and evaluation in a database prototype system environment is under developement.
This work has partially been sponsored by the Swiss National Science Foundation (SNF) under grant NF 21-32801.91 as part of the ESPRIT Basic Research Activity “AMUSING” (EP6881).
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Norbert Beckmann, Hans-Peter Kriegel, Ralf Schneider, and Bernhard Seeger. The R*-tree: An Efficient and Robust Access Method for Points and Rectangles. In Proc. of ACM SIGMOD Conf., pages 322–331, June 1990.
Uwe Deppisch, Hans-Bernd Paul, and Hans-Jörg Schek. A Storage System for Complex Objects. In Klaus Dittrich and Umeshwar Dayal, editors, International Workshop on Object-Oriented Database Systems, Proceedings, pages 183–195. IEEE Computer Society Press, September 1986.
Gisbert Dröge and Hans-Jörg Schek. Query-adaptive data space partitioning using variable-size storage clusters. In David Abel and Beng Chin Ooi, editors, Advances in Spatial Databases, Third Symposium, SSD '93, Proceedings, volume 692 of LNCS, pages 337–356. Springer Verlag, June 1993.
Gisbert Dröge, Hans-Jörg Schek, and Andreas Wolf. Extensibility in DASDBS. Informatik Forschung und Entwicklung, 5:162–176, 1990. (in German).
O. Günther and A. Buchmann. Research Issues in Spatial Databases. ACM SIG-MOD RECORD, 19(4):61–68, December 1990.
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.
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.
A. Guttman. R-trees: A Dynamic Index Structure for Spatial Searching. ACM SIGMOD Proceedings of Annual Meeting, 14(2):47–57, June 1984.
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, volume 525 of LNCS, pages 257–276. Springer Verlag, August 1991.
Samuel J. Leffler, Marshall Kirk McKusick, Michael J. Karels, and John S. Quaterman. The Design and Implementation of the 4.3BSD Unix Operating System. Addison-Wesley Publishing Company, October 1990.
Hongjun Lu and Beng-Chin Ooi. Spatial Indexing: Past and Future. Bulletin of the Technical Committee on Data Engineering, 19(3):16–21, September 1993.
Jürg Nievergelt, Hans 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.
Heinz-Bernhard Paul, Hans-Jörg Schek, Marc H. Scholl, Gerhard Weikum, and Uwe Deppisch. Architecture and Implementation of the Darmstadt Database Kernel System. In Proc. of the 1981 ACM SIGMOD Conference, San Francisco, pages 196–207, May 1987.
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.
Hans-Jörg Schek and Walter Waterfeld. A database kernel system for geoscientific applications. In Proc. 2nd Int. Symp. on Spatial Data Handling, pages 273–288, 1986.
Hans-Jörg Schek and Andreas Wolf. Cooperation between Autonomous Operation Services and Object Database Systems in a Heterogeneous Environment. In DavidK. Hsiao, Erich J. Neuhold, and Ron Sacks-Davis, editors, Proc. of IFIP DS-5 Semantics of Interoperable Database Systems, pages 255–281. Elsevier Science Publishers B.V. (North-Holland), November 1992.
Berhard Seeger and Hans-Peter Kriegel. Techniques for Design and Implementation of Efficient Spatial Access Methods. In Proc. of the 14th VLDB Conf., pages 360–371, 1988.
Timos Sellis, Nick Roussopoulos, and Christos Faloutsos. The R+-Tree: A Dynamic Index Structure for Multi-Dimensional Objects. In Proc. of the 13th VLDB Conference, Brighton, pages 507–518, 1987.
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.
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.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Dröge, G. (1994). Patchwork — A query-driven locally adaptive data space partitioning. In: Nievergelt, J., Roos, T., Schek, HJ., Widmayer, P. (eds) IGIS '94: Geographic Information Systems. IGIS 1994. Lecture Notes in Computer Science, vol 884. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-58795-0_49
Download citation
DOI: https://doi.org/10.1007/3-540-58795-0_49
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58795-8
Online ISBN: 978-3-540-49105-7
eBook Packages: Springer Book Archive