Groups | Blog | Home
all groups > sql server data mining > september 2007 >

sql server data mining : Data mining & CLR UDTs


Efstathios Mantadakis
9/8/2007 9:40:12 PM
Hello,

I would like to ask if it possible to perform data mining on Clr Udt data. If the answer is yes please give me some more information because it is urgent for my project.

Thank you,
Dejan Sarka
9/9/2007 12:00:00 AM
[quoted text, click to view]

I do not think you can use an UDT directly in a mining structure. You can
create a named query in your data source view and refer to UDT properties
and methods that return scalar values from the column of the UDT type, like
SELECT MyUDTcol.Property1, MyUDTcol.Property2...
You can also use the default ToString method, if it returns string that
makes sense for your mining model. If you refer to UDT directly, without an
explicit property, like
SELECT MyUDTcol,
SQL Servr returns binary string (the serialized UDT), and I do not think
SSAS can cast it to UDT, as it does not have access to the code of the UDT.

--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/

AddThis Social Bookmark Button