Skip to main content
SpringerLink
Log in

Efficient processing of spatial queries in line segment databases

  • Query Processing
  • Conference paper
  • First Online:
Advances in Spatial Databases (SSD 1991)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 525))

Included in the following conference series:

Abstract

A study is performed of the issues arising in the efficient processing of spatial queries in large spatial databases. The domain is restricted to line segment databases such as those found in transportation networks and polygonal maps. Three classes of queries are identified. Those that deal with the line segments themselves, those that involve both the line segments and the space from which they are drawn (e.g., proximity queries), and those that involve attributes of the line segments. Handling the three types of queries requires that the line segments be stored implicitly using a bucketing approach on the space from which they are drawn. A number of bucketing approaches are examined and the PMR quadtree is chosen as the most suitable representation. Its storage and execution time requirements are evaluated in the context of finding the nearest line segment to a given point. This operation is shown to take time proportional to the splitting threshold (similar to the bucket capacity) and is independent of the density of the data. The evaluation uses the road networks in the data of the U.S. Bureau of the Census.

This work was supported in part by the Bureau of the Census under Joint Statistical Agreement 88-21 and the National Science Foundation under Grant IRI-90-17393.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Bureau of the Census, tiger/Line precensus files: 1990 technical documentation, Bureau of the Census, Washington, DC, 1989.

    Google Scholar 

  2. A. Buchmann, O. Günther, T.R. Smith, and Y.-F. Wang, eds., Design and Implementation of Large Spatial Databases, Lecture Notes in Computer Science No. 409, Springer-Verlag, Berlin, 1990

    Google Scholar 

  3. D. Comer, The ubiquitous b-tree, ACM Computing Surveys 11, 2(June 1979), 121–137.

    Google Scholar 

  4. C. Faloutsos, T. Sellis, and N. Roussopoulos, Analysis of object oriented spatial access methods, Proceedings of the SIGMOD Conference, San Francisco, May 1987, 426–439.

    Google Scholar 

  5. J. D. Foley, A. van Dam, S. K. Feiner, and J. F. Hughes, Computer Graphics: Principles and Practice, Second Edition, Addison-Wesley, Reading, MA, 1990.

    Google Scholar 

  6. W. R. Franklin, Adaptive grids for geometric operations, Cartographica 21, 2&3(Summer & Autumn 1984), 160–167.

    Google Scholar 

  7. M. Freeston, The bang file: a new kind of grid file, Proceedings of the SIGMOD Conference, San Francisco, May 1987, 260–269.

    Google Scholar 

  8. O. Günther, Efficient structures for geometric data management, Ph.D. dissertation, UCB/ERL M87/77, Electronics Research Laboratory, College of Engineering, University of California at Berkeley, Berkeley, CA, 1987 (Lecture Notes in Computer Science 337, Springer-Verlag, Berlin, 1988).

    Google Scholar 

  9. A. Guttman, r-trees: a dynamic index structure for spatial searching, Proceedings of the SIGMOD Conference, Boston, June 1984, 47–57.

    Google Scholar 

  10. A. Henrich, H. W. Six, and P. Widmayer, The lsd tree: spatial access to multidimensional point and non-point data, Proceedings of the Fifteenth International Conference on Very Large Data Bases, P. M. G. Apers and G. Wiederhold, eds., Amsterdam, August 1989, 45–53.

    Google Scholar 

  11. K. Hinrichs and J. Nievergelt, The grid file: a data structure designed to support proximity queries on spatial objects, Proceedings of the WG'83 (International Workshop on Graphtheoretic Concepts in Computer Science), M. Nagl and J. Perl, eds., Trauner Verlag, Linz, Austria, 1983, 100–113.

    Google Scholar 

  12. H. V. Jagadish, On indexing line segments, Proceedings of the Sixteenth International Conference on Very Large Data Bases, D. McLeod, R. Sacks-Davis, and H. Schek, eds., Brisbane, Australia, August 1990, 614–625.

    Google Scholar 

  13. R. C. Nelson and H. Samet, A consistent hierarchical representation for vector data, Computer Graphics 20, 4(August 1986), 197–206 (also Proceedings of the SIGGRAPH'86 Conference, Dallas, August 1986).

    Google Scholar 

  14. R. C. Nelson and H. Samet, A population analysis for hierarchical data structures, Proceedings of the SIGMOD Conference, San Francisco, May 1987, 270–277.

    Google Scholar 

  15. J. Nievergelt, H. Hinterberger, and K. C. Sevcik, The grid file: an adaptable, symmetric multikey file structure, ACM Transactions on Database Systems 9, 1(March 1984), 38–71.

    Google Scholar 

  16. J. A. Orenstein, Redundnacy in spatial databases, Proceedings of the SIGMOD Conference, Portland, OR, June 1989, 294–305.

    Google Scholar 

  17. J. A. Orenstein and T. H. Merrett, A class of data structures for associative searching, Proceedings of the Third ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, Waterloo, Canada, April 1984, 181–190.

    Google Scholar 

  18. D. J. Peuquet and D. F. Marble, Arc/info: An example of a contemporary geographic information system, in Introductory Readings In Geographic Information Systems, D. F. Peuquet and D. F. Marble, eds., Taylor & Francis, London, 1990, 90–99.

    Google Scholar 

  19. H. Samet, The Design and Analysis of Spatial Data Structures, Addison-Wesley, Reading, MA, 1990.

    Google Scholar 

  20. H. Samet, Applications of Spatial Data Structures: Computer Graphics, Image Processing, and GIS, Addison-Wesley, Reading, MA, 1990.

    Google Scholar 

  21. H. Samet and R. E. Webber, Storing a collection of polygons using quadtrees, ACM Transactions on Graphics 4, 3(July 1985), 182–222.

    Google Scholar 

  22. L. A. Santalo, Integral geometry and geometric probability, in Encyclopedia of Mathematics and its Applications, G. C. Rota, ed., Addison-Wesley, Reading, MA, 1976.

    Google Scholar 

  23. C. A. Shaffer, H. Samet, and R. C. Nelson, Quilt: a geographic information system based on quadtrees, International Journal of Geographical Information Systems 4, 2(April–June 1990), 103–131.

    Google Scholar 

  24. B. Seeger and H. P. Kriegel, The buddy-tree: an efficient and robust access method for spatial data base systems, Proceedings of the Sixteenth International Conference on Very Large Data Bases, D. McLeod, R. Sacks-Davis, and H. Schek, eds., Brisbane, Australia, August 1990, 590–601.

    Google Scholar 

  25. M. Stonebraker, T. Sellis, and E. Hanson, An analysis of rule indexing implementations in data base systems, Proceedings of the First International Conference on Expert Database Systems, Charleston, SC, April 1986, 353–364.

    Google Scholar 

  26. M. Tamminen, The excell method for efficient geometric access to data, Acta Polytechnica Scandinavica, Mathematics and Computer Science Series No. 34, Helsinki, Finland, 1981.

    Google Scholar 

  27. M. Tamminen, Efficient spatial access to a data base, Proceedings of the SIGMOD Conference, Orlando, June 1982, 47–57.

    Google Scholar 

  28. H. Tropf and H. Herzog, Multidimensional range search in dynamically balanced trees, Angewandte Informatik 23, 2(February 1981), 71–77.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Bureau of the Census, 20233, Washington, D.C.

    Erik G. Hoel

  2. Computer Science Department Center for Automation Research Institute for Advanced Computer Studies, University of Maryland, 20742, College Park, Maryland

    Hanan Samet

  3. the Center for Automation Research at the University of Maryland, USA

    Erik G. Hoel

Authors
  1. Erik G. Hoel
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Hanan Samet
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Oliver Günther Hans-Jörg Schek

Rights and permissions

Reprints and permissions

Copyright information

© 1991 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Hoel, E.G., Samet, H. (1991). Efficient processing of spatial queries in line segment databases. In: Günther, O., Schek, HJ. (eds) Advances in Spatial Databases. SSD 1991. Lecture Notes in Computer Science, vol 525. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-54414-3_41

Download citation

  • DOI: https://doi.org/10.1007/3-540-54414-3_41

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-54414-2

  • Online ISBN: 978-3-540-47615-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation