In Databases HSM has seen little use with databases. StorHouse has a high volume data loader for Direct Channel loads from mainframes and FTP loads from the network. It can process 10s of GBytes of table data per day and concurrently build all required indexes. It can build massive tables spanning many years and holding 10s of TBytes. Both hash and value indexes are supported to enable fast exact match retrievals and range-based retrievals.
Indexes are multilevel and can reside separately in the storage hierarchy.
StorHouse contains its own SQL query processor, optimizer, execution manager and database gateways. This support includes the use of large magnetic disk performance buffers that enable the storage of 100s of GBytes of the most active portions of indexes or tables to further enhance performance. The following diagram illustrates the various StorHouse components. Database gateways provide access to StorHouse from many different database systems. StorHouse and the gateways provide for full sharing of data from different database environments.