News for hackers. Stuff that matters.

A comment on Introducing “Database Performance at Scale”: A Free, Open Source Book. Parent comment

Re:Introducing “Database Performance at Scale”: A Free, Open... by stvltvs on Thursday October 05, 2023 @02:00PM (#37781827)
Sounds like the job for a denormalized OLAP data structure (e.g. star schema) with a BI tool. This is the kind of use case they were made for. In other words, you've rediscovered the motivation for data warehouses.
[ Parent | on HN ]
Re:Introducing “Database Performance at Scale”: A Free, Open... by WesleyJohnson on Thursday October 05, 2023 @04:48PM (#37784109)
Thank you for the feedback. I'll do some research along these lines. We have moved a report or two to Power BI which has been must faster than similar reports built using dynamic queries. Keeping the data in sync and the Power BI learning curve have not been easy.
[ Parent | on HN ]