Article

Efficient OLAP operations for spatial data using peano trees

Authors:

Baoying Wang,

Fei Pan,

Dongmei Ren,

Yue Cui,

Qiang Ding,

William PerrizoAuthors Info & Claims

DMKD '03: Proceedings of the 8th ACM SIGMOD workshop on Research issues in data mining and knowledge discovery

Pages 28 - 34

https://doi.org/10.1145/882082.882090

Published: 13 June 2003 Publication History

Get Access

Abstract

Online Analytical Processing (OLAP) is an important application of data warehouses. With more and more spatial data being collected, such as remotely sensed images, geographical information, digital sky survey data, efficient OLAP for spatial data is in great demand. In this paper, we build up a new data warehouse structure -- PD-cube, With PD-cube, OLAP operations and queries can be efficiently implemented. All these are accomplished based on the fast logical operations of Peano Trees (P-Trees*). One of the P-tree variations, Predicate P-tree, is used to efficiently reduce data accesses by filtering out "bit holes" consisting of consecutive 0's. Experiments show that OLAP operations can be executed much faster than with traditional OLAP methods.

References

[1]

K. Lin, H. V. Jagadish, C. Faloutsos. The TV-Tree: An Index Structure for High-Dimensional Data, VLDB Journal, Vol. 7, pp. 517--542, 1995.

Digital Library

Google Scholar

[2]

S. Berchtold, D. Keim, H. P. Kriegel. The X-Tree: An Index Structure for High-Dimensional Data, Proc. 22nd Int. Conf. on Very Large Databases (VLDB), 1996, pp. 28--79.

Digital Library

Google Scholar

[3]

J. Gray, A. Bosworth, A. Layman, H. Pirahesh. Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-tab, and Sub-Totals. Data Mining and Knowledge Discovery 1, 29--57, 1997

Digital Library

Google Scholar

