The SEQUOIA 2000 storage benchmark

This paper presents a benchmark that concisely captures the data base requirements of a collection of Earth Scientists working in the SEQUOIA 2000 project on various aspects of global change research. This benchmark has the novel characteristic that it uses real data sets and real queries that are representative of Earth Science tasks. Because it appears that Earth Science problems are typical of the problems of engineering and scientific DBMS users, we claim that this benchmark represents the needs of this more general community. Also included in the paper are benchmark results for three example DBMSs: GRASS, IPW and POSTGRES.

[1]  Guy M. Lohman,et al.  Remotely-sensed geophysical databases: experience and implications for generalized DBMS , 1983, SIGMOD '83.

[2]  A OrensteinJack Spatial query processing in an object-oriented database system , 1986 .

[3]  J. T. Robinson,et al.  The K-D-B-tree: a search structure for large multidimensional dynamic indexes , 1981, SIGMOD '81.

[4]  K. S. Baker,et al.  Optical variability and pigment biomass in the Sargasso Sea as determined using deep-sea optical mooring data , 1991 .

[5]  Jürg Nievergelt,et al.  The Grid File: An Adaptable, Symmetric Multikey File Structure , 1984, TODS.

[6]  David B. Lomet,et al.  The hB-tree: a multiattribute indexing method with good guaranteed performance , 1990, TODS.

[7]  Michael Stonebraker,et al.  A measure of transaction processing power , 1985 .

[8]  R. G. G. Cattell,et al.  Object operations benchmark , 1992, TODS.

[9]  David J. DeWitt,et al.  Benchmarking Database Systems A Systematic Approach , 1983, VLDB.

[10]  Jeffrey D. Ullman,et al.  Implementation of logical query languages for databases , 1985, TODS.

[11]  Hanan Samet,et al.  The Quadtree and Related Hierarchical Data Structures , 1984, CSUR.

[12]  Nick Roussopoulos,et al.  Direct spatial search on pictorial databases using packed R-trees , 1985, SIGMOD Conference.

[13]  Jean Luc Bell,et al.  A specialized data management system for parallel execution of particle physics codes , 1988, SIGMOD '88.

[14]  Christos Faloutsos,et al.  Analysis of object oriented spatial access methods , 1987, SIGMOD '87.

[15]  Jr. James Edward Frew The image processing workbench , 1991 .

[16]  Carlo Zaniolo,et al.  The LDL System Prototype , 1990, IEEE Trans. Knowl. Data Eng..

[17]  A. Guttmma,et al.  R-trees: a dynamic index structure for spatial searching , 1984 .