customerprofitcategory.dmm

来自「< SQL Server2005程序设计>」· DMM 代码 · 共 816 行 · 第 1/3 页

      <Name>Is Car Owner</Name>
      <Type>Text</Type>
      <Content>Discrete</Content>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="cd05db38-c181-4378-9242-80e5bda17b25">
          <DataType>WChar</DataType>
          <DataSize>1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="d525abc5-a04f-497e-8ef3-91feb564f630">
            <TableID>dbo_vCustomerProfitability</TableID>
            <ColumnID>IsCarOwner</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
    </Column>
    <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="4f9d4210-a67b-4b9a-8892-56a4c73c657e">
      <ID>Is Home Owner</ID>
      <Name>Is Home Owner</Name>
      <Type>Text</Type>
      <Content>Discrete</Content>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="5a241be1-9a15-4607-9fc2-addcf9f76729">
          <DataType>WChar</DataType>
          <DataSize>1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="39d050c6-a610-493e-99e4-55f036a12590">
            <TableID>dbo_vCustomerProfitability</TableID>
            <ColumnID>IsHomeOwner</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
    </Column>
    <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="2eb44cb1-9f42-4b81-9e66-351ae0ad0ab7">
      <ID>Is New Customer</ID>
      <Name>Is New Customer</Name>
      <Type>Text</Type>
      <Content>Discrete</Content>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="9a280ee7-3143-458f-bc29-d168d6c184ba">
          <DataType>WChar</DataType>
          <DataSize>1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="9b590274-0876-4f0a-b0d1-b51b68bab061">
            <TableID>dbo_vCustomerProfitability</TableID>
            <ColumnID>IsNewCustomer</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
    </Column>
    <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="ad3ee27f-0b46-4942-b453-f2874e042c9f">
      <ID>Marital Status</ID>
      <Name>Marital Status</Name>
      <Type>Text</Type>
      <Content>Discrete</Content>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="21fe01a6-e196-4a89-8629-6864acef441b">
          <DataType>WChar</DataType>
          <DataSize>1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="387f6b2f-9f42-4188-a011-624260f27483">
            <TableID>dbo_vCustomerProfitability</TableID>
            <ColumnID>MaritalStatus</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
    </Column>
    <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="34b1e821-49e8-438e-9250-7cf022902b2c">
      <ID>Num Prod Group</ID>
      <Name>Num Prod Group</Name>
      <Type>Text</Type>
      <Content>Discrete</Content>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="25e09c6b-c4f3-4afa-a861-28caafd710e3">
          <DataType>WChar</DataType>
          <DataSize>2</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="2dbd22e4-05be-4de0-bb13-ce188847c016">
            <TableID>dbo_vCustomerProfitability</TableID>
            <ColumnID>NumProdGroup</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
    </Column>
    <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="08d8c9fd-c66b-44b9-bad8-de9481d8dee5">
      <ID>Profit Category</ID>
      <Name>Profit Category</Name>
      <Type>Text</Type>
      <Content>Discrete</Content>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="5113b010-2e5a-40d8-832a-757e8f56cfeb">
          <DataType>WChar</DataType>
          <DataSize>4</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="0e6768a2-a110-425e-a3a9-d4f1aae97381">
            <TableID>dbo_vCustomerProfitability</TableID>
            <ColumnID>ProfitCategory</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
    </Column>
    <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="52d00b61-8b28-46fb-aac0-747153869398">
      <ID>Recency Group</ID>
      <Name>Recency Group</Name>
      <Type>Text</Type>
      <Content>Discrete</Content>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="c2b00115-b8a1-40dc-afbd-629be08b2887">
          <DataType>WChar</DataType>
          <DataSize>19</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="d06352ea-2bff-4dcc-b6bc-d170ab8d6503">
            <TableID>dbo_vCustomerProfitability</TableID>
            <ColumnID>RecencyGroup</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
    </Column>
    <Column xsi:type="ScalarMiningStructureColumn" dwd:design-time-name="0e440aa2-eb73-4931-982b-10ab97e7100d">
      <ID>Region</ID>
      <Name>Region</Name>
      <Type>Text</Type>
      <Content>Discrete</Content>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="fc682c82-8bf8-4c9b-9d60-71c9633a028c">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="e9b1511b-6ae1-421e-b514-45152ff6e012">
            <TableID>dbo_vCustomerProfitability</TableID>
            <ColumnID>Region</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
    </Column>
  </Columns>
  <MiningModels>
    <MiningModel dwd:design-time-name="965946a1-9d06-42a7-81f7-cad1f04d4a16">
      <ID>CustomerProfitCategory_CL</ID>
      <Name>CustomerProfitCategory_CL</Name>
      <CreatedTimestamp>0001-01-01T05:00:00Z</CreatedTimestamp>
      <LastSchemaUpdate>0001-01-01T05:00:00Z</LastSchemaUpdate>
      <LastProcessed>0001-01-01T05:00:00Z</LastProcessed>
      <State>Unprocessed</State>
      <Algorithm>Microsoft_Clustering</Algorithm>
      <Columns>
        <Column dwd:design-time-name="b740cbfa-6aad-48f7-a6d0-981f4a56f3e4">
          <ID>Age</ID>
          <Name>Age</Name>
          <SourceColumnID>Age</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="a25d775b-3a78-4813-9753-2a5887c896a9">
          <ID>Commute Distance</ID>
          <Name>Commute Distance</Name>
          <SourceColumnID>Commute Distance</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="02ac2f49-f674-42ce-a6f8-66abd890e6fa">
          <ID>Customer Key</ID>
          <Name>Customer Key</Name>
          <SourceColumnID>Customer Key</SourceColumnID>
          <Usage>Key</Usage>
        </Column>
        <Column dwd:design-time-name="1ef77c5e-4b11-4dcc-9575-a7013b32f20a">
          <ID>English Education</ID>
          <Name>English Education</Name>
          <SourceColumnID>English Education</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="2fcb9600-9595-4d85-ad73-afef16baaee7">
          <ID>Gender</ID>
          <Name>Gender</Name>
          <SourceColumnID>Gender</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="93dafe61-4533-4574-9faa-a0c836478d9c">
          <ID>Has Kids At Home</ID>
          <Name>Has Kids At Home</Name>
          <SourceColumnID>Has Kids At Home</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="6f6524b8-80a5-4825-a246-d2956f9d498a">
          <ID>Income Group</ID>
          <Name>Income Group</Name>
          <SourceColumnID>Income Group</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="dadceee0-b7bf-459f-b721-01984e86c092">
          <ID>Is Car Owner</ID>
          <Name>Is Car Owner</Name>
          <SourceColumnID>Is Car Owner</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="0df36d20-9efa-432a-8927-6e1639dacb03">
          <ID>Is Home Owner</ID>
          <Name>Is Home Owner</Name>
          <SourceColumnID>Is Home Owner</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="d5999b6f-9084-4921-b81d-1ee00c3d735d">
          <ID>Is New Customer</ID>
          <Name>Is New Customer</Name>
          <SourceColumnID>Is New Customer</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="3217c53a-15e6-494b-83af-833085c75b12">
          <ID>Marital Status</ID>
          <Name>Marital Status</Name>
          <SourceColumnID>Marital Status</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="50364b8a-15c3-4edb-8f27-e5ceb1e5f0ca">
          <ID>Num Prod Group</ID>
          <Name>Num Prod Group</Name>
          <SourceColumnID>Num Prod Group</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="52cc522f-70fe-4298-ac77-485a6e4e93d4">
          <ID>Profit Category</ID>
          <Name>Profit Category</Name>
          <SourceColumnID>Profit Category</SourceColumnID>
          <Usage>Predict</Usage>
        </Column>
        <Column dwd:design-time-name="7cf4cf11-9505-4ed7-ba16-7ca3e3bcc2d7">
          <ID>Recency Group</ID>
          <Name>Recency Group</Name>
          <SourceColumnID>Recency Group</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="87fbe20d-1743-4936-9c92-e487912f6780">
          <ID>Region</ID>
          <Name>Region</Name>
          <SourceColumnID>Region</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="ae3f6101-3436-45ea-9b65-8bcb4d3c9d94">
          <ID>v Customer Purchases</ID>
          <Name>v Customer Purchases</Name>
          <SourceColumnID>v Customer Purchases</SourceColumnID>
          <Columns>
            <Column dwd:design-time-name="4a704715-db16-4a8c-a392-afcd166cb295">
              <ID>Product Category</ID>
              <Name>Product Category</Name>
              <SourceColumnID>Product Category</SourceColumnID>
              <Usage>Key</Usage>
            </Column>
          </Columns>
        </Column>
      </Columns>
    </MiningModel>
    <MiningModel dwd:design-time-name="e67eb1d3-8731-4acb-91ce-43ad7e8063dd">
      <ID>CustomerProfitCategory_CL5</ID>
      <Name>CustomerProfitCategory_CL5</Name>
      <CreatedTimestamp>0001-01-01T05:00:00Z</CreatedTimestamp>
      <LastSchemaUpdate>0001-01-01T05:00:00Z</LastSchemaUpdate>
      <LastProcessed>0001-01-01T05: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="6fd23324-168d-4b29-a7e8-e61e123a0528">
          <ID>Age</ID>
          <Name>Age</Name>
          <SourceColumnID>Age</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="59c2887f-8f25-4042-9de1-aa1df6fe0f9e">
          <ID>Commute Distance</ID>
          <Name>Commute Distance</Name>
          <SourceColumnID>Commute Distance</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="369908c4-5f3a-4878-80c9-934af17a7bdb">
          <ID>Customer Key</ID>
          <Name>Customer Key</Name>
          <SourceColumnID>Customer Key</SourceColumnID>
          <Usage>Key</Usage>
        </Column>
        <Column dwd:design-time-name="344dfb67-fc7d-4ba7-b166-cab7b07afb69">
          <ID>English Education</ID>
          <Name>English Education</Name>
          <SourceColumnID>English Education</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="335bc492-dfa1-49fd-969b-3a86402dcce8">
          <ID>Gender</ID>
          <Name>Gender</Name>
          <SourceColumnID>Gender</SourceColumnID>
        </Column>
        <Column dwd:design-time-name="36eff66a-2e8d-4347-b06f-444f21a3d608">
          <ID>Has Kids At Home</ID>