Hierarchical Storage Management for Relational Databases

Abstract

Hierarchical Storage Management has the potential to optimize the cost and performance of data storage and access by automatically managing the placement of data on different storage media. Unfortunately, this potential is not realize for data stored by database management systems (DBMSs), because current DBMSs require all database tables to be stored on disk. This paper describes a prototype that integrates a database management system with a storage management system, allowing simple, cost effective access to large volumes of data stored in a tape archive.