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 56186788.80606@hogranch.com
Whole thread Raw
In response to Re: Best practices for aggregate table design  (Roxanne Reid-Bennett <rox@tara-lu.com>)
List pgsql-general
On 10/9/2015 6:07 PM, Roxanne Reid-Bennett wrote:
> On 10/9/2015 3:16 PM, droberts wrote:
>> Thanks for everyone's help. Can anyone recommend a good book on
>> database modeling, around these 'cube' or aggregate concepts in
>> particular? I'm using Postgres but shouldn't matter too much I assume.
>
> Given the shift towards NoSQL for BI, and the age of the consultants,
> I don't know how much of a driver of design patterns the Kimball Group
> still is in the BI/Data warehouse space - but their blogs and books
> have been good fodder for thought for the modeling I've done.

actually, there've been numerous cases where NoSQL deployments never
worked right, and people reverted to SQL for reporting.

--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: Roxanne Reid-Bennett
Date:
Subject: Re: Best practices for aggregate table design
Next
From: Victor Blomqvist
Date:
Subject: Re: Drop or alter column under load give ERROR #42804 structure of query does not match function result type: