问题描述
我们有一个拥有Oracle Standard 的客户，以及一个使用OLAP可以轻松解决十倍的项目.但是，Oracle仅支持 Enterprise 版本的OLAP.
We have a client that has Oracle Standard, and a project that would be ten times easier addressed using OLAP. However, Oracle only supports OLAP in the Enterprise version.
不能迁移到企业
我正在考虑对OLAP进行一些手动模拟，创建关系表以模拟该技术.
I'm thinking of doing some manual simulation of OLAP, creating relational tables to simulate the technology.
您知道我可以通过其他方式执行此操作吗?也许是OLAP的开源工具?有什么想法吗?
Do you know of some other way I could do this? Maybe an open-source tool for OLAP? Any ideas?
推荐答案
您可以使用指向关系数据库的客户端工具来模拟OLAP功能.
You can simulate OLAP functionality using client side tools pointed at a relational database.
我个人认为，完成这项工作的最佳工具可能是 Tableau Desktop .这是一个非常复杂的前端分析工具，它可以使您的关系数据看起来很多维，而无需付出太多努力，并且该工具本身确实令人不寒而栗.他们有免费试用版，因此您可以试用一下.我们将Tableau大量用于我们自己的分析，并给我们留下了深刻的印象.当然，此工具也可用于多维数据库，因此，如果一天结束时遇到一些多维数据集，则可以继续使用Tableau前端.
Personally I think the best tool for the job is probably Tableau Desktop. This is an amazingly sophisticated front end analytics tool that will make your relational data look multidimensional without much effort, and the tool itself is really mind blowing. They have a free trial so you can take it for a spin. We use Tableau heavily for our own analysis and have been very impressed. Of course, this tool also works with multidimensional databases as well, so if you end up with some cubes at the end of the day you can continue to use the Tableau front end.
对于开源，您可以尝试 Palo -开源MOLAP服务器和Excel前端.
As for open source, you could try out Palo - an open source MOLAP server and Excel front end.
如果您对构建自己的报告前端并使用.NET感兴趣，则可以使用许多组件(例如 DevExpress PivotGrid 或 RadarSoft )中的几种工具同样的事情，但需要一些肘部油脂才能将其连接在一起.
If you are interesting in building your own reporting front end and use .NET there are a number of components (such as the DevExpress PivotGrid or the several tools from RadarSoft) that will do the same thing, but will require some elbow grease to get wired together.
这篇关于模拟OLAP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！