【正文】
問題和提供決策支持,并確保:一致、集成的數(shù)據(jù)存儲(chǔ) ??n任意的數(shù)據(jù)粒度 ??n在整個(gè)企業(yè)的業(yè)務(wù)范圍 ??n保持企業(yè)內(nèi)一致的信息視圖n企業(yè)內(nèi)一致的信息視圖 ( Single Version of the Truth)集成的企業(yè)信息( Integrated corporate information)不針對(duì)特定應(yīng)用( Application neutral)無冗余( Non redundant)用于報(bào)表和決策支持( Reporting and decision making)n最詳細(xì)的數(shù)據(jù)和信息 ( Detailed Data)n任何時(shí)候,針對(duì)任意數(shù)據(jù),提出任意業(yè)務(wù)問題 ( Ask any question, any data, any time)數(shù)據(jù)倉庫的特點(diǎn)數(shù)據(jù)倉庫領(lǐng)域的兩位大師Bill Inmon數(shù)據(jù)倉庫之父,數(shù)據(jù)倉庫概念的創(chuàng)始人理論: Corporate Information Factory(CIF) 主要著作: 《 數(shù)據(jù)倉庫 》 、 《 企業(yè)信息工廠 》Ralph Kimball數(shù)據(jù)倉庫方面的知名學(xué)者理論: Mutildimensional Architecture(MD) 企業(yè)信息工廠數(shù)據(jù)倉庫總線 企業(yè)總線總線架構(gòu)矩陣數(shù)據(jù)架構(gòu)形態(tài)各數(shù)據(jù)架構(gòu)比較Inmon vs KimballInmon KimballOverall approach Topdown BottomupComplexity of the method Quite plex Fairly simpleData Orientation Data derived Process orientedPrimary audience IT audience End userTool 3NF Dimensional ModelingArchitectural structure Enterprise wide ,Data warehouse feeds department databasesData mart model a single business process Enterprise consistency achieved through busn BI各概念關(guān)系n 商業(yè)智能n 數(shù)據(jù)倉庫n