資源描述:
《BI商業(yè)智能簡介.ppt》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在應(yīng)用文檔-天天文庫。
1、BI/DWIntroductionJamesChenPSOSr.Consultant程序=算法+數(shù)據(jù)結(jié)構(gòu)--NiklausWirth數(shù)據(jù)結(jié)構(gòu)離散結(jié)構(gòu)線形結(jié)構(gòu)-數(shù)組鏈表?xiàng)j?duì)列樹圖算法空間復(fù)雜度時(shí)間復(fù)雜度用戶內(nèi)存中數(shù)據(jù)結(jié)構(gòu)物理數(shù)據(jù)結(jié)構(gòu)E-R業(yè)務(wù)流程二者相輔相成,不同應(yīng)用側(cè)重不同經(jīng)典業(yè)務(wù)系統(tǒng)模型Skillset數(shù)據(jù)庫C++/J2EE/.netPowerDesignerER_WINOOUML面向過程OODesignWorkflowDevelopBusinessTypeModelIdentifyBusinessInterfacesIdentifySy
2、stemInterfaces&OpsCreateInitialCompSpecs&ArchitectureDiscoverBusinessOperationsRefineInterfaces&OpsRefineComponentSpecs&ArchitectureDefineInterfaceInformationModelsSpecifyOperationPre/PostconditionsSpecifyComponentInterfaceConstraintsBusinessConceptModelUseCaseModelBusines
3、sInterfacesSystemInterfacesInterfacesInterfacesComponentSpecs&ArchitectureComponentSpecs&ArchitectureComponentSpecs&ArchitectureBusinessTypeModelArchitecturePatternsExistingInterfacesExistingAssetsComponentIdentificationComponentInteractionComponentSpecification笑一笑數(shù)據(jù)倉庫初學(xué)者:
4、數(shù)據(jù)倉庫與數(shù)據(jù)庫有什么區(qū)別?某專家:一個(gè)有倉一個(gè)沒倉!BI/DW的引出統(tǒng)計(jì)報(bào)表需求數(shù)字越來越重要報(bào)表越來越多效率越來越差數(shù)據(jù)倉庫的定義“數(shù)據(jù)倉庫是在企業(yè)管理和決策中面向主題的,集成的,與時(shí)間相關(guān)的和不可修改的數(shù)據(jù)集合”BillInmon數(shù)據(jù)倉庫(DataWarehouse)是一種專為聯(lián)機(jī)分析應(yīng)用和決策支持系統(tǒng)提供數(shù)據(jù)源的結(jié)構(gòu)化的數(shù)據(jù)環(huán)境數(shù)據(jù)倉庫要解決的問題是從數(shù)據(jù)庫中獲取信息的問題。數(shù)據(jù)信息INFORMATIONINFORMATIONINFORMATIONINFORMATION影響數(shù)據(jù)倉庫的幾個(gè)人物BillInmon-《數(shù)據(jù)倉庫》Ralph
5、Kimball-《數(shù)據(jù)倉庫工具箱》BernardLiautaud-《商業(yè)智能》OLTP與數(shù)據(jù)倉庫系統(tǒng)RDBMS關(guān)系數(shù)據(jù)庫SAP/ERPVSAM主機(jī)系統(tǒng)EXCELWeb/XMLOLTP業(yè)務(wù)系統(tǒng)數(shù)據(jù)倉庫系統(tǒng)數(shù)據(jù)是當(dāng)前的數(shù)據(jù)總在實(shí)時(shí)變化中存儲(chǔ)明細(xì)數(shù)據(jù)優(yōu)化是針對(duì)即時(shí)更新的事務(wù)處理支持日常的業(yè)務(wù)支持辦事人員或行政人員數(shù)據(jù)是歷史的數(shù)據(jù)是靜態(tài)的,除數(shù)據(jù)刷新外數(shù)據(jù)是匯總的優(yōu)化是針對(duì)大批量查詢而不是更新支持長遠(yuǎn)的業(yè)務(wù)戰(zhàn)略決策支持決策人員和管理人員面向事務(wù)面向決策5-10年數(shù)據(jù)集市分析型CRM業(yè)務(wù)指標(biāo)分析數(shù)據(jù)倉庫BI系統(tǒng)建設(shè)方法(1)直接建立BI應(yīng)用OLTP數(shù)
6、據(jù)源各種前端應(yīng)用KPI指標(biāo)報(bào)表多維分析即席查詢數(shù)據(jù)挖掘數(shù)據(jù)倉庫環(huán)境業(yè)務(wù)智能層中央數(shù)據(jù)倉庫數(shù)據(jù)倉庫數(shù)據(jù)集結(jié)數(shù)據(jù)源公司數(shù)據(jù)源外部數(shù)據(jù)源BIW數(shù)據(jù)集市數(shù)據(jù)倉庫管理子系統(tǒng)數(shù)據(jù)倉庫元數(shù)據(jù)目錄信息訪問和引用部件BI系統(tǒng)建設(shè)方法(2)企業(yè)數(shù)據(jù)倉庫體系架構(gòu)RelationalPackageLegacyExternalsourceDataCleanToolSourceDataDataStagingWareHouseAdmin.ToolsEnterpriseDataWarehouseDataExtraction,TransformationandloadDat
7、amartDatamartEnterprise/CentralDataWarehouseRDBMSROLAPRDBMSRDBMSArchitectedDatamartsCentralMetadataDataModelingToolEnd-UserToolEnd-UserToolMDBEnd-UserToolEnd-UserToolLocalMetadataLocalMetadata典型物理架構(gòu)ETL_DM1ETL_DM2BAS_DW1BAS_DW2BAS_OP1BAS_OP2Bas_sw01Bas_sw02Dx_sp01Dx_sp02Dx_
8、sp03元數(shù)據(jù)管理服務(wù)器BAS_SM1BAS_SM270T!企業(yè)數(shù)據(jù)倉庫的目的數(shù)據(jù)整合--建立一個(gè)企業(yè)統(tǒng)一的信息平臺(tái)建立統(tǒng)一的業(yè)務(wù)數(shù)據(jù)定義建立唯一的統(tǒng)計(jì)分析數(shù)據(jù)源快速訪問—采用適