data mining cross-sell.asdatabase

来自「数据仓库开发的很好的一个例子」· ASDATABASE 代码 · 共 831 行 · 第 1/4 页
ASDATABASE
831 行
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="Gender" msprop:FriendlyName="Gender" msprop:DbColumnName="Gender" msprop:design-time-name="2d3d0def-9398-444f-b713-3ff497e26e21" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="1" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="YearlyIncome" msprop:FriendlyName="YearlyIncome" msprop:DbColumnName="YearlyIncome" msprop:design-time-name="3d640acb-20ee-47b3-9c1b-be348213318c" type="xs:decimal" minOccurs="0" />
                      <xs:element name="TotalChildren" msprop:FriendlyName="TotalChildren" msprop:DbColumnName="TotalChildren" msprop:design-time-name="ef45fd7d-0822-423d-82dd-24c5e3a4d6c8" type="xs:unsignedByte" minOccurs="0" />
                      <xs:element name="NumberChildrenAtHome" msprop:FriendlyName="NumberChildrenAtHome" msprop:DbColumnName="NumberChildrenAtHome" msprop:design-time-name="4edfafee-cd04-4269-853c-7074f432b088" type="xs:unsignedByte" minOccurs="0" />
                      <xs:element name="EnglishEducation" msprop:FriendlyName="EnglishEducation" msprop:DbColumnName="EnglishEducation" msprop:design-time-name="ffd32a22-f295-4f09-91f2-c89a8866034e" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="40" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="EnglishOccupation" msprop:FriendlyName="EnglishOccupation" msprop:DbColumnName="EnglishOccupation" msprop:design-time-name="82e54b74-4ca5-4b38-808e-7bc08113c5bf" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="100" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="HouseOwnerFlag" msprop:FriendlyName="HouseOwnerFlag" msprop:DbColumnName="HouseOwnerFlag" msprop:design-time-name="e5cbcd0e-8793-4ca7-be47-e1696ee1423c" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="1" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="NumberCarsOwned" msprop:FriendlyName="NumberCarsOwned" msprop:DbColumnName="NumberCarsOwned" msprop:design-time-name="18a70eee-ddb0-428a-84c9-95d7b7835725" type="xs:unsignedByte" minOccurs="0" />
                      <xs:element name="DateFirstPurchase" msprop:FriendlyName="DateFirstPurchase" msprop:DbColumnName="DateFirstPurchase" msprop:design-time-name="13011206-c029-4e6d-9144-1201af9b06b1" type="xs:dateTime" minOccurs="0" />
                      <xs:element name="CommuteDistance" msprop:FriendlyName="CommuteDistance" msprop:DbColumnName="CommuteDistance" msprop:design-time-name="aa7013d8-6bac-4b4e-b212-e8a6149a1152" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="15" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="StateProvinceName" msprop:FriendlyName="StateProvinceName" msprop:DbColumnName="StateProvinceName" msprop:design-time-name="5ed94aae-e6a2-4c4e-a976-b6acf5839e09" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="50" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="EnglishCountryRegionName" msprop:FriendlyName="EnglishCountryRegionName" msprop:DbColumnName="EnglishCountryRegionName" msprop:design-time-name="7aedb498-0cc3-4bbf-9699-e22b5e914310" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="50" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="PostalCode" msprop:FriendlyName="PostalCode" msprop:DbColumnName="PostalCode" msprop:design-time-name="7f88634f-2a11-4a0f-b46c-e38579cc834e" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="15" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="City" msprop:FriendlyName="City" msprop:DbColumnName="City" msprop:design-time-name="a013827e-7cc9-47cc-9524-29305687f3c3" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="30" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                    </xs:sequence>
                  </xs:complexType>
                </xs:element>
                <xs:element name="DMDemoCustAll" msprop:QueryDefinition="SELECT CustomerKey, FirstName, MiddleName, LastName, NameStyle, BirthDate, MaritalStatus, Gender, YearlyIncome, TotalChildren, NumberChildrenAtHome, EnglishEducation, EnglishOccupation, HouseOwnerFlag, NumberCarsOwned, DateFirstPurchase, CommuteDistance, &#xD;&#xA;          StateProvinceName, EnglishCountryRegionName, PostalCode, City&#xD;&#xA;FROM   DMDemoCustTest&#xD;&#xA;UNION&#xD;&#xA;SELECT CustomerKey, FirstName, MiddleName, LastName, NameStyle, BirthDate, MaritalStatus, Gender, YearlyIncome, TotalChildren, NumberChildrenAtHome, EnglishEducation, EnglishOccupation, HouseOwnerFlag, NumberCarsOwned, DateFirstPurchase, CommuteDistance, &#xD;&#xA;          StateProvinceName, EnglishCountryRegionName, PostalCode, City&#xD;&#xA;FROM   DMDemoCustTrain" msprop:DbTableName="DMDemoCustAll" msprop:QueryBuilder="SpecificQueryBuilder" msprop:IsLogical="True" msprop:FriendlyName="DMDemoCustAll" msprop:design-time-name="2c035280-8b17-49bf-8537-7331c1edb394" msprop:TableType="View" msprop:Description="">
                  <xs:complexType>
                    <xs:sequence>
                      <xs:element name="CustomerKey" msdata:ReadOnly="true" msprop:FriendlyName="CustomerKey" msprop:DbColumnName="CustomerKey" msprop:design-time-name="b244528c-9c0d-426a-a9ad-8b634c9d77d6" type="xs:int" />
                      <xs:element name="FirstName" msdata:ReadOnly="true" msprop:FriendlyName="FirstName" msprop:DbColumnName="FirstName" msprop:design-time-name="fa1893a8-91ab-4ea1-b052-9065e3918b5c" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="50" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="MiddleName" msdata:ReadOnly="true" msprop:FriendlyName="MiddleName" msprop:DbColumnName="MiddleName" msprop:design-time-name="12c22465-6039-4041-b9ef-1459b10652d9" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="50" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="LastName" msdata:ReadOnly="true" msprop:FriendlyName="LastName" msprop:DbColumnName="LastName" msprop:design-time-name="37d4eeef-8422-43af-af92-6a460aaca572" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="50" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="NameStyle" msdata:ReadOnly="true" msprop:FriendlyName="NameStyle" msprop:DbColumnName="NameStyle" msprop:design-time-name="dca4ee2d-6a5c-4803-a2ae-6c50fa9f2f3a" type="xs:boolean" minOccurs="0" />
                      <xs:element name="BirthDate" msdata:ReadOnly="true" msprop:FriendlyName="BirthDate" msprop:DbColumnName="BirthDate" msprop:design-time-name="f4a7ff3c-b41f-4685-b48c-f39053b6211b" type="xs:dateTime" minOccurs="0" />
                      <xs:element name="MaritalStatus" msdata:ReadOnly="true" msprop:FriendlyName="MaritalStatus" msprop:DbColumnName="MaritalStatus" msprop:design-time-name="35fcfe4e-267b-4faa-b728-2828d98b3cb1" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="1" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="Gender" msdata:ReadOnly="true" msprop:FriendlyName="Gender" msprop:DbColumnName="Gender" msprop:design-time-name="363c5975-28d3-4c54-b8f6-916d135569ad" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="1" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="YearlyIncome" msdata:ReadOnly="true" msprop:FriendlyName="YearlyIncome" msprop:DbColumnName="YearlyIncome" msprop:design-time-name="72aacaf2-fdc9-472e-830a-4788bd2768b2" type="xs:decimal" minOccurs="0" />
                      <xs:element name="TotalChildren" msdata:ReadOnly="true" msprop:FriendlyName="TotalChildren" msprop:DbColumnName="TotalChildren" msprop:design-time-name="e1a391a7-10b5-4f99-9d28-13f81a9717bc" type="xs:unsignedByte" minOccurs="0" />
                      <xs:element name="NumberChildrenAtHome" msdata:ReadOnly="true" msprop:FriendlyName="NumberChildrenAtHome" msprop:DbColumnName="NumberChildrenAtHome" msprop:design-time-name="5236ab17-053d-4c64-9b57-3e1f0708db87" type="xs:unsignedByte" minOccurs="0" />
                      <xs:element name="EnglishEducation" msdata:ReadOnly="true" msprop:FriendlyName="EnglishEducation" msprop:DbColumnName="EnglishEducation" msprop:design-time-name="59df3b66-d44b-4650-9bc2-7fe8ce76db92" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="40" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="EnglishOccupation" msdata:ReadOnly="true" msprop:FriendlyName="EnglishOccupation" msprop:DbColumnName="EnglishOccupation" msprop:design-time-name="f330e677-aa51-4ba5-acd4-3f7c54fba0ae" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="100" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="HouseOwnerFlag" msdata:ReadOnly="true" msprop:FriendlyName="HouseOwnerFlag" msprop:DbColumnName="HouseOwnerFlag" msprop:design-time-name="e405501d-7062-46fb-9fb5-8b5df64a2dbc" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="1" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="NumberCarsOwned" msdata:ReadOnly="true" msprop:FriendlyName="NumberCarsOwned" msprop:DbColumnName="NumberCarsOwned" msprop:design-time-name="30ab4c07-2d46-47d5-a522-7a6bf4452065" type="xs:unsignedByte" minOccurs="0" />
                      <xs:element name="DateFirstPurchase" msdata:ReadOnly="true" msprop:FriendlyName="DateFirstPurchase" msprop:DbColumnName="DateFirstPurchase" msprop:design-time-name="fce154b7-d762-438c-b3f7-04055a163ff4" type="xs:dateTime" minOccurs="0" />
                      <xs:element name="CommuteDistance" msdata:ReadOnly="true" msprop:FriendlyName="CommuteDistance" msprop:DbColumnName="CommuteDistance" msprop:design-time-name="e7a665fe-8c20-4134-88a4-cdd505f4e531" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="15" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="StateProvinceName" msdata:ReadOnly="true" msprop:FriendlyName="StateProvinceName" msprop:DbColumnName="StateProvinceName" msprop:design-time-name="5a874fcf-f36b-41dc-9475-c767e13789c5" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="50" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="EnglishCountryRegionName" msdata:ReadOnly="true" msprop:FriendlyName="EnglishCountryRegionName" msprop:DbColumnName="EnglishCountryRegionName" msprop:design-time-name="e5486867-39e7-4ac8-be23-151497e4c010" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="50" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="PostalCode" msdata:ReadOnly="true" msprop:FriendlyName="PostalCode" msprop:DbColumnName="PostalCode" msprop:design-time-name="3e67bc0a-8e51-497e-99ce-9ecaf38e57b5" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="15" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                      <xs:element name="City" msdata:ReadOnly="true" msprop:FriendlyName="City" msprop:DbColumnName="City" msprop:design-time-name="19287f6c-7c02-4130-8ab0-0acaf3886733" minOccurs="0">
                        <xs:simpleType>
                          <xs:restriction base="xs:string">
                            <xs:maxLength value="30" />
                          </xs:restriction>
                        </xs:simpleType>
                      </xs:element>
                    </xs:sequence>
                  </xs:complexType>
                </xs:element>
              </xs:choice>
            </xs:complexType>
            <xs:unique name="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
              <xs:selector xpath=".//dbo_DMDemoCustTest" />
              <xs:field xpath="CustomerKey" />
            </xs:unique>
            <xs:unique name="dbo_DMDemoCustTrain_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
              <xs:selector xpath=".//dbo_DMDemoCustTrain" />
              <xs:field xpath="CustomerKey" />
            </xs:unique>
            <xs:unique name="DMDemoCustAll_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
              <xs:selector xpath=".//DMDemoCustAll" />
              <xs:field xpath="CustomerKey" />
            </xs:unique>
          </xs:element>
          <xs:annotation>
            <xs:appinfo>
              <msdata:Relationship name="DMDemoCustPurch-DMDemoCustTest" msdata:parent="dbo_DMDemoCustTest" msdata:child="dbo_DMDemoCustPurch" msdata:parentkey="CustomerKey" msdata:childkey="CustomerKey" msprop:Description="" msprop:IsLogical="True" />
              <msdata:Relationship name="DMDemoCustPurch-DMDemoCustTrain" msdata:parent="dbo_DMDemoCustTrain" msdata:child="dbo_DMDemoCustPurch" msdata:parentkey="CustomerKey" msdata:childkey="CustomerKey" msprop:Description="" msprop:IsLogical="True" />
              <msdata:Relationship name="DMDemoCustPurch-DMDemoCustAll" msdata:parent="DMDemoCustAll" msdata:child="dbo_DMDemoCustPurch" msdata:parentkey="CustomerKey" msdata:childkey="CustomerKey" msprop:Description="" msprop:IsLogical="True" />
            </xs:appinfo>
          </xs:annotation>
        </xs:schema>
        <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" />
      </Schema>
    </DataSourceView>
  </DataSourceViews>
</Database>
data mining cross-sell.asdatabase - 源码说明

本页面展示了「数据仓库开发的很好的一个例子」中的 data mining cross-sell.asdatabase 源码文件，采用 ASDATABASE 编程语言编写，共 831 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。
虫虫开发者社区收录了大量与数据仓库相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。
⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?