Sign in or 
| Version | User | Scope of changes |
|---|---|---|
| Oct 2 2009, 3:25 PM EDT (current) | sdrevik | 24 words added, 163 words deleted |
| Jun 22 2009, 4:04 PM EDT | sdrevik | 70 words added, 42 words deleted |
Changes
Key: Additions Deletions
[Version 2 - perhaps earlier to support archive of converted E-DASThis archives]Tooltool beallows requiredusers to archive off and delete (or just delete) old data. For AirVision site, this process may need tocan be automated to ensure SQL Express databases do not exceed 4 GB.
Archive of data for protection of submitted data may
The notool longercan be necessary, as AirVisionscheduled supportsin the locking of data records against changes.Tool shouldTask beScheduler, ableand tothe enableuser andcan define a maximum retention time for each averaging interval. Defining by site/parameter is not anticipated to be supported.
A manual tool is also needed,available, and ideal functions include:allows:
Archive may also be performed by copying the SQL database and deleting undesired data sets. This is less desirable because:Upgrades may require 'DNC' update script to be run on all database copies, or keep in XML-like format with column tags.While database copies are open, all realtime functions must be shut down to avoid loss ofstate table information.Archived data should have a mechanism to be restored.
Archive of data for protection of submitted data may
The notool longercan be necessary, as AirVisionscheduled supportsin the locking of data records against changes.Tool shouldTask beScheduler, ableand tothe enableuser andcan define a maximum retention time for each averaging interval. Defining by site/parameter is not anticipated to be supported.
A manual tool is also needed,available, and ideal functions include:allows:
- Designation of date ranges for archive/delete
- Designation of sites/parameters to be archived/deleted Option to retain data < 1 hour if the hourly average is flagged in any way (and an option to "keep entire day" if any hourly average is flagged).
Archive may also be performed by copying the SQL database and deleting undesired data sets. This is less desirable because:Upgrades may require 'DNC' update script to be run on all database copies, or keep in XML-like format with column tags.While database copies are open, all realtime functions must be shut down to avoid loss ofstate table information.Archived data should have a mechanism to be restored.
