[sims] Large sims database

[dapaulio]

Hi all.

For various reasons we are looking to reduce the size of the database which mainly stemmed from data retention.

 

We have done the usual suspects, archive attendance marks, orphaned contacts ya da yada however this is not really making much impact.

 

 

Calculating the tables sizes in sql it points to in touch messages (sims.itc.messages_out) holding 30gb over 15 years of tables rows.

 

Our sims support say there are a number of patches ranging from 1-5 years an an intouch purge patch from ess that can be applied however they just advise that this is highly destructive and not really answering the questions we are asking.

 

We have been advised that data has to be retained Upto the students 25th birthday. Longer in certain circumstances.

 

We have messages linked to the student record. Are the in touch messages that are linked to the students included in this?

 

How does the destructive patch know what to delete and what not to delete especially as the the longest patch retention is 5 years (shorter than the requirements of students 25th bday)

 

If we purge the intouch table does the patch unlink the linked students messages or are these stored /copied to another table within the database?

 

Thanks

[bobsmith]

safeguarding concerns, SEN information, Exam* results - these are the things that you have a statutory obligation to keep (* exams are held by the exam board so technically you don't have to keep them)

 

all the day to day crap only needs to be kept as long as you have a necessary reason for it.

 

GDPR principle:

The UK General Data Protection Regulation (GDPR) states that personal data should only be kept for as long as necessary for the intended purpose, meaning institutions must justify the length of their data retention periods

 

So in this case - unless you can think of a pressing need - lose it.[/color]