Has anyone been involved in the implementation of a hierarchical storage management solution - as part of a data warehouse implementation or otherwise ?<br>
<br>
A Hierarchical Storage Manager (HSM), is an integrated set of software and hardware, installed on a computer system, that provides enterprise-wide storage management services. HSMs can provide many different functions including automated backup, media management, archiving, migration, security, compression, among others. One of the key features most HSMs provide is the ability to store datafiles on less expensive offline or nearline storage devices, such as tape or WORM drives, while providing transparent disk-like, albeit delayed, access to the data.<br>
<br>
I'm looking into HSM for a proposed DW, and I find that though vendors say that in theory it should work, and they know there's an example somewhere of it being done, its not directly their area, and have you talked to the other vendors, etc.<br>
<br>
So, has anyone been directly involved with HSM ? If so, what products did you use, and what were your experiences ?
<br>
A Hierarchical Storage Manager (HSM), is an integrated set of software and hardware, installed on a computer system, that provides enterprise-wide storage management services. HSMs can provide many different functions including automated backup, media management, archiving, migration, security, compression, among others. One of the key features most HSMs provide is the ability to store datafiles on less expensive offline or nearline storage devices, such as tape or WORM drives, while providing transparent disk-like, albeit delayed, access to the data.<br>
<br>
I'm looking into HSM for a proposed DW, and I find that though vendors say that in theory it should work, and they know there's an example somewhere of it being done, its not directly their area, and have you talked to the other vendors, etc.<br>
<br>
So, has anyone been directly involved with HSM ? If so, what products did you use, and what were your experiences ?