Re: Best practices for aggregate table design

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Best practices for aggregate table design
Дата
Msg-id 56186788.80606@hogranch.com
обсуждение исходный текст
Ответ на Re: Best practices for aggregate table design  (Roxanne Reid-Bennett <rox@tara-lu.com>)
Список 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 по дате отправления:

Предыдущее
От: Roxanne Reid-Bennett
Дата:
Сообщение: Re: Best practices for aggregate table design
Следующее
От: Victor Blomqvist
Дата:
Сообщение: Re: Drop or alter column under load give ERROR #42804 structure of query does not match function result type: