Re: Is olap possible on postgresql???? - Mailing list pgsql-general

From Chris Travers
Subject Re: Is olap possible on postgresql????
Date
Msg-id 4113FA34.6000900@metatrontech.com
Whole thread Raw
In response to Is olap possible on postgresql????  (Jason Monserrate <jasonmonserrate@yahoo.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Randy Yates
Date:
Subject: Re: Postgres and Tools Intro?
Next
From: 2004@niederland.com (Roger Niederland)
Date:
Subject: constraint expression