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

  • From: Steven Patenaude <spatenau@xxxxxxxxx>
  • To: joseluis_delgado@xxxxxxxxx
  • Date: Thu, 13 Jan 2005 13:16:03 -0600

On Wed, 12 Jan 2005 10:09:30 -0800 (PST), Jose Luis Delgado
<joseluis_delgado@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l

Other related posts: