Questions tagged [star-schema]
The star-schema tag has no usage guidance.
58
questions
1
vote
1
answer
2k
views
~2 Billion row fact table in star schema on Oracle. Advisable? [closed]
Let me start with: I am not a DBA; I am a backend developer.
It has been suggested that, for a report schema, I implement a star schema where-in the fact table can have ~2B rows before being archived....
5
votes
1
answer
4k
views
Schema for analytics table in Postgres
We use Postgres for analytics (star schema).
Every few seconds we get reports on ~500 metrics types.
The simplest schema would be:
timestamp metric_type value
78930890 FOO ...
- 53
4
votes
1
answer
646
views
How to handle "many columns" in OLAP RDBMS
I have a fact that has around 1K different numerical attributes (i.e. columns). I would like to store this in to a column-oriented DB and perform cube analysis on it.
I tried to design a star ...
- 185
5
votes
2
answers
1k
views
Should I snowflake or duplicate it across my facts?
I'm building up a data warehouse to be used by SSAS to create cubes on, and I'm debating between two possible schemas.
In my warehouse, I've got two different fact tables that tracking daily changes ...
- 231
2
votes
1
answer
1k
views
IP Address lookup star schema design
I am working on a project in which we need to do IP Address lookups. So for this we have got the datasets and now the next steps is to populate this datasets in to the table. And then have some ...
- 135
4
votes
2
answers
2k
views
Open source and commercial tools to build dynamic queries of fact tables in star schema [closed]
What user interfaces or tools (commercial and/or open source) can query a star schema model (Ralph Kimball dimensional model)? So for example, if we have X fact tables, and Y dimension tables, and Z ...
- 2,072
2
votes
2
answers
3k
views
Data warehouse support tickets
I'm starting to design a data warehouse for a company. The first questions we're trying to resolve are regarding their support ticketing system. My initial schema is as follows
Now one of the ...
- 123
5
votes
2
answers
4k
views
Cardinality rule for bitmap indexes
The Oracle documentation includes the following advice:
A bitmap index should be built on each of the foreign key columns of
the fact table or tables
In that reference, there is even a bitmap ...
- 75