Re: Oracle and Postgresql

From: Blazej <bl(dot)oleszkiewicz(at)gmail(dot)com>
To: Artacus <artacus(at)comcast(dot)net>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Oracle and Postgresql
Date: 2008-11-10 04:30:47
Message-ID: 819df3760811092030p45d5ea5bq21759cff1a9b342e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-www

There is some my publications about SART AML System, where is more
detailed described all this things (and more) that I wrote below.

http://www.analyticsql.org/documentation.html

Regards,
Blazej Oleszkiewicz

2008/9/4 Blazej <bl(dot)oleszkiewicz(at)gmail(dot)com>:
> Hi Artacus
>
> 2008/9/4 Artacus <artacus(at)comcast(dot)net>:
>> Oh, as I was writing a CUBE query today and realized that I forgot to
>> mention this. And unlike most gripes, like MERGE INTO or CTE's which are
>> really convenience things, this is key piece of functionality that you just
>> can't reproduce in Postgres.
>>
>
> It is not true. First look at this:
> http://www.analyticsql.org/
>
> In atachment is two snapshots from production system (Analytic SQL
> Server based on PostgreSQL 8.3):
>
> Picture: non_uniform_dimension.JPG
>
> Heterogeneous data warehouse dimensions where each class of dimension:
> Chart of Account (PK), Synthetic Account (KS), Analytical Account (KA)
> may have a heterogeneous structure of the hierarchy (~60 000 items in
> hierarchy, max depth 9).
>
> For example, on picture marked heterogeneity of the hierarchy:
> -- Green: [PK, KS "operations involving cash and interbank
> operations," KS "Kasa," KS "Cash / banknotes and coins /" KA "Cash in
> hand GBP"]
> -- Red: [PK, KS "operations involving cash and interbank operations,"
> KS "Kasa," KS "bankers' cheques," KS "foreign bankers' cheques," KS
> "bankers' cheques, foreign currency," KA "bankers' cheques in USD "]
>
> Hence, we can see that both hierarchical structure:
> -- [PK, KS, KS, KS, KA] for a KA "Cash in hand GBP (ID: 339 in column KNT_ID);
> -- [PK, KS, KS, KS, KS, KS, KA] for a KA "foreign bankers' cheques in
> U.S. dollars" (ID: 363 in column KNT_ID)
>
> are different from each other in terms of the structure of the hierarchy.
>
> Picture:olap_raport_non_uniform_dimension.JPG - example of OLAP raport
> based on Chart of Account.
>
> so it is much more then "OLAP" ORACLE extensions like CUBE etc.
>
> Regards,
> Blazej Oleszkiewicz
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message dbalinglung 2008-11-10 05:06:04 Re: Get interval in months
Previous Message Blazej 2008-11-10 04:24:03 Re: Chart of Accounts

Browse pgsql-www by date

  From Date Subject
Next Message Guillaume Lelarge 2008-11-10 09:31:46 "latest" still points to "8.3.4"
Previous Message Simon Riggs 2008-11-06 23:10:11 Re: [sysadmins] new mailing list procedure