Question

Are there any performance advantages in using a ROLAP server such as Mondrian on top of a MySQL database, as opposed to simply querying the MySQL database?

在我提出的大多数询问比较简单的情况下,我提出这个问题(例如,在一定时期内发现所有销售),但数据库的规模相当庞大(数千个条目)。

My idea was to use OLAP to speed up queries, but now I m confused as to whether or not this is actually the purpose of this technology, especially in its ROLAP form. While trying the olap4j API, I realized that I can use it to make MDX queries without even having an actual OLAP server (just having a relational database and an OLAP schema for it). How could that be of any use in terms of performance?

增编

Answer 1

这取决于你们如何再使用。

如果你的询问是静态和简单的,那么就不使用法律事务厅。这将增加不必要的间接费用。

另一方面,如果你需要为报告和商业情报进行复杂而详细的互动数据分析,那么,我们就利用一切手段使用法律事务厅。

<><>UPDATE: 如果你需要为我的SQL提供高业绩的法律事务厅,请看

Answer 2

OLAP allows for analysing your data in several dimensions; each dimension possibly (if not always) being a "hierarchy" (i.e., tree). This allows you for going from the big picture (highly aggregated data) to the details when required (drilldown).

In addition, the power of the MDX language and/or calculated measures allows for complex queries quite difficult if not impossible to do in pure SQL.

友情链接