[GENERAL] OLAP

2013-08-27 Thread Alban Hertroys
Hi all, At work we have a system that's built on top of a proprietary OLAP database system (Rocket Gentia). We're looking into replacing that system with something that's still supported and in such a way that we can also access the data from our reporting software (WebFOCUS by information

Re: [GENERAL] OLAP

2013-08-27 Thread Paul Jungwirth
Hi Alban, I think Postgres works great for OLAP work, and Amazon's Red Shift is even based on Postgres. 100 million sales should be not problem at all. My understanding is Greenplum also builds on top of Postgres, so if you ever do outgrow your Postgres installation, that would be an easy

Re: [GENERAL] OLAP

2013-08-27 Thread Alban Hertroys
On Aug 27, 2013, at 19:07, Paul Jungwirth p...@illuminatedcomputing.com wrote: Hi Alban, I think Postgres works great for OLAP work What do you base that on? I don't really doubt that the database layer is up to the task, I'm much more worried about maintaining the model and the cube data

Re: [GENERAL] OLAP

2013-08-27 Thread Jerry Sievers
Alban Hertroys haram...@gmail.com writes: On Aug 27, 2013, at 19:07, Paul Jungwirth p...@illuminatedcomputing.com wrote: Hi Alban, I think Postgres works great for OLAP work What do you base that on? I don't really doubt that the database layer is up to the task, I'm much more

Re: [GENERAL] OLAP

2013-08-27 Thread Pavel Stehule
Dne 28. 8. 2013 0:05 Jerry Sievers gsiever...@comcast.net napsal(a): Alban Hertroys haram...@gmail.com writes: On Aug 27, 2013, at 19:07, Paul Jungwirth p...@illuminatedcomputing.com wrote: Hi Alban, I think Postgres works great for OLAP work What do you base that on? I don't

Re: [GENERAL] OLAP

2013-08-27 Thread Carlos Saritama
according to what you write pentaho best fits your needs On Tue, Aug 27, 2013 at 5:52 PM, Pavel Stehule pavel.steh...@gmail.comwrote: Dne 28. 8. 2013 0:05 Jerry Sievers gsiever...@comcast.net napsal(a): Alban Hertroys haram...@gmail.com writes: On Aug 27, 2013, at 19:07, Paul

Re: [GENERAL] OLAP

2013-08-27 Thread Carlos Saritama
Checkout the Saiku, the future of Open Source Interactive OLAP( http://analytical-labs.com ) On Tue, Aug 27, 2013 at 8:34 PM, Carlos Saritama cssarit...@gmail.comwrote: according to what you write pentaho best fits your needs On Tue, Aug 27, 2013 at 5:52 PM, Pavel Stehule

Re: [GENERAL] OLAP

2013-08-27 Thread Jayadevan
Alban Hertroys-4 wrote How is Pentaho an OLAP tool? Aren't you mixing up a few things? We already use Pentaho for ETL, so I'm a bit familiar with it. Why do you consider it suitable for managing an OLAP database? How would Pentaho manage cube rollup triggers, business models, dimensions and

Re: [GENERAL] OLAP

2013-08-27 Thread bricklen
On Tue, Aug 27, 2013 at 3:04 PM, Jerry Sievers gsiever...@comcast.netwrote: Vertica is another case of an analytics focused platform that dirived from Postgres, version 8.0 IIRC. FWIW, You might be thinking of Greenplum, and I think it forked from pg 8.1. Vertica was built from scratch, it is

[GENERAL] OLAP with PostgreSQL

2005-05-18 Thread Adem HUR
Hi, I am a student and I want to create Multidimensional Data Cubes -OLAP- with PostgreSQL. Is it possible? I have a relational database on PostgreSQL and it contains many records. I want to create an OLAP Cube from the records. And want to drill-down and drill-up operations on this cube. But

Re: [GENERAL] OLAP with PostgreSQL

2005-05-18 Thread Scott Marlowe
On Wed, 2005-05-18 at 12:46, Adem HUR wrote: Hi, I am a student and I want to create Multidimensional Data Cubes -OLAP- with PostgreSQL. Is it possible? I have a relational database on PostgreSQL and it contains many records. I want to create an OLAP Cube from the records. And want to