← Back to team overview

dhis2-devs team mailing list archive

Re: what different between aggregation table and analytics table?

 

Hi,

the tables starting with aggregated... is for pre-aggregated data and
referred to as a data mart. We keep this for legacy reasons and because it
is sometimes easier to integrate with SQL-based analysis tools.

The analytics tables are used by the analytics Web API and should ideally
not be used directly. The analytics API aggregates data on-the-fly and is
much more flexible and less time-consuming.

Lars




On Sat, Aug 17, 2013 at 6:29 AM, easy <lin_xd@xxxxxxx> wrote:

> Hi,sir,
>   I still not clear understand the diff and relation of the two kind
> table. can give some explane?
>  will the analytics table replace aggregation tables?
>  Thanks.
>
>
>
> --
> 此致
>
>   easy.
>
> 莫愁前路无知己,天下谁人不识君。
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

References