开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Internet/网络编程 > WEB源码(ASP,PHP,...) > 查看源码
BookSellAnalysis.asdatabase
资源名称：BookSellAnalysis.rar　[点击查看]
上传用户：abcs8778
上传日期：2022-08-03
资源大小：2093k
文件大小：85k
源码类别：

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

开发平台：

SQL

BookSellAnalysis.asdatabase：源码内容
  1. <Database 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="http://schemas.microsoft.com/analysisservices/2003/engine">
  2.   <ID>BookSellAnalysis</ID>
  3.   <Name>BookSellAnalysis</Name>
  4.   <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  5.   <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  6.   <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  7.   <State>Unprocessed</State>
  8.   <LastUpdate>0001-01-01T00:00:00Z</LastUpdate>
  9.   <DataSourceImpersonationInfo>
  10.     <ImpersonationMode>Default</ImpersonationMode>
  11.     <ImpersonationInfoSecurity>Unchanged</ImpersonationInfoSecurity>
  12.   </DataSourceImpersonationInfo>
  13.   <MiningStructures>
  14.     <MiningStructure>
  15.       <ID>Customer</ID>
  16.       <Name>Customer</Name>
  17.       <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  18.       <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  19.       <Annotations>
  20.         <Annotation>
  21.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CaseTableName</Name>
  22.           <Value>dbo_Customer</Value>
  23.         </Annotation>
  24.         <Annotation>
  25.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
  26.           <Value>true</Value>
  27.         </Annotation>
  28.         <Annotation>
  29.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>
  30.           <Value>
  31.             <dds xmlns="">
  32.               <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}">
  33.                 <font>
  34.                   <ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
  35.                 </font>
  36.                 <mouseicon>
  37.                   <ddsxmlobjectstreamwrapper binary="6c74000000000000" />
  38.                 </mouseicon>
  39.               </diagram>
  40.               <layoutmanager>
  41.                 <ddsxmlobj />
  42.               </layoutmanager>
  43.               <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">
  44.                 <control>
  45.                   <ddsxmlobjectstreaminitwrapper binary="00080000da1200003f1a0000" />
  46.                 </control>
  47.                 <layoutobject>
  48.                   <ddsxmlobj>
  49.                     <property name="LogicalObject" value="dbo_Customer" vartype="8" />
  50.                   </ddsxmlobj>
  51.                 </layoutobject>
  52.                 <shape groupshapeid="0" groupnode="0" />
  53.               </ddscontrol>
  54.             </dds>
  55.           </Value>
  56.         </Annotation>
  57.         <Annotation>
  58.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>
  59.           <Value>false</Value>
  60.         </Annotation>
  61.         <Annotation>
  62.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
  63.           <Value>true</Value>
  64.         </Annotation>
  65.         <Annotation>
  66.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
  67.           <Value>-4658</Value>
  68.         </Annotation>
  69.         <Annotation>
  70.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
  71.           <Value>-5027</Value>
  72.         </Annotation>
  73.         <Annotation>
  74.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
  75.           <Value>-3710</Value>
  76.         </Annotation>
  77.         <Annotation>
  78.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
  79.           <Value>-4525</Value>
  80.         </Annotation>
  81.         <Annotation>
  82.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
  83.           <Value>100</Value>
  84.         </Annotation>
  85.       </Annotations>
  86.       <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  87.       <State>Unprocessed</State>
  88.       <Source xsi:type="DataSourceViewBinding">
  89.         <DataSourceViewID>Book Sell</DataSourceViewID>
  90.       </Source>
  91.       <Columns>
  92.         <Column xsi:type="ScalarMiningStructureColumn">
  93.           <ID>Day Consume</ID>
  94.           <Name>DayConsume</Name>
  95.           <Type>Double</Type>
  96.           <Content>Discretized</Content>
  97.           <DiscretizationMethod>Clusters</DiscretizationMethod>
  98.           <DiscretizationBucketCount>3</DiscretizationBucketCount>
  99.           <KeyColumns>
  100.             <KeyColumn>
  101.               <DataType>Integer</DataType>
  102.               <DataSize>-1</DataSize>
  103.               <Source xsi:type="ColumnBinding">
  104.                 <TableID>dbo_Customer</TableID>
  105.                 <ColumnID>DayConsume</ColumnID>
  106.               </Source>
  107.             </KeyColumn>
  108.           </KeyColumns>
  109.         </Column>
  110.         <Column xsi:type="ScalarMiningStructureColumn">
  111.           <ID>ID</ID>
  112.           <Name>ID</Name>
  113.           <IsKey>true</IsKey>
  114.           <Type>Long</Type>
  115.           <Content>Key</Content>
  116.           <KeyColumns>
  117.             <KeyColumn>
  118.               <DataType>Integer</DataType>
  119.               <DataSize>-1</DataSize>
  120.               <Source xsi:type="ColumnBinding">
  121.                 <TableID>dbo_Customer</TableID>
  122.                 <ColumnID>ID</ColumnID>
  123.               </Source>
  124.             </KeyColumn>
  125.           </KeyColumns>
  126.         </Column>
  127.         <Column xsi:type="ScalarMiningStructureColumn">
  128.           <ID>Gender</ID>
  129.           <Name>Gender</Name>
  130.           <Type>Boolean</Type>
  131.           <Content>Discrete</Content>
  132.           <KeyColumns>
  133.             <KeyColumn>
  134.               <DataType>Boolean</DataType>
  135.               <DataSize>-1</DataSize>
  136.               <Source xsi:type="ColumnBinding">
  137.                 <TableID>dbo_Customer</TableID>
  138.                 <ColumnID>Gender</ColumnID>
  139.               </Source>
  140.             </KeyColumn>
  141.           </KeyColumns>
  142.         </Column>
  143.         <Column xsi:type="ScalarMiningStructureColumn">
  144.           <ID>Area</ID>
  145.           <Name>Area</Name>
  146.           <Type>Text</Type>
  147.           <Content>Discrete</Content>
  148.           <KeyColumns>
  149.             <KeyColumn>
  150.               <DataType>WChar</DataType>
  151.               <DataSize>20</DataSize>
  152.               <Source xsi:type="ColumnBinding">
  153.                 <TableID>dbo_Customer</TableID>
  154.                 <ColumnID>Area</ColumnID>
  155.               </Source>
  156.             </KeyColumn>
  157.           </KeyColumns>
  158.         </Column>
  159.         <Column xsi:type="ScalarMiningStructureColumn">
  160.           <ID>Degree</ID>
  161.           <Name>Degree</Name>
  162.           <Type>Text</Type>
  163.           <Content>Discrete</Content>
  164.           <KeyColumns>
  165.             <KeyColumn>
  166.               <DataType>WChar</DataType>
  167.               <DataSize>20</DataSize>
  168.               <Source xsi:type="ColumnBinding">
  169.                 <TableID>dbo_Customer</TableID>
  170.                 <ColumnID>Degree</ColumnID>
  171.               </Source>
  172.             </KeyColumn>
  173.           </KeyColumns>
  174.         </Column>
  175.         <Column xsi:type="ScalarMiningStructureColumn">
  176.           <ID>Age</ID>
  177.           <Name>Age</Name>
  178.           <Type>Long</Type>
  179.           <Content>Discretized</Content>
  180.           <DiscretizationMethod>EqualAreas</DiscretizationMethod>
  181.           <DiscretizationBucketCount>3</DiscretizationBucketCount>
  182.           <KeyColumns>
  183.             <KeyColumn>
  184.               <DataType>Integer</DataType>
  185.               <DataSize>-1</DataSize>
  186.               <Source xsi:type="ColumnBinding">
  187.                 <TableID>dbo_Customer</TableID>
  188.                 <ColumnID>Age</ColumnID>
  189.               </Source>
  190.             </KeyColumn>
  191.           </KeyColumns>
  192.         </Column>
  193.         <Column xsi:type="ScalarMiningStructureColumn">
  194.           <ID>Levels</ID>
  195.           <Name>Levels</Name>
  196.           <Type>Long</Type>
  197.           <Content>Discrete</Content>
  198.           <KeyColumns>
  199.             <KeyColumn>
  200.               <DataType>SmallInt</DataType>
  201.               <DataSize>-1</DataSize>
  202.               <Source xsi:type="ColumnBinding">
  203.                 <TableID>dbo_Customer</TableID>
  204.                 <ColumnID>Levels</ColumnID>
  205.               </Source>
  206.             </KeyColumn>
  207.           </KeyColumns>
  208.         </Column>
  209.       </Columns>
  210.       <MiningModels>
  211.         <MiningModel>
  212.           <ID>Customer</ID>
  213.           <Name>CustomerLevels</Name>
  214.           <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  215.           <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  216.           <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  217.           <State>Unprocessed</State>
  218.           <Algorithm>Microsoft_Naive_Bayes</Algorithm>
  219.           <Columns>
  220.             <Column>
  221.               <ID>Levels</ID>
  222.               <Name>Levels</Name>
  223.               <SourceColumnID>Levels</SourceColumnID>
  224.               <Usage>PredictOnly</Usage>
  225.             </Column>
  226.             <Column>
  227.               <ID>ID</ID>
  228.               <Name>ID</Name>
  229.               <SourceColumnID>ID</SourceColumnID>
  230.               <Usage>Key</Usage>
  231.             </Column>
  232.             <Column>
  233.               <ID>Gender</ID>
  234.               <Name>Gender</Name>
  235.               <SourceColumnID>Gender</SourceColumnID>
  236.             </Column>
  237.             <Column>
  238.               <ID>Area</ID>
  239.               <Name>Area</Name>
  240.               <SourceColumnID>Area</SourceColumnID>
  241.             </Column>
  242.             <Column>
  243.               <ID>Degree</ID>
  244.               <Name>Degree</Name>
  245.               <SourceColumnID>Degree</SourceColumnID>
  246.             </Column>
  247.             <Column>
  248.               <ID>Age</ID>
  249.               <Name>Age</Name>
  250.               <SourceColumnID>Age</SourceColumnID>
  251.             </Column>
  252.           </Columns>
  253.         </MiningModel>
  254.         <MiningModel>
  255.           <ID>CustomerType</ID>
  256.           <Name>CustomerType</Name>
  257.           <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  258.           <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  259.           <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  260.           <State>Unprocessed</State>
  261.           <Algorithm>Microsoft_Clustering</Algorithm>
  262.           <AlgorithmParameters>
  263.             <AlgorithmParameter>
  264.               <Name>CLUSTER_COUNT</Name>
  265.               <Value xsi:type="xsd:int">5</Value>
  266.             </AlgorithmParameter>
  267.           </AlgorithmParameters>
  268.           <Columns>
  269.             <Column>
  270.               <ID>ID</ID>
  271.               <Name>ID</Name>
  272.               <SourceColumnID>ID</SourceColumnID>
  273.               <Usage>Key</Usage>
  274.             </Column>
  275.             <Column>
  276.               <ID>Degree</ID>
  277.               <Name>Degree</Name>
  278.               <SourceColumnID>Degree</SourceColumnID>
  279.             </Column>
  280.             <Column>
  281.               <ID>Age</ID>
  282.               <Name>Age</Name>
  283.               <SourceColumnID>Age</SourceColumnID>
  284.             </Column>
  285.             <Column>
  286.               <ID>DayConsume</ID>
  287.               <Name>DayConsume</Name>
  288.               <SourceColumnID>Day Consume</SourceColumnID>
  289.               <Usage>Predict</Usage>
  290.             </Column>
  291.           </Columns>
  292.         </MiningModel>
  293.         <MiningModel>
  294.           <ID>CustomerScore</ID>
  295.           <Name>CustomerConsume</Name>
  296.           <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  297.           <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  298.           <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  299.           <State>Unprocessed</State>
  300.           <Algorithm>Microsoft_Decision_Trees</Algorithm>
  301.           <Columns>
  302.             <Column>
  303.               <ID>ID</ID>
  304.               <Name>ID</Name>
  305.               <SourceColumnID>ID</SourceColumnID>
  306.               <Usage>Key</Usage>
  307.             </Column>
  308.             <Column>
  309.               <ID>Gender</ID>
  310.               <Name>Gender</Name>
  311.               <SourceColumnID>Gender</SourceColumnID>
  312.             </Column>
  313.             <Column>
  314.               <ID>Area</ID>
  315.               <Name>Area</Name>
  316.               <SourceColumnID>Area</SourceColumnID>
  317.             </Column>
  318.             <Column>
  319.               <ID>Degree</ID>
  320.               <Name>Degree</Name>
  321.               <SourceColumnID>Degree</SourceColumnID>
  322.             </Column>
  323.             <Column>
  324.               <ID>Age</ID>
  325.               <Name>Age</Name>
  326.               <SourceColumnID>Age</SourceColumnID>
  327.             </Column>
  328.             <Column>
  329.               <ID>DayConsume</ID>
  330.               <Name>DayConsume</Name>
  331.               <SourceColumnID>Day Consume</SourceColumnID>
  332.               <Usage>PredictOnly</Usage>
  333.             </Column>
  334.           </Columns>
  335.         </MiningModel>
  336.       </MiningModels>
  337.     </MiningStructure>
  338.     <MiningStructure>
  339.       <ID>CustomerBooks</ID>
  340.       <Name>CustomerBooks</Name>
  341.       <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  342.       <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  343.       <Annotations>
  344.         <Annotation>
  345.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CaseTableName</Name>
  346.           <Value>dbo_Customer</Value>
  347.         </Annotation>
  348.         <Annotation>
  349.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
  350.           <Value>true</Value>
  351.         </Annotation>
  352.         <Annotation>
  353.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>
  354.           <Value>
  355.             <dds xmlns="">
  356.               <diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="8" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-4658" scrolltop="-1327" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="12356" y="15055" 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}">
  357.                 <font>
  358.                   <ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
  359.                 </font>
  360.                 <mouseicon>
  361.                   <ddsxmlobjectstreamwrapper binary="6c74000000000000" />
  362.                 </mouseicon>
  363.               </diagram>
  364.               <layoutmanager>
  365.                 <ddsxmlobj />
  366.               </layoutmanager>
  367.               <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="V_BookSell (dbo.V_BookSell)" left="20" top="7400" logicalid="4" controlid="1" masterid="0" hint1="0" hint2="0" width="3000" height="5000" 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">
  368.                 <control>
  369.                   <ddsxmlobjectstreaminitwrapper binary="00080000b80b000088130000" />
  370.                 </control>
  371.                 <layoutobject>
  372.                   <ddsxmlobj>
  373.                     <property name="LogicalObject" value="dbo_V_BookSell" vartype="8" />
  374.                   </ddsxmlobj>
  375.                 </layoutobject>
  376.                 <shape groupshapeid="0" groupnode="0" />
  377.               </ddscontrol>
  378.               <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Customer (dbo.Customer)" left="20" top="0" logicalid="5" controlid="2" masterid="0" hint1="0" hint2="0" width="3000" height="5000" 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">
  379.                 <control>
  380.                   <ddsxmlobjectstreaminitwrapper binary="00080000b80b000088130000" />
  381.                 </control>
  382.                 <layoutobject>
  383.                   <ddsxmlobj>
  384.                     <property name="LogicalObject" value="dbo_Customer" vartype="8" />
  385.                   </ddsxmlobj>
  386.                 </layoutobject>
  387.                 <shape groupshapeid="0" groupnode="0" />
  388.               </ddscontrol>
  389.               <ddscontrol controlprogid="MSDDS.Polyline" left="1121" top="4501" logicalid="6" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="3199" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
  390.                 <control>
  391.                   <ddsxmlobj>
  392.                     <polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
  393.                   </ddsxmlobj>
  394.                 </control>
  395.                 <layoutobject>
  396.                   <ddsxmlobj>
  397.                     <property name="LogicalObject" value="dataSet.Relations[V_BookSell-Customer]" vartype="8" />
  398.                     <property name="Virtual" value="0" vartype="11" />
  399.                     <property name="VisibleAP" value="0" vartype="3" />
  400.                   </ddsxmlobj>
  401.                 </layoutobject>
  402.                 <connector lineroutestyle="MSDDS.Rectilinear" sourceid="2" destid="1" sourceattachpoint="5" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">
  403.                   <point x="1520" y="5000" />
  404.                   <point x="1520" y="7400" />
  405.                 </connector>
  406.               </ddscontrol>
  407.             </dds>
  408.           </Value>
  409.         </Annotation>
  410.         <Annotation>
  411.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>
  412.           <Value>false</Value>
  413.         </Annotation>
  414.         <Annotation>
  415.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
  416.           <Value>true</Value>
  417.         </Annotation>
  418.         <Annotation>
  419.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
  420.           <Value>-4658</Value>
  421.         </Annotation>
  422.         <Annotation>
  423.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
  424.           <Value>-1327</Value>
  425.         </Annotation>
  426.         <Annotation>
  427.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
  428.           <Value>20</Value>
  429.         </Annotation>
  430.         <Annotation>
  431.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
  432.           <Value>0</Value>
  433.         </Annotation>
  434.         <Annotation>
  435.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
  436.           <Value>100</Value>
  437.         </Annotation>
  438.       </Annotations>
  439.       <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  440.       <State>Unprocessed</State>
  441.       <Source xsi:type="DataSourceViewBinding">
  442.         <DataSourceViewID>Book Sell</DataSourceViewID>
  443.       </Source>
  444.       <Columns>
  445.         <Column xsi:type="ScalarMiningStructureColumn">
  446.           <ID>Age</ID>
  447.           <Name>Age</Name>
  448.           <Type>Long</Type>
  449.           <Content>Discretized</Content>
  450.           <DiscretizationMethod>EqualAreas</DiscretizationMethod>
  451.           <DiscretizationBucketCount>3</DiscretizationBucketCount>
  452.           <KeyColumns>
  453.             <KeyColumn>
  454.               <DataType>Integer</DataType>
  455.               <DataSize>-1</DataSize>
  456.               <Source xsi:type="ColumnBinding">
  457.                 <TableID>dbo_Customer</TableID>
  458.                 <ColumnID>Age</ColumnID>
  459.               </Source>
  460.             </KeyColumn>
  461.           </KeyColumns>
  462.         </Column>
  463.         <Column xsi:type="ScalarMiningStructureColumn">
  464.           <ID>Gender</ID>
  465.           <Name>Gender</Name>
  466.           <Type>Boolean</Type>
  467.           <Content>Discrete</Content>
  468.           <KeyColumns>
  469.             <KeyColumn>
  470.               <DataType>Boolean</DataType>
  471.               <DataSize>-1</DataSize>
  472.               <Source xsi:type="ColumnBinding">
  473.                 <TableID>dbo_Customer</TableID>
  474.                 <ColumnID>Gender</ColumnID>
  475.               </Source>
  476.             </KeyColumn>
  477.           </KeyColumns>
  478.         </Column>
  479.         <Column xsi:type="ScalarMiningStructureColumn">
  480.           <ID>Area</ID>
  481.           <Name>Area</Name>
  482.           <Type>Text</Type>
  483.           <Content>Discrete</Content>
  484.           <KeyColumns>
  485.             <KeyColumn>
  486.               <DataType>WChar</DataType>
  487.               <DataSize>20</DataSize>
  488.               <Source xsi:type="ColumnBinding">
  489.                 <TableID>dbo_Customer</TableID>
  490.                 <ColumnID>Area</ColumnID>
  491.               </Source>
  492.             </KeyColumn>
  493.           </KeyColumns>
  494.         </Column>
  495.         <Column xsi:type="ScalarMiningStructureColumn">
  496.           <ID>Degree</ID>
  497.           <Name>Degree</Name>
  498.           <Type>Text</Type>
  499.           <Content>Discrete</Content>
  500.           <KeyColumns>
  501.             <KeyColumn>
  502.               <DataType>WChar</DataType>
  503.               <DataSize>20</DataSize>
  504.               <Source xsi:type="ColumnBinding">
  505.                 <TableID>dbo_Customer</TableID>
  506.                 <ColumnID>Degree</ColumnID>
  507.               </Source>
  508.             </KeyColumn>
  509.           </KeyColumns>
  510.         </Column>
  511.         <Column xsi:type="ScalarMiningStructureColumn">
  512.           <ID>ID</ID>
  513.           <Name>ID</Name>
  514.           <IsKey>true</IsKey>
  515.           <Type>Long</Type>
  516.           <Content>Key</Content>
  517.           <KeyColumns>
  518.             <KeyColumn>
  519.               <DataType>Integer</DataType>
  520.               <DataSize>-1</DataSize>
  521.               <Source xsi:type="ColumnBinding">
  522.                 <TableID>dbo_Customer</TableID>
  523.                 <ColumnID>ID</ColumnID>
  524.               </Source>
  525.             </KeyColumn>
  526.           </KeyColumns>
  527.         </Column>
  528.         <Column xsi:type="TableMiningStructureColumn">
  529.           <Annotations>
  530.             <Annotation>
  531.               <Name>MDXFilterComponent</Name>
  532.             </Annotation>
  533.           </Annotations>
  534.           <ID>V Book Sell</ID>
  535.           <Name>BookSell</Name>
  536.           <ForeignKeyColumns>
  537.             <ForeignKeyColumn>
  538.               <DataType>Integer</DataType>
  539.               <DataSize>-1</DataSize>
  540.               <Source xsi:type="ColumnBinding">
  541.                 <TableID>dbo_V_BookSell</TableID>
  542.                 <ColumnID>CustomerID</ColumnID>
  543.               </Source>
  544.             </ForeignKeyColumn>
  545.           </ForeignKeyColumns>
  546.           <Columns>
  547.             <Column xsi:type="ScalarMiningStructureColumn">
  548.               <ID>Name</ID>
  549.               <Name>Name</Name>
  550.               <IsKey>true</IsKey>
  551.               <Type>Text</Type>
  552.               <Content>Key</Content>
  553.               <KeyColumns>
  554.                 <KeyColumn>
  555.                   <DataType>WChar</DataType>
  556.                   <DataSize>256</DataSize>
  557.                   <Source xsi:type="ColumnBinding">
  558.                     <TableID>dbo_V_BookSell</TableID>
  559.                     <ColumnID>Name</ColumnID>
  560.                   </Source>
  561.                 </KeyColumn>
  562.               </KeyColumns>
  563.             </Column>
  564.           </Columns>
  565.         </Column>
  566.       </Columns>
  567.       <MiningModels>
  568.         <MiningModel>
  569.           <ID>CustomerBooks</ID>
  570.           <Name>CustomerBooks</Name>
  571.           <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  572.           <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  573.           <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  574.           <State>Unprocessed</State>
  575.           <Algorithm>Microsoft_Association_Rules</Algorithm>
  576.           <Columns>
  577.             <Column>
  578.               <ID>Age</ID>
  579.               <Name>Age</Name>
  580.               <SourceColumnID>Age</SourceColumnID>
  581.             </Column>
  582.             <Column>
  583.               <ID>Gender</ID>
  584.               <Name>Gender</Name>
  585.               <SourceColumnID>Gender</SourceColumnID>
  586.             </Column>
  587.             <Column>
  588.               <ID>Area</ID>
  589.               <Name>Area</Name>
  590.               <SourceColumnID>Area</SourceColumnID>
  591.             </Column>
  592.             <Column>
  593.               <ID>Degree</ID>
  594.               <Name>Degree</Name>
  595.               <SourceColumnID>Degree</SourceColumnID>
  596.             </Column>
  597.             <Column>
  598.               <ID>ID</ID>
  599.               <Name>ID</Name>
  600.               <SourceColumnID>ID</SourceColumnID>
  601.               <Usage>Key</Usage>
  602.             </Column>
  603.             <Column>
  604.               <ID>V Book Sell</ID>
  605.               <Name>BookSell</Name>
  606.               <SourceColumnID>V Book Sell</SourceColumnID>
  607.               <Usage>Predict</Usage>
  608.               <Columns>
  609.                 <Column>
  610.                   <ID>Name</ID>
  611.                   <Name>Name</Name>
  612.                   <SourceColumnID>Name</SourceColumnID>
  613.                   <Usage>Key</Usage>
  614.                 </Column>
  615.               </Columns>
  616.             </Column>
  617.           </Columns>
  618.           <AllowDrillThrough>true</AllowDrillThrough>
  619.         </MiningModel>
  620.       </MiningModels>
  621.     </MiningStructure>
  622.     <MiningStructure>
  623.       <ID>BookPrice</ID>
  624.       <Name>BookPrice</Name>
  625.       <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  626.       <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  627.       <Annotations>
  628.         <Annotation>
  629.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CaseTableName</Name>
  630.           <Value>dbo_V_Book</Value>
  631.         </Annotation>
  632.         <Annotation>
  633.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
  634.           <Value>true</Value>
  635.         </Annotation>
  636.         <Annotation>
  637.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>
  638.         </Annotation>
  639.         <Annotation>
  640.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>
  641.           <Value>false</Value>
  642.         </Annotation>
  643.         <Annotation>
  644.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
  645.           <Value>true</Value>
  646.         </Annotation>
  647.         <Annotation>
  648.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
  649.           <Value>0</Value>
  650.         </Annotation>
  651.         <Annotation>
  652.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
  653.           <Value>0</Value>
  654.         </Annotation>
  655.         <Annotation>
  656.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
  657.           <Value>0</Value>
  658.         </Annotation>
  659.         <Annotation>
  660.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
  661.           <Value>0</Value>
  662.         </Annotation>
  663.         <Annotation>
  664.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
  665.           <Value>100</Value>
  666.         </Annotation>
  667.       </Annotations>
  668.       <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  669.       <State>Unprocessed</State>
  670.       <Source xsi:type="DataSourceViewBinding">
  671.         <DataSourceViewID>Book Sell</DataSourceViewID>
  672.       </Source>
  673.       <Columns>
  674.         <Column xsi:type="ScalarMiningStructureColumn">
  675.           <ID>ID</ID>
  676.           <Name>ID</Name>
  677.           <IsKey>true</IsKey>
  678.           <Type>Long</Type>
  679.           <Content>Key</Content>
  680.           <KeyColumns>
  681.             <KeyColumn>
  682.               <DataType>Integer</DataType>
  683.               <DataSize>-1</DataSize>
  684.               <Source xsi:type="ColumnBinding">
  685.                 <TableID>dbo_V_Book</TableID>
  686.                 <ColumnID>ID</ColumnID>
  687.               </Source>
  688.             </KeyColumn>
  689.           </KeyColumns>
  690.         </Column>
  691.         <Column xsi:type="ScalarMiningStructureColumn">
  692.           <ID>Pages</ID>
  693.           <Name>Pages</Name>
  694.           <Type>Long</Type>
  695.           <Content>Continuous</Content>
  696.           <KeyColumns>
  697.             <KeyColumn>
  698.               <DataType>SmallInt</DataType>
  699.               <DataSize>-1</DataSize>
  700.               <Source xsi:type="ColumnBinding">
  701.                 <TableID>dbo_V_Book</TableID>
  702.                 <ColumnID>Pages</ColumnID>
  703.               </Source>
  704.             </KeyColumn>
  705.           </KeyColumns>
  706.         </Column>
  707.         <Column xsi:type="ScalarMiningStructureColumn">
  708.           <ID>Price</ID>
  709.           <Name>Price</Name>
  710.           <Type>Double</Type>
  711.           <Content>Continuous</Content>
  712.           <KeyColumns>
  713.             <KeyColumn>
  714.               <DataType>Double</DataType>
  715.               <DataSize>-1</DataSize>
  716.               <Source xsi:type="ColumnBinding">
  717.                 <TableID>dbo_V_Book</TableID>
  718.                 <ColumnID>Price</ColumnID>
  719.               </Source>
  720.             </KeyColumn>
  721.           </KeyColumns>
  722.         </Column>
  723.       </Columns>
  724.       <MiningModels>
  725.         <MiningModel>
  726.           <ID>BookPrice</ID>
  727.           <Name>BookPrice</Name>
  728.           <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  729.           <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  730.           <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  731.           <State>Unprocessed</State>
  732.           <Algorithm>Microsoft_Linear_Regression</Algorithm>
  733.           <Columns>
  734.             <Column>
  735.               <ID>ID</ID>
  736.               <Name>ID</Name>
  737.               <SourceColumnID>ID</SourceColumnID>
  738.               <Usage>Key</Usage>
  739.             </Column>
  740.             <Column>
  741.               <ID>Pages</ID>
  742.               <Name>Pages</Name>
  743.               <SourceColumnID>Pages</SourceColumnID>
  744.               <ModelingFlags>
  745.                 <ModelingFlag>REGRESSOR</ModelingFlag>
  746.               </ModelingFlags>
  747.             </Column>
  748.             <Column>
  749.               <ID>Price</ID>
  750.               <Name>Price</Name>
  751.               <SourceColumnID>Price</SourceColumnID>
  752.               <Usage>PredictOnly</Usage>
  753.               <ModelingFlags>
  754.                 <ModelingFlag>REGRESSOR</ModelingFlag>
  755.               </ModelingFlags>
  756.             </Column>
  757.           </Columns>
  758.           <AllowDrillThrough>true</AllowDrillThrough>
  759.         </MiningModel>
  760.       </MiningModels>
  761.     </MiningStructure>
  762.     <MiningStructure>
  763.       <ID>WeekSell</ID>
  764.       <Name>WeekSell</Name>
  765.       <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  766.       <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  767.       <Annotations>
  768.         <Annotation>
  769.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CaseTableName</Name>
  770.           <Value>dbo_V_WeekSell</Value>
  771.         </Annotation>
  772.         <Annotation>
  773.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
  774.           <Value>true</Value>
  775.         </Annotation>
  776.         <Annotation>
  777.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>
  778.           <Value>
  779.             <dds xmlns="">
  780.               <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="-6376" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="11853" y="15055" 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}">
  781.                 <font>
  782.                   <ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
  783.                 </font>
  784.                 <mouseicon>
  785.                   <ddsxmlobjectstreamwrapper binary="6c74000000000000" />
  786.                 </mouseicon>
  787.               </diagram>
  788.               <layoutmanager>
  789.                 <ddsxmlobj />
  790.               </layoutmanager>
  791.               <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="V_WeekSell (dbo.V_WeekSell)" left="-3684" top="-5953" logicalid="2" controlid="1" masterid="0" hint1="0" hint2="0" width="3000" height="2302" 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">
  792.                 <control>
  793.                   <ddsxmlobjectstreaminitwrapper binary="00080000b80b0000fe080000" />
  794.                 </control>
  795.                 <layoutobject>
  796.                   <ddsxmlobj>
  797.                     <property name="LogicalObject" value="dbo_V_WeekSell" vartype="8" />
  798.                   </ddsxmlobj>
  799.                 </layoutobject>
  800.                 <shape groupshapeid="0" groupnode="0" />
  801.               </ddscontrol>
  802.             </dds>
  803.           </Value>
  804.         </Annotation>
  805.         <Annotation>
  806.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>
  807.           <Value>false</Value>
  808.         </Annotation>
  809.         <Annotation>
  810.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
  811.           <Value>true</Value>
  812.         </Annotation>
  813.         <Annotation>
  814.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
  815.           <Value>-4658</Value>
  816.         </Annotation>
  817.         <Annotation>
  818.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
  819.           <Value>-6376</Value>
  820.         </Annotation>
  821.         <Annotation>
  822.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
  823.           <Value>-3684</Value>
  824.         </Annotation>
  825.         <Annotation>
  826.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
  827.           <Value>-5953</Value>
  828.         </Annotation>
  829.         <Annotation>
  830.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
  831.           <Value>100</Value>
  832.         </Annotation>
  833.       </Annotations>
  834.       <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  835.       <State>Unprocessed</State>
  836.       <Source xsi:type="DataSourceViewBinding">
  837.         <DataSourceViewID>Book Sell</DataSourceViewID>
  838.       </Source>
  839.       <Columns>
  840.         <Column xsi:type="ScalarMiningStructureColumn">
  841.           <ID>ID</ID>
  842.           <Name>ID</Name>
  843.           <IsKey>true</IsKey>
  844.           <Type>Long</Type>
  845.           <Content>Key</Content>
  846.           <KeyColumns>
  847.             <KeyColumn>
  848.               <DataType>Integer</DataType>
  849.               <DataSize>-1</DataSize>
  850.               <Source xsi:type="ColumnBinding">
  851.                 <TableID>dbo_V_WeekSell</TableID>
  852.                 <ColumnID>ID</ColumnID>
  853.               </Source>
  854.             </KeyColumn>
  855.           </KeyColumns>
  856.         </Column>
  857.         <Column xsi:type="ScalarMiningStructureColumn">
  858.           <ID>Sell Sum</ID>
  859.           <Name>SellSum</Name>
  860.           <Type>Double</Type>
  861.           <Content>Continuous</Content>
  862.           <KeyColumns>
  863.             <KeyColumn>
  864.               <DataType>Double</DataType>
  865.               <DataSize>-1</DataSize>
  866.               <Source xsi:type="ColumnBinding">
  867.                 <TableID>dbo_V_WeekSell</TableID>
  868.                 <ColumnID>SellSum</ColumnID>
  869.               </Source>
  870.             </KeyColumn>
  871.           </KeyColumns>
  872.         </Column>
  873.         <Column xsi:type="ScalarMiningStructureColumn">
  874.           <ID>Week</ID>
  875.           <Name>Week</Name>
  876.           <IsKey>true</IsKey>
  877.           <Type>Long</Type>
  878.           <Content>Key Time</Content>
  879.           <KeyColumns>
  880.             <KeyColumn>
  881.               <DataType>Integer</DataType>
  882.               <DataSize>-1</DataSize>
  883.               <Source xsi:type="ColumnBinding">
  884.                 <TableID>dbo_V_WeekSell</TableID>
  885.                 <ColumnID>Week</ColumnID>
  886.               </Source>
  887.             </KeyColumn>
  888.           </KeyColumns>
  889.         </Column>
  890.       </Columns>
  891.       <MiningModels>
  892.         <MiningModel>
  893.           <ID>WeekSell</ID>
  894.           <Name>WeekSell</Name>
  895.           <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  896.           <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  897.           <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  898.           <State>Unprocessed</State>
  899.           <Algorithm>Microsoft_Time_Series</Algorithm>
  900.           <AlgorithmParameters>
  901.             <AlgorithmParameter>
  902.               <Name>MINIMUM_SERIES_VALUE</Name>
  903.               <Value xsi:type="xsd:double">0</Value>
  904.             </AlgorithmParameter>
  905.             <AlgorithmParameter>
  906.               <Name>MISSING_VALUE_SUBSTITUTION</Name>
  907.               <Value xsi:type="xsd:string">0</Value>
  908.             </AlgorithmParameter>
  909.           </AlgorithmParameters>
  910.           <Columns>
  911.             <Column>
  912.               <ID>ID</ID>
  913.               <Name>ID</Name>
  914.               <SourceColumnID>ID</SourceColumnID>
  915.               <Usage>Key</Usage>
  916.             </Column>
  917.             <Column>
  918.               <ID>Sell Sum</ID>
  919.               <Name>SellSum</Name>
  920.               <SourceColumnID>Sell Sum</SourceColumnID>
  921.               <Usage>Predict</Usage>
  922.               <ModelingFlags>
  923.                 <ModelingFlag>REGRESSOR</ModelingFlag>
  924.               </ModelingFlags>
  925.             </Column>
  926.             <Column>
  927.               <ID>Week</ID>
  928.               <Name>Week</Name>
  929.               <SourceColumnID>Week</SourceColumnID>
  930.               <Usage>Key</Usage>
  931.             </Column>
  932.           </Columns>
  933.           <AllowDrillThrough>true</AllowDrillThrough>
  934.         </MiningModel>
  935.       </MiningModels>
  936.     </MiningStructure>
  937.     <MiningStructure>
  938.       <ID>Book</ID>
  939.       <Name>Book</Name>
  940.       <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  941.       <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  942.       <Annotations>
  943.         <Annotation>
  944.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CaseTableName</Name>
  945.           <Value>dbo_V_Book</Value>
  946.         </Annotation>
  947.         <Annotation>
  948.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
  949.           <Value>true</Value>
  950.         </Annotation>
  951.         <Annotation>
  952.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>
  953.           <Value>
  954.             <dds xmlns="">
  955.               <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="-4597" scrolltop="-5027" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="12488" y="15055" 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}">
  956.                 <font>
  957.                   <ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
  958.                 </font>
  959.                 <mouseicon>
  960.                   <ddsxmlobjectstreamwrapper binary="6c74000000000000" />
  961.                 </mouseicon>
  962.               </diagram>
  963.               <layoutmanager>
  964.                 <ddsxmlobj />
  965.               </layoutmanager>
  966.               <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="V_Book (dbo.V_Book)" left="-3446" top="-4498" logicalid="2" controlid="1" masterid="0" hint1="0" hint2="0" width="3122" height="6296" 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">
  967.                 <control>
  968.                   <ddsxmlobjectstreaminitwrapper binary="00080000320c000098180000" />
  969.                 </control>
  970.                 <layoutobject>
  971.                   <ddsxmlobj>
  972.                     <property name="LogicalObject" value="dbo_V_Book" vartype="8" />
  973.                   </ddsxmlobj>
  974.                 </layoutobject>
  975.                 <shape groupshapeid="0" groupnode="0" />
  976.               </ddscontrol>
  977.             </dds>
  978.           </Value>
  979.         </Annotation>
  980.         <Annotation>
  981.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>
  982.           <Value>false</Value>
  983.         </Annotation>
  984.         <Annotation>
  985.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
  986.           <Value>true</Value>
  987.         </Annotation>
  988.         <Annotation>
  989.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
  990.           <Value>-4597</Value>
  991.         </Annotation>
  992.         <Annotation>
  993.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
  994.           <Value>-5027</Value>
  995.         </Annotation>
  996.         <Annotation>
  997.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
  998.           <Value>-3446</Value>
  999.         </Annotation>
  1000.         <Annotation>
  1001.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
  1002.           <Value>-4498</Value>
  1003.         </Annotation>
  1004.         <Annotation>
  1005.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
  1006.           <Value>100</Value>
  1007.         </Annotation>
  1008.       </Annotations>
  1009.       <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  1010.       <State>Unprocessed</State>
  1011.       <Source xsi:type="DataSourceViewBinding">
  1012.         <DataSourceViewID>Book Sell</DataSourceViewID>
  1013.       </Source>
  1014.       <Columns>
  1015.         <Column xsi:type="ScalarMiningStructureColumn">
  1016.           <ID>Category</ID>
  1017.           <Name>Category</Name>
  1018.           <Type>Text</Type>
  1019.           <Content>Discrete</Content>
  1020.           <KeyColumns>
  1021.             <KeyColumn>
  1022.               <DataType>WChar</DataType>
  1023.               <DataSize>20</DataSize>
  1024.               <Source xsi:type="ColumnBinding">
  1025.                 <TableID>dbo_V_Book</TableID>
  1026.                 <ColumnID>Category</ColumnID>
  1027.               </Source>
  1028.             </KeyColumn>
  1029.           </KeyColumns>
  1030.         </Column>
  1031.         <Column xsi:type="ScalarMiningStructureColumn">
  1032.           <ID>CD</ID>
  1033.           <Name>CD</Name>
  1034.           <Type>Boolean</Type>
  1035.           <Content>Discrete</Content>
  1036.           <KeyColumns>
  1037.             <KeyColumn>
  1038.               <DataType>Boolean</DataType>
  1039.               <DataSize>-1</DataSize>
  1040.               <Source xsi:type="ColumnBinding">
  1041.                 <TableID>dbo_V_Book</TableID>
  1042.                 <ColumnID>CD</ColumnID>
  1043.               </Source>
  1044.             </KeyColumn>
  1045.           </KeyColumns>
  1046.         </Column>
  1047.         <Column xsi:type="ScalarMiningStructureColumn">
  1048.           <ID>Day Sell Number</ID>
  1049.           <Name>DaySellNumber</Name>
  1050.           <Type>Long</Type>
  1051.           <Content>Continuous</Content>
  1052.           <KeyColumns>
  1053.             <KeyColumn>
  1054.               <DataType>Integer</DataType>
  1055.               <DataSize>-1</DataSize>
  1056.               <Source xsi:type="ColumnBinding">
  1057.                 <TableID>dbo_V_Book</TableID>
  1058.                 <ColumnID>DaySellNumber</ColumnID>
  1059.               </Source>
  1060.             </KeyColumn>
  1061.           </KeyColumns>
  1062.         </Column>
  1063.         <Column xsi:type="ScalarMiningStructureColumn">
  1064.           <ID>Day Sell Sum</ID>
  1065.           <Name>DaySellSum</Name>
  1066.           <Type>Double</Type>
  1067.           <Content>Continuous</Content>
  1068.           <KeyColumns>
  1069.             <KeyColumn>
  1070.               <DataType>Double</DataType>
  1071.               <DataSize>-1</DataSize>
  1072.               <Source xsi:type="ColumnBinding">
  1073.                 <TableID>dbo_V_Book</TableID>
  1074.                 <ColumnID>DaySellSum</ColumnID>
  1075.               </Source>
  1076.             </KeyColumn>
  1077.           </KeyColumns>
  1078.         </Column>
  1079.         <Column xsi:type="ScalarMiningStructureColumn">
  1080.           <ID>ID</ID>
  1081.           <Name>ID</Name>
  1082.           <IsKey>true</IsKey>
  1083.           <Type>Long</Type>
  1084.           <Content>Key</Content>
  1085.           <KeyColumns>
  1086.             <KeyColumn>
  1087.               <DataType>Integer</DataType>
  1088.               <DataSize>-1</DataSize>
  1089.               <Source xsi:type="ColumnBinding">
  1090.                 <TableID>dbo_V_Book</TableID>
  1091.                 <ColumnID>ID</ColumnID>
  1092.               </Source>
  1093.             </KeyColumn>
  1094.           </KeyColumns>
  1095.         </Column>
  1096.         <Column xsi:type="ScalarMiningStructureColumn">
  1097.           <ID>Pages</ID>
  1098.           <Name>Pages</Name>
  1099.           <Type>Long</Type>
  1100.           <Content>Discretized</Content>
  1101.           <KeyColumns>
  1102.             <KeyColumn>
  1103.               <DataType>SmallInt</DataType>
  1104.               <DataSize>-1</DataSize>
  1105.               <Source xsi:type="ColumnBinding">
  1106.                 <TableID>dbo_V_Book</TableID>
  1107.                 <ColumnID>Pages</ColumnID>
  1108.               </Source>
  1109.             </KeyColumn>
  1110.           </KeyColumns>
  1111.         </Column>
  1112.         <Column xsi:type="ScalarMiningStructureColumn">
  1113.           <ID>Press</ID>
  1114.           <Name>Press</Name>
  1115.           <Type>Text</Type>
  1116.           <Content>Discrete</Content>
  1117.           <KeyColumns>
  1118.             <KeyColumn>
  1119.               <DataType>WChar</DataType>
  1120.               <DataSize>50</DataSize>
  1121.               <Source xsi:type="ColumnBinding">
  1122.                 <TableID>dbo_V_Book</TableID>
  1123.                 <ColumnID>Press</ColumnID>
  1124.               </Source>
  1125.             </KeyColumn>
  1126.           </KeyColumns>
  1127.         </Column>
  1128.         <Column xsi:type="ScalarMiningStructureColumn">
  1129.           <ID>Price</ID>
  1130.           <Name>Price</Name>
  1131.           <Type>Double</Type>
  1132.           <Content>Discretized</Content>
  1133.           <KeyColumns>
  1134.             <KeyColumn>
  1135.               <DataType>Double</DataType>
  1136.               <DataSize>-1</DataSize>
  1137.               <Source xsi:type="ColumnBinding">
  1138.                 <TableID>dbo_V_Book</TableID>
  1139.                 <ColumnID>Price</ColumnID>
  1140.               </Source>
  1141.             </KeyColumn>
  1142.           </KeyColumns>
  1143.         </Column>
  1144.       </Columns>
  1145.       <MiningModels>
  1146.         <MiningModel>
  1147.           <ID>BookSell</ID>
  1148.           <Name>BookSell</Name>
  1149.           <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  1150.           <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  1151.           <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  1152.           <State>Unprocessed</State>
  1153.           <Algorithm>Microsoft_Neural_Network</Algorithm>
  1154.           <Columns>
  1155.             <Column>
  1156.               <ID>Category</ID>
  1157.               <Name>Category</Name>
  1158.               <SourceColumnID>Category</SourceColumnID>
  1159.             </Column>
  1160.             <Column>
  1161.               <ID>CD</ID>
  1162.               <Name>CD</Name>
  1163.               <SourceColumnID>CD</SourceColumnID>
  1164.             </Column>
  1165.             <Column>
  1166.               <ID>Day Sell Number</ID>
  1167.               <Name>DaySellNumber</Name>
  1168.               <SourceColumnID>Day Sell Number</SourceColumnID>
  1169.               <Usage>PredictOnly</Usage>
  1170.             </Column>
  1171.             <Column>
  1172.               <ID>ID</ID>
  1173.               <Name>ID</Name>
  1174.               <SourceColumnID>ID</SourceColumnID>
  1175.               <Usage>Key</Usage>
  1176.             </Column>
  1177.             <Column>
  1178.               <ID>Pages</ID>
  1179.               <Name>Pages</Name>
  1180.               <SourceColumnID>Pages</SourceColumnID>
  1181.             </Column>
  1182.             <Column>
  1183.               <ID>Press</ID>
  1184.               <Name>Press</Name>
  1185.               <SourceColumnID>Press</SourceColumnID>
  1186.             </Column>
  1187.             <Column>
  1188.               <ID>Price</ID>
  1189.               <Name>Price</Name>
  1190.               <SourceColumnID>Price</SourceColumnID>
  1191.             </Column>
  1192.           </Columns>
  1193.         </MiningModel>
  1194.       </MiningModels>
  1195.     </MiningStructure>
  1196.     <MiningStructure>
  1197.       <ID>BookAssociation</ID>
  1198.       <Name>BookAssociation</Name>
  1199.       <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  1200.       <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  1201.       <Annotations>
  1202.         <Annotation>
  1203.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CaseTableName</Name>
  1204.           <Value>dbo_Customer</Value>
  1205.         </Annotation>
  1206.         <Annotation>
  1207.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
  1208.           <Value>true</Value>
  1209.         </Annotation>
  1210.         <Annotation>
  1211.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>
  1212.           <Value>
  1213.             <dds xmlns="">
  1214.               <diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="4" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-4446" scrolltop="-1116" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="12356" y="15055" 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}">
  1215.                 <font>
  1216.                   <ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
  1217.                 </font>
  1218.                 <mouseicon>
  1219.                   <ddsxmlobjectstreamwrapper binary="6c74000000000000" />
  1220.                 </mouseicon>
  1221.               </diagram>
  1222.               <layoutmanager>
  1223.                 <ddsxmlobj />
  1224.               </layoutmanager>
  1225.               <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="V_BookSell (dbo.V_BookSell)" left="20" top="7400" logicalid="1" controlid="1" masterid="0" hint1="0" hint2="0" width="3000" height="5000" 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">
  1226.                 <control>
  1227.                   <ddsxmlobjectstreaminitwrapper binary="00080000b80b000088130000" />
  1228.                 </control>
  1229.                 <layoutobject>
  1230.                   <ddsxmlobj>
  1231.                     <property name="LogicalObject" value="dbo_V_BookSell" vartype="8" />
  1232.                   </ddsxmlobj>
  1233.                 </layoutobject>
  1234.                 <shape groupshapeid="0" groupnode="0" />
  1235.               </ddscontrol>
  1236.               <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Customer (dbo.Customer)" left="20" top="0" logicalid="2" controlid="2" masterid="0" hint1="0" hint2="0" width="3000" height="5000" 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">
  1237.                 <control>
  1238.                   <ddsxmlobjectstreaminitwrapper binary="00080000b80b000088130000" />
  1239.                 </control>
  1240.                 <layoutobject>
  1241.                   <ddsxmlobj>
  1242.                     <property name="LogicalObject" value="dbo_Customer" vartype="8" />
  1243.                   </ddsxmlobj>
  1244.                 </layoutobject>
  1245.                 <shape groupshapeid="0" groupnode="0" />
  1246.               </ddscontrol>
  1247.               <ddscontrol controlprogid="MSDDS.Polyline" left="1121" top="4501" logicalid="3" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="3199" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
  1248.                 <control>
  1249.                   <ddsxmlobj>
  1250.                     <polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
  1251.                   </ddsxmlobj>
  1252.                 </control>
  1253.                 <layoutobject>
  1254.                   <ddsxmlobj>
  1255.                     <property name="LogicalObject" value="dataSet.Relations[V_BookSell-Customer]" vartype="8" />
  1256.                     <property name="Virtual" value="0" vartype="11" />
  1257.                     <property name="VisibleAP" value="0" vartype="3" />
  1258.                   </ddsxmlobj>
  1259.                 </layoutobject>
  1260.                 <connector lineroutestyle="MSDDS.Rectilinear" sourceid="2" destid="1" sourceattachpoint="5" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">
  1261.                   <point x="1520" y="5000" />
  1262.                   <point x="1520" y="7400" />
  1263.                 </connector>
  1264.               </ddscontrol>
  1265.             </dds>
  1266.           </Value>
  1267.         </Annotation>
  1268.         <Annotation>
  1269.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>
  1270.           <Value>false</Value>
  1271.         </Annotation>
  1272.         <Annotation>
  1273.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
  1274.           <Value>true</Value>
  1275.         </Annotation>
  1276.         <Annotation>
  1277.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
  1278.           <Value>-4446</Value>
  1279.         </Annotation>
  1280.         <Annotation>
  1281.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
  1282.           <Value>-1116</Value>
  1283.         </Annotation>
  1284.         <Annotation>
  1285.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
  1286.           <Value>20</Value>
  1287.         </Annotation>
  1288.         <Annotation>
  1289.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
  1290.           <Value>0</Value>
  1291.         </Annotation>
  1292.         <Annotation>
  1293.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
  1294.           <Value>100</Value>
  1295.         </Annotation>
  1296.       </Annotations>
  1297.       <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  1298.       <State>Unprocessed</State>
  1299.       <Source xsi:type="DataSourceViewBinding">
  1300.         <DataSourceViewID>Book Sell</DataSourceViewID>
  1301.       </Source>
  1302.       <Columns>
  1303.         <Column xsi:type="ScalarMiningStructureColumn">
  1304.           <ID>ID</ID>
  1305.           <Name>ID</Name>
  1306.           <IsKey>true</IsKey>
  1307.           <Type>Long</Type>
  1308.           <Content>Key</Content>
  1309.           <KeyColumns>
  1310.             <KeyColumn>
  1311.               <DataType>Integer</DataType>
  1312.               <DataSize>-1</DataSize>
  1313.               <Source xsi:type="ColumnBinding">
  1314.                 <TableID>dbo_Customer</TableID>
  1315.                 <ColumnID>ID</ColumnID>
  1316.               </Source>
  1317.             </KeyColumn>
  1318.           </KeyColumns>
  1319.         </Column>
  1320.         <Column xsi:type="TableMiningStructureColumn">
  1321.           <Annotations>
  1322.             <Annotation>
  1323.               <Name>MDXFilterComponent</Name>
  1324.             </Annotation>
  1325.           </Annotations>
  1326.           <ID>V Book Sell</ID>
  1327.           <Name>BookSell</Name>
  1328.           <ForeignKeyColumns>
  1329.             <ForeignKeyColumn>
  1330.               <DataType>Integer</DataType>
  1331.               <DataSize>-1</DataSize>
  1332.               <Source xsi:type="ColumnBinding">
  1333.                 <TableID>dbo_V_BookSell</TableID>
  1334.                 <ColumnID>CustomerID</ColumnID>
  1335.               </Source>
  1336.             </ForeignKeyColumn>
  1337.           </ForeignKeyColumns>
  1338.           <Columns>
  1339.             <Column xsi:type="ScalarMiningStructureColumn">
  1340.               <ID>Book ID</ID>
  1341.               <Name>Book ID</Name>
  1342.               <IsKey>true</IsKey>
  1343.               <Type>Long</Type>
  1344.               <Content>Key Sequence</Content>
  1345.               <KeyColumns>
  1346.                 <KeyColumn>
  1347.                   <DataType>Integer</DataType>
  1348.                   <DataSize>-1</DataSize>
  1349.                   <Source xsi:type="ColumnBinding">
  1350.                     <TableID>dbo_V_BookSell</TableID>
  1351.                     <ColumnID>BookID</ColumnID>
  1352.                   </Source>
  1353.                 </KeyColumn>
  1354.               </KeyColumns>
  1355.             </Column>
  1356.             <Column xsi:type="ScalarMiningStructureColumn">
  1357.               <ID>Name</ID>
  1358.               <Name>Name</Name>
  1359.               <Type>Text</Type>
  1360.               <Content>Discrete</Content>
  1361.               <KeyColumns>
  1362.                 <KeyColumn>
  1363.                   <DataType>WChar</DataType>
  1364.                   <DataSize>256</DataSize>
  1365.                   <Source xsi:type="ColumnBinding">
  1366.                     <TableID>dbo_V_BookSell</TableID>
  1367.                     <ColumnID>Name</ColumnID>
  1368.                   </Source>
  1369.                 </KeyColumn>
  1370.               </KeyColumns>
  1371.             </Column>
  1372.           </Columns>
  1373.         </Column>
  1374.       </Columns>
  1375.       <MiningModels>
  1376.         <MiningModel>
  1377.           <ID>BookAssociation</ID>
  1378.           <Name>BookAssociation</Name>
  1379.           <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  1380.           <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  1381.           <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  1382.           <State>Unprocessed</State>
  1383.           <Algorithm>Microsoft_Sequence_Clustering</Algorithm>
  1384.           <AlgorithmParameters>
  1385.             <AlgorithmParameter>
  1386.               <Name>CLUSTER_COUNT</Name>
  1387.               <Value xsi:type="xsd:int">0</Value>
  1388.             </AlgorithmParameter>
  1389.           </AlgorithmParameters>
  1390.           <Columns>
  1391.             <Column>
  1392.               <ID>ID</ID>
  1393.               <Name>ID</Name>
  1394.               <SourceColumnID>ID</SourceColumnID>
  1395.               <Usage>Key</Usage>
  1396.             </Column>
  1397.             <Column>
  1398.               <ID>V Book Sell</ID>
  1399.               <Name>BookSell</Name>
  1400.               <SourceColumnID>V Book Sell</SourceColumnID>
  1401.               <Columns>
  1402.                 <Column>
  1403.                   <ID>Book ID</ID>
  1404.                   <Name>Book ID</Name>
  1405.                   <SourceColumnID>Book ID</SourceColumnID>
  1406.                   <Usage>Key</Usage>
  1407.                 </Column>
  1408.                 <Column>
  1409.                   <ID>Name</ID>
  1410.                   <Name>Name</Name>
  1411.                   <SourceColumnID>Name</SourceColumnID>
  1412.                   <Usage>Predict</Usage>
  1413.                 </Column>
  1414.               </Columns>
  1415.             </Column>
  1416.           </Columns>
  1417.           <AllowDrillThrough>true</AllowDrillThrough>
  1418.         </MiningModel>
  1419.       </MiningModels>
  1420.     </MiningStructure>
  1421.   </MiningStructures>
  1422.   <DataSources>
  1423.     <DataSource xsi:type="RelationalDataSource">
  1424.       <ID>Book Sell</ID>
  1425.       <Name>Book Sell</Name>
  1426.       <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  1427.       <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  1428.       <ConnectionString>Provider=SQLNCLI.1;Data Source=GLZ;Integrated Security=SSPI;Initial Catalog=BookSell</ConnectionString>
  1429.       <ConnectionStringSecurity>Unchanged</ConnectionStringSecurity>
  1430.       <ImpersonationInfo>
  1431.         <ImpersonationMode>ImpersonateServiceAccount</ImpersonationMode>
  1432.         <ImpersonationInfoSecurity>Unchanged</ImpersonationInfoSecurity>
  1433.       </ImpersonationInfo>
  1434.       <Timeout>PT0S</Timeout>
  1435.     </DataSource>
  1436.   </DataSources>
  1437.   <DataSourceViews>
  1438.     <DataSourceView>
  1439.       <ID>Book Sell</ID>
  1440.       <Name>Book Sell</Name>
  1441.       <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  1442.       <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  1443.       <Annotations>
  1444.         <Annotation>
  1445.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
  1446.           <Value>true</Value>
  1447.         </Annotation>
  1448.         <Annotation>
  1449.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CurrentLayout</Name>
  1450.           <Value>_ALL_TABLES_</Value>
  1451.         </Annotation>
  1452.         <Annotation>
  1453.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:NameMatchingCriteria</Name>
  1454.           <Value>3</Value>
  1455.         </Annotation>
  1456.         <Annotation>
  1457.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:SchemaRestriction</Name>
  1458.         </Annotation>
  1459.         <Annotation>
  1460.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:RetrieveRelationships</Name>
  1461.           <Value>true</Value>
  1462.         </Annotation>
  1463.         <Annotation>
  1464.           <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:Layouts</Name>
  1465.           <Value>
  1466.             <Layouts xmlns="">
  1467.               <Diagram>
  1468.                 <Name>_ALL_TABLES_</Name>
  1469.                 <DiagramLayout>
  1470.                   <dds>
  1471.                     <diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="12" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-210" scrolltop="-244" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="13732" y="16536" 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}">
  1472.                       <font>
  1473.                         <ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
  1474.                       </font>
  1475.                       <mouseicon>
  1476.                         <ddsxmlobjectstreamwrapper binary="6c74000000000000" />
  1477.                       </mouseicon>
  1478.                     </diagram>
  1479.                     <layoutmanager>
  1480.                       <ddsxmlobj />
  1481.                     </layoutmanager>
  1482.                     <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Customer (dbo.Customer)" left="0" top="0" logicalid="6" controlid="1" masterid="0" hint1="0" hint2="0" width="4324" height="7276" 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">
  1483.                       <control>
  1484.                         <ddsxmlobjectstreaminitwrapper binary="00080000e41000006c1c0000" />
  1485.                       </control>
  1486.                       <layoutobject>
  1487.                         <ddsxmlobj>
  1488.                           <property name="LogicalObject" value="dbo_Customer" vartype="8" />
  1489.                         </ddsxmlobj>
  1490.                       </layoutobject>
  1491.                       <shape groupshapeid="0" groupnode="0" />
  1492.                     </ddscontrol>
  1493.                     <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="V_BookSell (dbo.V_BookSell)" left="4904" top="38" logicalid="7" controlid="2" masterid="0" hint1="0" hint2="0" width="3000" height="5000" 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">
  1494.                       <control>
  1495.                         <ddsxmlobjectstreaminitwrapper binary="00080000b80b000088130000" />
  1496.                       </control>
  1497.                       <layoutobject>
  1498.                         <ddsxmlobj>
  1499.                           <property name="LogicalObject" value="dbo_V_BookSell" vartype="8" />
  1500.                         </ddsxmlobj>
  1501.                       </layoutobject>
  1502.                       <shape groupshapeid="0" groupnode="0" />
  1503.                     </ddscontrol>
  1504.                     <ddscontrol controlprogid="MSDDS.Polyline" left="4024" top="-61" logicalid="8" controlid="3" masterid="0" hint1="0" hint2="0" width="1180" height="799" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
  1505.                       <control>
  1506.                         <ddsxmlobj>
  1507.                           <polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
  1508.                         </ddsxmlobj>
  1509.                       </control>
  1510.                       <layoutobject>
  1511.                         <ddsxmlobj>
  1512.                           <property name="LogicalObject" value="dataSet.Relations[V_BookSell-Customer]" vartype="8" />
  1513.                           <property name="Virtual" value="0" vartype="11" />
  1514.                           <property name="VisibleAP" value="0" vartype="3" />
  1515.                         </ddsxmlobj>
  1516.                       </layoutobject>
  1517.                       <connector lineroutestyle="MSDDS.Rectilinear" sourceid="1" destid="2" sourceattachpoint="15" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">
  1518.                         <point x="4324" y="338" />
  1519.                         <point x="4724" y="338" />
  1520.                         <point x="4724" y="338" />
  1521.                         <point x="4504" y="338" />
  1522.                         <point x="4504" y="338" />
  1523.                         <point x="4904" y="338" />
  1524.                       </connector>
  1525.                     </ddscontrol>
  1526.                     <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="V_Book (dbo.V_Book)" left="31" top="7736" logicalid="9" controlid="4" masterid="0" hint1="0" hint2="0" width="3000" height="5979" 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">
  1527.                       <control>
  1528.                         <ddsxmlobjectstreaminitwrapper binary="00080000b80b00005b170000" />
  1529.                       </control>
  1530.                       <layoutobject>
  1531.                         <ddsxmlobj>
  1532.                           <property name="LogicalObject" value="dbo_V_Book" vartype="8" />
  1533.                         </ddsxmlobj>
  1534.                       </layoutobject>
  1535.                       <shape groupshapeid="0" groupnode="0" />
  1536.                     </ddscontrol>
  1537.                     <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="V_WeekSell (dbo.V_WeekSell)" left="5156" top="6873" logicalid="10" controlid="5" masterid="0" hint1="0" hint2="0" width="3000" height="2302" 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">
  1538.                       <control>
  1539.                         <ddsxmlobjectstreaminitwrapper binary="00080000b80b0000fe080000" />
  1540.                       </control>
  1541.                       <layoutobject>
  1542.                         <ddsxmlobj>
  1543.                           <property name="LogicalObject" value="dbo_V_WeekSell" vartype="8" />
  1544.                         </ddsxmlobj>
  1545.                       </layoutobject>
  1546.                       <shape groupshapeid="0" groupnode="0" />
  1547.                     </ddscontrol>
  1548.                   </dds>
  1549.                 </DiagramLayout>
  1550.                 <ShowRelationshipNames>False</ShowRelationshipNames>
  1551.                 <UseDiagramDefaultLayout>True</UseDiagramDefaultLayout>
  1552.                 <DiagramViewPortLeft>-210</DiagramViewPortLeft>
  1553.                 <DiagramViewPortTop>-244</DiagramViewPortTop>
  1554.                 <DiagramBoundingLeft>0</DiagramBoundingLeft>
  1555.                 <DiagramBoundingTop>0</DiagramBoundingTop>
  1556.                 <DiagramZoom>100</DiagramZoom>
  1557.               </Diagram>
  1558.             </Layouts>
  1559.           </Value>
  1560.         </Annotation>
  1561.       </Annotations>
  1562.       <DataSourceID>Book Sell</DataSourceID>
  1563.       <Schema>
  1564.         <xs:schema id="Book_x0020_Sell" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
  1565.           <xs:element name="Book_x0020_Sell" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:design-time-name="6e08c3d7-89ee-4554-bca5-406b0363c270">
  1566.             <xs:complexType>
  1567.               <xs:choice minOccurs="0" maxOccurs="unbounded">
  1568.                 <xs:element name="dbo_Customer" msprop:FriendlyName="Customer" msprop:DbSchemaName="dbo" msprop:DbTableName="Customer" msprop:design-time-name="ac3a4c67-a932-40e6-98e7-29e125e94776" msprop:TableType="Table">
  1569.                   <xs:complexType>
  1570.                     <xs:sequence>
  1571.                       <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:FriendlyName="ID" msprop:DbColumnName="ID" msprop:design-time-name="d5dd3520-0b06-4d6b-887a-b7f94d8caa47" type="xs:int" />
  1572.                       <xs:element name="Name" msprop:FriendlyName="Name" msprop:DbColumnName="Name" msprop:design-time-name="53169317-d2e6-4ee7-9342-545ff589bf02">
  1573.                         <xs:simpleType>
  1574.                           <xs:restriction base="xs:string">
  1575.                             <xs:maxLength value="20" />
  1576.                           </xs:restriction>
  1577.                         </xs:simpleType>
  1578.                       </xs:element>
  1579.                       <xs:element name="Levels" msprop:FriendlyName="Levels" msprop:DbColumnName="Levels" msprop:design-time-name="4358b429-46fb-4d46-972f-ed42bade6b90" type="xs:short" minOccurs="0" />
  1580.                       <xs:element name="Gender" msprop:FriendlyName="Gender" msprop:DbColumnName="Gender" msprop:design-time-name="e5942f5a-f213-4967-8fea-c9bdc1f12cf7" type="xs:boolean" minOccurs="0" />
  1581.                       <xs:element name="Birthday" msprop:FriendlyName="Birthday" msprop:DbColumnName="Birthday" msprop:design-time-name="0369b46d-3be9-4ead-a7a6-a52a0d4487f7" type="xs:dateTime" minOccurs="0" />
  1582.                       <xs:element name="Degree" msprop:FriendlyName="Degree" msprop:DbColumnName="Degree" msprop:design-time-name="d819b248-cc7d-4915-962a-fea8262f3f7c" minOccurs="0">
  1583.                         <xs:simpleType>
  1584.                           <xs:restriction base="xs:string">
  1585.                             <xs:maxLength value="20" />
  1586.                           </xs:restriction>
  1587.                         </xs:simpleType>
  1588.                       </xs:element>
  1589.                       <xs:element name="Area" msprop:FriendlyName="Area" msprop:DbColumnName="Area" msprop:design-time-name="c7e2931c-0f78-4f54-945f-9df4d35eb569" minOccurs="0">
  1590.                         <xs:simpleType>
  1591.                           <xs:restriction base="xs:string">
  1592.                             <xs:maxLength value="20" />
  1593.                           </xs:restriction>
  1594.                         </xs:simpleType>
  1595.                       </xs:element>
  1596.                       <xs:element name="Address" msprop:FriendlyName="Address" msprop:DbColumnName="Address" msprop:design-time-name="10b9a9d6-bce6-4a7c-864b-d3d69380423e" minOccurs="0">
  1597.                         <xs:simpleType>
  1598.                           <xs:restriction base="xs:string">
  1599.                             <xs:maxLength value="256" />
  1600.                           </xs:restriction>
  1601.                         </xs:simpleType>
  1602.                       </xs:element>
  1603.                       <xs:element name="Telephone" msprop:FriendlyName="Telephone" msprop:DbColumnName="Telephone" msprop:design-time-name="f17a9dfd-b6eb-4b9f-976d-cf262ff33c84" minOccurs="0">
  1604.                         <xs:simpleType>
  1605.                           <xs:restriction base="xs:string">
  1606.                             <xs:maxLength value="50" />
  1607.                           </xs:restriction>
  1608.                         </xs:simpleType>
  1609.                       </xs:element>
  1610.                       <xs:element name="Email" msprop:FriendlyName="Email" msprop:DbColumnName="Email" msprop:design-time-name="b4c1997f-4d6f-49b6-8ae6-48b3b18dd922" minOccurs="0">
  1611.                         <xs:simpleType>
  1612.                           <xs:restriction base="xs:string">
  1613.                             <xs:maxLength value="50" />
  1614.                           </xs:restriction>
  1615.                         </xs:simpleType>
  1616.                       </xs:element>
  1617.                       <xs:element name="Score" msprop:FriendlyName="Score" msprop:DbColumnName="Score" msprop:design-time-name="81cb67d5-4b1b-4cf3-bc05-3c7950211408" type="xs:int" minOccurs="0" />
  1618.                       <xs:element name="Age" msdata:ReadOnly="true" msprop:design-time-name="3bf61c90-0dbb-4098-9e1d-e0abb47e897e" msprop:DbColumnName="Age" msprop:ComputedColumnExpression="YEAR(GETDATE()) - YEAR(dbo.Customer.Birthday)" msprop:Description="" msprop:IsLogical="True" type="xs:int" minOccurs="0" />
  1619.                       <xs:element name="RegTime" msprop:design-time-name="fd67be7e-0b33-4688-9bd5-5551f699cc97" msprop:DbColumnName="RegTime" type="xs:dateTime" minOccurs="0" />
  1620.                       <xs:element name="DayConsume" msdata:ReadOnly="true" msprop:design-time-name="f9c25530-4f81-4df1-a357-b2a567c05b3b" msprop:DbColumnName="DayConsume" msprop:ComputedColumnExpression="CAST (Score AS Decimal) / DATEDIFF(DAY,RegTime,GETDATE())" msprop:Description="" msprop:IsLogical="True" type="xs:decimal" minOccurs="0" />
  1621.                     </xs:sequence>
  1622.                   </xs:complexType>
  1623.                 </xs:element>
  1624.                 <xs:element name="dbo_V_BookSell" msprop:FriendlyName="V_BookSell" msprop:DbSchemaName="dbo" msprop:DbTableName="V_BookSell" msprop:design-time-name="2fb48511-2075-46ff-b759-85197d20655e" msprop:TableType="View">
  1625.                   <xs:complexType>
  1626.                     <xs:sequence>
  1627.                       <xs:element name="ID" msprop:FriendlyName="ID" msprop:DbColumnName="ID" msprop:design-time-name="4466e450-be2c-46d9-900f-0fbf26fb45b6" type="xs:int" />
  1628.                       <xs:element name="SellID" msprop:FriendlyName="SellID" msprop:DbColumnName="SellID" msprop:design-time-name="12e4cac6-ccca-4db1-9a71-32bb82d50ea7" type="xs:int" />
  1629.                       <xs:element name="CustomerID" msprop:FriendlyName="CustomerID" msprop:DbColumnName="CustomerID" msprop:design-time-name="3f134563-5a36-4de1-b1ab-82fff1caef2e" type="xs:int" minOccurs="0" />
  1630.                       <xs:element name="Time" msprop:FriendlyName="Time" msprop:DbColumnName="Time" msprop:design-time-name="f5bf9047-f20b-406d-b925-03154e55b5b8" type="xs:dateTime" />
  1631.                       <xs:element name="BookID" msprop:FriendlyName="BookID" msprop:DbColumnName="BookID" msprop:design-time-name="c4a300b4-a4a5-42f5-89f3-5e59a6d510e4" type="xs:int" />
  1632.                       <xs:element name="ISBN" msprop:FriendlyName="ISBN" msprop:DbColumnName="ISBN" msprop:design-time-name="9ebff113-36dc-4666-8f76-66fc045e6d11">
  1633.                         <xs:simpleType>
  1634.                           <xs:restriction base="xs:string">
  1635.                             <xs:maxLength value="10" />
  1636.                           </xs:restriction>
  1637.                         </xs:simpleType>
  1638.                       </xs:element>
  1639.                       <xs:element name="Name" msprop:FriendlyName="Name" msprop:DbColumnName="Name" msprop:design-time-name="bcf90945-6345-4e68-abfb-96f922164e64">
  1640.                         <xs:simpleType>
  1641.                           <xs:restriction base="xs:string">
  1642.                             <xs:maxLength value="256" />
  1643.                           </xs:restriction>
  1644.                         </xs:simpleType>
  1645.                       </xs:element>
  1646.                       <xs:element name="Press" msprop:FriendlyName="Press" msprop:DbColumnName="Press" msprop:design-time-name="5ca1fe6f-4299-4a8b-8f17-0701876e7415" minOccurs="0">
  1647.                         <xs:simpleType>
  1648.                           <xs:restriction base="xs:string">
  1649.                             <xs:maxLength value="50" />
  1650.                           </xs:restriction>
  1651.                         </xs:simpleType>
  1652.                       </xs:element>
  1653.                       <xs:element name="Price" msprop:FriendlyName="Price" msprop:DbColumnName="Price" msprop:design-time-name="a25d7919-fa9d-4d30-9a71-00cc5dd6f5fa" type="xs:decimal" />
  1654.                       <xs:element name="Number" msprop:FriendlyName="Number" msprop:DbColumnName="Number" msprop:design-time-name="6ecbba82-3d52-459d-9550-c7b5f25f4ab6" type="xs:int" />
  1655.                       <xs:element name="Discount" msprop:FriendlyName="Discount" msprop:DbColumnName="Discount" msprop:design-time-name="0ce0b48a-ab8b-485d-a17d-70b7beead3b2" type="xs:double" minOccurs="0" />
  1656.                       <xs:element name="Sum" msprop:FriendlyName="Sum" msprop:DbColumnName="Sum" msprop:design-time-name="3b77ff34-57d9-42dc-b7f3-72bfb753ee03" type="xs:decimal" minOccurs="0" />
  1657.                     </xs:sequence>
  1658.                   </xs:complexType>
  1659.                 </xs:element>
  1660.                 <xs:element name="dbo_V_Book" msprop:FriendlyName="V_Book" msprop:DbSchemaName="dbo" msprop:DbTableName="V_Book" msprop:design-time-name="c7cca7cb-6081-47a8-b9ba-9b96992c6ca5" msprop:TableType="View">
  1661.                   <xs:complexType>
  1662.                     <xs:sequence>
  1663.                       <xs:element name="ID" msprop:FriendlyName="ID" msprop:DbColumnName="ID" msprop:design-time-name="4d39e741-35a7-4a1d-919d-0627057d36c1" type="xs:int" />
  1664.                       <xs:element name="Name" msprop:FriendlyName="Name" msprop:DbColumnName="Name" msprop:design-time-name="544a48d4-4318-4682-8e5f-b0678d17ef46">
  1665.                         <xs:simpleType>
  1666.                           <xs:restriction base="xs:string">
  1667.                             <xs:maxLength value="256" />
  1668.                           </xs:restriction>
  1669.                         </xs:simpleType>
  1670.                       </xs:element>
  1671.                       <xs:element name="Category" msprop:FriendlyName="Category" msprop:DbColumnName="Category" msprop:design-time-name="2807ceaa-3e79-4f6f-9b1f-21f5cc9b60a0">
  1672.                         <xs:simpleType>
  1673.                           <xs:restriction base="xs:string">
  1674.                             <xs:maxLength value="20" />
  1675.                           </xs:restriction>
  1676.                         </xs:simpleType>
  1677.                       </xs:element>
  1678.                       <xs:element name="Press" msprop:FriendlyName="Press" msprop:DbColumnName="Press" msprop:design-time-name="40df5c9d-f49c-4ad9-86c9-7a004fd3b342" minOccurs="0">
  1679.                         <xs:simpleType>
  1680.                           <xs:restriction base="xs:string">
  1681.                             <xs:maxLength value="50" />
  1682.                           </xs:restriction>
  1683.                         </xs:simpleType>
  1684.                       </xs:element>
  1685.                       <xs:element name="Price" msprop:FriendlyName="Price" msprop:DbColumnName="Price" msprop:design-time-name="7ef66ed9-f19d-48cf-9f65-b66c82fddfa9" type="xs:decimal" />
  1686.                       <xs:element name="Pages" msprop:FriendlyName="Pages" msprop:DbColumnName="Pages" msprop:design-time-name="ca10d9e3-8ee1-45c6-98f8-18d86af14df1" type="xs:short" minOccurs="0" />
  1687.                       <xs:element name="CD" msprop:FriendlyName="CD" msprop:DbColumnName="CD" msprop:design-time-name="ad141bbf-db75-425e-ae84-099e648e2b2e" type="xs:boolean" minOccurs="0" />
  1688.                       <xs:element name="SellNumber" msdata:ReadOnly="true" msprop:FriendlyName="SellNumber" msprop:DbColumnName="SellNumber" msprop:design-time-name="c98490ee-1872-48a8-b88c-92c129dac59c" type="xs:int" minOccurs="0" />
  1689.                       <xs:element name="SellSum" msdata:ReadOnly="true" msprop:FriendlyName="SellSum" msprop:DbColumnName="SellSum" msprop:design-time-name="008b65ad-d2d3-4c4e-951b-7552e053b0ea" type="xs:decimal" minOccurs="0" />
  1690.                       <xs:element name="ShelfDate" msprop:FriendlyName="ShelfDate" msprop:DbColumnName="ShelfDate" msprop:design-time-name="e28d8269-aaba-4dae-90eb-5cfcf460d081" type="xs:dateTime" minOccurs="0" />
  1691.                       <xs:element name="DaySellNumber" msdata:ReadOnly="true" msprop:design-time-name="b16018db-0763-46d9-b68e-8ab04b20bdd9" msprop:DbColumnName="DaySellNumber" msprop:ComputedColumnExpression="SellNumber/DATEDIFF(DAY, ShelfDate, '2007-4-1')" msprop:Description="日均销量" msprop:IsLogical="True" type="xs:int" minOccurs="0" />
  1692.                       <xs:element name="DaySellSum" msdata:ReadOnly="true" msprop:design-time-name="e3dd0813-8a63-46f8-9d08-548c55e7bc8f" msprop:DbColumnName="DaySellSum" msprop:ComputedColumnExpression="SellSum/DATEDIFF(DAY, ShelfDate, '2007-4-1')" msprop:Description="日均销售额" msprop:IsLogical="True" type="xs:decimal" minOccurs="0" />
  1693.                     </xs:sequence>
  1694.                   </xs:complexType>
  1695.                 </xs:element>
  1696.                 <xs:element name="dbo_V_WeekSell" msprop:FriendlyName="V_WeekSell" msprop:DbSchemaName="dbo" msprop:DbTableName="V_WeekSell" msprop:design-time-name="1205ed08-174b-4bca-853f-1c8d70f7492f" msprop:TableType="View">
  1697.                   <xs:complexType>
  1698.                     <xs:sequence>
  1699.                       <xs:element name="Week" msdata:ReadOnly="true" msprop:FriendlyName="Week" msprop:DbColumnName="Week" msprop:design-time-name="05f7b7ba-2e66-4fb8-83ca-9f842e5eb23e" type="xs:int" minOccurs="0" />
  1700.                       <xs:element name="ID" msprop:FriendlyName="ID" msprop:DbColumnName="ID" msprop:design-time-name="0717fc54-ce3f-48cc-8cb1-9cb26667de4e" type="xs:int" />
  1701.                       <xs:element name="SellSum" msdata:ReadOnly="true" msprop:FriendlyName="SellSum" msprop:DbColumnName="SellSum" msprop:design-time-name="25bae63c-9119-49b9-8eb3-5fa3a6e4fccb" type="xs:decimal" minOccurs="0" />
  1702.                     </xs:sequence>
  1703.                   </xs:complexType>
  1704.                 </xs:element>
  1705.               </xs:choice>
  1706.             </xs:complexType>
  1707.             <xs:unique name="Constraint1" msdata:PrimaryKey="true">
  1708.               <xs:selector xpath=".//dbo_Customer" />
  1709.               <xs:field xpath="ID" />
  1710.             </xs:unique>
  1711.             <xs:unique name="dbo_V_BookSell_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  1712.               <xs:selector xpath=".//dbo_V_BookSell" />
  1713.               <xs:field xpath="ID" />
  1714.               <xs:field xpath="SellID" />
  1715.             </xs:unique>
  1716.             <xs:unique name="dbo_V_Book_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  1717.               <xs:selector xpath=".//dbo_V_Book" />
  1718.               <xs:field xpath="ID" />
  1719.             </xs:unique>
  1720.             <xs:unique name="dbo_V_WeekSell_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  1721.               <xs:selector xpath=".//dbo_V_WeekSell" />
  1722.               <xs:field xpath="ID" />
  1723.             </xs:unique>
  1724.           </xs:element>
  1725.           <xs:annotation>
  1726.             <xs:appinfo>
  1727.               <msdata:Relationship name="V_BookSell-Customer" msdata:parent="dbo_Customer" msdata:child="dbo_V_BookSell" msdata:parentkey="ID" msdata:childkey="CustomerID" msprop:Description="" msprop:IsLogical="True" />
  1728.             </xs:appinfo>
  1729.           </xs:annotation>
  1730.         </xs:schema>
  1731.         <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" />
  1732.       </Schema>
  1733.     </DataSourceView>
  1734.   </DataSourceViews>
  1735. </Database>