[4]

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 (SIGMOD'97), pages 159--170, Tucson, AZ, May 1997.

Digital Library

Google Scholar

[5]

P. O'Neil, G. Graefe. Multi-Table Joins Through Bitmapped Join Indices, SIGMOD Record 24(7), September 1995

Digital Library

Google Scholar

[6]

P. Valduriez, Join Indices, ACM TODS, 12(2), June 1987.

Digital Library

Google Scholar

[7]

M. C. Wu, A. Buchmann. Encoded Bitmap Indexing for Data Warehouses. Proceedings of the 14th International Conference on Data Engineering, Orlando, Florida, USA, Feb. 1998, pp. 220--270.

Digital Library

Google Scholar

[8]

S. Amer-Yahia, T. Johnson. Optimizing Queries on Compressed Bitmaps. VLDB 2000: 729--778

Digital Library

Google Scholar

[9]

E. Codd, S. Codd, C. Salley. Providing OLAP (On-Line Analytical Processing) to User-Analysts: An IT Mandate. Technical Report. 1997, available at http://www.arborsoft.com/essbase/wht_ppr/coddps.zip.

Google Scholar

[10]

W. Perrizo, Peano Count Tree Technology, Technical Report NDSU-CSOR-TR-01-1, 2001.

Google Scholar

[11]

M. Khan, Q. Ding, W. Perrizo. k-Nearest Neighbor Classification on Spatial Data Streams Using P-Trees, PAKDD 2002, Spriger-Verlag, LNAI 2776, 2002, pp. 517--528.

Digital Library

Google Scholar

[12]

TIFF image data sets. Available at http://midas10cs.ndsu.nodak.edu/data/images/.

Google Scholar

Cited By

View all

Jassim IAbd A(2020)The role of business intelligence techniques in enhancing requirements of knowledge management: An applied analytical study of the teachers' opinions of the Northern Technical University and some of its formations2020 2nd Annual International Conference on Information and Sciences (AiCIS)10.1109/AiCIS51645.2020.00039(191-202)Online publication date: Nov-2020
https://doi.org/10.1109/AiCIS51645.2020.00039
Rahal IRen DWu WDenton ABesemann CPerrizo W(2018)Exploiting edge semantics in citation graphs using efficient, vertical ARMKnowledge and Information Systems10.1007/s10115-005-0229-210:1(57-91)Online publication date: 29-Dec-2018
https://dl.acm.org/doi/10.1007/s10115-005-0229-2
Boedihardjo A(2017)Stream Mining, SpatialEncyclopedia of GIS10.1007/978-3-319-17885-1_1358(2212-2218)Online publication date: 12-May-2017
https://doi.org/10.1007/978-3-319-17885-1_1358
Show More Cited By

Efficient OLAP operations for spatial data using peano trees
1. Information systems
  1. Information systems applications
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory

Recommendations

Object-Based Selective Materialization for Efficient Implementation of Spatial Data Cubes

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 OLAP of spatial data. In this ...
A Security Concept for OLAP
DEXA '97: Proceedings of the 8th International Workshop on Database and Expert Systems Applications

A data warehouse collects and integrates data from multiple, autonomous, heterogeneous sources with the purpose of efficiently implementing decision support or OLAP queries. Much work in data warehousing has been performed on view materialization and ...
Decision tree classification of spatial data streams using Peano Count Trees
SAC '02: Proceedings of the 2002 ACM symposium on Applied computing

Many organizations have large quantities of spatial data collected in various application areas, including remote sensing, geographical information systems (GIS), astronomy, computer cartography, environmental assessment and planning, etc. These data ...

Comments

Information & Contributors

Information

Published In

DMKD '03: Proceedings of the 8th ACM SIGMOD workshop on Research issues in data mining and knowledge discovery

June 2003

103 pages

ISBN:9781450374224

DOI:10.1145/882082

Conference Chairs:
Mohammed J. Zaki
Rensselaer Polytechnic Institute, Troy, New York
,
Charu C. Aggarwal
IBM T.J. Watson Research Center, Yorktown Heights, New York

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 13 June 2003

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Conference

DMKD03

Sponsor:

SIGMOD

DMKD03: 8th ACM SIGMOD Workshop on Research Issues in Data Mining and Knowledge Discovery ( held in conjunction with MOD/PODS 2003 conference / co-located with FCRC 2003 Conference )

June 13, 2003

California, San Diego

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

6
Total Citations
View Citations
467
Total Downloads

Downloads (Last 12 months)1
Downloads (Last 6 weeks)0

Reflects downloads up to 23 Dec 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Jassim IAbd A(2020)The role of business intelligence techniques in enhancing requirements of knowledge management: An applied analytical study of the teachers' opinions of the Northern Technical University and some of its formations2020 2nd Annual International Conference on Information and Sciences (AiCIS)10.1109/AiCIS51645.2020.00039(191-202)Online publication date: Nov-2020
https://doi.org/10.1109/AiCIS51645.2020.00039
Rahal IRen DWu WDenton ABesemann CPerrizo W(2018)Exploiting edge semantics in citation graphs using efficient, vertical ARMKnowledge and Information Systems10.1007/s10115-005-0229-210:1(57-91)Online publication date: 29-Dec-2018
https://dl.acm.org/doi/10.1007/s10115-005-0229-2
Boedihardjo A(2017)Stream Mining, SpatialEncyclopedia of GIS10.1007/978-3-319-17885-1_1358(2212-2218)Online publication date: 12-May-2017
https://doi.org/10.1007/978-3-319-17885-1_1358
Boedihardjo A(2016)Stream Mining, SpatialEncyclopedia of GIS10.1007/978-3-319-23519-6_1358-2(1-7)Online publication date: 26-May-2016
https://doi.org/10.1007/978-3-319-23519-6_1358-2
Khan ASakhare A(2015)A Gestalt of Data Exploration and Conception2015 Fifth International Conference on Communication Systems and Network Technologies10.1109/CSNT.2015.240(908-912)Online publication date: Apr-2015
https://doi.org/10.1109/CSNT.2015.240
Boedihardjo A(2008)Stream Mining, SpatialEncyclopedia of GIS10.1007/978-0-387-35973-1_1358(1141-1145)Online publication date: 2008
https://doi.org/10.1007/978-0-387-35973-1_1358

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Recommendations

Object-Based Selective Materialization for Efficient Implementation of Spatial Data Cubes

A Security Concept for OLAP

Decision tree classification of spatial data streams using Peano Count Trees