Space savings in Star Vs 3NF
Jeff Smith at 19h11
25
Mar
2010
Space savings in Star Vs 3NF
I was curious if anybody had any estimates of the savings in space between a 3NF database and the same Data in a Star Schema? If a 3NF database took up 2.5TB, would the Star be 1.25TB? I was just wondering if there was a rule of thumb about it.
In looking at the big tables in the 3NF, I see a lot of fields that can be grouped together in a junk dimension, plus they are using a lot of Datetime fields that I would replace with the a surrogat
I was curious if anybody had any estimates of the savings in space between a 3NF database and the same Data in a Star Schema? If a 3NF database took up 2.5TB, would the Star be 1.25TB? I was just wondering if there was a rule of thumb about it.
In looking at the big tables in the 3NF, I see a lot of fields that can be grouped together in a junk dimension, plus they are using a lot of Datetime fields that I would replace with the a surrogat
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
I got there a little after 7. Nothing had started, but that's fine. Chris greeted me at the door and asked what I wanted him to draw on my hand. He seemed like he'd had a few by this point.
Chris Lynch:
So, his set was hilarious. After 4 or 5
Can anyone list the advantages and disadvantages of Star vs. Snowflake in your DW environement . And has anyone switched from one to another and why?
I'm designing a data mart for employee compensation. The measures will include things such as salary and various bonuses.
Most of the data marts I've designed so far have fallen rather gracefully into a star schema. For this one, however, I have
Here is my first try at ranks, hope you like them!
Thanks!
Drag~
We hear a lot of BI implementations using star schema. (with few dims snowflaked sometimes )
Why not choose a flat table with all data put together instead of a star schema?
(well , this question may seem strange, but please help me out here)
Few
Forums from same category
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
HmongThoobNtiajTeb. com/
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
LEGO Island Discussion, modding, news and more!
Search
See also
Informations
5 Replies For the topic :
"Space savings in Star Vs 3NF"
This topic has been viewed 1491 times.
Last message :
25/03/2010 at 19h11 by "Jeff Smith"
