CRUD diagram - out of date?

[cojak]

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....

[cojak]

Rats - I was going to put this in Technology.

[lambrini_socialist]

storage is cheap and there's a lot to be said for "insert only" databases...

[Gonzo]

storage is cheap and there's a lot to be said for "insert only" databases...

Storage is cheap but you would be suprised at how much managing the backups can cost ......

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?

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.

And that includes the MS Word docs that are so old that they cannot be opened with any current version of the software

[swamp]

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.

[TykeMerc]

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.