Re: Managing high volumes of data... how to...

From: Steven Patenaude <spatenau_at_gmail.com>
Date: Thu, 13 Jan 2005 13:16:03 -0600
Message-ID: <10644b9e05011311161992086@mail.gmail.com>

On Wed, 12 Jan 2005 10:09:30 -0800 (PST), Jose Luis Delgado <joseluis_delgado_at_yahoo.com> wrote:
> All...
>
> We need to build web reports to display those data I
> mean volumes and some parameters, for some reports the
> type is as following:
>
> for a date:
> today_volume,
> volume_yesterday,
> from_begin_month,
> from_begin_year......
>
> Please, note that this structure is asking for high
> summaries as from the beginning of the year/month up
> to date.

Is this historical data that stays static after a particular day? If so, maybe borrowing a page from the datamart world would be in order. Would it be a problem to create aggregate data table(s)?

Steven

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 13 2005 - 13:16:20 CST