Skip to main content
SpringerLink
Log in

Selective materialization: An efficient method for spatial data cube construction

  • Papers
  • Conference paper
  • First Online:
Research and Development in Knowledge Discovery and Data Mining (PAKDD 1998)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 1394))

Included in the following conference series:

Abstract

On-line analytical processing (OLAP) has gained its popularity in database industry. With a huge amount of data stored in spatial databases and the introduction of spatial components to many relational or object-relational databases, it is important to study the methods for spatial data warehousing and on-line analytical processing of spatial data. In this paper, we study methods for spatial OLAP, by integration of nonspatial on-line analytical processing (OLAP) methods with spatial database implementation techniques. A spatial data warehouse model, which consists of both spatial and nonspatial dimensions and measures, is proposed. Methods for computation of spatial data cubes and analytical processing on such spatial data cubes are studied, with several strategies proposed, including approximation and partial materialization of the spatial objects resulted from spatial OLAP operations. Some techniques for selective materialization of the spatial computation results are worked out, and the performance study has demonstrated the effectiveness of these techniques.

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. S. Agarwal, R. Agrawal, P. M. Deshpande, A. Gupta, J. F. Naughton, R. Ramakrishnan, and S. Sarawagi. On the computation of multidimensional aggregates. In Proc. 1996 Int. Conf. Very Large Data Bases, pages 506–521, Bombay, India, Sept. 1996.

    Google Scholar 

  2. S. Chaudhuri and U. Dayal. An overview of data warehousing and OLAP technology. ACM SIGMOD Record, 26:65–74, 1997.

    Article  Google Scholar 

  3. M. Ester, H.-P. Kriegel, and J. Sander. Spatial data mining: A database approach. In Proc. Int. Symp. Large Spatial Databases (SSD'97), pages 47–66, Berlin, Germany, July 1997.

    Google Scholar 

  4. U. M. Fayyad, G. Piatetsky-Shapiro, P. Smyth, and R. Uthurusamy. Advances in Knowledge Discovery and Data Mining. AAAI/MIT Press, 1996.

    Google Scholar 

  5. J. Gray, S. Chaudhuri, A. Bosworth, A. Layman, D. Reichart, M. Venkatrao, F. Pellow, and H. Pirahesh. Data cube: A relational aggregation operator generalizing group-by, cross-tab and sub-totals. Data Mining and Knowledge Discovery, 1:29–54, 1997.

    Article  Google Scholar 

  6. R. H. Güting. An introduction to spatial database systems. The VLDB Journal, 3:357–400, 1994.

    Article  Google Scholar 

  7. J. Han, K. Koperski, and N. Stefanovic. GeoMiner: A system prototype for spatial data mining. In Proc. 1997 ACM-SIGMOD Int. Conf. Management of Data, pages 553–556, Tucson, Arizona, May 1997.

    Google Scholar 

  8. V. Harinarayan, A. Rajaraman, and J. D. Ullman. Implementing data cubes efficiently. In Proc. 1996 ACM-SIGMOD Int. Conf. Management of Data, pages 205–216, Montreal, Canada, June 1996.

    Google Scholar 

  9. W. H. Inmon. Building the Data Warehouse. John Wiley, 1996.

    Google Scholar 

  10. R. Kimball. The Data Warehouse Toolkit. John Wiley & Sons, New York, 1996.

    Google Scholar 

  11. K. Koperski, J. Han, and J. Adhikary. Mining knowledge in geographic data. In Comm. ACM (to appear), 1998.

    Google Scholar 

  12. N. Stefanovic. Design and implementation of on-line analytical processing (OLAP) of spatial data. M.Sc. Thesis, Simon Fraser University, Canada, September 1997.

    Google Scholar 

  13. Y. Zhao, P. M. Deshpande, and J. F. Naughton. An array-based algorithm for simultaneous multidimensional aggregates. In Proc. 1997 ACM-SIGMOD Int. Conf. Management of Data, pages 159–170, Tucson, Arizona, May 1997.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. School of Computing Science, Simon Fraser University, V5A 1S6, Burnaby, BC, Canada

    Jiawei Han, Nebojsa Stefanovic & Krzysztof Koperski

Authors
  1. Jiawei Han
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Nebojsa Stefanovic
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Krzysztof Koperski
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. School of Computer Science and Software Engineering, Monash university, 900 Dandenong Road, Caulfield East, Victoria, 3145, Australia

    Xindong Wu

  2. Department of Computer Science, The University of Melbourne, Parkville, Victoria, 3052, Australia

    Ramamohanarao Kotagiri

  3. School of Computer Science and Engineering, Monash university, Clayton, Victoria, 3168, Australia

    Kevin B. Korb

Rights and permissions

Reprints and permissions

Copyright information

© 1998 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Han, J., Stefanovic, N., Koperski, K. (1998). Selective materialization: An efficient method for spatial data cube construction. In: Wu, X., Kotagiri, R., Korb, K.B. (eds) Research and Development in Knowledge Discovery and Data Mining. PAKDD 1998. Lecture Notes in Computer Science, vol 1394. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-64383-4_13

Download citation

  • DOI: https://doi.org/10.1007/3-540-64383-4_13

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-64383-8

  • Online ISBN: 978-3-540-69768-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation