Oracle vs. Microsoft in analysis languages

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. Received on Mon Dec 19 2005 - 19:47:58 CST