Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle vs. Microsoft in analysis languages

Re: Oracle vs. Microsoft in analysis languages

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Mon, 19 Dec 2005 17:54:22 -0800
Message-ID: <peydncOOJ95__jrenZ2dnUVZ_sWdnZ2d@comcast.com>

<dino_hsu_1019_at_yahoo.com> wrote in message news:1135043278.477949.191550_at_g14g2000cwa.googlegroups.com...
> This message is cross-posted to 2 groups because of making comparsons.
>
> When I review SQL Server 2005 functions, and get to know languages
> called MDX, DMX, XML/A. MDX is kinda dimenstional version of SQL, which
> Oracle seems to try to include as extension to SQL such as "group by
> rollup", "group by cube", etc., and looks not as powerful as DMX. DMX
> is kinda data mining version of SQL, which I don't know Oracle's
> counterpart, but I heard about the industry standard called DMML, if I
> am correct. XML/A is the protocol between SSAS and it's clients, I am
> not sure whether it's a language people use, but I know the structural
> nature of XML is quite useful for, say, storing metadata kinda things.
> Anyone can make comparison between Oracle and Microsoft on this aspect?
>
> On the other hand, Oracle embraces Java such as in Java stored
> procedure, SQLJ, JDBC, but Microsoft's kinda hate it (such as in that
> you have to download JRE by yourself, no garantee the version will be
> correct). Any comments too?
>
> Thanks in advance.
>

I won't comment on MS's offering because I don't know much about it. My question is what business problem are you trying to solve? Jim Received on Mon Dec 19 2005 - 19:54:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US