Seen far too much of the customer insisting ages old data is vital even when it can be proven that the data hasn't been accessed in years, decades in a recent case.
The cost of migration of clearly obsolete data from a legacy system to a shiny new one as part of my last gig was a little over £250k (in man hours not storage). Chances are absolutely nil that 90% of the migrated data will ever be accessed.
In my experience housekeeping cleanups are the most neglected database tasks but generally represent excellent value for money/time invested.
-
The rule is if you ask The Business if they want some data the answer is always going to be "yes":
Yes we want a complete archive, yes we want full audit trail, yes we want to record every conceivable fact that comes our way. The problem is that it's hard to apply the YAGNI (You Ain't Gonna Need It) principle as you can't (usually) go back and get data you didn't capture earlier.Leave a comment:
-
Storage is cheap but you would be suprised at how much managing the backups can cost ......Originally posted by lambrini_socialist View Post
I don't think that is just IT. The business users at current clientCo refused point blank to allow files to be a moved to an archive because it might take four hours to get them back.Originally posted by cojak View Post
And that includes the MS Word docs that are so old that they cannot be opened with any current version of the software
Leave a comment:
-
storage is cheap and there's a lot to be said for "insert only" databases...Leave a comment:
-
CRUD diagram - out of date?
Philosophical musings here...
Just going through a high-level CRUD diagram and wishing that I saw the odd D here and there...
Whenever I ask people if they want to delete stuff they say 'no - we'll need that' so I have 2 or 3 levels of archive; easy retrieval, cold storage or deep freeze (don't ask...)
Has IT become a culture of hoarders?
Although I only have to look at my own IT needs to answer that....
Leave a comment: