Re: Data Retention

From: JRStern <JXSternChangeX2R_at_gte.net>
Date: Tue, 12 Mar 2002 22:08:29 GMT
Message-ID: <3c8e7c82.17407310_at_news.verizon.net>

On Sun, 10 Mar 2002 22:24:28 -0600, "Dave" <Dave_at_mail.com> wrote:
>Anyone struggling with a data retention plan? I looking for resources on
>how to start planning.

An underappreciated issue. I have no pointers, just sympathy.

I usually try to establish an archive database for stuff more than X years old, and keep it online, just in case. When it gets more than Y years old, you can stuff it on a CD just in case, but take it offline.

Usually there is some overlap between current and archive data, especially when you have some business transactions in the data that span long periods of time. It's nearly impossible to draw clear lines between current and obsolete, so the trick is not to try. Hey, storage is cheap.

Joshua Stern
JRStern_at_gte.net Received on Tue Mar 12 2002 - 23:08:29 CET

This message: [ Message body ]
Next message: Manfred Jeusfeld: "CfP: Data Warehouse Workshop DMDW'02 at CAiSE'02 in Toronto"
Previous message: hakan ferhatosmanoglu: "CFP: ACM CIKM 2002"
In reply to: Dave: "Data Retention"
In reply to Dave: "Data Retention"
Next in thread: Jonathan Feinberg: "Re: handling database procedures in an object"
Reply: Bien LX: "Re: C.J. Date class "Relational Remodeled""

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message