【正文】 財達(dá)證券有限責(zé)任公司數(shù)據(jù)中心建設(shè) 項(xiàng)目投標(biāo)書 第 II 頁 1 總體概述 ..............................................................................................................................................................9 項(xiàng)目背景 ....................................................................................................................................................9 總體設(shè)計目標(biāo) ............................................................................................................................................9 階段建設(shè)目標(biāo) ............................................................................................................................................9 系統(tǒng)范圍 ................................................................................................................................................. 10 2 整體解決方案 ....................................................................................................................................................11 總體原則 ..................................................................................................................................................11 總體架構(gòu) ................................................................................................................................................. 12 邏輯架構(gòu) ........................................................................................................................................... 13 物理架構(gòu) ........................................................................................................................................... 13 網(wǎng)絡(luò)架構(gòu) ........................................................................................................................................... 18 標(biāo)準(zhǔn)化中間件 ................................................................................................................................... 18 調(diào)度監(jiān)控管理 ................................................................................................................................... 19 數(shù)據(jù)倉庫建模方案 ................................................................................................................................ 20 數(shù)據(jù)模型設(shè)計思路和原則 .............................................................................................................. 20 證券業(yè)概念模型 ............................................................................................................................... 21 數(shù)據(jù)倉庫解決方案 ........................................................................................................................... 23 元數(shù)據(jù)設(shè)計模型 ............................................................................................................................... 31 數(shù)據(jù)建模工具和方法 ...................................................................................................................... 34 數(shù)據(jù)存儲架構(gòu)方案 ................................................................................................................................ 37 數(shù)據(jù)層次 ........................................................................................................................................... 38 數(shù)據(jù)流轉(zhuǎn)服務(wù) ................................................................................................................................... 39 存儲管理 ........................................................................................................................................... 40 系統(tǒng)性能設(shè)計 ................................................................................................................................... 41 標(biāo)準(zhǔn)化流程、模板 ................................................................................................................................ 42 ETL流程 ........................................................................................................................................... 42 數(shù)據(jù)質(zhì)量控制流程 ........................................................................................................................... 47 規(guī)范及模板 ....................................................................................................................................... 53 信息安全解決方案 ................................................................................................................................ 54 財達(dá)證券有限責(zé)任公司數(shù)據(jù)中心建設(shè) 項(xiàng)目投標(biāo)書 第 III 頁 數(shù)據(jù)安全和訪問機(jī)制闡述 .............................................................................................................. 54 數(shù)據(jù)保護(hù)技術(shù) ................................................................................................................................... 54 數(shù)據(jù)訪問控制 ................................................................................................................................... 54 數(shù)據(jù)備份和恢復(fù)策略 ...................................................................................................................... 54 ETL 流程調(diào)度和監(jiān)控 ....................................................................................................................... 55 數(shù)據(jù)存儲和傳輸?shù)陌踩? .................................................................................................................. 55 3 應(yīng)用系統(tǒng)解決方案 .......................................................................................................................................... 56 總體結(jié)構(gòu) ................................................................................................................................................. 56 總體結(jié)構(gòu)圖 ....................................................................................................................................... 56 報表實(shí)施流程 ................................................................................................................................... 59 綜合報表 .................................................................................................................................................