Reason for change
The main change is adding a set of indexes to the tables to improve the ingestion time.
These indexes also improve the cleanup time AND avoid the conflicts generated when multiple ingests were ran simultaneously.
The schema is also changed to allow different processes (Digi, Recon, FastMon, etc) to ingest data at different frequencies (like 15 secs, run level, 5 mins, etc).
Test Procedure
These changes have been added to the DEV and TEST databases. We have an updated ingestion script that is happily running on DEV and TEST (this one for stress testing the new database). A version of the web front end is deployed on the Development server and is working fine when looking at the DEV and TEST dbs.
Rollback procedure
To rollback we would have to undo the schema changes.