• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

CRUD diagram - out of date?

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    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?

    (looking at my hard drives I'd say yes...)
    "I can put any old tat in my sig, put quotes around it and attribute to someone of whom I've heard, to make it sound true."
    - Voltaire/Benjamin Franklin/Anne Frank...

    #2
    Originally posted by cojak View Post
    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
    Confusion is a natural state of being

    Comment


      #3
      Originally posted by cojak View Post
      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

      Comment


        #4
        Originally posted by cojak View Post
        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.

        Comment


          #5
          I have several thousand .flv files I need to delete come to think of it
          "If you can read this, thank a teacher....and since it's in English, thank a soldier"

          Comment


            #6
            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.
            "Being nice costs nothing and sometimes gets you extra bacon" - Pondlife.

            Comment


              #7
              Originally posted by daviejones View Post
              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
              "Being nice costs nothing and sometimes gets you extra bacon" - Pondlife.

              Comment

              Working...
              X