Teradata and near-line storage

Database

Teradata and near-line storage

For the sake of this discussion, I am using the phrase 'nearline storage' to refer to the process/solution/technology for moving rarely-used data outside the DATABASE and to a cheaper storage system to alleviate database performance and to reduce (storage) costs. I am also stating that such a technology/solution would make it transparent to an user i.e. when a query attempts to read the archived data, then automatic processes kick in to retrieve the data and respond to the query - thus the user only sees a delay in the response of his query.

Are there any such solutions available for Teradata ?
2 REPLIES
Enthusiast

Re: Teradata and near-line storage

No, not currently.
Enthusiast

Re: Teradata and near-line storage

Any rumors that such a solution might be available at some point in the future?

Anybody here working with a solution they think comes close to this approach?

We've got a budget crunch this year and our Teradata DBAs keep reminding us that Teradata storage is very expense. Their solution is to ask users to drop tables. I know our users could practice better database hygiene, but I'd still like to find an approach that makes them feel more comfortable about off-loading less frequently used data with an ability to quickly and easily restore if needed.

Thoughts?

NM