Difference between revisions of "Maintenance ETL"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
==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 or file. |
| + | These records are considered to be orphaned. | ||
| + | |||
* <code>[Alert]</code> | * <code>[Alert]</code> | ||
* <code>[Content]</code> | * <code>[Content]</code> | ||
Revision as of 14:31, 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 or file. These records are considered to be orphaned.
[Alert][Content][Entity][Event][EXIF][ExpandedFile][File][Filename][Free][Image][InvestigationMedia][Location][Log][LogString][Message][MessageAddress][MessageAddress_Message][MessageAddressDescription][MessageSubject][MessagePiece][ReviewItem][Slack][USBDevice][WebsiteVisit]
