⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 foodmartsale as.asdatabase

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页　数： 383 出 版 社： 电子工业
💻 ASDATABASE
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
      </Source>
      <UnknownMember>Visible</UnknownMember>
      <CurrentStorageMode>Molap</CurrentStorageMode>
      <Attributes>
        <Attribute>
          <ID>Customer</ID>
          <Name>Customer</Name>
          <Usage>Key</Usage>
          <KeyColumns>
            <KeyColumn>
              <NullProcessing>UnknownMember</NullProcessing>
              <DataType>Integer</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>customer_id</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <AttributeRelationships>
            <AttributeRelationship>
              <AttributeID>Account Num</AttributeID>
              <Name>Account Num</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Lname</AttributeID>
              <Name>Lname</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Fname</AttributeID>
              <Name>Fname</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Mi</AttributeID>
              <Name>Mi</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Address1</AttributeID>
              <Name>Address1</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Address2</AttributeID>
              <Name>Address2</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Address3</AttributeID>
              <Name>Address3</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Address4</AttributeID>
              <Name>Address4</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>City</AttributeID>
              <Name>City</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>State Province</AttributeID>
              <Name>State Province</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Postal Code</AttributeID>
              <Name>Postal Code</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Country</AttributeID>
              <Name>Country</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Customer Region Id</AttributeID>
              <Name>Customer Region Id</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Phone1</AttributeID>
              <Name>Phone1</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Phone2</AttributeID>
              <Name>Phone2</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Birthdate</AttributeID>
              <Name>Birthdate</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Marital Status</AttributeID>
              <Name>Marital Status</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Yearly Income</AttributeID>
              <Name>Yearly Income</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Gender</AttributeID>
              <Name>Gender</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Total Children</AttributeID>
              <Name>Total Children</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Num Children At Home</AttributeID>
              <Name>Num Children At Home</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Education</AttributeID>
              <Name>Education</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Date Accnt Opened</AttributeID>
              <Name>Date Accnt Opened</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Member Card</AttributeID>
              <Name>Member Card</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Occupation</AttributeID>
              <Name>Occupation</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Houseowner</AttributeID>
              <Name>Houseowner</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Num Cars Owned</AttributeID>
              <Name>Num Cars Owned</Name>
            </AttributeRelationship>
          </AttributeRelationships>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>MandatoryFilter</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Account Num</ID>
          <Name>Account Num</Name>
          <KeyColumns>
            <KeyColumn>
              <DataType>Double</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>account_num</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>MandatoryFilter</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Lname</ID>
          <Name>Lname</Name>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>100</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>lname</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>MandatoryFilter</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Fname</ID>
          <Name>Fname</Name>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>50</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>fname</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>MandatoryFilter</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Mi</ID>
          <Name>Mi</Name>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>20</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>mi</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>FilteredList</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Address1</ID>
          <Name>Address1</Name>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>100</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>address1</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>MandatoryFilter</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Address2</ID>
          <Name>Address2</Name>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>100</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>address2</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>MandatoryFilter</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Address3</ID>
          <Name>Address3</Name>
          <EstimatedCount>1</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>100</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>address3</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Address4</ID>
          <Name>Address4</Name>
          <EstimatedCount>1</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>100</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>address4</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>City</ID>
          <Name>City</Name>
          <EstimatedCount>108</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>50</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>city</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>List</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>State Province</ID>
          <Name>State Province</Name>
          <EstimatedCount>13</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>50</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>state_province</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Postal Code</ID>
          <Name>Postal Code</Name>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>50</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>postal_code</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>MandatoryFilter</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Country</ID>
          <Name>Country</Name>
          <EstimatedCount>3</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>50</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>country</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Customer Region Id</ID>
          <Name>Customer Region Id</Name>
          <EstimatedCount>109</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Integer</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
                <ColumnID>customer_region_id</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>List</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Phone1</ID>
          <Name>Phone1</Name>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>50</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_customer</TableID>
12345

⌨️ 快捷键说明

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