【正文】 1 / 80附件一紹興電信綜合營(yíng)銷(xiāo)系統(tǒng)（IMS）――方案建議2 / 80目 錄1 系統(tǒng)綜述 ..........................................................................................................................................62 系統(tǒng)總體設(shè)計(jì) ..................................................................................................................................7 建設(shè)策略建議 ........................................................................................................................7 集中解決目前急需問(wèn)題 ....................................................................................................7 以客戶(hù)為中心建立數(shù)據(jù)集市 ............................................................................................7 簡(jiǎn)化數(shù)據(jù)來(lái)源 ....................................................................................................................8 功能上應(yīng)有取有舍 ............................................................................................................8 以數(shù)據(jù)集市為核心組織基礎(chǔ)數(shù)據(jù) ....................................................................................8 系統(tǒng)建設(shè)原則 ........................................................................................................................9 系統(tǒng)的業(yè)務(wù)架構(gòu) ..................................................................................................................10 以針對(duì)性營(yíng)銷(xiāo)為核心的分析架構(gòu) ..................................................................................10 以營(yíng)銷(xiāo)自動(dòng)化為核心的處理架構(gòu) ..................................................................................11 以多角色支持為核心的界面架構(gòu) ..................................................................................11 系統(tǒng)的技術(shù)架構(gòu) ..................................................................................................................12 數(shù)據(jù)獲取層 ......................................................................................................................13 數(shù)據(jù)存儲(chǔ)層 ......................................................................................................................13 數(shù)據(jù)展現(xiàn)層 ......................................................................................................................14 元數(shù)據(jù) ..............................................................................................................................15 系統(tǒng)功能結(jié)構(gòu) ......................................................................................................................153 數(shù)據(jù)獲取層 ....................................................................................................................................16 數(shù)據(jù)源分析 ..........................................................................................................................16 系統(tǒng)接口分析 ..................................................................................................................16 ETL 過(guò)程 ...................................................................................................................................19 數(shù)據(jù)抽取 ..........................................................................................................................20 數(shù)據(jù)轉(zhuǎn)換 ..........................................................................................................................21 數(shù)據(jù)加載 ..........................................................................................................................23 數(shù)據(jù)審核 ..........................................................................................................................233 / 80 ETL 過(guò)程管理 ..................................................................................................................24 ETL 具體實(shí)現(xiàn) ..................................................................................................................254 數(shù)據(jù)存儲(chǔ)層 ....................................................................................................................................27 數(shù)據(jù)倉(cāng)庫(kù)信息模型設(shè)計(jì)原則 ..............................................................................................27 模型設(shè)計(jì)方法 ......................................................................................................................27 數(shù)據(jù)倉(cāng)庫(kù)信息模型 ..............................................................................................................29 數(shù)據(jù)集市構(gòu)建方法 ..............................................................................................................31 OLAP 分析模型 ........................................................................................................................32 OLAP 分析模型建模方法 ...............................................................................................32 OLAP 分析技術(shù)實(shí)現(xiàn)方法 ...............................................................................................32 客戶(hù)情況分析模型 ..........................................................................................................34 業(yè)務(wù)發(fā)展分析模型 ..........................................................................................................34 收益情況分析模型 ..........................................................................................................35 市場(chǎng)競(jìng)爭(zhēng)分析模型 ..........................................................................................................365 數(shù)據(jù)展現(xiàn)層 ....................................................................................................................................37 綜合查詢(xún) ..............................................................................................................................37 自定義查詢(xún)功能 ..............................................................................................................37 主題查詢(xún)功能 ..................................................................................................................37 即席查詢(xún)功能 ..................................................................................................................38 統(tǒng)計(jì)分析報(bào)表 ...................................