Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is a cube database, simply an RDBMS—such as PostgreSQL or MySQL—configured for OLAP via a star or snowflake schema? Or is a cube database different from an RDBMS, and if so how?

share|improve this question

3 Answers 3

Simplistic answer: A cube allows you to define dimensions (things you'd need to filter on like Dates, , regions,....), hierarchies (eg months within a year, countries for Continents,...) and measures and rules on how these measures relate with the dimensions... Then you can query values based on that using MDX

More simplistic view?

An RDBMS would be an spreadsheet and a cube a Pivotable...

Hope this helps

share|improve this answer

Cubes are very a different beast from a traditional database. There are several different kinds of cube storage processes depending on need (OLAP, MOLAP, ROLAP, etc.) which are all done differently depending on how real time the data needs to be.

I actually did a webcast with another Microsoft MVP a couple of weeks ago where we talked a little about the BI process and how it impacts the traditional database, which might be interesting to you. The recordings (which are free) aren't available yet, but should be soon.

share|improve this answer

The short answer is no.

  • Generally an OLAP database will precalculate aggregations while an OLTP system will have to do those calculations when it is asked.

  • The language for interacting with cubes is appears similar to SQL but MDX is far different beast.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["                  <li><a href=\"//area51.stackexchange.com\" title=\"proposing new sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"//careers.stackoverflow.com\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2015 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a>                   with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2015.1.28.2238\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Database Administrators Stack Exchange works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class"], "copyright__copyright__copyright": ["e this answer\n\nThe short answer is no.\n\n  \u2022 Generally an OLAP database will precalculate aggregations while an OLTP system will have to do those calculations when it is asked.\n\n  \u2022 The language for interacting with cubes is appears similar to SQL but MDX is far different beast.\n\nshare|improve this answer\n\nYour Answer\n\n\u00a0\ndiscard\n\nBy posting your answer, you agree to the privacy policy and terms of service.\n\nNot the answer you're looking for? Browse other questions tagged or ask your own question."]}