在Cognos BI环境中使用Apache Hadoop [英] Using Apache Hadoop in a Cognos BI environment

问题描述

这可能是一个愚蠢的问题，因为我还没有完全理解Cognos BI的工作原理。
另外，我尝试在Stack Exchange上发布这个帖子，这是徒劳的（与放置标签有关）。

我的问题是 - Apache Hadoop可以用来制作Cognos BI工作更快？
或者Cognos与Hadoop所做的功能相同（MapReduce功能）？

我开始工作的地方使用Cognos BI套件Sybase IQ（内容存储）。 Apache Tomcat是Web服务器。有时候会发生的情况是，如果数据集很大，Cognos会花费很多时间（几乎死亡）来生成报告。

因此，Apache Hadoop可以帮助Cognos更好地运行介于Cognos和Sybase之间？或者是报告优化是这种情况下的唯一出路？

谢谢你们。

Hadoop作为一个平台并不针对临时查询或分析报告。

Cognos是一款IBM产品。它只能查询它自己的Hadoop分布，这就是所谓的大分析：

InfoSphere BigInsights

通过BigInsight Cognos使用Hive发布查询，最终转换为MapReduce。


您说您正在使用Sybase IQ（这不是内容存储库，这是您的查询在运行的报告数据库）。

虽然我不知道关于Sybase IQ，我正在与Vertica合作，这也是列式DB。

为了获得良好的性能，您必须调整任何可能的方法：


$ b

• Cognos框架模型


• Cognos报告


• Sybase数据库调整和结构。
  Hadoop无疑可以通过准确的数据准确度和预先计算所需的计算来提供帮助。
  
  

  This might be a dumb question since I have not yet fully understood how Cognos BI works. Also, I tried posting this on Stack Exchange, in vain (error with putting tags).

  My question is - Can Apache Hadoop be used to make Cognos BI work faster ? Or is Cognos doing the same thing which Hadoop does (MapReduce functionality) ?

  The place where I have started working, uses the Cognos BI suite on top of Sybase IQ (the content store). Apache Tomcat is the web server. What happens sometimes is that Cognos takes a lot of time(almost dies) to generate reports if the data set is large.

  So can Apache Hadoop help Cognos perform better by fitting somewhere between Cognos and Sybase ? Or is report optimization the only way out in this case ?

  Thanks Guys.

  解决方案

  Hadoop as a platform is not aimed for ad-hoc queries or analytic reports.
  Cognos is an IBM product. It can only query it's own distribution of Hadoop, which is called big insights:
  InfoSphere BigInsights
  Over BigInsight Cognos issues queries using Hive, which eventually translate to MapReduce.
  
  You say you are using Sybase IQ (this is not the content store, this is the reporting DB your queries are running on).
  Although I don't know much about Sybase IQ, I am working heavily with Vertica, which is also columnar DB.
  In order to get good performance, you have to tune anything possible:
  

  • Cognos Framework model
  • Cognos reports
  • Sybase DB tuning and structure. Hadoop can certainly help by preparing data in the correct level of granularity and by precalculate any your required calculations.

  这篇关于在Cognos BI环境中使用Apache Hadoop的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！