- <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">
- <ID>Customer</ID>
- <Name>Customer</Name>
- <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
- <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
- <Annotations>
- <Annotation>
- <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CaseTableName</Name>
- <Value>dbo_Customer</Value>
- </Annotation>
- <Annotation>
- <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
- <Value>true</Value>
- </Annotation>
- <Annotation>
- <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>
- <Value>
- <dds xmlns="">
- <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}">
- <font>
- <ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
- </font>
- <mouseicon>
- <ddsxmlobjectstreamwrapper binary="6c74000000000000" />
- </mouseicon>
- </diagram>
- <layoutmanager>
- <ddsxmlobj />
- </layoutmanager>
- <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">
- <control>
- <ddsxmlobjectstreaminitwrapper binary="00080000da1200003f1a0000" />
- </control>
- <layoutobject>
- <ddsxmlobj>
- <property name="LogicalObject" value="dbo_Customer" vartype="8" />
- </ddsxmlobj>
- </layoutobject>
- <shape groupshapeid="0" groupnode="0" />
- </ddscontrol>
- </dds>
- </Value>
- </Annotation>
- <Annotation>
- <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>
- <Value>false</Value>
- </Annotation>
- <Annotation>
- <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
- <Value>true</Value>
- </Annotation>
- <Annotation>
- <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
- <Value>-4658</Value>
- </Annotation>
- <Annotation>
- <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
- <Value>-5027</Value>
- </Annotation>
- <Annotation>
- <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
- <Value>-3710</Value>
- </Annotation>
- <Annotation>
- <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
- <Value>-4525</Value>
- </Annotation>
- <Annotation>
- <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
- <Value>100</Value>
- </Annotation>
- </Annotations>
- <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
- <State>Unprocessed</State>
- <Source xsi:type="DataSourceViewBinding" dwd:design-time-name="bcb7db6d-e9d9-481f-8d77-ed0c147a7eeb">
- <DataSourceViewID>Book Sell</DataSourceViewID>
- </Source>
- <Columns>
- <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="0758b9d2-811e-4037-bf1e-a830aabe4af8">
- <ID>Day Consume</ID>
- <Name>DayConsume</Name>
- <Type>Double</Type>
- <Content>Discretized</Content>
- <DiscretizationMethod>Clusters</DiscretizationMethod>
- <DiscretizationBucketCount>3</DiscretizationBucketCount>
- <KeyColumns>
- <KeyColumn dwd:design-time-name="9242dc2b-428d-46a4-b301-c2e2850d7743">
- <DataType>Integer</DataType>
- <DataSize>-1</DataSize>
- <Source xsi:type="ColumnBinding" dwd:design-time-name="9efbb5c9-a3bb-4cc8-98d1-e9230289bc0b">
- <TableID>dbo_Customer</TableID>
- <ColumnID>DayConsume</ColumnID>
- </Source>
- </KeyColumn>
- </KeyColumns>
- </Column>
- <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="808907fc-7466-4a8c-a67b-e8580fbf97a4">
- <ID>ID</ID>
- <Name>ID</Name>
- <IsKey>true</IsKey>
- <Type>Long</Type>
- <Content>Key</Content>
- <KeyColumns>
- <KeyColumn dwd:design-time-name="57dcb31b-d411-4ccf-825c-cd060a6520e6">
- <DataType>Integer</DataType>
- <DataSize>-1</DataSize>
- <Source xsi:type="ColumnBinding" dwd:design-time-name="558fe809-1f53-430c-a861-9f8cd37e4b9e">
- <TableID>dbo_Customer</TableID>
- <ColumnID>ID</ColumnID>
- </Source>
- </KeyColumn>
- </KeyColumns>
- </Column>
- <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="8cf42e14-b3b1-4a53-9335-529e7bb28005">
- <ID>Gender</ID>
- <Name>Gender</Name>
- <Type>Boolean</Type>
- <Content>Discrete</Content>
- <KeyColumns>
- <KeyColumn dwd:design-time-name="758e54a3-b09f-419f-9566-73ac359b4cc1">
- <DataType>Boolean</DataType>
- <DataSize>-1</DataSize>
- <Source xsi:type="ColumnBinding" dwd:design-time-name="6396ba90-3a8e-4dfb-a081-43442659b521">
- <TableID>dbo_Customer</TableID>
- <ColumnID>Gender</ColumnID>
- </Source>
- </KeyColumn>
- </KeyColumns>
- </Column>
- <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="cd741301-804b-4e8f-850b-12039237960a">
- <ID>Area</ID>
- <Name>Area</Name>
- <Type>Text</Type>
- <Content>Discrete</Content>
- <KeyColumns>
- <KeyColumn dwd:design-time-name="cd2bb8ea-1977-4317-9335-c86628627912">
- <DataType>WChar</DataType>
- <DataSize>20</DataSize>
- <Source xsi:type="ColumnBinding" dwd:design-time-name="307c2a03-cc4f-4699-bbac-113aa8a1afc9">
- <TableID>dbo_Customer</TableID>
- <ColumnID>Area</ColumnID>
- </Source>
- </KeyColumn>
- </KeyColumns>
- </Column>
- <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="7aec924d-e3e7-4ead-abdb-81ec72063497">
- <ID>Degree</ID>
- <Name>Degree</Name>
- <Type>Text</Type>
- <Content>Discrete</Content>
- <KeyColumns>
- <KeyColumn dwd:design-time-name="8ac8d60f-4635-43ec-9a7d-3ddf435c243c">
- <DataType>WChar</DataType>
- <DataSize>20</DataSize>
- <Source xsi:type="ColumnBinding" dwd:design-time-name="e62d54e6-3e5b-43bd-ba6b-834812747474">
- <TableID>dbo_Customer</TableID>
- <ColumnID>Degree</ColumnID>
- </Source>
- </KeyColumn>
- </KeyColumns>
- </Column>
- <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="4c7737f2-2298-46a9-b503-0f0ee303065f">
- <ID>Age</ID>
- <Name>Age</Name>
- <Type>Long</Type>
- <Content>Discretized</Content>
- <DiscretizationMethod>EqualAreas</DiscretizationMethod>
- <DiscretizationBucketCount>3</DiscretizationBucketCount>
- <KeyColumns>
- <KeyColumn dwd:design-time-name="9f9bf14f-9c2f-41d4-aba2-ac49ac192d8c">
- <DataType>Integer</DataType>
- <DataSize>-1</DataSize>
- <Source xsi:type="ColumnBinding" dwd:design-time-name="2d17eb05-bc86-40e8-a004-4f19e32eb768">
- <TableID>dbo_Customer</TableID>
- <ColumnID>Age</ColumnID>
- </Source>
- </KeyColumn>
- </KeyColumns>
- </Column>
- <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="83e1f795-0b85-4916-a115-38a0d6d935f9">
- <ID>Levels</ID>
- <Name>Levels</Name>
- <Type>Long</Type>
- <Content>Discrete</Content>
- <KeyColumns>
- <KeyColumn dwd:design-time-name="242d295e-0642-4e28-972b-4d1b60d42448">
- <DataType>SmallInt</DataType>
- <DataSize>-1</DataSize>
- <Source xsi:type="ColumnBinding" dwd:design-time-name="ddb1239f-73b4-46ca-9359-c37c035231e7">
- <TableID>dbo_Customer</TableID>
- <ColumnID>Levels</ColumnID>
- </Source>
- </KeyColumn>
- </KeyColumns>
- </Column>
- </Columns>
- <MiningModels>
- <MiningModel dwd:design-time-name="d3ac7f95-0f38-415d-a3c1-67d43a495a95">
- <ID>Customer</ID>
- <Name>CustomerLevels</Name>
- <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
- <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
- <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
- <State>Unprocessed</State>
- <Algorithm>Microsoft_Naive_Bayes</Algorithm>
- <Columns>
- <Column dwd:design-time-name="75618461-0eb7-4144-8097-aee91490f979">
- <ID>Levels</ID>
- <Name>Levels</Name>
- <SourceColumnID>Levels</SourceColumnID>
- <Usage>PredictOnly</Usage>
- </Column>
- <Column dwd:design-time-name="ddc9e87c-294e-4144-998b-a7132ecc507c">
- <ID>ID</ID>
- <Name>ID</Name>
- <SourceColumnID>ID</SourceColumnID>
- <Usage>Key</Usage>
- </Column>
- <Column dwd:design-time-name="84cd35e6-d6e9-4790-a388-8307d9bfc52e">
- <ID>Gender</ID>
- <Name>Gender</Name>
- <SourceColumnID>Gender</SourceColumnID>
- </Column>
- <Column dwd:design-time-name="938f1976-c277-4401-90b9-cf4fad0774df">
- <ID>Area</ID>
- <Name>Area</Name>
- <SourceColumnID>Area</SourceColumnID>
- </Column>
- <Column dwd:design-time-name="cd1c5c93-754a-4473-b3bd-dae3c5fab395">
- <ID>Degree</ID>
- <Name>Degree</Name>
- <SourceColumnID>Degree</SourceColumnID>
- </Column>
- <Column dwd:design-time-name="d384f38d-ad90-467c-9522-a356d2927911">
- <ID>Age</ID>
- <Name>Age</Name>
- <SourceColumnID>Age</SourceColumnID>
- </Column>
- </Columns>
- </MiningModel>
- <MiningModel dwd:design-time-name="1eb50fb0-b509-4a77-974d-59a36e66ee78">
- <ID>CustomerType</ID>
- <Name>CustomerType</Name>
- <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
- <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
- <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
- <State>Unprocessed</State>
- <Algorithm>Microsoft_Clustering</Algorithm>
- <AlgorithmParameters>
- <AlgorithmParameter>
- <Name>CLUSTER_COUNT</Name>
- <Value xsi:type="xsd:int">5</Value>
- </AlgorithmParameter>
- </AlgorithmParameters>
- <Columns>
- <Column dwd:design-time-name="5804b798-9aa8-4257-9c37-dd5b8d2cdf50">
- <ID>ID</ID>
- <Name>ID</Name>
- <SourceColumnID>ID</SourceColumnID>
- <Usage>Key</Usage>
- </Column>
- <Column dwd:design-time-name="c36109ba-1885-41c9-9164-41f05f8e5608">
- <ID>Degree</ID>
- <Name>Degree</Name>
- <SourceColumnID>Degree</SourceColumnID>
- </Column>
- <Column dwd:design-time-name="6adcff91-cff4-4f71-8309-dda4aa00b5ae">
- <ID>Age</ID>
- <Name>Age</Name>
- <SourceColumnID>Age</SourceColumnID>
- </Column>
- <Column dwd:design-time-name="42cea945-4db4-4ee1-a5c8-5edd0643cf61">
- <ID>DayConsume</ID>
- <Name>DayConsume</Name>
- <SourceColumnID>Day Consume</SourceColumnID>
- <Usage>Predict</Usage>
- </Column>
- </Columns>
- </MiningModel>
- <MiningModel dwd:design-time-name="8f4ab97d-4333-4ad4-893f-9c9d177ac394">
- <ID>CustomerScore</ID>
- <Name>CustomerConsume</Name>
- <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
- <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
- <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
- <State>Unprocessed</State>
- <Algorithm>Microsoft_Decision_Trees</Algorithm>
- <Columns>
- <Column dwd:design-time-name="0b831fdb-725b-4e5c-8fe0-ce96f502004a">
- <ID>ID</ID>
- <Name>ID</Name>
- <SourceColumnID>ID</SourceColumnID>
- <Usage>Key</Usage>
- </Column>
- <Column dwd:design-time-name="26019024-d3e3-47f9-8170-9f7feb7cb8f8">
- <ID>Gender</ID>
- <Name>Gender</Name>
- <SourceColumnID>Gender</SourceColumnID>
- </Column>
- <Column dwd:design-time-name="1b261a9e-eaa8-4c8a-9531-54d68eb3234b">
- <ID>Area</ID>
- <Name>Area</Name>
- <SourceColumnID>Area</SourceColumnID>
- </Column>
- <Column dwd:design-time-name="5759064f-a520-4014-a069-e4f459a66478">
- <ID>Degree</ID>
- <Name>Degree</Name>
- <SourceColumnID>Degree</SourceColumnID>
- </Column>
- <Column dwd:design-time-name="140cc29c-8cd2-488a-b3eb-b473f128efab">
- <ID>Age</ID>
- <Name>Age</Name>
- <SourceColumnID>Age</SourceColumnID>
- </Column>
- <Column dwd:design-time-name="f4a0b6b2-57af-4a14-9174-6762de156bf8">
- <ID>DayConsume</ID>
- <Name>DayConsume</Name>
- <SourceColumnID>Day Consume</SourceColumnID>
- <Usage>PredictOnly</Usage>
- </Column>
- </Columns>
- </MiningModel>
- </MiningModels>
- </MiningStructure>