Thread: Is olap possible on postgresql????

Is olap possible on postgresql????

From
Jason Monserrate
Date:
  I'm a student currently working on a postgresql
based project.
  I want to know whether olap technologies are
compatible with postgresql and would like some links
to sites that could give me more info on this subject.
  What is the latest on olap in postgresql????



__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo

Re: Is olap possible on postgresql????

From
Chris Travers
Date:
Last I checked, PostgreSQL supported most of the ANSI-99 OLAP functions
with the following notable exceptions:
1) Table and row constructors
2) CUBE and ROLLUP functions

Of course OLAP merely means that you are doing data mining rather than
transaction processing, so it is more of an approach than a set of
supported technologies.  PostgreSQL handles OLAP *much* better than
MySQL which doesn't even support views....

If you can tell us more about what you need, maybe we can help.

Best Wishes,
Chris Travers
Metatron Technology Consulting

Jason Monserrate wrote:

>  I'm a student currently working on a postgresql
>based project.
>  I want to know whether olap technologies are
>compatible with postgresql and would like some links
>to sites that could give me more info on this subject.
>  What is the latest on olap in postgresql????
>
>
>
>__________________________________
>Do you Yahoo!?
>Take Yahoo! Mail with you! Get it on your mobile phone.
>http://mobile.yahoo.com/maildemo
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>
>
>


Attachment