Question : We have a star schema data warehouse running on MySQL 5.6. We keep a rolling 18 months of […]
Tag: star-schema
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 […]
How do I choose primary keys for star schema BI data warehouse?
Question : I am extracting sales turnover data from a Microsoft Dynamics Database into another SQL database that will be […]
FK Issue with Fact Table
Question : I have a Datawarehouse star schema. One Dim table is ‘DimTweet’. This contains tweet details. For a selected […]
- 1
- 2