Clean up SQL database (analysis)

Analysis title

Clean up SQL database

Provider

Institute of Systems Biology

Class

CleanUpSqlDatabase

Plugin

ru.biosoft.analysis (Common methods of data analysis plug-in)

Description

This analysis checks project SQL database for not used tables and removes them. Please be careful and make sure that the database is used for the specified project only and not for anything else!

Parameters:

• Projects to clean up – List of projects which will SQL databases will be checked for orphaned tables
• Print table names – Whether to print orphaned table names
• Perform clean up – Whether to actually drop orphaned tables or just to gather statistics