Postgres Pro
Downloads
Home   >   mailing lists

Thread: Data cube in PostgreSQL

Data cube in PostgreSQL

From
Gowrishankar
Date:
Hi All,

I want to implement data cube operator in PostGReSQL. I searched few
forums and found that I only can have interface to postgresql using
EFEU package which allows basic cube operations.

Is there any other way of extending postgresql to include cubes?

thanks
Gowrishankar

Re: Data cube in PostgreSQL

From
Dimitri Fontaine
Date:
Hi,

Le Wednesday 26 September 2007 20:58:38 Gowrishankar, vous avez écrit :
> Is there any other way of extending postgresql to include cubes?

Something like the cube contrib?
  http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/

Contribs are part of PostgreSQL sources and maintained as such, but not
included into the 'core' project. They are certainly distributed along with
PostgreSQL in your packaging system of choice.

Regards,
--
dim

Data cube in PostgreSQL

From
"Gowrishankar L"
Date:
Hi All,

I need to make certain changes to cube.c file  which comes with cube contrib ( http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/). I am not sure how to compile it so that I can use those changes in postgresql. Could you help me?

Thanks
Gowrishankar L


On 10/19/07, Gowrishankar L < gowrishankar83@gmail.com> wrote:
Hi,

I am using cube contrib from   http://developer. postgresql.org/cvsweb.cgi/pgsql/contrib/cube/

I am able to use most of the functions like cube_distance,cube_contains etc. I am facing a problem when passing an argument to these functions which are table columns.

For example :

 select cube_distance('(0)','(1)');

 cube_distance
---------------
             1
(1 row)

works fine.

But

select cube_distance('(0)',(select a from temp));

ERROR:  function cube_distance("unknown", integer) does not exist
HINT:  No function matches the given name and argument types. You may need to add explicit type casts.

I am not sure what to typecast to. Could you please help me correct this error.

Thanks
Gowrishankar L


On 10/1/07, Dimitri Fontaine < dfontaine@hi-media.com> wrote:
Hi,

Le Wednesday 26 September 2007 20:58:38 Gowrishankar, vous avez écrit:
> Is there any other way of extending postgresql to include cubes?

Something like the cube contrib?
   http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/

Contribs are part of PostgreSQL sources and maintained as such, but not
included into the 'core' project. They are certainly distributed along with
PostgreSQL in your packaging system of choice.

Regards,
--
dim


Re: Data cube in PostgreSQL

From
Richard Huxton
Date:
Gowrishankar L wrote:
> Hi All,
>
> I need to make certain changes to cube.c file  which comes with cube contrib
> ( http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/). I am not
> sure how to compile it so that I can use those changes in postgresql. Could
> you help me?

Well, the full procedure would be:

1. Download source package of postgresql, untar somewhere, cd to top
directory
2. ./configure <with options>; make; make install <as root>
3. cd contrib/cube; make; make install <as root>
4. start/restart the server
5. Run any .sql scripts you need to in your target database (see
README.cube)

If you're making changes you might well be restarting PG frequently, so
you might want to script that.

Does that help?

--
   Richard Huxton
   Archonet Ltd

Re: Data cube in PostgreSQL

From
"Filip Rembiałkowski"
Date:
I see a misunderstanding here.

cube contrib is for handling geometrical  data.

EFEU package is OLAP - related, that's entirely different topic.
http://www.informit.com/articles/article.aspx?p=24684



2007/10/1, Dimitri Fontaine <dfontaine@hi-media.com>:
> Hi,
>
> Le Wednesday 26 September 2007 20:58:38 Gowrishankar, vous avez écrit:
> > Is there any other way of extending postgresql to include cubes?
>
> Something like the cube contrib?
>   http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/
>
> Contribs are part of PostgreSQL sources and maintained as such, but not
> included into the 'core' project. They are certainly distributed along with
> PostgreSQL in your packaging system of choice.
>
> Regards,
> --
> dim
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


--
Filip Rembiałkowski