star-schema Archives

Schema for analytics table in Postgres

By adminPosted on November 23, 2022

Question : We use Postgres for analytics (star schema). Every few seconds we get reports on ~500 metrics types. The […]

By adminPosted on October 9, 2022

Question : I am a newbie and would appreciate suggestions/material to research I have 3 types on information in a […]

By adminPosted on August 2, 2022

Question : We have a star schema data warehouse running on MySQL 5.6. We keep a rolling 18 months of […]

By adminPosted on June 12, 2022

Question : I am new to data warehouse modelling so please bear with me. In database warehouse modelling, the star […]

By adminPosted on February 11, 2022

Question : We use Postgres for analytics (star schema). Every few seconds we get reports on ~500 metrics types. The […]

By adminPosted on April 29, 2021

Question : I am working on a project in which we need to do IP Address lookups. So for this […]

By adminPosted on April 7, 2021

Question : I have a fact that has around 1K different numerical attributes (i.e. columns). I would like to store […]

By adminPosted on April 7, 2021

Question : I am working on a project in which we need to do IP Address lookups. So for this […]

By adminPosted on March 19, 2021

Question : I’m trying to design a star-schema fact table along with some dimension tables that will surround it. If […]

By adminPosted on March 10, 2021

Question : Closed. This question is off-topic. It is not currently accepting answers. Tip of the iceberg – the question […]