Finally got a chance to try essbase out on real data volumes. Building half-a-billion facts cube turned out into something like this:
PS: I have very special attitude to David Lynch’s films. A physical one. Just the sight of road running away at “Lost Highway” makes me creepy. It takes me about 5 seconds to identify [...]
I’ve made this simple web-based closed cube drawing tool to explain what closed cubes are and how they’re good in removing redundant aggregates from storage. I’ve wrote this for myself initially to get better insights on different aggregate situations and thought somebody might get interested as well.
Go check it out, if you’re interested in how [...]
New digest:
1 This blog changed hosting once more. Now it’s ultra speed webfaction instead of Yahoo.
Speed, ssh, svn are main switch reasons
2 I’ve started a more light-weighted blog in russian ykud.ru (who’d guess).
3 And I’m thinking about this blog’s future. I’ve got only one post laying in drafts (it’s called “Testing in EP”) and [...]
An excellent Kimball’s article.
Finished Analytics&OLAP in SQL by Joe Celko today. A very “blog-style” book, some very good ideas, some repeats (read “Trees&Hierarchies in SQL” previously), sarcasm and a set of good examples. Not a starter-book, but a recommended reading for anyone interested in data analysis.
“Tape-based” approach and Von Neumann logic still dominate IT. SQL is bad [...]
Powered by FireStats