Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle vs. Microsoft in analysis languages
<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