Re: Up-to-date reports database

From: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
To: Herouth Maoz <herouth(at)unicell(dot)co(dot)il>
Cc: cernst(at)zvelo(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Up-to-date reports database
Date: 2012-05-23 15:54:00
Message-ID: CAD8_Ucaw2KgZKGae0afZFuCrUN0OGzefBOGS+9uUY6R7Pc4JaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
my suggestion is to redesign reporting database to fit reporting specifics
(e.g. brake normal form of database, in some cases this will speed up
reports). Than you can use some ETL tool to sync production and reporting.
Good thing is to use some OLAP software to use multidimensional analyze -
this will make queries easier (with MDX language). I think this kind of
discussion is huge one :)

there are some opensource ETL and BI suits available.

Regards,
Bartek

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message deepak 2012-05-23 16:03:33 Re: FATAL: lock file "postmaster.pid" already exists
Previous Message Herouth Maoz 2012-05-23 15:12:45 Re: Up-to-date reports database