dimension table 中文意思是什麼
dimension table
解釋
維度表-
The data flow looks up regional codes for territories and writes the results to a dimension table in
數據流查找區域的區域代碼並將結果寫入 -
Each dimension table is directly related to and usually joined to the fact table by a key column
為表定義的屬性，防止可能創建無效數據的數據修改。 -
Loads data from a. csv file into a dimension table in
大容量插入任務將數據從. csv文件加載到 -
Based on the datawarehouse ( dw ) and decision support syst ^ m ( dss ), this paper presents a data warehouse module on a traditional database. the key point of designing a data warehouse is how to design fact table and dimension table
基於數據倉庫和決策支持的系統的原理，本文在傳統數據庫（ mis系統）的基礎上，提出了構建數據倉庫的模型，闡述了如何進行混合型的數據倉庫建模。 -
For example, you might create five data flows, each copying data from a flat file into a different dimension table in a data warehouse star schema
例如，可以創建五個數據流，每個數據流都將數據從平面文件復制到數據倉庫星形架構中的不同維度表中。 -
Thirdly, we need to build up database to keep the data for data mining, and based on the analysis of economic data warehouse, data table and the problems of data granularity, data partition and the structure of data warehouse, we set the star structure of regional macro economic analysis, and we design the fact table and dimension table for data warehouse. so we design and construct economic data warehouse and fulfill economic data entry, transfer, store and management
在這章中我們給出了一個關于pse的數據倉庫屬性的定義，即：數據倉庫是一種來源於各種渠道的單一的、完整的、穩定的、集成的數據存儲，這個儲存的數據本質上是面向主題的、集成的、非易失的和可動態更新的，數據的邏輯形式是提供公式數據和組織數據。 -
Dimension table based on matching
維度表的 -
The fact table is joined with each dimension table on a dimension key. sql server considers special index manipulation strategies on these queries to minimize access to the fact table. 2
其值與同一個表或另一個表中的主鍵（ pk ）或唯一鍵相匹配的列或列的組合，也稱為引用鍵。 -
Combining frequent sets method on 2 - dimension table
基於二維表的頻繁集組合方法 -
Select the main dimension table dimension wizard
選擇主維度表（維度向導） -
Page to select a dimension table to load
頁可以選擇要加載的維度表。 -
To identify promotions and writes the results to a dimension table in
的查詢以標識促銷並將結果寫入 -
Select a dimension table and keys slowly changing dimension wizard
>選擇維度表和鍵（漸變維度向導） -
These attributes appear as attribute hierarchies and can be organized into user - defined hierarchies, or can be defined as parent - child hierarchies based on columns in the underlying dimension table
這些屬性顯示為屬性層次結構，並且可以組織到多級別層次結構中。這些層次結構用於組織多維數據集中包含的度量值。 -
A calculated member corresponds to rows in the dimension table in the dimension in which they are defined
這些表有一個列維度和一個行維度。 -
Redesign and realize the clear up and upfront work of data source according to new demands is unbearable on waste of time and manpower. the article described development and analysis status of ubisp ( united business information service platform ) system, analyzed the extract strategy and optimized algorithm of etl rules, discussed the data capacity and granularity selection in dw modeling, raised an idea of how to sub divide dimension table and fact table ' s granularity by compound primary key aimed at above question
本論文介紹了該電信公司經營分析數據倉庫系統的開發與研究現狀，分析了etl規則的抽取策略和優化演算法，討論了數據倉庫建模中的數據量估算和粒度選擇，並針對上面的問題提出了利用復合主鍵和橫表縱表之間的轉換實現維表和事實表粒度向下細分的思想，即在不修改源數據提供系統的情況下，最大限度的利用已有的數據實現新的需求。 -
The paper systematically discussed design and implement steps on multi - dimensions data model, the interlink between data warehouse and multi - sources, the capture of changed data, the increased - load of dimension table and the data cleaning by specific examples
系統的分析並舉例說明了多維數據模型設計，數據倉庫與多數據源互聯，變化數據捕捉，維表增量加載，數據清洗等技術要點的設計與具體實現步驟。 -
And writes the results to a dimension table in
中的維度表。 -
Select a dimension table and keys
「選擇維度表和鍵」 -
For example, a series of named queries can be used to split up a complex dimension table into smaller, simpler dimension tables for use in database dimensions
例如，可以使用一系列命名查詢將一個復雜的維度表分割為幾個較小、較簡單的維度表以便在數據庫維度中使用。
分享友人