Skip to main content
SpringerLink
Log in

Size Estimation of the Intersection Join between Two Line Segment Datasets

  • Conference paper
  • First Online:
Current Issues in Databases and Information Systems (ADBIS 2000, DASFAA 2000)

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

Abstract

In this paper we provide a theoretical framework for estimating the size of the intersection join between two line segment datasets (e.g., roads, railways, utilities). For real datasets, it has been pointed out that the line segment lengths and slopes are distributed according to specific mathematical laws [14]. Starting from this result, we show how to predict the size of the intersection join between two line segment datasets. We evaluate our formula through several experimentations, showing that the estimation is accurate, as compared to that obtained by using a naive uniform model.

This work has been partially supported by the EU TMR Grant CHOROCHRONOS.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. A. Belussi and C. Faloutsos. Estimating the selectivity of spatial queries using the’ correlation’ fractal dimension. In 21th Conference on Very Large Data Bases (VLDB’95), pages 299–310, Zurich, Switzerland, 1995.

    Google Scholar 

  2. T. Brinkhoff, H.P. Kriegel, and B. Seeger. Efficient processing of spatial joins using R-trees. In 19th ACM Int. Conf. on Management of Data (SIGMOD’93), pages 237–246, 1993.

    Google Scholar 

  3. S. Christodoulakis. Implication of certain assumptions in database performance evaluation. ACM TODS, 9(2):163–186, June 1984.

    Google Scholar 

  4. C. Faloutsos, M. Ranganathan, and Y. Manolopoulos. Fast subsequence matching in time-series databases. In 20th ACM Int. Conference on Management of Data (SIGMOD’94), pages 419–429, Minneapolis, MN, May 1994.

    Google Scholar 

  5. L. Forlizzi, R.H. Güting, E. Nardelli, and M. Schneider. A data model and data structures for moving objects databases. In 26th ACM Int. Conf. on Management of Data (SIGMOD 2000), pages 319–330, 2000.

    Google Scholar 

  6. A.U. Frank, S. Grumbach, R.H. Güting, C.S. Jensen, M. Koubarakis, N.A. Lorentzos, Y. Manolopoulos, E. Nardelli, B. Pernici, H.J. Schek, M. Scholl, T.K. Sellis, B. Theodoulidis, and P. Widmayer. Chorochronos: A research network for spatiotemporal database systems. SIGMOD Record, 28(3):12–21, 1999.

    Article  Google Scholar 

  7. V. Gaede and O. Günther. Multidimensional access methods. Computing Surveys, 30(2):170–231, 1998.

    Article  Google Scholar 

  8. V. Gaede and W.F. Riekert. Spatial access methods and query processing in the object-oriented GIS GODOT. In AGDM’94 Workshop, pages 40–52, Delft, The Netherlands, 1994.

    Google Scholar 

  9. R.L. Graham, D.E. Knuth, and O. Patashnik. Concrete Mathematics. Addison-Wesley Publishing Company, New York, 1989.

    MATH  Google Scholar 

  10. R.H. Güting. An introduction to spatial database systems. VLDB Journal, 3(4):357–399, 1994.

    Article  Google Scholar 

  11. N. Koudas and K.C. Sevcik. Size separation spatial join. In 23th ACM Int. Conf. on Management of Data (SIGMOD’97), pages 324–335, 1997.

    Google Scholar 

  12. M.L. Lo and C.V. Ravishankar. Spatial joins using seeded trees. In 20th ACM Int. Conf. on Management of Data (SIGMOD’94), pages 209–220, 1994.

    Google Scholar 

  13. D. Papadias, N. Mamoulis, and Y. Theodoridis. Processing and optimization of multiway spatial joins using R-trees. In 18th ACM Symp. on Principles of Database Systems (PODS’99), pages 44–55, 1999.

    Google Scholar 

  14. G. Proietti and C. Faloutsos. Selectivity estimation of window queries for line segment datasets. In 7th ACM Conference on Information and Knowledge Management (CIKM’98), pages 340–347, Washington, DC, 1998.

    Google Scholar 

  15. G. Proietti and C. Faloutsos. Accurate modeling of region data. IEEE Trans. on Knowledge and Data Engineering, in press, 2000. Also available as CMU-TR-98-126, Dept. of Computer Science, Carnegie Mellon University, Pittsburgh, PA.

    Google Scholar 

  16. G.K. Zipf. Human behavior and principle of least effort: an introduction to human ecology. Addison Wesley, Cambridge, MA, 1949.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dipartimento di Matematica Pura ed Applicata, Università di L’Aquila, Via Vetoio, 67010, L’Aquila, Italy

    Enrico Nardelli & Guido Proietti

  2. Consiglio Nazionale delle Ricerche, Istituto di Analisi dei Sistemi e Informatica, Viale Manzoni 30, 00185, Roma, Italy

    Enrico Nardelli & Guido Proietti

Authors
  1. Enrico Nardelli
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Guido Proietti
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Institute of Computer Science, Academy of Sciences of the Czech Republic, Pod Vodárenskou věží 2, 182 07, Prague 8, Czech Republic

    Július Štuller

  2. Faculty of Mathematics and Physics, Charles University, Malostranské nám. 25, 118 00, Prague 1, Czech Republic

    Jaroslav Pokorný

  3. Computer Science Institute, Brandenburg University of Technology, P.O. Box 101344, 03013, Cottbus, Germany

    Bernhard Thalheim

  4. Faculty of Science, Department of Information Science, Ochanomizu University, 2-1-1 Otsuka, Bunkyo-ku, Tokyo, 112-8610, Japan

    Yoshifumi Masunaga

Rights and permissions

Reprints and permissions

Copyright information

© 2000 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Nardelli, E., Proietti, G. (2000). Size Estimation of the Intersection Join between Two Line Segment Datasets. In: Štuller, J., Pokorný, J., Thalheim, B., Masunaga, Y. (eds) Current Issues in Databases and Information Systems. ADBIS DASFAA 2000 2000. Lecture Notes in Computer Science, vol 1884. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44472-6_18

Download citation

  • DOI: https://doi.org/10.1007/3-540-44472-6_18

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-67977-6

  • Online ISBN: 978-3-540-44472-5

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation