Report on the HPSS Database Benchmark

Concerns about the long-term viability of SFS as the metadata store for HPSS have been increasing. A concern that Transarc may discontinue support for SFS motivates us to consider alternative means to store HPSS metadata. The obvious alternative is a commercial database. Commercial databases have th...

Full description

Bibliographic Details
Main Author: Fisher,D
Language:unknown
Published: 2018
Subjects:
DML
Online Access:http://www.osti.gov/servlets/purl/15006190
https://www.osti.gov/biblio/15006190
https://doi.org/10.2172/15006190
id ftosti:oai:osti.gov:15006190
record_format openpolar
spelling ftosti:oai:osti.gov:15006190 2023-07-30T04:03:12+02:00 Report on the HPSS Database Benchmark Fisher,D 2018-08-21 application/pdf http://www.osti.gov/servlets/purl/15006190 https://www.osti.gov/biblio/15006190 https://doi.org/10.2172/15006190 unknown http://www.osti.gov/servlets/purl/15006190 https://www.osti.gov/biblio/15006190 https://doi.org/10.2172/15006190 doi:10.2172/15006190 99 GENERAL AND MISCELLANEOUS//MATHEMATICS COMPUTING AND INFORMATION SCIENCE BENCHMARKS COMPETITION MAINTENANCE MANAGEMENT MARKET PERFORMANCE PROGRAMMING STORAGE VIABILITY 2018 ftosti https://doi.org/10.2172/15006190 2023-07-11T11:03:22Z Concerns about the long-term viability of SFS as the metadata store for HPSS have been increasing. A concern that Transarc may discontinue support for SFS motivates us to consider alternative means to store HPSS metadata. The obvious alternative is a commercial database. Commercial databases have the necessary characteristics for storage of HPSS metadata records. They are robust and scalable and can easily accommodate the volume of data that must be stored. They provide programming interfaces, transactional semantics and a full set of maintenance and performance enhancement tools. A team was organized within the HPSS project to study and recommend an approach for the replacement of SFS. Members of the team are David Fisher, Jim Minton, Donna Mecozzi, Danny Cook, Bart Parliman and Lynn Jones. We examined several possible solutions to the problem of replacing SFS, and recommended on May 22, 2000, in a report to the HPSS Technical and Executive Committees, to change HPSS into a database application over either Oracle or DB2. We recommended either Oracle or DB2 on the basis of market share and technical suitability. Oracle and DB2 are dominant offerings in the market, and it is in the best interest of HPSS to use a major player's product. Both databases provide a suitable programming interface. Transaction management functions, support for multi-threaded clients and data manipulation languages (DML) are available. These findings were supported in meetings held with technical experts from both companies. In both cases, the evidence indicated that either database would provide the features needed to host HPSS. Other/Unknown Material DML SciTec Connect (Office of Scientific and Technical Information - OSTI, U.S. Department of Energy)
institution Open Polar
collection SciTec Connect (Office of Scientific and Technical Information - OSTI, U.S. Department of Energy)
op_collection_id ftosti
language unknown
topic 99 GENERAL AND MISCELLANEOUS//MATHEMATICS
COMPUTING
AND INFORMATION SCIENCE
BENCHMARKS
COMPETITION
MAINTENANCE
MANAGEMENT
MARKET
PERFORMANCE
PROGRAMMING
STORAGE
VIABILITY
spellingShingle 99 GENERAL AND MISCELLANEOUS//MATHEMATICS
COMPUTING
AND INFORMATION SCIENCE
BENCHMARKS
COMPETITION
MAINTENANCE
MANAGEMENT
MARKET
PERFORMANCE
PROGRAMMING
STORAGE
VIABILITY
Fisher,D
Report on the HPSS Database Benchmark
topic_facet 99 GENERAL AND MISCELLANEOUS//MATHEMATICS
COMPUTING
AND INFORMATION SCIENCE
BENCHMARKS
COMPETITION
MAINTENANCE
MANAGEMENT
MARKET
PERFORMANCE
PROGRAMMING
STORAGE
VIABILITY
description Concerns about the long-term viability of SFS as the metadata store for HPSS have been increasing. A concern that Transarc may discontinue support for SFS motivates us to consider alternative means to store HPSS metadata. The obvious alternative is a commercial database. Commercial databases have the necessary characteristics for storage of HPSS metadata records. They are robust and scalable and can easily accommodate the volume of data that must be stored. They provide programming interfaces, transactional semantics and a full set of maintenance and performance enhancement tools. A team was organized within the HPSS project to study and recommend an approach for the replacement of SFS. Members of the team are David Fisher, Jim Minton, Donna Mecozzi, Danny Cook, Bart Parliman and Lynn Jones. We examined several possible solutions to the problem of replacing SFS, and recommended on May 22, 2000, in a report to the HPSS Technical and Executive Committees, to change HPSS into a database application over either Oracle or DB2. We recommended either Oracle or DB2 on the basis of market share and technical suitability. Oracle and DB2 are dominant offerings in the market, and it is in the best interest of HPSS to use a major player's product. Both databases provide a suitable programming interface. Transaction management functions, support for multi-threaded clients and data manipulation languages (DML) are available. These findings were supported in meetings held with technical experts from both companies. In both cases, the evidence indicated that either database would provide the features needed to host HPSS.
author Fisher,D
author_facet Fisher,D
author_sort Fisher,D
title Report on the HPSS Database Benchmark
title_short Report on the HPSS Database Benchmark
title_full Report on the HPSS Database Benchmark
title_fullStr Report on the HPSS Database Benchmark
title_full_unstemmed Report on the HPSS Database Benchmark
title_sort report on the hpss database benchmark
publishDate 2018
url http://www.osti.gov/servlets/purl/15006190
https://www.osti.gov/biblio/15006190
https://doi.org/10.2172/15006190
genre DML
genre_facet DML
op_relation http://www.osti.gov/servlets/purl/15006190
https://www.osti.gov/biblio/15006190
https://doi.org/10.2172/15006190
doi:10.2172/15006190
op_doi https://doi.org/10.2172/15006190
_version_ 1772814144052920320