On 03/03/16 20:13, Jim Starkey wrote: >> Where i can see a useful segregation is archival data which will never >> be modified. Would be very usefull if all that could be backed up on a >> Slow cycle, and only the real dynamic data kept in the primary table >> space? But one can do most of that by having multiple databases anyway? > > You know, that's a really good idea. Disk is almost free, too cheap to > meter (so to speak). Store something once and just don't worry if it > goes out of style...
I spent last night down at the local A&E to get a problem sorted. I was reading these emails while waiting and was re-thinking the problem of medical data given the size of the piles of paper records passing by ... Where the bulk of that material is old paper and images, digitizing them for easy access anywhere is a 'cost' problem. but replacing with electronic copies creates the sort of 'blob' data that I was talking about originally. It's the sort of static data that perhaps needs multiple storage sites, but does not need to be continually backed up in any database system ... just the index of available material. Content extracted from that data for easy access such as say 'blood pressure and temperature', while part of the dynamic element of the records is essentially a static set of records to which material is added, and it's this element that could perhaps benefit from a different process? 'Non-deletable' data so the pages containing it are essentially static, but with an active final page? I think a large section of data would be better handled like this such as bank transactions or telephone calls. Delete in these cases would be date related, but 'older' pages could simply be left on the system so one can just scroll back through if necessary? What gets my goat currently is the way my bank 'archives' the on-line data to bank statements so one can't easily scroll back, but each of those 'blob's of data could be made accessable with a different approach to the storage? -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
