Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgres for OLAP & data mining

postgres for OLAP & data mining

From
Dario Beraldi
Date:
Hello,

I'm looking for some information (guidelines, docs, tutorials, etc...) about using postgres for OLAP, data mining, data warehousing. The sort of questions I'm trying to answer are on the lines of
- What tools/SQL commands are available?
- How should postgres be configured?
- How suitable is postgres for these tasks (compared to other databases)?

I have done some Google search but I would appreciate any advice/hint from more experienced users.

Many thanks in advance!

Dario

Re: postgres for OLAP & data mining

From
Ovnicraft
Date:


On Fri, Sep 30, 2011 at 9:12 AM, Dario Beraldi <dario.beraldi@gmail.com> wrote:
Hello,

I'm looking for some information (guidelines, docs, tutorials, etc...) about using postgres for OLAP, data mining, data warehousing. The sort of questions I'm trying to answer are on the lines of
- What tools/SQL commands are available?
- How should postgres be configured?
- How suitable is postgres for these tasks (compared to other databases)?

I have done some Google search but I would appreciate any advice/hint from more experienced users.

IMHO what you need is in logic layer software is not in data layer.

Regards, 

Many thanks in advance!

Dario



--
Cristian Salamea
@ovnicraft

Re: postgres for OLAP & data mining

From
Henry Drexler
Date:
Are you looking for stuff like this?

http://www.postgresql.org/docs/9.0/static/functions-string.html

On Fri, Sep 30, 2011 at 10:12 AM, Dario Beraldi <dario.beraldi@gmail.com> wrote:
Hello,

I'm looking for some information (guidelines, docs, tutorials, etc...) about using postgres for OLAP, data mining, data warehousing. The sort of questions I'm trying to answer are on the lines of
- What tools/SQL commands are available?
- How should postgres be configured?
- How suitable is postgres for these tasks (compared to other databases)?

I have done some Google search but I would appreciate any advice/hint from more experienced users.

Many thanks in advance!

Dario

Re: postgres for OLAP & data mining

From
Eduardo Morras
Date:
At 16:12 30/09/2011, Dario Beraldi wrote:
>Hello,
>
>I'm looking for some information (guidelines, docs, tutorials,
>etc...) about using postgres for OLAP, data mining, data
>warehousing. The sort of questions I'm trying to answer are on the lines of
>- What tools/SQL commands are available?
>- How should postgres be configured?
>- How suitable is postgres for these tasks (compared to other databases)?
>
>I have done some Google search but I would appreciate any
>advice/hint from more experienced users.

Check these tutorials:

http://pgexperts.com/document.html?id=49

http://www.pgexperts.com/document.html?id=40

There are more at http://www.pgexperts.com/presentations.html

YOu can check the presentations made on several pgcons and similar events

http://www.pgcon.org/2011/schedule/index.en.html

http://www.postgresopen.org/2011/home/

HTH

Re: postgres for OLAP & data mining

From
Dario Beraldi
Date:
On 30 September 2011 18:41, Henry Drexler <alonup8tb@gmail.com> wrote:
Are you looking for stuff like this?

Thanks for reply. Yes, I knew these functions. In fact, I was rather wondering whether there are dedicated packages for OLAP and some guidelines for configuring postgres (and whether postgres is a good option for OLAP).

Best
Dario

 
On Fri, Sep 30, 2011 at 10:12 AM, Dario Beraldi <dario.beraldi@gmail.com> wrote:
Hello,

I'm looking for some information (guidelines, docs, tutorials, etc...) about using postgres for OLAP, data mining, data warehousing. The sort of questions I'm trying to answer are on the lines of
- What tools/SQL commands are available?
- How should postgres be configured?
- How suitable is postgres for these tasks (compared to other databases)?

I have done some Google search but I would appreciate any advice/hint from more experienced users.

Many thanks in advance!

Dario


Re: postgres for OLAP & data mining

From
Eduardo Morras
Date:
At 16:12 30/09/2011, Dario Beraldi wrote:
>Hello,
>
>I'm looking for some information (guidelines, docs, tutorials,
>etc...) about using postgres for OLAP, data mining, data
>warehousing. The sort of questions I'm trying to answer are on the lines of
>- What tools/SQL commands are available?
>- How should postgres be configured?
>- How suitable is postgres for these tasks (compared to other databases)?
>
>I have done some Google search but I would appreciate any
>advice/hint from more experienced users.

Check these tutorials:

http://pgexperts.com/document.html?id=49

http://www.pgexperts.com/document.html?id=40

There are more at http://www.pgexperts.com/presentations.html

YOu can check the presentations made on several pgcons and similar events

http://www.pgcon.org/2011/schedule/index.en.html

http://www.postgresopen.org/2011/home/

HTH