modeldemo.dsv

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

<DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ID>Adventure Works</ID>
  <Name>Adventure Works</Name>
  <Annotations xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
      <Value>true</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CurrentLayout</Name>
      <Value>_ALL_TABLES_</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:SchemaRestriction</Name>
      <Value>
      </Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:RetrieveRelationships</Name>
      <Value>true</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:Layouts</Name>
      <Value>
        <Layouts xmlns="">
          <Diagram>
            <Name>_ALL_TABLES_</Name>
            <DiagramLayout />
            <ShowRelationshipNames>False</ShowRelationshipNames>
            <UseDiagramDefaultLayout>True</UseDiagramDefaultLayout>
            <DiagramViewPortLeft>0</DiagramViewPortLeft>
            <DiagramViewPortTop>0</DiagramViewPortTop>
            <DiagramBoundingLeft>0</DiagramBoundingLeft>
            <DiagramBoundingTop>0</DiagramBoundingTop>
            <DiagramZoom>100</DiagramZoom>
          </Diagram>
        </Layouts>
      </Value>
    </Annotation>
  </Annotations>
  <DataSourceID>Adventure Works</DataSourceID>
  <Schema>
    <xs:schema id="Adventure_x0020_Works" 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">
      <xs:element name="Adventure_x0020_Works" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:design-time-name="46997193-ba75-43af-b30c-8c2e8a26e6a0" msprop:CompareInfo="&lt;CompareInfo&gt;&lt;Culture&gt;en-US&lt;/Culture&gt;&lt;IgnoreKanaType&gt;true&lt;/IgnoreKanaType&gt;&lt;IgnoreWidth&gt;true&lt;/IgnoreWidth&gt;&lt;/CompareInfo&gt;">
        <xs:complexType>
          <xs:choice minOccurs="0" maxOccurs="unbounded">
            <xs:element name="Sales_Customer" msprop:FriendlyName="Customer" msprop:DbTableName="Customer" msprop:DbSchemaName="Sales" msprop:stats_RowCount="19185" msprop:design-time-name="d2df066d-8900-47bd-8ca8-7dbe07034d69" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="CustomerID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:stats_StDevWidth="0.411163" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="CustomerID" msprop:design-time-name="9f68abd4-8b04-4604-893a-f17d193fa54f" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="19185" msprop:stats_AvgWidth="4.921293" msprop:DbColumnName="CustomerID" type="xs:int" />
                  <xs:element name="TerritoryID" msprop:stats_StDevWidth="0.3023907" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="TerritoryID" msprop:design-time-name="0ddb01f7-56c3-4b5c-a023-e2dc5f7b1b0d" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="10" msprop:stats_AvgWidth="1.101798" msprop:DbColumnName="TerritoryID" type="xs:int" minOccurs="0" />
                  <xs:element name="AccountNumber" msdata:ReadOnly="true" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="AccountNumber" msprop:design-time-name="5a5b1107-4a7a-4411-a376-f6774306fa73" msprop:stats_MaxWidth="10" msprop:stats_UniqueValueCount="19185" msprop:stats_AvgWidth="10" msprop:DbColumnName="AccountNumber">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="10" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="CustomerType" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="CustomerType" msprop:design-time-name="04c75f09-1cf7-403a-b91b-8cdf54ffef42" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="2" msprop:stats_AvgWidth="1" msprop:DbColumnName="CustomerType">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <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="0bdb2119-e7aa-4e6c-af6a-2c8f8c2d5f4e" msprop:stats_MaxWidth="36" msprop:stats_UniqueValueCount="19185" msprop:stats_AvgWidth="36" msprop:DbColumnName="rowguid" type="xs:string" />
                  <xs:element name="ModifiedDate" msprop:FriendlyName="ModifiedDate" msprop:DbColumnName="ModifiedDate" msprop:stats_UniqueValuePercent="0" msprop:design-time-name="a04ee6ec-6240-4f21-8164-226a9287d018" msprop:stats_UniqueValueCount="1" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Sales_Store" msprop:FriendlyName="Store" msprop:DbTableName="Store" msprop:DbSchemaName="Sales" msprop:stats_RowCount="701" msprop:design-time-name="3e24b480-654b-43fd-ba10-4e30a13e30b8" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="CustomerID" msprop:stats_StDevWidth="0.3952593" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="CustomerID" msprop:design-time-name="850d085e-5a16-41c4-9fa9-26a26e638c59" msprop:stats_MaxWidth="3" msprop:stats_UniqueValueCount="701" msprop:stats_AvgWidth="2.845934" msprop:DbColumnName="CustomerID" type="xs:int" />
                  <xs:element name="Name" msprop:stats_StDevWidth="5.441792" msprop:stats_UniqueValuePercent="99" msprop:FriendlyName="Name" msprop:design-time-name="22e0d238-3dff-4cb8-ad76-83de003479a3" msprop:stats_MaxWidth="41" msprop:stats_UniqueValueCount="699" msprop:stats_AvgWidth="20.1184" msprop:DbColumnName="Name">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="SalesPersonID" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="1" msprop:FriendlyName="SalesPersonID" msprop:design-time-name="7e8b1b41-93f5-48dc-a7fc-d1582515476b" msprop:stats_MaxWidth="3" msprop:stats_UniqueValueCount="13" msprop:stats_AvgWidth="3" msprop:DbColumnName="SalesPersonID" type="xs:int" minOccurs="0" />
                  <xs:element name="Demographics" msprop:FriendlyName="Demographics" msprop:DbColumnName="Demographics" msprop:stats_UniqueValuePercent="100" msprop:design-time-name="bd908b5c-fe19-4204-b0c0-6137c17a7e07" msprop:stats_UniqueValueCount="701" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="2147483647" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <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="e0f539f8-edc9-4533-b9d8-eed3574dbe6e" msprop:stats_MaxWidth="36" msprop:stats_UniqueValueCount="701" msprop:stats_AvgWidth="36" msprop:DbColumnName="rowguid" type="xs:string" />
                  <xs:element name="ModifiedDate" msprop:FriendlyName="ModifiedDate" msprop:DbColumnName="ModifiedDate" msprop:stats_UniqueValuePercent="0" msprop:design-time-name="773105ee-cd84-4a3d-b1b8-aed26eb005f6" msprop:stats_UniqueValueCount="1" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Sales_Individual" msprop:FriendlyName="Individual" msprop:DbTableName="Individual" msprop:DbSchemaName="Sales" msprop:stats_RowCount="18484" msprop:design-time-name="d8fc0bc7-f149-4287-ab1c-6738e4903ec1" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="CustomerID" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="CustomerID" msprop:design-time-name="5a5c13c0-a44e-440f-892c-2051184de057" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="18484" msprop:stats_AvgWidth="5" msprop:DbColumnName="CustomerID" type="xs:int" />
                  <xs:element name="ContactID" msprop:stats_StDevWidth="0.5080184" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="ContactID" msprop:design-time-name="28804f38-a0b0-4b6b-9ef0-d99880e382ea" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="18484" msprop:stats_AvgWidth="4.535166" msprop:DbColumnName="ContactID" type="xs:int" />
                  <xs:element name="Demographics" msprop:FriendlyName="Demographics" msprop:DbColumnName="Demographics" msprop:stats_UniqueValuePercent="100" msprop:design-time-name="fee292f8-9cfe-4ba4-a721-0266af93d649" msprop:stats_UniqueValueCount="18484" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="2147483647" />
                      </xs:restriction>