fashouri (1) [Avatar] Offline
I am currently working on climatic raster databases created using PostGIS/Postgresql. This is data stream that is updated every hour with new data. The problem with the database is huge size of data over long period. So, I am thinking of using aggregate functions to store summarized information of older data. Imagine I have hourly temperature, after a month hourly information is no longer needed. I need to store daily temperature average for the data older than a month. Is there specific methods to do that? (I mean for data aging in genera, not necessarily my raster database). Besides, do you know any reference or scientific paper or book dealing with the issue?