I have a star-schema with n dimensions and one fact table.
Now I want to calculate the total amount of space is needed to save all the data from the star-schema in a ROLAP-Cube.
Is there like a formula or something?
Asked
Active
Viewed 48 times
0
Hammelkeule
- 197
- 5
- 17
-
You might get close with calculation field length of every column with amount of rows. Add a bit for management and subtract a bit for good table handling. Also, In-Memory engines usually compress the content quite a bit so you might up with a lot less RAM required. – tobi6 Nov 08 '16 at 09:13
-
Sorry maybe I used the wrong vocabulary. I meant the total amount of storage space in a database. – Hammelkeule Nov 08 '16 at 15:03
-
I'd go with the calculation approximation I provided in the first comment. It could be that some compression happens. Why would you need to calculate this? – tobi6 Nov 08 '16 at 15:19