[Contrib: Evaluation System] data in EvalSys - best practices

[Jim Eng]

Hi Rebecca,

At Michigan, the evalsys response data is harvested and imported into an external system.  All analysis and reporting is done through the external system.  As soon as possible after we verify that the data was harvested without error, we delete and purge all evalsys data for the semester from our sakai instance (CTools) using SQL scripts.  I believe that we'd need to delay the removal of data if reporting was being done through evalsys, but removing the data from the sakai's database tables severs the connection between a sakai user and a specific eval response, ensuring protection the identity of the evaluator. For that reason, we purge all backups of those tables as well as the tables themselves at that point.  

The SQL scripts need to be written to avoid constraint violations and to avoid deleting data about evals that are not yet completed (if any).  I'm not able to share the scripts since I am no longer involved in that process, but you might contact Beth Kirschner if you'd like a copy of Michigan's scripts.

Jim   


On Sep 11, 2012, at 6:41 PM, Rebecca Peet wrote:

> Hi,
> 
> We are interested in understanding how members in the community who are using EvalSys are managing their data in EvalSys.
> 
> Specifically, do you periodically purge your evaluation data?
> If so, how often do you remove the evaluation data?
> 
> We'd be very interested to get a look at any scripts that you run to accomplish a data purge.
> 
> Are there any known performance issues related to large amounts of data in EvalSys?
> 
> Thanks,
> Rebecca Peet
> Learning Technologies
> UC Santa Cruz
> 831.459.1573
> 
> 
> 
> _______________________________________________
> evaluation mailing list
> evaluation at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/evaluation
> 
> TO UNSUBSCRIBE: send email to evaluation-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/evaluation/attachments/20120912/86881514/attachment.html