Re: Is olap possible on postgresql????

From: Chris Travers <chris(at)metatrontech(dot)com>
To: Jason Monserrate <jasonmonserrate(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is olap possible on postgresql????
Date: 2004-08-06 21:37:56
Message-ID: 4113FA34.6000900@metatrontech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
chris.vcf text/x-vcard 127 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-06 22:57:30 Re: probelm migrating from 7.3.4 to 7.42
Previous Message Marc G. Fournier 2004-08-06 21:19:03 Re: replication