The SEQUOIA 2000 storage benchmark

ABSTRACT

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.

REFERENCES

• ANON85: Anon et. al., "A Measure of Transaction Processing Power," Tandem Technical Report 85.1, Tandem Computers, Cupertino, Ca., August 1985.
• BELL88: Jean L. Bell, A specialized data management system for parallel execution of particle physics codes, Proceedings of the 1988 ACM SIGMOD international conference on Management of data, p.277-285, June 01-03, 1988, Chicago, Illinois, United States
• BITT83: Dina Bitton , David J. DeWitt , Carolyn Turbyfill, Benchmarking Database Systems A Systematic Approach, Proceedings of the 9th International Conference on Very Large Data Bases, p.8-19, October 31-November 02, 1983
• CATT92: R. G. G. Cattell , J. Skeen, Object operations benchmark, ACM Transactions on Database Systems (TODS), v.17 n.1, p.1-31, March 1992 [doi>10.1145/128765.128766]
• CHIM91: D. Chimenti , R. Gamboa , R. Krishnamurthy , S. Naqvi , S. Tsur , C. Zaniolo, The LDL System Prototype, IEEE Transactions on Knowledge and Data Engineering, v.2 n.1, p.76-90, March 1990 [doi>10.1109/69.50907]
• GRAY91: Gray, J., "The Benchmark Handbook," Morgen-Kaufman, San Mateo, Ca., 1991.
• GUTM84: Antonin Guttman, R-trees: a dynamic index structure for spatial searching, Proceedings of the 1984 ACM SIGMOD international conference on Management of data, June 18-21, 1984, Boston, Massachusetts
• FREW90: James Edward Frew, Jr., The image processing workbench, University of California at Santa Barbara, Santa Barbara, CA, 1991
• LOHM83: Guy M. Lohman , Joseph C. Stoltzfus , Anita N. Benson , Michael D. Martin , Alfonso F. Cardenas, Remotely-sensed geophysical databases: experience and implications for generalized DBMS, Proceedings of the 1983 ACM SIGMOD international conference on Management of data, May 23-26, 1983, San Jose, California
• LOME90: David B. Lomet , Betty Salzberg, The hB-tree: a multiattribute indexing method with good guaranteed performance, ACM Transactions on Database Systems (TODS), v.15 n.4, p.625-658, Dec. 1990 [doi>10.1145/99935.99949]
• MOSH92: Mosher, C., "The POSTGRES Version 4.0 Reference Manual," Electronics Research Laboratory, University of California, Berkeley, Ca., July 1992.
• NIEV84: J. Nievergelt , Hans Hinterberger , Kenneth C. Sevcik, The Grid File: An Adaptable, Symmetric Multikey File Structure, ACM Transactions on Database Systems (TODS), v.9 n.1, p.38-71, March 1984 [doi>10.1145/348.318586]
• OLSO93: Olson, M. et. al., "The SEQUOIA 2000 Visualization Benchmark," (in preparation)
• OREN86: Jack A. Orenstein, Spatial query processing in an object-oriented database system, Proceedings of the 1986 ACM SIGMOD international conference on Management of data, p.326-336, May 28-30, 1986, Washington, D.C., United States
• ROUS85: Nick Roussopoulos , Daniel Leifker, Direct spatial search on pictorial databases using packed R-trees, Proceedings of the 1985 ACM SIGMOD international conference on Management of data, p.17-31, May 1985, Austin, Texas, United States
• SMIT91: Smith, R. C., et al., "Optical Variability and Pigment Biomass in the Sargasso Sea as Determined Using Deep Sea Optical Mooring Data," Journal of Geophysical Research, September 1991.
• STON92: Stonebraker, M. and Dozier, J., "SEQUOIA 2000: Large Capacity Object Servers to Support Global Change Research," SEQUOIA 2000 Technical Report No 1, Electronics Research Lab, March 1992.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.4 Systems
          Subjects: Transaction processing

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.1 Logical Design
          Subjects: Data models
      H.2.4 Systems
          Subjects: Query processing

  I. Computing Methodologies
  I.4 IMAGE PROCESSING AND COMPUTER VISION
      I.4.m Miscellaneous

          Nouns: Landsat

  J. Computer Applications
  J.2 PHYSICAL SCIENCES AND ENGINEERING
      Subjects: Earth and atmospheric sciences

General Terms:
Design, Performance