与模式无关的 OLAP 类工具？
是否存在任何（最好是免费或开源的）工具来对关系数据库中的任意表执行 OLAP 分析，而不需要任何维度层次结构、基数或任何其他元信息的预先规范除了表之外什么可以从表本身自动提取？
我无法在 Google 上搜索到我所描述的内容，这让我怀疑自己使用了不正确的术语，并且我正在搜索的内容不适合被视为 OLAP。如果是这种情况，我特别想要的是能够让技术上不熟练的用户使用关系数据库中的表创建交叉表或列联表聚合，而无需编写复杂的 SQL 查询。
或者，换句话说，我想要更大规模地模仿 Excel 数据透视表的东西。我很欣赏，当您创建数据透视表时，Excel 确实会在幕后生成大量缓存，但它不需要用户向其解释需要创建哪些缓存。这是我试图在其他地方找到的功能（如果存在的话）。
Do there exist any (ideally free or open-source) tools for performing OLAP analyses on arbitrary tables in a relational database, without requiring any advance specification of dimensional hierarchies, cardinalities, or any other meta-information about the table beyond what can be extracted automatically from the table itself?
My inability to Google for anything like what I'm describing makes me suspect I'm using incorrect terminology and what I'm searching for isn't properly considered to be OLAP. If this is the case, what I specifically want is anything that would let technically unsophisticated users create cross-tab or contingency table aggregations using tables in a relational DB without needing to write elaborate SQL queries.
Or, in other words, I'd like something that mimics Excel's PivotTables on a larger scale. I appreciate that Excel does indeed generate extensive caches behind the scenes when you make a PivotTable, but it does this without the user having to explain to it which caches need creating. This is the functionality I'm trying to find elsewhere, if it exists.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
icCube 旨在尽可能简单地设置 OLAP 多维数据集。它不是模式不可知的，但我想从现有数据库表定义维度和事实非常简单。然而，这可能并不那么“简单”，具体取决于您的表格 - 如果不了解它们就很难说。我想没有通用的简单解决方案;-)
然后您可以使用 Excel 数据透视表（以及其他）来访问多维数据集。请注意，据我所知，Excel 在连接到多维数据集时既不执行任何缓存也不进行聚合。事实上，它正在生成多维数据集所需的所有 MDX 请求。
希望有帮助。
icCube aims to setup an OLAP cube as simply as possible. It is not schema-agnostic, but I guess this is quite simple to define dimensions and facts from existing DB tables. Nevertheless, this could be not so "simple" depending on your tables - difficult to say without knowledge about them. I guess there's no generic easy solution ;-)
Then you can use Excel pivot table (amongst others) to access the cubes. Note as far as I know Excel does not do any caching neither aggregation when connecting to a cube. Indeed, it is generating all the required MDX requests to the cube.
Hope that helps.
我所知道的最好的选择是 Excel 和 Access，但当然它们不是开源的。这个领域在人们对现在所谓的商业智能的兴趣爆发中受到了践踏，许多公司被微软和其他公司收购。据我所知，现在已经很薄了。不过我会看这个线程。
我认为最有用的范例是电子表格，而且那里不再有太多竞争。 Google 文档电子表格可以导入从数据库导出的 csv 等，并且有一个可用的数据透视图，但仅此而已。
我看到的 OLAP 功能的另一个地方是 Adobe Flex 库，如果您有这方面的兴趣，可以使用 ActionScript 进行构建。和往常一样，Adobe 成功地做到了 90% 左右，但并没有提供完整的产品。
The best options I know of are Excel and Access, but of course they are not open source. This space kinda got trampled in the explosion of interest in what is now called Business Intelligence and a lot of companies got bought by MS and others. It's pretty thin now as far as I can tell. I'll watch this thread though.
The most useful paradigm to attach to is I think spreadsheets and there's not much competition there any more. Google Docs spreadsheets can import csv etc. exported from databases, and there's a pivot chart available, but not much more.
The other place I've seen OLAP capabilities is in the Adobe Flex libraries to build on with ActionScript if you have any inclination in that direction. As usual, Adobe manages to get it about 90% right but doesn't quite provide a whole product.