Advertisement

A storage and access architecture for efficient query processing in spatial database systems

  • Thomas Brinkhoff
  • Holger Horn
  • Hans-Peter Kriegel
  • Ralf Schneider
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 692)

Abstract

Due to the high complexity of objects and queries and also due to extremely large data volumes, geographic database systems impose stringent requirements on their storage and access architecture with respect to efficient query processing. Performance improving concepts such as spatial storage and access structures, approximations, object decompositions and multi-phase query processing have been suggested and analyzed as single building blocks. In this paper, we describe a storage and access architecture which is composed from the above building blocks in a modular fashion. Additionally, we incorporate into our architecture a new ingredient, the scene organization, for efficiently supporting set-oriented access of large-area region queries. An experimental performance comparison demonstrates that the concept of scene organization leads to considerable performance improvements for large-area region queries by a factor of up to 150.

Keywords

Geographic Information System Query Processing Range Query Spatial Object Simple Polygon 
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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. [Aro 91]
    Aronoff S.: ‘Geographic Information Systems', WDL Publications, 1991.Google Scholar
  2. [Bar 88]
    Bartelme N.: ‘GIS Technology: Geographic information systems, land information systems and their fundamentals’ (in German), Springer, 1988.Google Scholar
  3. [BKS 93a]
    Brinkhoff T., Kriegel H.-P., Schneider R.: ‘Comparison of Approximations of Complex Objects used for Approximation-based Query Processing in Spatial Database Systems', Proc. 9th Int. Conf. on Data Engineering, Vienna, Austria, 1993.Google Scholar
  4. [BKS 93b]
    Brinkhoff T., Kriegel H.-P., Schneider R.: ‘Scene Organization: A Technique for Global Clustering in Spatial Database Systems', 1993, submitted for publication.Google Scholar
  5. [BKSS 90]
    Beckmann N., Kriegel H.-P., Schneider R., Seeger B.: ‘The R*-tree:An Efficient and Robust Access Method for Points and Rectangles', Proc. ACM SIGMOD Int. Conf. on Management of Data, Atlantic City, NJ., 1990, pp. 322–331.Google Scholar
  6. [Bur 86]
    Burrough P.A.: ‘Principles of Geographical Information Systems for Land Resources Assessment', Oxford University Press, 1986.Google Scholar
  7. [Bur 89]
    Bureau of the Census: ‘TIGER/Line Percensus Files, 1990 Technical Documentation', Washington, DC., 1989.Google Scholar
  8. [CDRS 86]
    Carey M. J., DeWitt D. J., Richardson J. E., Shekita E. J.: ‘Object and File Management in the EXODUS Extensible Database System', Proc. 12th Int. Conf. on Very Large Data Bases, Kyoto, Japan, 1986, pp. 91–100.Google Scholar
  9. [Cra 90]
    Crain I.K.: ‘Extremely Large Spatial Information Systems — A Quantitative Perspective', Proc. 4th Int. Symp. on Spatial Data Handling, Zürich, Switzerland, 1990, pp. 632–641.Google Scholar
  10. [Fra 91]
    Frank, A.U.: ‘Properties of Geographic Data', Proc. 2nd Symp. on Large Spatial Databases, Zürich, Switzerland, 1991, in: Lecture Notes in Computer Science, Vol. 525, Springer, 1991, pp. 225–234.Google Scholar
  11. [GC 87]
    Gorny A.J., Carter R.: ‘World Data Bank II: General users guide', Technical report, U.S. Central Intelligence Agency, Washington, 1987.Google Scholar
  12. [Gut 84]
    Guttman A.: ‘R-trees: A Dynamic Index Structure for Spatial Searching', Proc. ACM SIGMOD Int. Conf. on Management of Data, Boston, MA., 1984, pp. 47–57.Google Scholar
  13. [Güt 89]
    Güting R. H.: ‘Gral: an extensible relational database system for geografic applications', Proc. 15th Int. Conf. on Very Large Data Bases, Amsterdam, Netherland, 1989, pp. 33–44.Google Scholar
  14. [HS 92]
    Hoel E.G., Samet H.: ‘A Qualitative Comparison Study of Data Structures for Large Line Segment Databases', Proc. SIGMOD Conf., San Diego, CA., 1992, pp 205–214.Google Scholar
  15. [HSW 88]
    Hutflesz A., Six H.-W., Widmayer P.: ‘Globally Order Preserving Multidimensional Linear Hashing', Proc. 4th Int. Conf. on Data Engineering, Los Angeles, CA., 1988, pp. 572–579.Google Scholar
  16. [HWZ 91]
    Hutflesz A., Widmayer P., Zimmermann C.: ‘Global Order Makes Spatial Access Faster', Int. Workshop on Database Management Systems for Geographical Applications, Capri, Italy, 1991, in: Geographic Database Management Systems, Springer, 1992, pp. 161–176.Google Scholar
  17. [KBS 91]
    Kriegel H.-P., Brinkhoff T., Schneider R.: ‘An Efficient Map Overlay Algorithm based on Spatial Access Methods and Computational Geometry', Int. Workshop on Database Management Systems for Geographical Applications, Capri, Italy, 1991, in: Geographic Database Management Systems, Springer, 1992, pp. 194–211.Google Scholar
  18. [KHS 91]
    Kriegel H.-P., Horn H., Schiwietz M.: ‘The Performance of Object Decomposition Techniques for Spatial Query Processing', Proc. 2nd Symp. on Large Spatial Databases, Zürich, Switzerland, 1991, in: Lecture Notes in Computer Science, Vol. 525, Springer, 1991, pp. 257–276.Google Scholar
  19. [Kri 91a]
    Kriegel H.-P., Heep P., Heep S., Schiwietz M., Schneider R.: ‘An Access Method Based Query Processor for Spatial Database Systems', Int. Workshop on Database Management Systems for Geographical Applications, Capri, Italy, 1991, in: Geographic Database Management Systems, Springer, 1992, pp. 273–292.Google Scholar
  20. [Kri 91b]
    Kriegel H.-P., Heep P., Heep S., Schiwietz M., Schneider R.: ‘A Flexible and Extensible Index Manager for Spatial Database Systems', Proc. 2nd Int. Conf. on Database and Expert Systems Applications, Berlin, Germany, 1991, pp. 179–184.Google Scholar
  21. [Ore 89]
    Orenstein J. A.: ‘Redundancy in Spatial Databases', Proc. ACM SIGMOD Int. Conf. on Management of Data, Portland, USA, 1989, pp. 294–305.Google Scholar
  22. [PH 90]
    Paterson D., Hennessy J.: ‘Computer Architecture: A Quantitative Approach', Morgan Kaufman, 1990.Google Scholar
  23. [PS 88]
    Preparata F.P., Shamos M.I.: ‘Computational Geometry', Springer, 1988.Google Scholar
  24. [Sam 90]
    Samet H.: ‘The Design and Analysis of Spatial Data Structures', Addison Wesley, 1990.Google Scholar
  25. [Sch 92]
    Schneider R.: ‘A Storage and Access Structure for Spatial Database Systems', Ph.D.-thesis (in German), Institute for Computer Science, University of Munich, 1992.Google Scholar
  26. [SK 91]
    Schneider R., Kriegel H.-P.: ‘The TR*-tree: A New Representation of Polygonal Objects Supporting Spatial Queries and Operations', Proc. 7th Workshop on Computational Geometry, Bern, Switzerland, 1991, in: Lecture Notes in Computer Science, Vol. 553, Springer, 1991, pp. 249–264.Google Scholar
  27. [SR 86]
    Stonebraker M., Rowe L.: ‘The Design of POSTGRES', Proc. ACM SIGMOD Conf. on Management of Data, Washinton D.C., 1986.Google Scholar
  28. [SV 89]
    Scholl M., Voisard A.: ‘Thematic Map Modelling', Proc. 1st Symp. on the Design and Implementation of Large Spatial Databases, Santa Barbara, CA., 1989, in: Lecture Notes in Computer Science, Vol. 409, Springer, 1990, pp. 167–190.Google Scholar
  29. [SW 86]
    Schek H.-J., Waterfeld W.: ‘A Database Kernel System for Geoscientific Applications', Proc. 2nd Int. Symp. on Spatial Data Handling, Seattle, Washington, 1986, pp. 273–288.Google Scholar
  30. [Wei 89]
    Weikum G.: ‘Set-Oriented Disk Access to Large Complex Objects', Proc. 5th Int. Conf. on Data Engineering, Los Angeles, CA., 1989, pp. 426–433.Google Scholar
  31. [Wid 91]
    Widmayer P.: ‘Data Structures for Spatial Databases’ (in German) in: Vossen G., Witt K.-U. (eds.): ‘Entwicklungstendenzen bei Datenbank-Systemen’ (Future Trends in Database Systems), Oldenbourg, 1991, pp. 317–361.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1993

Authors and Affiliations

  • Thomas Brinkhoff
    • 1
  • Holger Horn
    • 1
  • Hans-Peter Kriegel
    • 1
  • Ralf Schneider
    • 1
  1. 1.Institute for Computer ScienceUniversity of MunichMünchen 40Germany

Personalised recommendations