Sign in to wikis by wetpaint
This version of Internet Explorer is no longer supported. Please try a current version of
IE
or
Firefox
.
Home
Discussions
Photos
Videos
News
Updates
Members
Sign in
or
Data Archive Tool
Page Versions
Key:
additions
deletions
Please select two page versions to compare - check the checkbox to the right of each version.
Showing 8 pages
Date/Time
Made By
Edit Note
Type
Scope
Compare
Oct 2 2009, 3:25 PM EDT
sdrevik
edit
24 words added
163 words deleted
Change:
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 export format
to
is
be
XML and
defined,
includes
probably
Universal
IDs,
similar to the format used for node-node
View changes from previous version.
(Word count: 95)
Jun 22 2009, 4:04 PM EDT
sdrevik
edit
70 words added
42 words deleted
Change:
information.
Databases
Archived
must
data
be
should
disconnected/reconnected
have
via
a
SQL
mechanism
Enterprise
to
Manager
be
restored.
it may be desirable to give Client the option to log into a list of known databases, having the long instance spawn a separate AV server, connecting to the particular database (?)
View changes from previous version.
(Word count: 234)
Apr 14 2008, 10:23 PM EDT
sdrevik
edit
32 words added
Change:
to avoid loss ofstate table information.Databases must be disconnected/reconnected via SQL Enterprise Manager
it may be desirable to give Client the option to log into a list of known databases, having the long instance spawn a separate AV server, connecting to the particular database (?)
View changes from previous version.
(Word count: 203)
Apr 14 2008, 9:53 PM EDT
sdrevik
edit
95 words added
1 word deleted
Change:
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
While database copies are open, all realtime functions must be shut down to avoid loss of
state
View changes from previous version.
(Word count: 172)
Apr 6 2008, 3:54 PM EDT
sdrevik
edit
2 words added
1 word deleted
Change:
not exceed 4 GB.Tool should be able to enable and define a maxmimum retention time for each averaging interval. Defining by site/parameter is not anticipated to be supported.Archive export format to be defined, probably similar to the format used for node-node data
transfer.
transfer
.
View changes from previous version.
(Word count: 78)
Apr 6 2008, 3:51 PM EDT
sdrevik
Moved from: Transaction Log Strategies
move
No content added or deleted.
Change:
Moved by
sdrevik
Apr 6 2008, 3:51 PM EDT
Apr 6 2008, 3:50 PM EDT
sdrevik
edit
76 words added
Change:
Tool be required to archive off and delete (or just delete) old data. For AirVision site, this process may need to be automated to ensure SQL Express databases do not exceed 4 GB.
Tool should be able to enable and define a
View changes from previous version.
(Word count: 78)
Apr 6 2008, 3:47 PM EDT
sdrevik
create
No content added or deleted.
Change:
Created by
sdrevik
Apr 6 2008, 3:47 PM EDT for: no reason given
JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then
try again
.
Home
FAQs
AirVision Documentation
AirVision Concepts
Installing AirVision
Configuring AirVision
Using AirVision
Public Information (Web) Tools
Optional Features
Database Schema
Data Archive Tool
Data Fill (Top of Day)
Training
Release Notes
Technical Notes / Workarounds
Design Notes: Upcoming Features
Tricks and Tips
ADVP Rule Suggestions
EPA Conference Notes
Step By Step Procedures
new page
(Uncategorized)