CRUD diagram - out of date?

[DaveB]

I have several thousand .flv files I need to delete come to think of it

It's easier just top leave them on YouPorn you know

[DaveB]

And yet pretty much every company I've ever audited from big multinationals to small engineering firms havn't kept their system/transaction/user activity log files becasue they didnt want to spend money on the storage and management.

[daviejones]

I have several thousand .flv files I need to delete come to think of it

[DimPrawn]

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?

(looking at my hard drives I'd say yes...)

Most systems these days implement a logical deletion of data (think recycle bin) as management change their minds and want the data back "from archive".

Also in relational systems where there is a degree of historical reporting, it makes sense to move old data to a different schema designed for reporting purposes rather than delete it.

Then there is always a requirement to audit data changes, who deleted it and what was it that was deleted? Again a logical deletion is preferred.

And finally, storage is very cheap, even 1TB of data, which in database terms is a lot of records.

[NickFitz]

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?

(looking at my hard drives I'd say yes...)

I think attitudes increasingly tend towards thinking that storage is so cheap one might as well not bother throwing anything away.

I worked on the media manager component of a CMS recently, specifically the image gallery. It allowed you to upload images (usually photos), resize and crop them and so forth. As a rough estimate, there would probably be maybe a thousand or so images, including full-resolution originals, added each month. Although I didn't work on that part, there will also be large sound and video files (interviews, podcasts, etc).

When we were speccing it all out I raised the question of deleting stuff. It took us about a minute to decide, according to the YAGNI principle, that there was no point spending time on that, given that we could for all practical purposes treat storage capacity as infinite - if the need ever arose, the deletion functionality could be added later. We all know that means it'll never happen

[Diver]

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?

(looking at my hard drives I'd say yes...)

That reminds me, I have several hundred pictures of Items I've sold on ebay stored that I must get rid of

[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?

(looking at my hard drives I'd say yes...)