A 12 billions market has been created just to address the need for bookkeeping
historic data, it's called business intelligence (BI).
Never heard of data warehouses and OLAP tools ? Many businesses use these
if they can pay for them....
These things are cumbersome to implement, you have to extract data from your
operational systems following a tight schedule (otherwise data gets obliterated
before you can grab it) and import it in a BI backend and get it reorganized.
Data to be dumped in the BI backend has to be selected, frequency of uploads,
.. You cannot be certain that you grabbed everything that
matters, not knowing what future needs analysts may have. You also need a separate
infrastructure to run the whole gizmo.
Having a database where values can be read at will, replicated transparently
and scale easily where you do not loose any fact would simplify BI implementations a lot.
Most probably the whole migration process could be tossed away. The only
remaining need would be the creation of meta data needed for the analysis tool.
It may be important for us to forget past facts, otherwise we would go crazy but
may I point out that our brains never forget anything, we happen to have
neural cells specialized to hide past facts but these can be recalled.
As you age, this mechanism fails from time to time and can bring you back fresh souvenirs like if events happened yesterday.
:))))
Luc P.
Softaddicts<
lprefo...@softaddicts.ca> sent by ibisMail from my ipad!