Re: Old data (was Re: Long term database archival)

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Richard Broersma Jr wrote:
> [snip]
> > I am not to sure of the relevance, but I periodically worked as a
> > sub-contractor for an Oil-producing Company in California. They
> > were carrying 35 years of data on an Alpha Server running
> > Ca-Ingres. The really bad part is that hundreds and hundreds of
> > reporting tables were created on top of the functioning system
> > for reporting over the years. Now nobody know which tables are
> > relevant and with are redundant and or deprecated.
> >
> > Also year after year, new custom text file reports were created
> > with procedural scrips. The load on the server was such that the
> > daily reporting was taking near taking 23 hours to complete. And
> > the requests for new reports was getting the IT department very
> > worried.
> >
> > Worst of all know one there really know the ins and outs of
> > Ingres to do anything about it.
> >
> > Well, I take part of that back. They recently upgrade to a newer
> > alpha to reduce the time daily reporting was taking. :-)
>
> OpenVMS never stops, does it? :)
>
> We've got some big OLTP systems running RDB. I dread having to move
> to Oracle, even though it will be running on Linux.

I don't know but maybe some-one else on the list will. :-)

Regards,

Richard Broersma Jr.