Re: Oracle vs. Microsoft in analysis languages

The approach with SQL Server Data Mining is to provide familiar modeling concepts and APIs so that it's easy for database developers develop solutions and embed data mining.

The DMX language uses standard database paradigms for creating (CREATE MINING MODEL ..), training (INSERT INTO <model>) and querying (SELECT ... FROM <model> PREDICTION JOIN <data>) mining models as standard database objects. In addition, developers can connect to and query models using standard object models like OLE DB, ADO and their .NET/managed counterparts, ADO.NET and ADOMD.NET.

PMML (the XML format for interoperability with other data mining products) is also supported so third-party mining models can be loaded and queried by SQL Server 2005 as well.

Another facet of the API story is the ability for third-party developers to plug in their own data mining algorithms and viewers into SQL Server Data Mining, at the same level as the built-in algorithms and viewers.

You can find a lot of content from the development team, including technical whitepapers, articles and live samples, at our web site: http://www.sqlserverdatamining.com (no marketing info here).

-- 
-Raman Iyer
SQL Server Data Mining
[This posting is provided "AS IS" with no warranties, and confers no 
rights.]

<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.

>