Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1145/1516360.1516466acmotherconferencesArticle/Chapter ViewAbstractPublication PagesedbtConference Proceedingsconference-collections
research-article
Free access

Towards integrated and efficient scientific sensor data processing: a database approach

Published: 24 March 2009 Publication History

Abstract

In this work, we focus on managing scientific environmental data, which are measurement readings collected from wireless sensors. In environmental science applications, raw sensor data often need to be validated, interpolated, aligned and aggregated before being used to construct meaningful result sets. Due to the lack of a system that integrates all the necessary processing steps, scientists often resort to multiple tools to manage and process the data, which can severely affect the efficiency of their work. In this paper, we propose a new data processing framework, HyperGrid, to address the problem. HyperGrid adopts a generic data model and a generic query processing and optimization framework. It offers an integrated environment to store, query, analyze and visualize scientific datasets. The experiments on real query set and data set show that the framework not only introduces little processing overhead, but also provides abundant opportunities to optimize the processing cost and thus significantly enhances the processing efficiency.

References

[1]
R. Agrawal, A. Gupta, and S. Sarawagi. Modeling multidimensional databases. In ICDE, pages 232--243, 1997.
[2]
G. Barrenetxea, F. Ingelrest, G. Schaefer, M. Vetterli, O. Couach, and M. Parlange. Sensorscope: Out-of-the-box environmental monitoring. In IPSN, pages 332--343, 2008.
[3]
P. Baumann. Management of multidimensional discrete data. VLDB J., 3(4):401--444, 1994.
[4]
P. Baumann, P. Furtado, R. Ritsch, and N. Widmann. Geo/environmental and medical data management in the rasdaman system. In VLDB, pages 548--552, 1997.
[5]
M. Chen, R. H. Clayton, A. V. Holden, and J. V. Tucker. Visualising cardiac anatomy using constructive volume geometry. In FIMH, pages 30--38, 2003.
[6]
M. Chen, A. S. Winter, D. Rodgman, and S. Treuvett. Enriching volume modelling with scalar fields. In Data Visualization: The State of the Art, pages 345--362, 2003.
[7]
Z. Chen and V. R. Narasayya. Efficient computation of multiple group by queries. In SIGMOD Conference, pages 263--274, 2005.
[8]
A. Deshpande and S. Madden. Mauvedb: supporting model-based user views in database systems. In SIGMOD Conference, pages 73--84, 2006.
[9]
B. Howe and D. Maier. Algebraic manipulation of scientific datasets. In VLDB, pages 924--935, 2004.
[10]
L. Libkin, R. Machlin, and L. Wong. A query language for multidimensional arrays: Design, implementation, and optimization techniques. In SIGMOD Conference, pages 228--239, 1996.
[11]
E. Lo, B. Kao, W.-S. Ho, S. D. Lee, C. K. Chui, and D. W. Cheung. Olap on sequence data. In SIGMOD Conference, pages 649--660, 2008.
[12]
A. P. Marathe and K. Salem. Query processing techniques for arrays. VLDB J., 11(1):68--91, 2002.
[13]
The wolfram mathematica homepage. http://www.wolfram.com/, 2008.
[14]
The mathematica mathlink. http://www.wolfram.com/solutions/mathlink/mathlink.html, 2008.
[15]
S. Papadomanolakis, A. Ailamaki, J. C. López, T. Tu, D. R. O'Hallaron, and G. Heber. Efficient query processing on unstructured tetrahedral meshes. In SIGMOD Conference, pages 551--562, 2006.
[16]
J. E. Richardson and M. J. Carey. Programming constructs for database system implementation in exodus. In SIGMOD Conference, pages 208--219, 1987.
[17]
H. Samet. Foundations of Multidimensional and Metric Data Structures. Morgan-Kaufmann, San Francisco, CA, 2006.
[18]
B. Shneiderman. The eyes have it: A task by data type taxonomy for information visualizations. In VL, pages 336--343, 1996.
[19]
B. Shneiderman. Extreme visualization: squeezing a billion records into a million pixels. In SIGMOD Conference, pages 3--12, 2008.
[20]
T. Wang, S. Santini, and A. Gupta. An interpolated volume model for databases. In ER, pages 335--348, 2003.

Cited By

View all
  • (2019)Built environment and management: exploring grand challenges and management issues in built environmentFrontiers of Engineering Management10.1007/s42524-019-0049-9Online publication date: 30-Jul-2019
  • (2016)Analysis of critical features and evaluation of BIM software: towards a plug-in for construction waste minimization using big dataInternational Journal of Sustainable Building Technology and Urban Development10.1080/2093761X.2015.11164156:4(211-228)Online publication date: 21-Jan-2016
  • (2015)Distributed Sequence Pattern Detection Over Multiple Data StreamsAdvances in Databases and Information Systems10.1007/978-3-319-23135-8_26(380-394)Online publication date: 15-Aug-2015
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences
EDBT '09: Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
March 2009
1180 pages
ISBN:9781605584225
DOI:10.1145/1516360
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: 24 March 2009

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Research-article

Conference

EDBT/ICDT '09
EDBT/ICDT '09: EDBT/ICDT '09 joint conference
March 24 - 26, 2009
Saint Petersburg, Russia

Acceptance Rates

Overall Acceptance Rate 7 of 10 submissions, 70%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)33
  • Downloads (Last 6 weeks)12
Reflects downloads up to 09 Sep 2024

Other Metrics

Citations

Cited By

View all
  • (2019)Built environment and management: exploring grand challenges and management issues in built environmentFrontiers of Engineering Management10.1007/s42524-019-0049-9Online publication date: 30-Jul-2019
  • (2016)Analysis of critical features and evaluation of BIM software: towards a plug-in for construction waste minimization using big dataInternational Journal of Sustainable Building Technology and Urban Development10.1080/2093761X.2015.11164156:4(211-228)Online publication date: 21-Jan-2016
  • (2015)Distributed Sequence Pattern Detection Over Multiple Data StreamsAdvances in Databases and Information Systems10.1007/978-3-319-23135-8_26(380-394)Online publication date: 15-Aug-2015
  • (2012)On retrieving patterns in environmental sensor dataEarth Science Informatics10.1007/s12145-012-0095-x5:1(43-59)Online publication date: 15-Feb-2012
  • (2012)Outlier detection of air temperature series data using probabilistic finite state automata-based algorithmComplexity10.1002/cplx.2139017:5(48-57)Online publication date: 1-May-2012
  • (2011)Semantic sensor data search in a large-scale federated sensor networkProceedings of the 4th International Conference on Semantic Sensor Networks - Volume 83910.5555/2887659.2887662(23-38)Online publication date: 24-Oct-2011
  • (2011)Smart Query Answering for Marine Sensor DataSensors10.3390/s11030288511:3(2885-2897)Online publication date: 3-Mar-2011
  • (2011)Big data from the built environmentProceedings of the 2nd international workshop on Research in the large10.1145/2025528.2025537(29-32)Online publication date: 18-Sep-2011
  • (2011)Pattern mining for query answering in marine sensor data2011 Sixth International Conference on Digital Information Management10.1109/ICDIM.2011.6093319(288-293)Online publication date: Sep-2011

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media