數(shù)據(jù)倉庫商務(wù)智能的解決方案-wenkub.com
2025-01-23 18:09 本頁面
【正文】 基于數(shù)據(jù)倉庫模型，為前端 DSS/OLAP工具生成所需的數(shù)據(jù)立方體。集成的主要產(chǎn)品lDesignl Warehouse ArchitectlManagel Sybase ASIQMlIntegratel Informatica l Enterprise Connectl Replication Server PowerMartlVisualizel Bo、 Briol Cognosl SPSSlAdministerl Warehouse Control Center WarehouseControlCentreSybase數(shù)據(jù)倉庫相關(guān)產(chǎn)品集的構(gòu)成RelationalPackageLegacyExternalsourceDataCleanToolSource DataDataStagingWareHouseAdmin. ToolsEnterprise DataWarehouse Data Extraction,Transformationand loadDatamartDatamartEnterprise/Central DataWarehouseRDBMSROLAPRDBMSRDBMS, Star SchemaArchitectedDatamartsCentralMetadata Data Modeling ToolEndUserToolEndUserToolMDBEndUserToolEndUserToolLocal MetadataLocal MetadataPowerCenterPowerMart Sybase IQMSybase IQMBrio/BOPowerMartWarehouseArchitectWCCCognos設(shè)計(jì) : 成功的關(guān)鍵數(shù)據(jù)庫的設(shè)計(jì)對數(shù)據(jù)倉庫系統(tǒng)的整體性能、裝載和建立索引的時(shí)間以及數(shù)據(jù)量的增長等的影響超過任何其它方面。 IQ Multiplex的主要特點(diǎn)是：? 高可擴(kuò)展性 – 支持?jǐn)?shù)以千計(jì)的并發(fā)用戶存取 TB級的數(shù)據(jù)。 用戶反饋167。 ETL 模板167。INFORMATION 信 息 信 息INFORMATION什么是數(shù)據(jù)倉庫解決方案？應(yīng)用價(jià)值時(shí)間1. 日常報(bào)表2. 即席查詢3. 分析4. 數(shù)據(jù)挖掘?qū)ｎ}應(yīng)用1 2 3 4 數(shù)據(jù)倉庫應(yīng)用類型數(shù)據(jù)倉庫應(yīng)用數(shù)據(jù)倉庫系統(tǒng)體系架構(gòu)RelationalPackageLegacyExternalsourceDataCleanToolSource DataDataStagingWareHouseAdmin. ToolsEnterprise DataWarehouse Data Extraction,Transformationand loadDatamartDatamartEnterprise/Central DataWarehouseRDBMSROLAPRDBMS Dimension ModelingConformed dimensionfactIncluding atomicaggregateArchitectedDatamartsCentralMetadata Data Modeling ToolEndUserToolEndUserToolMDBEndUserToolEndUserToolLocal MetadataLocal Metadata數(shù)據(jù)倉庫 /商務(wù)智能應(yīng)用成功的關(guān)鍵? 做什么，怎么做？? 數(shù)據(jù)倉庫性能Sybase Partner 專業(yè)服務(wù)專業(yè)服務(wù) 數(shù)據(jù)倉庫顧問咨詢數(shù)據(jù)倉庫顧問咨詢Industry Warehouse StudioSybase IWS 方法學(xué)方法學(xué)? ER Design Tool? Impact Analysis? Metadata ManagementSybase Industry Warehouse Studio打包的 數(shù)據(jù)倉庫基礎(chǔ)平臺(tái)概述業(yè)務(wù)業(yè)務(wù)模型模型物理物理模式模式 元數(shù)據(jù)元數(shù)據(jù) ETL 工具工具例子例子報(bào)表報(bào)表算法算法? ETL Tool Metadata Exchange? Smart ETL Maps (Future)? SQL Templates? Cognos? Business Objects? MicroStrategy? Business Models focused on Key Industry Events? Enterprisewide, Star Schemabased designIWS 產(chǎn)品介紹TABLE TABLETABLETABLE TABLEIndustryspecific Data ModelsData Warehouse“Open RDBMS*”O(jiān)RACLE, IBM, MICROSOFT, NCR, SYBASE, etc. BI PartnersSample Applications Analytical CRM? Sales Analysis? Customer Profiling? Campaign Analysis? Customer Care Analysis? Loyalty AnalysisBusiness PerformanceAnalysis? Industry SpecificSample DataGeneral RepresentativeSystems Integrators GuideProject PlansImplementation Protocol. InformaticaETL ToolWarehouse ArchitectMultiDimensional Design Tool SQL SampleReportsWarehouse Control CenterMeta Data Management 客戶構(gòu)成分析營銷活動(dòng)分析客戶興趣分析忠誠度分析銷售分析行業(yè)相關(guān)的經(jīng)營業(yè)績分析收益率分析EVT_TYP_ID = EVT_TYP_IDPRD_ID = PRD_IDENTY_ID = ENTY_IDENTY_ID = EMP_IDGEO_ID = GEO_IDLANGUAGE_ID = LANGUAGE_IDPRODUCT_ID = PRODUCT_IDDEMO_ID = DEMO_IDENTY_ID = V_E_ENTY_IDENTY_ID = ENTY_IDENTY_ID = F_C_ENTY_IDCOR_EVT_TYP_ID = COR_EVT_TYP_IDCOR_RPT_STRC_ID = COR_RPT_STRC_IDENTY_ID = CNTC_RSOL_EMP_IDGEO_ID = GEO_IDFNCL_SCOR_ID = FNCL_SCOR_IDMEASURE_UNIT_ID = MEASURE_UNIT_IDCOR_EVT_TXN_ID = COR_EVT_TXN_IDLANGUAGE_ID = LANGUAGE_IDCOR_EVT_TXN_SEQ_NB = COR_EVT_TXN_SEQ_NBPN_BHVR_SCOR_ID = PN_BHVR_SCOR_IDPRODUCT_ID = PRODUCT_IDDEMO_ID = DEMO_IDENTY_ID = ENTY_IDFNCL_SCOR_ID = FNCL_SCOR_IDMEASURE_UNIT_ID = MEASURE_UNIT_IDDEMO_ID = DEMO_IDPRODUCT_ID = PRODUCT_IDPN_BHVR_SCOR_ID = PN_BHVR_SCOR_IDLANGUAGE_ID = LANGUAGE_IDFNCL_SCORES_ID = FNCL_SCOR_IDMEASURE_UNIT_ID = D_M_MEASURE_UNIT_IDMEASURE_UNIT_ID = MEASURE_UNIT_IDGEO_ID = GEO_IDCOR_RPT_STRC_ID = COR_RPT_STRC_IDEVT_TYP_ID = COR_EVT_TYP_IDENTY_ID = F_C_ENTY_IDGEO_ID = GEO_IDLANGUAGE_ID = LANGUAGE_IDEVT_TYP_ID = EVT_TYP_IDDV_HR_EVT_TYPEEVT_TXN_ID pk,fk INTEGEREVT_TYP_ID fk INTEGEREVT_TYP_SHRT_NM CHAREVT_TYP_FULL_NM charEVT_TYP_CAT_SHRT_N CHAREVT_TYP_CAT_FULL_N charF_HR_EVTV_E_ENTY_ID fk INTEGERV_E2_ENTY_ID fk INTEGEREVT_DT_PRD_ID INTEGE
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1