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

📄 foodmartsale as.asdatabase

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页　数： 383 出 版 社： 电子工业
💻 ASDATABASE
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Media Type</ID>
          <Name>Media Type</Name>
          <EstimatedCount>14</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>255</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_promotion</TableID>
                <ColumnID>media_type</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Cost</ID>
          <Name>Cost</Name>
          <EstimatedCount>1711</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Double</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_promotion</TableID>
                <ColumnID>cost</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>FilteredList</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Start Date</ID>
          <Name>Start Date</Name>
          <EstimatedCount>313</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Date</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_promotion</TableID>
                <ColumnID>start_date</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>List</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>End Date</ID>
          <Name>End Date</Name>
          <EstimatedCount>469</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Date</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_promotion</TableID>
                <ColumnID>end_date</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>List</InstanceSelection>
        </Attribute>
      </Attributes>
    </Dimension>
    <Dimension>
      <ID>Store</ID>
      <Name>Store</Name>
      <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
      <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
      <Annotations>
        <Annotation>
          <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>
        </Annotation>
        <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:ShowRelationshipNames</Name>
          <Value>false</Value>
        </Annotation>
        <Annotation>
          <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
          <Value>true</Value>
        </Annotation>
        <Annotation>
          <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
          <Value>0</Value>
        </Annotation>
        <Annotation>
          <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
          <Value>0</Value>
        </Annotation>
        <Annotation>
          <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
          <Value>0</Value>
        </Annotation>
        <Annotation>
          <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
          <Value>0</Value>
        </Annotation>
        <Annotation>
          <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
          <Value>100</Value>
        </Annotation>
      </Annotations>
      <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
      <State>Unprocessed</State>
      <Source xsi:type="DataSourceViewBinding">
        <DataSourceViewID>Foodmartsale DW</DataSourceViewID>
      </Source>
      <UnknownMember>Visible</UnknownMember>
      <CurrentStorageMode>Molap</CurrentStorageMode>
      <Attributes>
        <Attribute>
          <ID>Store</ID>
          <Name>Store</Name>
          <Usage>Key</Usage>
          <EstimatedCount>25</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <NullProcessing>UnknownMember</NullProcessing>
              <DataType>Integer</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_store</TableID>
                <ColumnID>store_id</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <AttributeRelationships>
            <AttributeRelationship>
              <AttributeID>Store Type</AttributeID>
              <Name>Store Type</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Region Id</AttributeID>
              <Name>Region Id</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Store Name</AttributeID>
              <Name>Store Name</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Store Number</AttributeID>
              <Name>Store Number</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Store Street Address</AttributeID>
              <Name>Store Street Address</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Store City</AttributeID>
              <Name>Store City</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Store State</AttributeID>
              <Name>Store State</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Store Postal Code</AttributeID>
              <Name>Store Postal Code</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Store Country</AttributeID>
              <Name>Store Country</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Store Manager</AttributeID>
              <Name>Store Manager</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Store Phone</AttributeID>
              <Name>Store Phone</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Store Fax</AttributeID>
              <Name>Store Fax</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>First Opened Date</AttributeID>
              <Name>First Opened Date</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Last Remodel Date</AttributeID>
              <Name>Last Remodel Date</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Lease Sqft</AttributeID>
              <Name>Lease Sqft</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Store Sqft</AttributeID>
              <Name>Store Sqft</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Grocery Sqft</AttributeID>
              <Name>Grocery Sqft</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Frozen Sqft</AttributeID>
              <Name>Frozen Sqft</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Meat Sqft</AttributeID>
              <Name>Meat Sqft</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Coffee Bar</AttributeID>
              <Name>Coffee Bar</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Video Store</AttributeID>
              <Name>Video Store</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Salad Bar</AttributeID>
              <Name>Salad Bar</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Prepared Food</AttributeID>
              <Name>Prepared Food</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Florist</AttributeID>
              <Name>Florist</Name>
            </AttributeRelationship>
          </AttributeRelationships>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Store Type</ID>
          <Name>Store Type</Name>
          <EstimatedCount>6</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>255</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_store</TableID>
                <ColumnID>store_type</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Region Id</ID>
          <Name>Region Id</Name>
          <EstimatedCount>24</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Integer</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_store</TableID>
                <ColumnID>region_id</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Store Name</ID>
          <Name>Store Name</Name>
          <EstimatedCount>25</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>255</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_store</TableID>
                <ColumnID>store_name</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Store Number</ID>
          <Name>Store Number</Name>
          <EstimatedCount>25</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Double</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_store</TableID>
                <ColumnID>store_number</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Store Street Address</ID>
          <Name>Store Street Address</Name>
          <EstimatedCount>25</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>255</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_store</TableID>
                <ColumnID>store_street_address</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Store City</ID>
          <Name>Store City</Name>
          <EstimatedCount>24</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>50</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_store</TableID>
                <ColumnID>store_city</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Store State</ID>
          <Name>Store State</Name>
          <EstimatedCount>10</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>50</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_store</TableID>
                <ColumnID>store_state</ColumnID>
              </Source>
            </KeyColumn>
12345

⌨️ 快捷键说明

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