modeldemo.dsv

来自「SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德」· DSV 代码 · 共 413 行 · 第 1/4 页

                  </xs:element>
                  <xs:element name="SalesYTD" msprop:stats_StDevWidth="0" msprop:stats_AvgScale="1.9" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="SalesYTD" msprop:design-time-name="22e9e2c3-04a6-498e-9159-23b5c1cfcc39" msprop:stats_StDevScale="0.3162278" msprop:stats_MaxWidth="10" msprop:stats_UniqueValueCount="10" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="10" msprop:DbColumnName="SalesYTD" type="xs:decimal" />
                  <xs:element name="SalesLastYear" msprop:stats_StDevWidth="0" msprop:stats_AvgScale="1.8" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="SalesLastYear" msprop:design-time-name="1218aa21-bc95-438e-a0d8-f83a8ffe5757" msprop:stats_StDevScale="0.421637" msprop:stats_MaxWidth="10" msprop:stats_UniqueValueCount="10" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="10" msprop:DbColumnName="SalesLastYear" type="xs:decimal" />
                  <xs:element name="CostYTD" msprop:stats_StDevWidth="0" msprop:stats_AvgScale="0" msprop:stats_UniqueValuePercent="10" msprop:FriendlyName="CostYTD" msprop:design-time-name="7ee9aa59-ecfd-4962-ba42-4f4a14125af1" msprop:stats_StDevScale="0" msprop:stats_MaxWidth="4" msprop:stats_UniqueValueCount="1" msprop:stats_MaxScale="0" msprop:stats_AvgWidth="4" msprop:DbColumnName="CostYTD" type="xs:decimal" />
                  <xs:element name="CostLastYear" msprop:stats_StDevWidth="0" msprop:stats_AvgScale="0" msprop:stats_UniqueValuePercent="10" msprop:FriendlyName="CostLastYear" msprop:design-time-name="163634b5-5eee-4b2c-afab-a1ea0dfc067a" msprop:stats_StDevScale="0" msprop:stats_MaxWidth="4" msprop:stats_UniqueValueCount="1" msprop:stats_MaxScale="0" msprop:stats_AvgWidth="4" msprop:DbColumnName="CostLastYear" type="xs:decimal" />
                  <xs:element name="rowguid" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="rowguid" msprop:design-time-name="d95bb86f-3d0e-457e-bbcb-ad4dadae9b3f" msprop:stats_MaxWidth="36" msprop:stats_UniqueValueCount="10" msprop:stats_AvgWidth="36" msprop:DbColumnName="rowguid" type="xs:string" />
                  <xs:element name="ModifiedDate" msprop:FriendlyName="ModifiedDate" msprop:DbColumnName="ModifiedDate" msprop:stats_UniqueValuePercent="10" msprop:design-time-name="687c213d-b5e9-4359-97e4-c33caccd15f3" msprop:stats_UniqueValueCount="1" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Production_ProductProductPhoto" msprop:FriendlyName="ProductProductPhoto" msprop:DbTableName="ProductProductPhoto" msprop:DbSchemaName="Production" msprop:stats_RowCount="504" msprop:design-time-name="31df7349-30d8-44b6-8e73-459db7bc24a1" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="ProductID" msprop:stats_StDevWidth="0.177642" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="ProductID" msprop:design-time-name="3b761b22-c9a0-4c86-82d5-a6837b2c23b7" msprop:stats_MaxWidth="3" msprop:stats_UniqueValueCount="504" msprop:stats_AvgWidth="2.984127" msprop:DbColumnName="ProductID" type="xs:int" />
                  <xs:element name="ProductPhotoID" msprop:stats_StDevWidth="0.8558586" msprop:stats_UniqueValuePercent="8" msprop:FriendlyName="ProductPhotoID" msprop:design-time-name="e9da6982-fed6-4923-ab79-f82d1f9e6bd0" msprop:stats_MaxWidth="3" msprop:stats_UniqueValueCount="42" msprop:stats_AvgWidth="1.555556" msprop:DbColumnName="ProductPhotoID" type="xs:int" />
                  <xs:element name="Primary" msprop:FriendlyName="Primary" msprop:DbColumnName="Primary" msprop:stats_UniqueValuePercent="0" msprop:design-time-name="8c6e236c-fb4d-40ba-9ad6-26ea29f9f3d5" msprop:stats_UniqueValueCount="1" type="xs:boolean" />
                  <xs:element name="ModifiedDate" msprop:FriendlyName="ModifiedDate" msprop:DbColumnName="ModifiedDate" msprop:stats_UniqueValuePercent="0" msprop:design-time-name="14185d78-149a-47af-ba97-a9fd7c6b2c23" msprop:stats_UniqueValueCount="4" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Production_ProductPhoto" msprop:FriendlyName="ProductPhoto" msprop:DbTableName="ProductPhoto" msprop:DbSchemaName="Production" msprop:stats_RowCount="101" msprop:design-time-name="25a27e06-d1d3-4eaf-a8d7-d9dc5748253f" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="ProductPhotoID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:stats_StDevWidth="0.4715678" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="ProductPhotoID" msprop:design-time-name="76d14153-b6a2-4e0d-9d9b-6b6b49e56563" msprop:stats_MaxWidth="3" msprop:stats_UniqueValueCount="101" msprop:stats_AvgWidth="2.722772" msprop:DbColumnName="ProductPhotoID" type="xs:int" />
                  <xs:element name="ThumbNailPhoto" msprop:DataSize="-1" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="ThumbNailPhoto" msprop:design-time-name="6332e12b-74ce-48f5-b789-74e2e1f1f21b" msprop:stats_UniqueValueCount="101" msprop:DbColumnName="ThumbNailPhoto" type="xs:base64Binary" minOccurs="0" />
                  <xs:element name="ThumbnailPhotoFileName" msprop:stats_StDevWidth="4.313667" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="ThumbnailPhotoFileName" msprop:design-time-name="5155845d-486c-4501-b63c-81f4c50de482" msprop:stats_MaxWidth="35" msprop:stats_UniqueValueCount="101" msprop:stats_AvgWidth="23.85148" msprop:DbColumnName="ThumbnailPhotoFileName" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="LargePhoto" msprop:DataSize="-1" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="LargePhoto" msprop:design-time-name="03620043-a756-4510-9ffe-c3cfc03639fc" msprop:stats_UniqueValueCount="101" msprop:DbColumnName="LargePhoto" type="xs:base64Binary" minOccurs="0" />
                  <xs:element name="LargePhotoFileName" msprop:stats_StDevWidth="4.313667" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="LargePhotoFileName" msprop:design-time-name="163626a9-afc6-4f8f-aac6-41312d359065" msprop:stats_MaxWidth="35" msprop:stats_UniqueValueCount="101" msprop:stats_AvgWidth="23.85148" msprop:DbColumnName="LargePhotoFileName" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="ModifiedDate" msprop:FriendlyName="ModifiedDate" msprop:DbColumnName="ModifiedDate" msprop:stats_UniqueValuePercent="5" msprop:design-time-name="64ad6d38-8757-4f5c-8de7-88361b491d22" msprop:stats_UniqueValueCount="6" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Production_Product" msprop:FriendlyName="Product" msprop:DbTableName="Product" msprop:DbSchemaName="Production" msprop:stats_RowCount="504" msprop:design-time-name="3439ddc9-5265-4f46-8fcf-12419200896f" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="ProductID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:stats_StDevWidth="0.177642" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="ProductID" msprop:design-time-name="8a3d4efb-bf3a-4426-82a5-211352e1ecba" msprop:stats_MaxWidth="3" msprop:stats_UniqueValueCount="504" msprop:stats_AvgWidth="2.984127" msprop:DbColumnName="ProductID" type="xs:int" />
                  <xs:element name="Name" msprop:stats_StDevWidth="6.291431" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="Name" msprop:design-time-name="201b8db9-a50d-434a-bb00-be061a0c2f12" msprop:stats_MaxWidth="32" msprop:stats_UniqueValueCount="504" msprop:stats_AvgWidth="18.40873" msprop:DbColumnName="Name">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="ProductNumber" msprop:stats_StDevWidth="1.420913" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="ProductNumber" msprop:design-time-name="2d22528d-32de-428a-a3a2-88bc04d0c3eb" msprop:stats_MaxWidth="10" msprop:stats_UniqueValueCount="504" msprop:stats_AvgWidth="8.196428" msprop:DbColumnName="ProductNumber">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="25" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="MakeFlag" msprop:FriendlyName="MakeFlag" msprop:DbColumnName="MakeFlag" msprop:stats_UniqueValuePercent="0" msprop:design-time-name="8202646b-d878-4771-a186-e6508a48d353" msprop:stats_UniqueValueCount="2" type="xs:boolean" />
                  <xs:element name="FinishedGoodsFlag" msprop:FriendlyName="FinishedGoodsFlag" msprop:DbColumnName="FinishedGoodsFlag" msprop:stats_UniqueValuePercent="0" msprop:design-time-name="02b4858d-212f-4acd-a36c-538e076e24d5" msprop:stats_UniqueValueCount="2" type="xs:boolean" />
                  <xs:element name="Color" msprop:stats_StDevWidth="1.532086" msprop:stats_UniqueValuePercent="3" msprop:FriendlyName="Color" msprop:design-time-name="7a9c473f-3589-4dec-87f0-ae378ab08062" msprop:stats_MaxWidth="12" msprop:stats_UniqueValueCount="9" msprop:stats_AvgWidth="5.097656" msprop:DbColumnName="Color" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="SafetyStockLevel" msprop:stats_StDevWidth="0.8615158" msprop:stats_UniqueValuePercent="1" msprop:FriendlyName="SafetyStockLevel" msprop:design-time-name="94901f4b-d912-4bcf-93e2-9c0ce5d9130d" msprop:stats_MaxWidth="4" msprop:stats_UniqueValueCount="6" msprop:stats_AvgWidth="3.085317" msprop:DbColumnName="SafetyStockLevel" type="xs:short" />
                  <xs:element name="ReorderPoint" msprop:stats_StDevWidth="0.676942" msprop:stats_UniqueValuePercent="1" msprop:FriendlyName="ReorderPoint" msprop:design-time-name="2a6199e6-012f-4d56-a88d-08fbfa129410" msprop:stats_MaxWidth="3" msprop:stats_UniqueValueCount="6" msprop:stats_AvgWidth="2.583333" msprop:DbColumnName="ReorderPoint" type="xs:short" />
                  <xs:element name="StandardCost" msprop:stats_StDevWidth="1.034936" msprop:stats_AvgScale="1.142857" msprop:stats_UniqueValuePercent="22" msprop:FriendlyName="StandardCost" msprop:design-time-name="33b69f86-7d17-4f44-8942-7148339ec720" msprop:stats_StDevScale="0.958082" msprop:stats_MaxWidth="7" msprop:stats_UniqueValueCount="114" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="5.021825" msprop:DbColumnName="StandardCost" type="xs:decimal" />
                  <xs:element name="ListPrice" msprop:stats_StDevWidth="1.154111" msprop:stats_AvgScale="1.075397" msprop:stats_UniqueValuePercent="20" msprop:FriendlyName="ListPrice" msprop:design-time-name="b4cb5672-87c2-4a28-9c5b-4cd79c3539d9" msprop:stats_StDevScale="0.9407232" msprop:stats_MaxWidth="7" msprop:stats_UniqueValueCount="103" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="5.172619" msprop:DbColumnName="ListPrice" type="xs:decimal" />
                  <xs:element name="Size" msprop:stats_StDevWidth="0.3548675" msprop:stats_UniqueValuePercent="8" msprop:FriendlyName="Size" msprop:design-time-name="b191bfe9-bdf1-40b9-8319-e66650565441" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="18" msprop:stats_AvgWidth="1.853081" msprop:DbColumnName="Size" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="5" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="SizeUnitMeasureCode" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="SizeUnitMeasureCode" msprop:design-time-name="36685ecd-f949-4370-b146-382b8f8e2ef2" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="1" msprop:stats_AvgWidth="2" msprop:DbColumnName="SizeUnitMeasureCode" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="3" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="WeightUnitMeasureCode" msprop:stats_StDevWidth="0.3493521" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="WeightUnitMeasureCode" msprop:design-time-name="f9c9b31e-fb39-4012-8882-eee266abe77a" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="2" msprop:stats_AvgWidth="1.858537" msprop:DbColumnName="WeightUnitMeasureCode" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="3" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Weight" msprop:stats_StDevWidth="0.7046338" msprop:stats_AvgScale="1.478049" msprop:stats_UniqueValuePercent="61" msprop:FriendlyName="Weight" msprop:design-time-name="1380719e-d491-4f5a-9dbb-4a85d019232d" msprop:stats_StDevScale="0.7894874" msprop:stats_MaxWidth="7" msprop:stats_UniqueValueCount="127" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="4.760976" msprop:DbColumnName="Weight" type="xs:decimal" minOccurs="0" />
                  <xs:element name="DaysToManufacture" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="DaysToManufacture" msprop:design-time-name="c31566ee-8cc7-492e-af84-bc962032b195" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="4" msprop:stats_AvgWidth="1" msprop:DbColumnName="DaysToManufacture" type="xs:int" />
                  <xs:element name="ProductLine" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="1" msprop:FriendlyName="ProductLine" msprop:design-time-name="cb4b9df1-3b5a-4e0e-8dd7-70827d6abb33" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="4" msprop:stats_AvgWidth="1" msprop:DbColumnName="ProductLine" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="2" />
                      </xs:restriction>
                    </xs:simpleType>