Database reference - Adventure Works DW

MiningStructure - Customer Mining

Mining structure properties

namevalue
nameCustomer Mining  
description 
idCustomer Clusters  
language1033  
collationLatin1_General_CI_AS  
data source view 

Mining models

nameidalgorithmallow drill throughlanguagecollation
Customer Clusters   Customer Clusters   Microsoft_Clustering   true   1033   Latin1_General_CI_AS  
Subcategory Associations   Subcategory Associations   Microsoft_Association_Rules   true   1033   Latin1_General_CI_AS  

Columns

nameidtypedatatypecontentdiscretization methoddiscretization bucket count
Subcategories   Internet Sales   TableMiningStructureColumn          
Customer Counts   Customer   ScalarMiningStructureColumn   Text   Key      
Commute Distance   Commute Distance   ScalarMiningStructureColumn   Text   Discrete      
Education   Education   ScalarMiningStructureColumn   Text   Discrete      
Gender   Gender   ScalarMiningStructureColumn   Text   Discrete      
Home Owner   Home Owner   ScalarMiningStructureColumn   Text   Discrete      
Marital Status   Marital Status   ScalarMiningStructureColumn   Text   Discrete      
Number of Cars Owned   Number of Cars Owned   ScalarMiningStructureColumn   Long   Continuous      
Number of Children At Home   Number of Children At Home   ScalarMiningStructureColumn   Long   Continuous      
Occupation   Occupation   ScalarMiningStructureColumn   Text   Discrete      
Total Children   Total Children   ScalarMiningStructureColumn   Long   Continuous      
Yearly Income   Yearly Income   ScalarMiningStructureColumn   Double   Discretized      

Dependency graph

Adventure WorksAdventure Works DWAdventure Works DWAccountCustomerDateDepartmentDestination CurrencyEmployeeGeographyInternet Sales Order DetailsOrganizationProductPromotionResellerReseller Sales Order DetailsSales ChannelSales ReasonSales Summary Order DetailsSales TerritoryScenarioSource CurrencyAdventure Works DWCustomer MiningCustomer ClustersSubcategory Associations

Objects that Customer Mining depends on

nameobject typelevel
Adventure WorksCube1
Adventure Works DWRelationalDataSource2
Sales Summary Order DetailsDimension2
Destination CurrencyDimension2
Sales ChannelDimension2
Internet Sales Order DetailsDimension2
Reseller Sales Order DetailsDimension2
Sales ReasonDimension2
Source CurrencyDimension2
DateDimension2
AccountDimension2
OrganizationDimension2
DepartmentDimension2
ScenarioDimension2
EmployeeDimension2
Sales TerritoryDimension2
GeographyDimension2
ProductDimension2
PromotionDimension2

Objects that depend on Customer Mining

nameobject typelevel
Customer ClustersMiningModel1
Clustered CustomersDimension2
Mined Customers Clustered CustomersCubeDimension3
Mined Customers Internet CustomersMeasureGroup4
Mined Customers Internet OrdersMeasureGroup4
Mined Customers Internet SalesMeasureGroup4
Subcategory AssociationsMiningModel1
Subcategory Basket AnalysisDimension2
Mined Customers Subcategory Basket AnalysisCubeDimension3

Code

MiningStructure.CustomerMining.xmla



Documentation generated by SqlSpec