Nice concept, but...
How do I then archive it off for "reasonable" availability any better than I do now? A good DBA has already taken measures to ensure critical production data is available, and production database access is fast. What if you're in the situation where you're production environment generates 30 million rows per day, that you need to archive off nightly (like my company...) and keep available for 2 years? How does this system improve that? It sounds to me like a very good idea, but if your company has DBAs that are worth a spit, you don't need it. Everything it does is BETTER done by good management of partitions, diskspace, and good backup/archive procedures. Once the procedure is regular, it can be scripted out, like everything else....