postgresql 我有哪些选项可以使用 Postgres 创建 OLAP 多维数据集并使其可通过 .net webservices/wcf 访问？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4022777/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What options do I have for creating OLAP cubes with Postgres and making it accessible via .net webservices/wcf?
提问by Mr Shoubs
We have a large POSTGRESQL transactional database (around 70 million rows in all), and have previously created a data warehouse from this (updated daily) to run reports off of.
我们有一个大型 POSTGRESQL 事务数据库（总共大约有 7000 万行），并且之前已经从中创建了一个数据仓库（每天更新）来运行报告。
To make this more flexible (as lots of different users require different reports and aren't very good at specifying what they want) we would like to create a multi dimensional OLAP cube and expose this via web services to our customers and possibly outsource report creation.
为了使这更灵活（因为许多不同的用户需要不同的报告并且不太擅长指定他们想要的内容），我们希望创建一个多维 OLAP 多维数据集并通过 Web 服务将其公开给我们的客户，并可能外包报告创建.
We program in .NET (mainly vb.net) and I believe this can be achieved by using XMLA for the webservice (or WCF) layer, but after a bit of research (everything seems propietory - either SSAS and SQL server, or Jasper Server and Jasper Analysis etc), I'm unsure of the following and wondered if anyone else out there has any experience they can share:
我们在 .NET（主要是 vb.net）中编程，我相信这可以通过将 XMLA 用于 webservice（或 WCF）层来实现，但经过一些研究（一切似乎都是专有的 - SSAS 和 SQL 服务器，或 Jasper Server和 Jasper 分析等），我不确定以下内容，并想知道是否有其他人可以分享他们的经验：
- How do (various) front ends integrate with this? - we don't want to tie users to a particular front end.
- what front ends are available?
- What can I use to build the OLAP cube?
- Are there any alternative that I haven't found other than this XMLA approach?
- （各种）前端如何与此集成？- 我们不想将用户绑定到特定的前端。
- 有哪些前端可用？
- 我可以使用什么来构建 OLAP 多维数据集？
- 除了这种 XMLA 方法之外，我还没有找到任何替代方法吗？
Scalability and Performance are huge factors for us, along with quick development time and an interface that is usable by users who only just learned how to use a mouse :p
可扩展性和性能对我们来说是重要的因素，还有快速的开发时间和可供刚学会使用鼠标的用户使用的界面：p
Note: ideally this solution be OpenSource and Free or less than ￡1k (most enterprise solutions are silly money)
注意：理想情况下，此解决方案是开源且免费的或低于 ￡1k（大多数企业解决方案都是傻钱）
采纳答案by Marc Polizzi
We (www.icCube.com) got a customer with similar setup regarding the data (volume and postgres).
我们（www.icCube.com）有一个客户在数据（volume 和 postgres）方面有类似的设置。
Regarding the front-end and access via .Net: we're not specialist (we're from JAVA) but the OLAP driver (actually the same used by Excel) should be ok to access our cube via XMLA (and transparent for your programmers).
关于前端和通过 .Net 访问：我们不是专家（我们来自 JAVA）但是 OLAP 驱动程序（实际上与 Excel 使用的相同）应该可以通过 XMLA 访问我们的多维数据集（并且对您的程序员透明） ）。
We're not free but I guess quite affordable compared to the big names in the BI market.
我们不是免费的，但我想与 BI 市场上的大牌相比，价格相当实惠。
回答by u557022
We came across a similar type of an issue and used Modrian (Pentahoe BI) as the OLAP server. This is free and open source. It should provide you access to the OLAP cube from your VB code since Mondrian is also based on XMLA. Front end, as far as browsing the cube and running live mdx queries are concerned, you will need to come up with some solution (actually we are currently developing and integrating the capability to our own BI tool). But we were successful using Mondrian on a web based solution.
我们遇到了类似的问题，并使用 Modrian (Pentahoe BI) 作为 OLAP 服务器。这是免费和开源的。它应该可以让您从 VB 代码访问 OLAP 多维数据集，因为 Mondrian 也是基于 XMLA 的。前端，就浏览多维数据集和运行实时 mdx 查询而言，您需要提出一些解决方案（实际上我们目前正在开发并将该功能集成到我们自己的 BI 工具中）。但是我们在基于 Web 的解决方案上成功地使用了蒙德里安。
