THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Buck Woody

Carpe Datum!

Permanent storage – a myth or a requirement?

I'm looking over some data retention strategy documents for a company, I noticed that they want to keep some data "forever". Now, beyond the quibble of determining how to store something for eternity, how permanent can data really be? There are atomic (n, not ACID, atomic) ways of storing binary representations, but will the interpretation of those 0's and 1's really be there for more than a few decades? Think about the data stored on punch cards - where is that now?

The answer is that it morphed into other storage along the way. If something really needs to be permanent, you need to think more about it's migration than the actual media it's stored on. That's what I'm recommending in this document - tag data sets to be migrated first, or at least considered in the migration planning. It's a simple pivot on storage versus programming, but an important one.

Published Thursday, August 5, 2010 8:12 AM by BuckWoody
Filed under: ,

Comments

No Comments
New Comments to this post are disabled

About BuckWoody

http://buckwoody.com/BResume.html

This Blog

Syndication

Privacy Statement