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

  • From: Jose Luis Delgado <joseluis_delgado@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 12 Jan 2005 10:09:30 -0800 (PST)


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:

Please, note that this structure is asking for high
summaries as from the beginning of the year/month up
to date.

We've created plsql functions to make some


gage_volume_year(gage_name, todate) 

return the volume from the beginning of the year
stopped to todate....

the same technique has been used for the beginning of
the month...etc

after that we've used a snapshot to gather all these
data, but as it wasn't simple functions then it was
not possible to use refresh fast., and the refresh
complete was too heavy.

Question: which would be the best way to manage this
high volume of data?

Thanks for your help


Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard. 

Other related posts: