Question : We use Postgres for analytics (star schema). Every few seconds we get reports on ~500 metrics types. The […]
Tag: star-schema
designing a star schema
Question : I am a newbie and would appreciate suggestions/material to research I have 3 types on information in a […]
Cleanup / Prune Unreferenced Data in Dimension Tables
Question : We have a star schema data warehouse running on MySQL 5.6. We keep a rolling 18 months of […]
Connecting dimension tables in a multi-fact star schema database warehouse?
Question : I am new to data warehouse modelling so please bear with me. In database warehouse modelling, the star […]
Schema for analytics table in Postgres
Question : We use Postgres for analytics (star schema). Every few seconds we get reports on ~500 metrics types. The […]
IP Address lookup star schema design
Question : I am working on a project in which we need to do IP Address lookups. So for this […]
How to handle “many columns” in OLAP RDBMS
Question : I have a fact that has around 1K different numerical attributes (i.e. columns). I would like to store […]
IP Address lookup star schema design
Question : I am working on a project in which we need to do IP Address lookups. So for this […]
What are the difference between a “dimension” table in a star-schema and a “lookup” table in a relational database?
Question : I’m trying to design a star-schema fact table along with some dimension tables that will surround it. If […]
~2 Billion row fact table in star schema on Oracle. Advisable? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Tip of the iceberg – the question […]
- 1
- 2