Performance Measurements of Tertiary Storage Devices.

@inproceedings{DBLP:conf/vldb/JohnsonM98,
  author    = {Theodore Johnson and
               Ethan L. Miller},
  editor    = {Ashish Gupta and
               Oded Shmueli and
               Jennifer Widom},
  title     = {Performance Measurements of Tertiary Storage Devices},
  booktitle = {VLDB'98, Proceedings of 24rd International Conference on Very
               Large Data Bases, August 24-27, 1998, New York City, New York,
               USA},
  publisher = {Morgan Kaufmann},
  year      = {1998},
  isbn      = {1-55860-566-5},
  pages     = {50-61},
  ee        = {db/conf/vldb/JohnsonM98.html},
  crossref  = {DBLP:conf/vldb/98},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

In spite of the rapid decrease in magnetic disk prices, tertiary storage (i.e., removable media in a robotic storage library) is becoming increasingly popular. The fact that so much data can be stored encourages applications that use ever more massive data sets. Application drivers include multimedia databases, data warehouses, scientific databases, and digital libraries and archives. The database research community has responded with investigations into systems integration, performance modeling, and performance optimization.

Tertiary storage systems present special challenges because of their unusual performance characteristics. Access latencies can range into minutes even on unloaded systems, but transfer rates can be very high. Tertiary storage is implemented with a wide array of technologies, each with its own performance quirks. However, little detailed performance information about tertiary storage devices has been published. In this paper we present detailed measurements of several tape drives and robotic storage libraries. Thetape drives we measure include the DLT 4000, DLT 7000, Ampex 310, IBM 3590, 4mm DAT, and the Sony DTF drive. This mixture of equipment includes highand low performance drives, serpentine and helical scan drives, and cartridge and cassette tapes. The detailed measurements of different aspects of tertiary storage system performance provides an understanding of the issues related to integrating tape- based tertiary storage with a DBMS.

Copyright © 1998 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.

Online Paper

• Download PDF file (www.vldb.org, Darmstadt, Germany)
• Download PDF file (www.acm.org, New York, USA)

ACM SIGMOD DiSC

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the CD and click on the path of your mount point:
  /Anthology/Disc99_1 or /cdrom

ACM SIGMOD Anthology

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the DVD and click on the path of your mount point:
  /Anthology/aDVD1 or /dvd

Printed Edition

References

[1]

Paul Brown, Michael Stonebraker: BigSur: A System For the Management of Earth Science Data. VLDB 1995: 720-728

[2]

...

[3]

Ling Tony Chen, R. Drach, M. Keating, S. Louis, Doron Rotem, Arie Shoshani: Efficient organization and access of multi-dimensional datasets on tertiary storage systems. Inf. Syst. 20(2): 155-183(1995)

[4]

...

[5]

Stavros Christodoulakis, Peter Triantafillou, Fenia Zioga: Principles of Optimally Placing Data in Tertiary Storage Libraries. VLDB 1997: 236-245

[6]

Daniel Alexander Ford, Stavros Christodoulakis: Optimal Placement of High-Probability Randomly Retrieved Blocks on CLV Optical Discs. ACM Trans. Inf. Syst. 9(1): 1-30(1991)

[7]

Leana Golubchik, Richard R. Muntz, Richard W. Watson: Analysis of Striping Techniques in Robotic Storage Libraries. IEEE Symposium on Mass Storage Systems 1995: 225-238

[8]

Jim Gray, Goetz Graefe: The Five-Minute Rule Ten Years Later, and Other Computer Storage Rules of Thumb. SIGMOD Record 26(4): 63-68(1997)

[9]

Bruce Hillyer, Abraham Silberschatz: On the Modeling and Performance Characteristics of a Serpentine Tape Drive. SIGMETRICS 1996: 170-179

[10]

Bruce Hillyer, Abraham Silberschatz: Random I/O Scheduling in Online Tertiary Storage Systems. SIGMOD Conference 1996: 195-204

[11]

...

[12]

...

[13]

David Isaac: Hierarchical Storage Management for Relational Databases. IEEE Symposium on Mass Storage Systems 1993: 139-144

[14]

...

[15]

Theodore Johnson: Coarse Indices for a Tape-Based Data Warehouse. ICDE 1998: 231-240

[16]

...

[17]

...

[18]

Martin G. Kienzle, Asit Dan, Dinkar Sitaram, William H. Tetzlaff: Using Tertiary Storage in Video-on-Demand Servers. COMPCON 1995: 225-233

[19]

Ben Kobler, John Berbert, Parris Caulk, P. C. Hariharan: Architecture and Design of Storage and Data Management for the NASA Earth Observing System Data and Information System (EOSDIS). IEEE Symposium on Mass Storage Systems 1995: 65-76

[20]

Achim Kraiss, Gerhard Weikum: Vertical Data Migration in Large Near-Line Document Archives Based on Markov-Chain Predictions. VLDB 1997: 246-255

[21]

Lee Luecking: Managing and Service a Multiterabyte Data Set at the Fermilab D0 Experiment. IEEE Symposium on Mass Storage Systems 1995: 200-208

[22]

...

[23]

Jussi Myllymaki, Miron Livny: Disk-Tape Joins: Synchronizing Disk and Tape Access. SIGMETRICS 1995: 279-290

[24]

Jussi Myllymaki, Miron Livny: Efficient Buffering for Concurrent Disk and Tape I/O. Perform. Eval. 27/28(4): 453-471(1996)

[25]

Jussi Myllymaki, Miron Livny: Relational Joins for Data on Tertiary Storage. ICDE 1997: 159-168

[26]

...

[27]

Mark A. Roth, Scott J. Van Horn: Database Compression. SIGMOD Record 22(3): 31-39(1993)

[28]

Chris Ruemmler, John Wilkes: An Introduction to Disk Drive Modeling. IEEE Computer 27(3): 17-28(1994)

[29]

Sunita Sarawagi, Michael Stonebraker: Reordering Query Execution in Tertiary Memory Databases. VLDB 1996: 156-167

[30]

Sunita Sarawagi: Query Processing in Tertiary Memory Databases. VLDB 1995: 585-596

[31]

...

[32]

...

[33]

Peter Triantafillou, Thomas Papadakis: On-Demand Data Elevation in Hierarchical Multimedia Storage Servers. VLDB 1997: 226-235

[34]

C. K. Wong: Algorithmic Studies in Mass Storage Systems. Computer Science Press 1983

[35]

...

[36]

Jie-Bing Yu, David J. DeWitt: Query Pre-Execution and Batching in Paradise: A Two-Pronged Approach to the Efficient Processing of Queries on Tape-Resident Raster Images. SSDBM 1997: 64-78