Experimenting the Query Performance of a Grid-Based Sensor Network Data Warehouse

Authors:
Alfredo Cuzzocrea;Abhas Kumar;Vincenzo Russo
Affiliations:
ICAR Institute and DEIS Department, University of Calabria, Italy;Department of Computer Science and Engineering, Indian Institute of Technology, Kanpur, India;ICAR Institute and DEIS Department, University of Calabria, Italy
Venue:
Globe '08 Proceedings of the 1st international conference on Data Management in Grid and Peer-to-Peer Systems
Year:
2008

Citing 24
Cited 2

An overview of data warehousing and OLAP technology

ACM SIGMOD Record
Range queries in OLAP data cubes

SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
On computing correlated aggregates over continual data streams

SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Processing complex aggregate queries over data streams

Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals

Data Mining and Knowledge Discovery
Continuous queries over data streams

ACM SIGMOD Record
Data management and transfer in high-performance computational grid environments

Parallel Computing - Parallel data-intensive algorithms and applications
Grid Services for Distributed System Integration

Computer
Data streams: algorithms and applications

SODA '03 Proceedings of the fourteenth annual ACM-SIAM symposium on Discrete algorithms
Distributed Query Processing on the Grid

GRID '02 Proceedings of the Third International Workshop on Grid Computing
On-Line Analytical Processing on Large Databases Managed by Computational Grids

DEXA '04 Proceedings of the Database and Expert Systems Applications, 15th International Workshop
A Distributed System for Answering Range Queries on Sensor Network Data

PERCOMW '05 Proceedings of the Third IEEE International Conference on Pervasive Computing and Communications Workshops
The design and implementation of Grid database services in OGSA-DAI: Research Articles

Concurrency and Computation: Practice & Experience - Grid Performance
The Anatomy of the Grid: Enabling Scalable Virtual Organizations

International Journal of High Performance Computing Applications
Large scale data warehouses on grid: Oracle database 10g and HP proliant servers

VLDB '05 Proceedings of the 31st international conference on Very large data bases
GridMiner: A Fundamental Infrastructure for Building Intelligent Grid Systems

WI '05 Proceedings of the 2005 IEEE/WIC/ACM International Conference on Web Intelligence
A Model for Distributing and Querying a Data Warehouse on a Computing Grid

ICPADS '05 Proceedings of the 11th International Conference on Parallel and Distributed Systems - Volume 01
Overcoming Limitations of Approximate Query Answering in OLAP

IDEAS '05 Proceedings of the 9th International Database Engineering & Application Symposium
Stream Cube: An Architecture for Multi-Dimensional Analysis of Data Streams

Distributed and Parallel Databases
A quad-tree based multiresolution approach for two-dimensional summary data

SSDBM '03 Proceedings of the 15th International Conference on Scientific and Statistical Database Management
The OLAP-Enabled Grid: Model and Query Processing Algorithms

HPCS '06 Proceedings of the 20th International Symposium on High-Performance Computing in an Advanced Collaborative Environment
Grid warehousing of molecular dynamics protein unfolding data

CCGRID '05 Proceedings of the Fifth IEEE International Symposium on Cluster Computing and the Grid - Volume 01
A Grid Services-Oriented Architecture for Efficient Operation of Distributed Data Warehouses on Globus

AINA '07 Proceedings of the 21st International Conference on Advanced Networking and Applications
An SLA-Enabled Grid DataWarehouse

IDEAS '07 Proceedings of the 11th International Database Engineering and Applications Symposium

F&A: a methodology for effectively and efficiently designing parallel relational data warehouses on heterogenous database clusters

DaWaK'10 Proceedings of the 12th international conference on Data warehousing and knowledge discovery
Query optimization over parallel relational data warehouses in distributed environments by simultaneous fragmentation and allocation

ICA3PP'10 Proceedings of the 10th international conference on Algorithms and Architectures for Parallel Processing - Volume Part I

Quantified Score

Hi-index	0.00

Visualization

Abstract

This paper presents our experience in experimenting the query performance of a Grid-based sensor network data warehouse, which encompasses several metaphors of data compression/approximation and high performance and high reliability computing that are typical of Grid architectures. Our experimentation focuses on two main classes of aggregate range queries over sensor readings, namely (i) the window queries, which apply a SQL aggregation operator over a fixed window over the reading stream produced by the sensor network, and (ii) the continuous queries, which instead consider a "moving" window, and produce as output a stream of answers. Both classes of queries are extremely useful to extract summarized knowledge to be exploited by OLAP-like analysis tools over sensor network data. The experimental results, conducted on several synthetic data sets, clearly confirm the benefits deriving from embedding the data compression/approximation paradigm into Grid-based sensor network data warehouses.