Scientific formats for object-relational database systems: a study of suitability and performance

Authors:
Shirley Cohen;Patrick Hurley;Karl W. Schulz;William L. Barth;Brad Benton
Affiliations:
University of Pennsylvania;The University of Texas at Austin;The University of Texas at Austin;The University of Texas at Austin;IBM Corporation
Venue:
ACM SIGMOD Record
Year:
2006

Citing 3
Cited 8

Modern database systems: the object model, interoperability, and beyond

Modern database systems: the object model, interoperability, and beyond
Bringing object-relational technology to the mainstream

SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Object-Relational DBMSs: Tracking the Next Great Wave

Object-Relational DBMSs: Tracking the Next Great Wave

GraphREL: A Decomposition-Based and Selectivity-Aware Relational Framework for Processing Sub-graph Queries

DASFAA '09 Proceedings of the 14th International Conference on Database Systems for Advanced Applications
Armazenamento distribuído de imagens médicas DICOM no formato de dados HDF5

Proceedings of the 14th Brazilian Symposium on Multimedia and the Web
Managing scientific data

Communications of the ACM
An architecture for DICOM medical images storage and retrieval adopting distributed file systems

International Journal of High Performance Systems Architecture
An efficient features-based processing technique for supergraph queries

Proceedings of the Fourteenth International Database Engineering & Applications Symposium
Supporting web-based visual exploration of large-scale raster geospatial data using binned min-max Quadtree

SSDBM'10 Proceedings of the 22nd international conference on Scientific and statistical database management
Querying graph-based repositories of business process models

DASFAA'10 Proceedings of the 15th international conference on Database systems for advanced applications
Application note: High-performance computing for climate change impact studies with the Pasture Simulation model

Computers and Electronics in Agriculture

Quantified Score

Hi-index	0.02

Visualization

Abstract

Commercial database management systems (DBMSs) have historically seen very limited use within the scientific computing community. One reason for this absence is that previous database systems lacked support for the extensible data structures and performance features required within a high-performance computing context. However, database vendors have recently enhanced the functionality of their systems by adding object extensions to the relational engine. In principle, these extensions allow for the representation of a rich collection of scientific datatypes and common statistical operations. Utilizing these new extensions, this paper presents a study of the suitability of incorporating two popular scientific formats, NetCDF and HDF, into an object-relational system. To assess the performance of the database approach, a series of solution variables from a regional weather forecast model are used to build representative small, medium and large databases. Common statistical operations and array element queries are then performed using the object-relational database, and the execution timings are compared against native NetCDF and HDF operations.