Обсуждение: Re: Old data (was Re: Long term database archival)

Поиск
Список
Период
Сортировка

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

От
Richard Broersma Jr
Дата:
> -----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.