Software produced by Teradata Corp will automatically place frequently used or ‘hot’ data on the fastest storage units and switch the least accessed or ‘cold’ warehoused data on a lower cost but slower storage platform.
The ‘temperature aware’ Virtual Storage database management software intelligently manages data placement while enabling system performance to remain high and predictable as data grows, the company said.
One outcome of the development is that storage administrators can opt to add larger disk drives to their data warehousing systems without needing to add extra processing units or nodes and database software.
“The proper placement of data supports high-performance access to hot data in support of real-time decision making, and provides an automated lifecycle management process as data age or ‘cool’ and migrate to less expensive drives,” the vendor said.
As an example, telco companies analyse the most recent 90 days of customer detail records which are then seen as‘hot’ data, but will go on to store the records off-line, making them cold and less accessible.
“With the lower cost storage capacity, the customer detail records can now be automatically migrated into ‘cold’ data storage on the warehouse after their initial use. In cold storage, they are still on-line and always available for retrieval for historical trend analysis or compliance.”
