PostgreSQL是否与Oracle的分析相当?

时间:2023-02-15 06:34:08

On another thread I saw a answer to a sql problem using Oracle's analytics. Is there a equivalent in PostgreSQL or generic SQL?

在另一个线程上,我看到了使用Oracle分析的sql问题的答案。在PostgreSQL或通用SQL中是否有等价物?

2 个解决方案

#1


Alas.. and it sounds like they won't be in Postgres 8.4, either. They are under development, though.

唉..而且听起来他们也不会在Postgres 8.4中。不过,他们正在开发中。

Some useful functions can be found in this contrib: http://www.postgresql.org/docs/8.3/static/tablefunc.html (connect_by, crosstab)

在这篇文章中可以找到一些有用的函数:http://www.postgresql.org/docs/8.3/static/tablefunc.html(connect_by,crosstab)

#2


I'm not familiar with Oracle Analytics, but I've worked with Jasper Reports a little and I like it.

我不熟悉Oracle Analytics,但我和Jasper Reports有点合作,我喜欢它。

  • Jasper Reports is a library that you can code against to run reports.
  • Jasper Reports是一个可以编写代码来运行报告的库。

  • Jasper Server lets you host your reports in a web app. It has security and scheduling.
  • Jasper Server允许您在Web应用程序中托管报表。它具有安全性和日程安排。

  • iReport is a GUI designer for Jasper and it can upload reports directly to Jasper Server.
  • iReport是Jasper的GUI设计器,它可以直接将报告上传到Jasper Server。

  • Jasper Analysis is for Analytics.
  • Jasper Analysis适用于Analytics。

More here: http://www.jaspersoft.com/JasperSoft_JasperServer.html

更多信息:http://www.jaspersoft.com/JasperSoft_JasperServer.html

Most of the stuff is free, but there are commercial versions too.

大多数东西都是免费的,但也有商业版本。

#1


Alas.. and it sounds like they won't be in Postgres 8.4, either. They are under development, though.

唉..而且听起来他们也不会在Postgres 8.4中。不过,他们正在开发中。

Some useful functions can be found in this contrib: http://www.postgresql.org/docs/8.3/static/tablefunc.html (connect_by, crosstab)

在这篇文章中可以找到一些有用的函数:http://www.postgresql.org/docs/8.3/static/tablefunc.html(connect_by,crosstab)

#2


I'm not familiar with Oracle Analytics, but I've worked with Jasper Reports a little and I like it.

我不熟悉Oracle Analytics,但我和Jasper Reports有点合作,我喜欢它。

  • Jasper Reports is a library that you can code against to run reports.
  • Jasper Reports是一个可以编写代码来运行报告的库。

  • Jasper Server lets you host your reports in a web app. It has security and scheduling.
  • Jasper Server允许您在Web应用程序中托管报表。它具有安全性和日程安排。

  • iReport is a GUI designer for Jasper and it can upload reports directly to Jasper Server.
  • iReport是Jasper的GUI设计器,它可以直接将报告上传到Jasper Server。

  • Jasper Analysis is for Analytics.
  • Jasper Analysis适用于Analytics。

More here: http://www.jaspersoft.com/JasperSoft_JasperServer.html

更多信息:http://www.jaspersoft.com/JasperSoft_JasperServer.html

Most of the stuff is free, but there are commercial versions too.

大多数东西都是免费的,但也有商业版本。