<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://sqlserver.ro/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Business Intelligence - Data Mining</title><link>http://sqlserver.ro/forums/18/ShowForum.aspx</link><description /><dc:language>en</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>Intrarea romanilor in UE- studii de risc seismic (partea III-a)</title><link>http://sqlserver.ro/forums/thread/1563.aspx</link><pubDate>Mon, 22 Jan 2007 11:26:25 GMT</pubDate><guid isPermaLink="false">963f3a18-65dd-4aad-905c-b785cfe1d7c7:1563</guid><dc:creator>ggciubuc</dc:creator><slash:comments>0</slash:comments><comments>http://sqlserver.ro/forums/thread/1563.aspx</comments><wfw:commentRss>http://sqlserver.ro/forums/commentrss.aspx?SectionID=18&amp;PostID=1563</wfw:commentRss><description>&lt;p class="MsoNormal"&gt;&lt;b&gt;&lt;span style="font-family:Verdana;"&gt;Intrarea romanilor in UE- studii de risc seismic
(partea III-a)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;



&lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&lt;span&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;Asa cum se stie, cel mai drag
algoritm de clasificare implementat este “Microsoft Decision Trees” care , asa
cum arata si denumirea, construieste un arbore in care nodurile sunt atributele
considerate relevante pentru cantitatea de date studiata . Iata in imaginea de
mai jos arborescenta descoperita in cele 716 cladiri cu sau fara bulina din
Bucuresti.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;

&lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&lt;img src="http://sqlserver.ro/photos/snapshots/images/1561/original.aspx" height="217" width="960"&gt;&lt;br&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;



&lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; In fiecare
nod este construita o conditie de splitare adica de spargere a seturilor de
date:&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;

&lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;

&lt;table class="MsoTableGrid" style="border:medium none;border-collapse:collapse;" cellpadding="0" cellspacing="0"&gt;
 &lt;tr&gt;
  &lt;td style="border:1pt solid windowtext;padding:0in 5.4pt;width:0.45in;"&gt;
  &lt;p class="MsoNormal" style="text-align:center;" align="center"&gt;&lt;b&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;Nr.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:solid solid solid none;border-color:windowtext windowtext windowtext -moz-use-text-color;border-width:1pt 1pt 1pt medium;padding:0in 5.4pt;width:135pt;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;b&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;Atribut&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:solid solid solid none;border-color:windowtext windowtext windowtext -moz-use-text-color;border-width:1pt 1pt 1pt medium;padding:0in 5.4pt;width:2.5in;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;b&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;Conditie
  de splitare&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;
  &lt;/td&gt;
 &lt;/tr&gt;
 &lt;tr&gt;
  &lt;td style="border-style:none solid solid;border-color:-moz-use-text-color windowtext windowtext;border-width:medium 1pt 1pt;padding:0in 5.4pt;width:0.45in;"&gt;
  &lt;p class="MsoNormal" style="text-align:center;" align="center"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;1&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:none solid solid none;border-color:-moz-use-text-color windowtext windowtext -moz-use-text-color;border-width:medium 1pt 1pt medium;padding:0in 5.4pt;width:135pt;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;Root&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:none solid solid none;border-color:-moz-use-text-color windowtext windowtext -moz-use-text-color;border-width:medium 1pt 1pt medium;padding:0in 5.4pt;width:2.5in;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
 &lt;/tr&gt;
 &lt;tr&gt;
  &lt;td style="border-style:none solid solid;border-color:-moz-use-text-color windowtext windowtext;border-width:medium 1pt 1pt;padding:0in 5.4pt;width:0.45in;"&gt;
  &lt;p class="MsoNormal" style="text-align:center;" align="center"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;2&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:none solid solid none;border-color:-moz-use-text-color windowtext windowtext -moz-use-text-color;border-width:medium 1pt 1pt medium;padding:0in 5.4pt;width:135pt;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;Expert&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:none solid solid none;border-color:-moz-use-text-color windowtext windowtext -moz-use-text-color;border-width:medium 1pt 1pt medium;padding:0in 5.4pt;width:2.5in;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;Expert=”Primaria”&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
 &lt;/tr&gt;
 &lt;tr&gt;
  &lt;td style="border-style:none solid solid;border-color:-moz-use-text-color windowtext windowtext;border-width:medium 1pt 1pt;padding:0in 5.4pt;width:0.45in;"&gt;
  &lt;p class="MsoNormal" style="text-align:center;" align="center"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;3&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:none solid solid none;border-color:-moz-use-text-color windowtext windowtext -moz-use-text-color;border-width:medium 1pt 1pt medium;padding:0in 5.4pt;width:135pt;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;An
  Constr&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:none solid solid none;border-color:-moz-use-text-color windowtext windowtext -moz-use-text-color;border-width:medium 1pt 1pt medium;padding:0in 5.4pt;width:2.5in;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;Pana in
  1935 si peste 1940&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
 &lt;/tr&gt;
 &lt;tr&gt;
  &lt;td style="border-style:none solid solid;border-color:-moz-use-text-color windowtext windowtext;border-width:medium 1pt 1pt;padding:0in 5.4pt;width:0.45in;"&gt;
  &lt;p class="MsoNormal" style="text-align:center;" align="center"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;4&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:none solid solid none;border-color:-moz-use-text-color windowtext windowtext -moz-use-text-color;border-width:medium 1pt 1pt medium;padding:0in 5.4pt;width:135pt;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;An
  Expertiza&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:none solid solid none;border-color:-moz-use-text-color windowtext windowtext -moz-use-text-color;border-width:medium 1pt 1pt medium;padding:0in 5.4pt;width:2.5in;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;Peste
  1994&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
 &lt;/tr&gt;
 &lt;tr&gt;
  &lt;td style="border-style:none solid solid;border-color:-moz-use-text-color windowtext windowtext;border-width:medium 1pt 1pt;padding:0in 5.4pt;width:0.45in;"&gt;
  &lt;p class="MsoNormal" style="text-align:center;" align="center"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;5&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:none solid solid none;border-color:-moz-use-text-color windowtext windowtext -moz-use-text-color;border-width:medium 1pt 1pt medium;padding:0in 5.4pt;width:135pt;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;Regim
  Inalt&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:none solid solid none;border-color:-moz-use-text-color windowtext windowtext -moz-use-text-color;border-width:medium 1pt 1pt medium;padding:0in 5.4pt;width:2.5in;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;S+P+2E&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
 &lt;/tr&gt;
 &lt;tr&gt;
  &lt;td style="border-style:none solid solid;border-color:-moz-use-text-color windowtext windowtext;border-width:medium 1pt 1pt;padding:0in 5.4pt;width:0.45in;"&gt;
  &lt;p class="MsoNormal" style="text-align:center;" align="center"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;6&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:none solid solid none;border-color:-moz-use-text-color windowtext windowtext -moz-use-text-color;border-width:medium 1pt 1pt medium;padding:0in 5.4pt;width:135pt;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;Regim
  Inalt&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
  &lt;td style="border-style:none solid solid none;border-color:-moz-use-text-color windowtext windowtext -moz-use-text-color;border-width:medium 1pt 1pt medium;padding:0in 5.4pt;width:2.5in;"&gt;
  &lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;S+P+2E+Ma&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;
  &lt;/td&gt;
 &lt;/tr&gt;
