Difference between revisions of "Maintenance ETL"

From truxwiki.com
Jump to navigation Jump to search
(Created page with "The Maintenance ETL is tasked with performing long running tasks. These tasks can take a significant amount of time and cause the Analyst Desktop to become unresponsive. =Tas...")
 
Line 7: Line 7:
 
==Clean Database==
 
==Clean Database==
 
When Maintenance cleans a database, it will determine if there are any records in the following tables that do not belong to any media.
 
When Maintenance cleans a database, it will determine if there are any records in the following tables that do not belong to any media.
* File
+
* <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code>
 
* Filename
 
* Filename
 
* Slack
 
* Slack
Line 18: Line 18:
 
* Message Address Descriptiosn
 
* Message Address Descriptiosn
 
* Investigation Media
 
* Investigation Media
* Log
+
* <code><nowiki>[</nowiki>[[Log Table|Log]]<nowiki>]</nowiki></code>
 
* Log Strings
 
* Log Strings
 
* Content
 
* Content

Revision as of 13:59, 25 July 2022

The Maintenance ETL is tasked with performing long running tasks. These tasks can take a significant amount of time and cause the Analyst Desktop to become unresponsive.

Tasks Performed

Maintenance is responsible for the following tasks.

Clean Database

When Maintenance cleans a database, it will determine if there are any records in the following tables that do not belong to any media.

  • [File]
  • Filename
  • Slack
  • Entity Strings
  • Expanded Files
  • Message Address Message
  • Message Address
  • Meddage Piece
  • Message Subjects
  • Message Address Descriptiosn
  • Investigation Media
  • [Log]
  • Log Strings
  • Content