Re: Best way to do this query.. - Mailing list pgsql-sql

> Yes the data does not change once it is logged.
> I am quite new to this whole thing, do you mind elaborating more
> about the OLAP data model you mentioned about?

Well just to give a generalization using an OLAP as your data model, the data is stored in a
denormalized yet defined model.  Data integrety is maintained because by definition all records
inserted will remain static.

Here are some additional links that can be used for getting started:

http://en.wikipedia.org/wiki/OLAP
http://www.amazon.com/gp/product/0123695120/sr=8-4/qid=1156546075/ref=pd_bbs_4/002-4041472-4877644?ie=UTF8


Another alternative is to create a materialized view that will update itself only when records are
inserted or updated.

http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html

Regards,

Richard Broersma Jr.