Postgres Pro
Downloads
Home   >   mailing lists

Re: Best practices for aggregate table design - Mailing list pgsql-general

From John R Pierce
Subject Re: Best practices for aggregate table design
Date
Msg-id 56141427.4060604@hogranch.com
Whole thread Raw
In response to Re: Best practices for aggregate table design  (droberts <david.roberts@riverbed.com>)
Responses Re: Best practices for aggregate table design  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
On 10/6/2015 11:24 AM, droberts wrote:
> OR a dimension 'type' with values outbound/inbound and a single measure
> column 'total' ?

that smells a bit too much like an "EAV" (entity-attribute-value) which
is considered an antipattern in relational circles

--
john r pierce, recycling bits in santa cruz

pgsql-general by date:

Previous
From: droberts
Date:
Subject: Re: Best practices for aggregate table design
Next
From: "David G. Johnston"
Date:
Subject: Re: Best practices for aggregate table design