Customer.dmm
上传用户:abcs8778
上传日期:2022-08-03
资源大小:2093k
文件大小:14k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

SQL

  1. <MiningStructure xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0" dwd:design-time-name="9c09d192-30b6-4b9a-88c9-951e09c3cfb9" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  2.   <ID>Customer</ID>
  3.   <Name>Customer</Name>
  4.   <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  5.   <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  6.   <Annotations>
  7.     <Annotation>
  8.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CaseTableName</Name>
  9.       <Value>dbo_Customer</Value>
  10.     </Annotation>
  11.     <Annotation>
  12.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
  13.       <Value>true</Value>
  14.     </Annotation>
  15.     <Annotation>
  16.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>
  17.       <Value>
  18.         <dds xmlns="">
  19.           <diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="3" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-4658" scrolltop="-5027" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="8652" y="9366" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="0" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
  20.             <font>
  21.               <ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
  22.             </font>
  23.             <mouseicon>
  24.               <ddsxmlobjectstreamwrapper binary="6c74000000000000" />
  25.             </mouseicon>
  26.           </diagram>
  27.           <layoutmanager>
  28.             <ddsxmlobj />
  29.           </layoutmanager>
  30.           <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Customer (dbo.Customer)" left="-3710" top="-4525" logicalid="2" controlid="1" masterid="0" hint1="0" hint2="0" width="4826" height="6719" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
  31.             <control>
  32.               <ddsxmlobjectstreaminitwrapper binary="00080000da1200003f1a0000" />
  33.             </control>
  34.             <layoutobject>
  35.               <ddsxmlobj>
  36.                 <property name="LogicalObject" value="dbo_Customer" vartype="8" />
  37.               </ddsxmlobj>
  38.             </layoutobject>
  39.             <shape groupshapeid="0" groupnode="0" />
  40.           </ddscontrol>
  41.         </dds>
  42.       </Value>
  43.     </Annotation>
  44.     <Annotation>
  45.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>
  46.       <Value>false</Value>
  47.     </Annotation>
  48.     <Annotation>
  49.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
  50.       <Value>true</Value>
  51.     </Annotation>
  52.     <Annotation>
  53.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
  54.       <Value>-4658</Value>
  55.     </Annotation>
  56.     <Annotation>
  57.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
  58.       <Value>-5027</Value>
  59.     </Annotation>
  60.     <Annotation>
  61.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
  62.       <Value>-3710</Value>
  63.     </Annotation>
  64.     <Annotation>
  65.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
  66.       <Value>-4525</Value>
  67.     </Annotation>
  68.     <Annotation>
  69.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
  70.       <Value>100</Value>
  71.     </Annotation>
  72.   </Annotations>
  73.   <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  74.   <State>Unprocessed</State>
  75.   <Source xsi:type="DataSourceViewBinding" dwd:design-time-name="bcb7db6d-e9d9-481f-8d77-ed0c147a7eeb">
  76.     <DataSourceViewID>Book Sell</DataSourceViewID>
  77.   </Source>
  78.   <Columns>
  79.     <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="0758b9d2-811e-4037-bf1e-a830aabe4af8">
  80.       <ID>Day Consume</ID>
  81.       <Name>DayConsume</Name>
  82.       <Type>Double</Type>
  83.       <Content>Discretized</Content>
  84.       <DiscretizationMethod>Clusters</DiscretizationMethod>
  85.       <DiscretizationBucketCount>3</DiscretizationBucketCount>
  86.       <KeyColumns>
  87.         <KeyColumn dwd:design-time-name="9242dc2b-428d-46a4-b301-c2e2850d7743">
  88.           <DataType>Integer</DataType>
  89.           <DataSize>-1</DataSize>
  90.           <Source xsi:type="ColumnBinding" dwd:design-time-name="9efbb5c9-a3bb-4cc8-98d1-e9230289bc0b">
  91.             <TableID>dbo_Customer</TableID>
  92.             <ColumnID>DayConsume</ColumnID>
  93.           </Source>
  94.         </KeyColumn>
  95.       </KeyColumns>
  96.     </Column>
  97.     <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="808907fc-7466-4a8c-a67b-e8580fbf97a4">
  98.       <ID>ID</ID>
  99.       <Name>ID</Name>
  100.       <IsKey>true</IsKey>
  101.       <Type>Long</Type>
  102.       <Content>Key</Content>
  103.       <KeyColumns>
  104.         <KeyColumn dwd:design-time-name="57dcb31b-d411-4ccf-825c-cd060a6520e6">
  105.           <DataType>Integer</DataType>
  106.           <DataSize>-1</DataSize>
  107.           <Source xsi:type="ColumnBinding" dwd:design-time-name="558fe809-1f53-430c-a861-9f8cd37e4b9e">
  108.             <TableID>dbo_Customer</TableID>
  109.             <ColumnID>ID</ColumnID>
  110.           </Source>
  111.         </KeyColumn>
  112.       </KeyColumns>
  113.     </Column>
  114.     <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="8cf42e14-b3b1-4a53-9335-529e7bb28005">
  115.       <ID>Gender</ID>
  116.       <Name>Gender</Name>
  117.       <Type>Boolean</Type>
  118.       <Content>Discrete</Content>
  119.       <KeyColumns>
  120.         <KeyColumn dwd:design-time-name="758e54a3-b09f-419f-9566-73ac359b4cc1">
  121.           <DataType>Boolean</DataType>
  122.           <DataSize>-1</DataSize>
  123.           <Source xsi:type="ColumnBinding" dwd:design-time-name="6396ba90-3a8e-4dfb-a081-43442659b521">
  124.             <TableID>dbo_Customer</TableID>
  125.             <ColumnID>Gender</ColumnID>
  126.           </Source>
  127.         </KeyColumn>
  128.       </KeyColumns>
  129.     </Column>
  130.     <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="cd741301-804b-4e8f-850b-12039237960a">
  131.       <ID>Area</ID>
  132.       <Name>Area</Name>
  133.       <Type>Text</Type>
  134.       <Content>Discrete</Content>
  135.       <KeyColumns>
  136.         <KeyColumn dwd:design-time-name="cd2bb8ea-1977-4317-9335-c86628627912">
  137.           <DataType>WChar</DataType>
  138.           <DataSize>20</DataSize>
  139.           <Source xsi:type="ColumnBinding" dwd:design-time-name="307c2a03-cc4f-4699-bbac-113aa8a1afc9">
  140.             <TableID>dbo_Customer</TableID>
  141.             <ColumnID>Area</ColumnID>
  142.           </Source>
  143.         </KeyColumn>
  144.       </KeyColumns>
  145.     </Column>
  146.     <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="7aec924d-e3e7-4ead-abdb-81ec72063497">
  147.       <ID>Degree</ID>
  148.       <Name>Degree</Name>
  149.       <Type>Text</Type>
  150.       <Content>Discrete</Content>
  151.       <KeyColumns>
  152.         <KeyColumn dwd:design-time-name="8ac8d60f-4635-43ec-9a7d-3ddf435c243c">
  153.           <DataType>WChar</DataType>
  154.           <DataSize>20</DataSize>
  155.           <Source xsi:type="ColumnBinding" dwd:design-time-name="e62d54e6-3e5b-43bd-ba6b-834812747474">
  156.             <TableID>dbo_Customer</TableID>
  157.             <ColumnID>Degree</ColumnID>
  158.           </Source>
  159.         </KeyColumn>
  160.       </KeyColumns>
  161.     </Column>
  162.     <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="4c7737f2-2298-46a9-b503-0f0ee303065f">
  163.       <ID>Age</ID>
  164.       <Name>Age</Name>
  165.       <Type>Long</Type>
  166.       <Content>Discretized</Content>
  167.       <DiscretizationMethod>EqualAreas</DiscretizationMethod>
  168.       <DiscretizationBucketCount>3</DiscretizationBucketCount>
  169.       <KeyColumns>
  170.         <KeyColumn dwd:design-time-name="9f9bf14f-9c2f-41d4-aba2-ac49ac192d8c">
  171.           <DataType>Integer</DataType>
  172.           <DataSize>-1</DataSize>
  173.           <Source xsi:type="ColumnBinding" dwd:design-time-name="2d17eb05-bc86-40e8-a004-4f19e32eb768">
  174.             <TableID>dbo_Customer</TableID>
  175.             <ColumnID>Age</ColumnID>
  176.           </Source>
  177.         </KeyColumn>
  178.       </KeyColumns>
  179.     </Column>
  180.     <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="83e1f795-0b85-4916-a115-38a0d6d935f9">
  181.       <ID>Levels</ID>
  182.       <Name>Levels</Name>
  183.       <Type>Long</Type>
  184.       <Content>Discrete</Content>
  185.       <KeyColumns>
  186.         <KeyColumn dwd:design-time-name="242d295e-0642-4e28-972b-4d1b60d42448">
  187.           <DataType>SmallInt</DataType>
  188.           <DataSize>-1</DataSize>
  189.           <Source xsi:type="ColumnBinding" dwd:design-time-name="ddb1239f-73b4-46ca-9359-c37c035231e7">
  190.             <TableID>dbo_Customer</TableID>
  191.             <ColumnID>Levels</ColumnID>
  192.           </Source>
  193.         </KeyColumn>
  194.       </KeyColumns>
  195.     </Column>
  196.   </Columns>
  197.   <MiningModels>
  198.     <MiningModel dwd:design-time-name="d3ac7f95-0f38-415d-a3c1-67d43a495a95">
  199.       <ID>Customer</ID>
  200.       <Name>CustomerLevels</Name>
  201.       <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  202.       <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  203.       <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  204.       <State>Unprocessed</State>
  205.       <Algorithm>Microsoft_Naive_Bayes</Algorithm>
  206.       <Columns>
  207.         <Column dwd:design-time-name="75618461-0eb7-4144-8097-aee91490f979">
  208.           <ID>Levels</ID>
  209.           <Name>Levels</Name>
  210.           <SourceColumnID>Levels</SourceColumnID>
  211.           <Usage>PredictOnly</Usage>
  212.         </Column>
  213.         <Column dwd:design-time-name="ddc9e87c-294e-4144-998b-a7132ecc507c">
  214.           <ID>ID</ID>
  215.           <Name>ID</Name>
  216.           <SourceColumnID>ID</SourceColumnID>
  217.           <Usage>Key</Usage>
  218.         </Column>
  219.         <Column dwd:design-time-name="84cd35e6-d6e9-4790-a388-8307d9bfc52e">
  220.           <ID>Gender</ID>
  221.           <Name>Gender</Name>
  222.           <SourceColumnID>Gender</SourceColumnID>
  223.         </Column>
  224.         <Column dwd:design-time-name="938f1976-c277-4401-90b9-cf4fad0774df">
  225.           <ID>Area</ID>
  226.           <Name>Area</Name>
  227.           <SourceColumnID>Area</SourceColumnID>
  228.         </Column>
  229.         <Column dwd:design-time-name="cd1c5c93-754a-4473-b3bd-dae3c5fab395">
  230.           <ID>Degree</ID>
  231.           <Name>Degree</Name>
  232.           <SourceColumnID>Degree</SourceColumnID>
  233.         </Column>
  234.         <Column dwd:design-time-name="d384f38d-ad90-467c-9522-a356d2927911">
  235.           <ID>Age</ID>
  236.           <Name>Age</Name>
  237.           <SourceColumnID>Age</SourceColumnID>
  238.         </Column>
  239.       </Columns>
  240.     </MiningModel>
  241.     <MiningModel dwd:design-time-name="1eb50fb0-b509-4a77-974d-59a36e66ee78">
  242.       <ID>CustomerType</ID>
  243.       <Name>CustomerType</Name>
  244.       <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  245.       <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  246.       <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  247.       <State>Unprocessed</State>
  248.       <Algorithm>Microsoft_Clustering</Algorithm>
  249.       <AlgorithmParameters>
  250.         <AlgorithmParameter>
  251.           <Name>CLUSTER_COUNT</Name>
  252.           <Value xsi:type="xsd:int">5</Value>
  253.         </AlgorithmParameter>
  254.       </AlgorithmParameters>
  255.       <Columns>
  256.         <Column dwd:design-time-name="5804b798-9aa8-4257-9c37-dd5b8d2cdf50">
  257.           <ID>ID</ID>
  258.           <Name>ID</Name>
  259.           <SourceColumnID>ID</SourceColumnID>
  260.           <Usage>Key</Usage>
  261.         </Column>
  262.         <Column dwd:design-time-name="c36109ba-1885-41c9-9164-41f05f8e5608">
  263.           <ID>Degree</ID>
  264.           <Name>Degree</Name>
  265.           <SourceColumnID>Degree</SourceColumnID>
  266.         </Column>
  267.         <Column dwd:design-time-name="6adcff91-cff4-4f71-8309-dda4aa00b5ae">
  268.           <ID>Age</ID>
  269.           <Name>Age</Name>
  270.           <SourceColumnID>Age</SourceColumnID>
  271.         </Column>
  272.         <Column dwd:design-time-name="42cea945-4db4-4ee1-a5c8-5edd0643cf61">
  273.           <ID>DayConsume</ID>
  274.           <Name>DayConsume</Name>
  275.           <SourceColumnID>Day Consume</SourceColumnID>
  276.           <Usage>Predict</Usage>
  277.         </Column>
  278.       </Columns>
  279.     </MiningModel>
  280.     <MiningModel dwd:design-time-name="8f4ab97d-4333-4ad4-893f-9c9d177ac394">
  281.       <ID>CustomerScore</ID>
  282.       <Name>CustomerConsume</Name>
  283.       <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  284.       <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  285.       <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  286.       <State>Unprocessed</State>
  287.       <Algorithm>Microsoft_Decision_Trees</Algorithm>
  288.       <Columns>
  289.         <Column dwd:design-time-name="0b831fdb-725b-4e5c-8fe0-ce96f502004a">
  290.           <ID>ID</ID>
  291.           <Name>ID</Name>
  292.           <SourceColumnID>ID</SourceColumnID>
  293.           <Usage>Key</Usage>
  294.         </Column>
  295.         <Column dwd:design-time-name="26019024-d3e3-47f9-8170-9f7feb7cb8f8">
  296.           <ID>Gender</ID>
  297.           <Name>Gender</Name>
  298.           <SourceColumnID>Gender</SourceColumnID>
  299.         </Column>
  300.         <Column dwd:design-time-name="1b261a9e-eaa8-4c8a-9531-54d68eb3234b">
  301.           <ID>Area</ID>
  302.           <Name>Area</Name>
  303.           <SourceColumnID>Area</SourceColumnID>
  304.         </Column>
  305.         <Column dwd:design-time-name="5759064f-a520-4014-a069-e4f459a66478">
  306.           <ID>Degree</ID>
  307.           <Name>Degree</Name>
  308.           <SourceColumnID>Degree</SourceColumnID>
  309.         </Column>
  310.         <Column dwd:design-time-name="140cc29c-8cd2-488a-b3eb-b473f128efab">
  311.           <ID>Age</ID>
  312.           <Name>Age</Name>
  313.           <SourceColumnID>Age</SourceColumnID>
  314.         </Column>
  315.         <Column dwd:design-time-name="f4a0b6b2-57af-4a14-9174-6762de156bf8">
  316.           <ID>DayConsume</ID>
  317.           <Name>DayConsume</Name>
  318.           <SourceColumnID>Day Consume</SourceColumnID>
  319.           <Usage>PredictOnly</Usage>
  320.         </Column>
  321.       </Columns>
  322.     </MiningModel>
  323.   </MiningModels>
  324. </MiningStructure>