Laserfiche WebLink
<br />. <br /> <br />. <br /> <br />. <br /> <br />Archiving data <br />Open the Arehive Data dialog try selecting File>Archive from the STORM Wateh main menu, Using <br />Arehive properly will allow the STORM Wateh application to provide optimum performanee by <br />removing older data from the operational database. The data are eompletely aeeessible for <br />reporting, analysis and simulation still, <br /> <br />~ Archive Data E3 <br /> <br />D41~base mdnagemenloplion:;-------- <br /> <br />Dal..bllSeMainlenancecanbeduIOOlaledt.y <br />selectinglheflslcheckbOl<andspeclYll1g1he <br />lmeoperaloos mollid begin each day <br /> <br />p Runmarnlenanceeverydayal 05:03 <br />Iv Appen:lrecold.toaJchive~abase <br />Iv PlJIgeoperallonalrecOIdsilflel 30 day~ <br />Iv CoJ'lllacloperal;ional dalabasewhen3lchi>mg <br />p Copydalab;,seloanotheflocationevely7 days <br /> <br />Check:t<ppend records' 10 copyon.me dala into <br />table 'OataChron'jn the archive dalabase.. <br />Olher dala llnd tables wil be copied as cnecked <br />'Puroe' femoves dala from the on.ine di:lt~se that <br />is older lhanthe number of days)louset <br /> <br />DalllMSeloco!lllons <br />Archive- Ie \PROGRAM FILES\STORM WA <br />Back.up, Iswcopy2mdb <br /> <br />B,,,,,,,.o::l <br />Browsel <br /> <br />'Compact'recovers Me space. defra.,nentslhe <br />dalo3base,and""provesperlormance <br /> <br />Addi'lonaldlllalolllchive <br /> <br />'CoPl"makes a backup copy of the opelahonal <br />dalabaseallhelnterv~youspedjl.IFlhe <br />dalabase~cOOlpacted Use'capy'tomainlaina <br />ready backup of your sjlstem conllguration <br /> <br />rArchiveduplicaleleports <br />r Ardive reports hom U'1del;ned sensors <br />rArchlvere,ecledreports <br /> <br />You can speClfjl Ihe locallon crJd names for the <br />arctlve and backup d/lt/lb/lles. <br /> <br />Additional I"bles to i:lfchive <br /> <br />1:::-A;~:~y~~~,~~~J1 EltgeDalaNow <br />CQmpacl Now I CllfllIact and Copy <br />Repllir S'+I Dlltllbase I Repa~ Arcr.;ve DB <br />I J;O~ <br /> <br />p" Time SerIeS ~nlervaL HOIl. Day) <br />r AreaA\lerages (Intelv/lt Hour,D/ljl <br />r BasinAverages(lnte!vaLHour.Di:ljI) <br />p" Alarm Log <br />r SyslemMessages <br /> <br />EWarning: Archiving moves data out of the database into other files on the same hard drive. <br />Archiving does not substitute Jar backing up the hard drive itself to another storage medium, <br />usually a tape or a network drive, on a regular basis. In the event oj a hard disk problem, your <br />.\y.'.;tem can be restored without losing precious data and configuration information, but only if <br />you backed it up, Without a hard drive backup, you risk losing everything, <br /> <br />Archiving activity-based data and configuration files <br />The Arehive utility allows you to remove older data from the on-line database, swatch2.mdb, to a <br />database called archive2,mdb, thus freeing up the on-line database for optimal performanee, <br /> <br />The tables involved are: <br /> <br />DataChron: eontains validated sensor data - this table is always arehived, the others are optional <br /> <br />AlarmsLog: contains all the alarms activity <br /> <br />Day: eontains daily rainfall data <br /> <br />DayAreaAvg: eontains daily area averages for overlay calculations <br /> <br />Hour: eontains hourly rainfall data <br /> <br />HourAreaAvg: eontains hourly area averages for overlay ealeulations <br /> <br />Interval: eontains interval rainfall data for the system interval <br /> <br />18 <br />