&lt;/table&gt;

&lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&lt;span&gt;&amp;nbsp;&lt;/span&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;









&lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Ca sa
vedem mai exact cum s-a ajuns la aceasta configuratie priviti imaginea
construita mai jos, din mai multe&lt;/span&gt;&amp;nbsp;&lt;/p&gt;

&lt;p class="MsoNormal"&gt;&lt;img src="http://sqlserver.ro/photos/snapshots/images/1562/original.aspx"&gt;&lt;br&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Punand
cursorul pe fiecare casuta dreptunghiulara cu valoarea atributului apare o
lista cu numarul de cazuri pentru fiecare valoare a atributului predictibil
Risc, astfel pentru “AnConstr &amp;lt;1935 or AnConstr &amp;gt;=1940” avem 288 cazuri (cladiri)
din care : 231 cu gradul I, 57 I+, 0 II si III , si nu exista cladiri cu risc
neprecizat (missing); mai mult right click pe acelasi nod apoi “Show legend” si
vedem probabilitatea ca o cladire sa aiba gradul I de risc , 77,56%, s.a.m.d;
in imagine apar toate listele de cazuri (in mod normal este afisata doar una
, cea pe care este asezat cursorul mouse-ului). &lt;o:p&gt;&lt;/o:p&gt;&lt;br&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Iata cum
ajuta aceasta configuratie la activitati de predictie date. Sa spunem ca undeva
s-ar descoperi o cladire uitata de primarie si cu probleme de risc seismic, iar
expertiza e facuta de un expert oarecare : daca anul de constructie este 1920
atunci sansa sa fie in gradul I de risc ar fi 77,56 %; mai departe , cum
expertiza este facuta dupa 1994 se intra pe ramura corespunzatoare; sa zicem ca
este S+P+1E atunci sansa sa fie in gradul I de risc este 50,24% s.a.m.d., pana
se ajunge la capatul arborelui la o frunza.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/span&gt;

&lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;Gigi
Ciubuc&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;

&lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;

&lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;

&lt;p class="MsoNormal"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&lt;span&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;

&lt;p class="MsoNormal" style="margin-left:0.25in;"&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;</description></item></channel></rss>