【正文】 Actuate Confidential 5/4/2020 中國(guó)外匯交易中心數(shù)據(jù)倉(cāng)庫(kù)一期項(xiàng)目 建議 第二冊(cè) 技術(shù)部分 安訊軟件（上海）有限公司 2020 年 5 月 4 日 Actuate Confidential 5/4/2020 目錄 1 項(xiàng)目目標(biāo) ........................................................................................................................1 2 技術(shù)解決方案 .................................................................................................................2 系統(tǒng)總體架構(gòu) ...................................................................................................2 邏輯架構(gòu) ...................................................................................................2 功能層面（上側(cè)面） .........................................................................2 非功能層面（右側(cè)面） .....................................................................3 設(shè)計(jì)層面 ...................................................................................................3 ETL 數(shù)據(jù)抽取 .....................................................................................3 報(bào)表設(shè) 計(jì) ...........................................................................................3 報(bào)表展現(xiàn) ...........................................................................................3 報(bào)表應(yīng)用 ...........................................................................................3 物理架構(gòu) ...................................................................................................3 數(shù)據(jù)架構(gòu) ...................................................................................................5 系統(tǒng)技術(shù)實(shí)現(xiàn)方案 ...........................................................................................6 總體技術(shù)實(shí)現(xiàn)方案 ....................................................................................6 高效的 ETL 處理 .......................................................................................7 ETL 總體處理流程 .............................................................................7 數(shù)據(jù)倉(cāng)庫(kù)模型設(shè)計(jì) .............................................................................9 數(shù)據(jù)質(zhì)量管理 .......................................................................................... 10 數(shù)據(jù)倉(cāng)庫(kù)對(duì)數(shù)據(jù)質(zhì)量的要求 ............................................................ 10 數(shù)據(jù)質(zhì)量改進(jìn)目標(biāo) ........................................................................... 10 數(shù)據(jù)質(zhì)量改進(jìn)方法 ........................................................................... 10 報(bào)表平臺(tái)設(shè)計(jì) .......................................................................................... 11 靈活的報(bào)表查詢 .............................................................................. 12 先進(jìn)的報(bào)表開(kāi)發(fā)模式 ....................................................................... 12 高效的報(bào)表消費(fèi) .............................................................................. 12 老系統(tǒng)統(tǒng)計(jì)報(bào)表移植 ....................................................................... 12 認(rèn)證管理 ................................................................................................. 13 系統(tǒng)可靠性及可擴(kuò)展性 ........................................................................... 13 Actuate Confidential 5/4/2020 非功能性設(shè)計(jì) .......................................................................................... 14 性能 需求 ......................................................................................... 14 災(zāi)備設(shè)計(jì) ......................................................................................... 15 可獲性設(shè)計(jì) ...................................................................................... 17 易用性設(shè)計(jì) ...................................................................................... 17 安全性設(shè)計(jì) ...................................................................................... 18 3 項(xiàng)目管理 ...................................................................................................................... 19 溝通管理 ........................................................................................................ 19 項(xiàng)目會(huì)議制度 .......................................................................................... 19 定期會(huì)議 ......................................................................................... 20 不定期會(huì)議 ...................................................................................... 20 項(xiàng)目狀態(tài)周報(bào)制度 .................................................................................. 21 溝通手段 ................................................................................................. 21 配置管理 ........................................................................................................ 22 配置管理原則 .......................................................................................... 22 配置庫(kù)管理 ............................................................................................. 22 變更管理 ........................................................................................................ 22 發(fā)起變更 ................................................................................................. 22 評(píng)估變更 ................................................................................................. 23 審批變更 ................................................................................................. 23 執(zhí)行變更 ...........................................................