SCM

Forum: How to use

Posted by: Alan Galante
Date: 2005-08-09 03:08
Summary:How to use
Project:PostGeoOlap

The whole thing works as follows:
1) you should design and implement your data warehouse on a postgresql database (that is: a Fact Table and its dimensions, as stated by Kimball's star model - do not forget the foreign key in the fact Table related to the dimensions)
2) This data warehouse (DW) will be populated with data from your transactional databases (you should get a loader or a some other tool in order to copy and transform data from your production databases to your DW)
3) Using postgeoolap, you will connect to your populated DW, and:
3.1 - Define a Fact Table and its numeric measures (the attributes you would like to summarize or aggregate)
3.2 - Define, one-by-one, the dimensions of the cube, and for each dimension you must define the hierarchy level of the attributes (e.g: state-city-street)
4) After the definitions stated in 3), your Cube is completely designed, and you should process the Cube so postgeoolap can generate aggregations, that is, create some new tables that will speed up the queries you will make.
5) After the Cube is processed, you can go to the analysis screen in order to query your data. In the Analysis screen, you are able to pick up (by double-clicking on a TreeView) the attributes of interest, and then when you are done, postgeoolap will display the results you requested on a JTable, and the geographical results (if any) will be displayed on a map (note that the visualization of the geographical resultas is still not finished in version 0.8.2 of postgeoolap).

P.S: Consider using bizgres (www.bizgres.org) in order to improve performance. Bizgres has also other tools, like a data loader, that should make it easier to support your Business Intelligence (or Decision Support) environment.

Sponsors Ads

Latest News

postgeoolap v0.8.2 released

Alan Galante - 2005-08-10 20:44 -

How to use

Alan Galante - 2005-08-09 03:08 -
Monitor Forum | Start New Thread Start New Thread
Powered By FusionForge