BIAppsArchitecture

InsertPictureHereOracleBI应用技术架构详解预制分析模型概述及示例©2007OracleCorporation–ProprietaryandConfidential基于角色的信息板分析工作流指导性导航安全性/可见性警报和预先发送逻辑层到物理抽象层计算和量度定义可见性和个性化动态SQL生成高度并行多层、可自定义部署模块化抽象的数据模型一致的维度异种数据库支持特定于数据库的索引OracleBI应用产品体系结构管理元数据OracleBI表示服务按角色分类的信息板报表、分析/分析工作流量度/KPI逻辑模型/主题领域物理映射OracleBIServer直接访问源数据数据仓库/数据模型ETL加载流程临时区域提取流程DAC联合数据源SiebelOracleSAPR/3PSFTEDW其它©2007OracleCorporation–ProprietaryandConfidentialETL概述管理元数据OracleBI表示服务按角色分类的信息板报表、分析/分析工作流量度/KPI逻辑模型/主题领域物理映射OracleBIServer直接访问源数据数据仓库/数据模型DAC联合数据源SiebelOracleSAPR/3PSFTEDW其它•可以通过三种方法来访问/加载源数据•批ETL•低延迟ETL•从OracleBIServer直接访问源数据•ETL将体系结构分为提取、通用临时存储和加载层•提供独立性、模块化和可扩展性•能够快速支持数据源系统版本更改•能够通过附加适配器扩展•渐变维度支持•针对性能而构建•所有映射都通过增量提取构建•高度优化的并发加载•批量加载器支持所有数据库•数据仓库应用程序控制台(DAC)•应用程序管理、执行和监视ETL加载流程临时区域提取流程DAC©2007OracleCorporation–ProprietaryandConfidential管理元数据OracleBI表示服务按角色分类的信息板报表、分析/分析工作流量度/KPI逻辑模型/主题领域物理映射OracleBIServer直接访问源数据数据仓库/数据模型DAC联合数据源SiebelOracleSAPR/3PSFTEDW其它ETL加载流程临时区域提取流程DACETL概述加载提取SAPPeopleSoft独立于源的层临时表提取其它SiebelOLTPOraclePowerConnectPowerConnectSQLSQLSQLSQL应用层ABAP应用层Oracle数据仓库©2007OracleCorporation–ProprietaryandConfidential数据提取和加载过程提取模式直接数据库访问OracleEBSSiebelCRMPowerConnect技术SAPR/3PeopleSoftEnterprise通用业务适配器对于没有预先包装业务适配器的系统通过平面文件接口转换和加载数据供应平面文件（S）或表定义的标准格式相对于从零开始建设全面ETL解决方案，明显降低实施和维护的成本加载提取SAPPeopleSoft独立于源的层临时表提取其它SiebelOLTPOraclePowerConnectPowerConnectSQLSQLSQLSQL应用层ABAP应用层Oracle数据仓库©2007OracleCorporation–ProprietaryandConfidential加载提取SAPPeopleSoft独立于源的层临时表提取其它SiebelOLTPOraclePowerConnectPowerConnectSQLSQLSQLSQL应用层ABAP应用层Oracle数据仓库数据提取和加载过程数据提取特定业务系统和通用业务适配器从复杂的商业实体系统中取得业务实体信息转换数据源相关的数据格式到通用临时表格式轻量级，优化抽取性能，并行执行设计可拓展©2007OracleCorporation–ProprietaryandConfidential加载提取SAPPeopleSoft独立于源的层临时表提取其它SiebelOLTPOraclePowerConnectPowerConnectSQLSQLSQLSQL应用层ABAP应用层Oracle数据仓库数据提取和加载过程独立于源的层封装仓库加载逻辑处理:缓慢变化维度信息查找比对/生成代理主键插入/更新策略货币转换数据一致性在所有数据库平台都使用批量加载©2007OracleCorporation–ProprietaryandConfidential数据源无关加载(SIL)数据源相关抽取(SDE)统一数据临时区SourceIndependentMappletBusinessComponentMappletSourceAdapterMapplet业务分析数据仓库PLPmpltmpltSiebelOracleSAPR/3PSFTEDWOther分散的数据源加载完成后流程–事实表上的数据聚合和预计算每条数据都附有数据源ID在ETL工具中预置开发好的数据抽取过程JDE©2007OracleCorporation–ProprietaryandConfidentialOracleEBSSourceTableSourceQualifierExpressionTransformationMappletoutputtoExtractMapping举例：预置抽取Oracle应用–产品维度©2007OracleCorporation–ProprietaryandConfidentialBusinessComponentMappletforOracleEBSProductMasterSourceAdapterMappletTemporaryStagingTable举例：预置抽取Oracle应用–产品维度©2007OracleCorporation–ProprietaryandConfidentialTemporaryStagingTables(ProductMaster)SourceQualifierExpressionTransformationUniversalStagingTable举例：预置抽取Oracle应用–产品维度©2007OracleCorporation–ProprietaryandConfidentialUniversalStagingTableSourceQualifierW_PRODUCT_DDataWarehouseTableSourceIndependentLoad(SIL)Mapplet举例：预置加载Oracle应用–产品维度©2007OracleCorporation–ProprietaryandConfidential举例：抽取PeopleSoft员工维度SDE_PSFT_EmployeeDimension_PhonesSDE_PSFT_EmployeeDimension_AddressesSDE_PSFT_EmployeeDimension_Biography1SDE_PSFT_EmployeeDimension_Biography2SDE_PSFT_EmployeeDimension_JobInformationSDE_PSFT_EmployeeDimensionSIL_EmployeeDimensionW_EMPLOYEE_D©2007OracleCorporation–ProprietaryandConfidential抽取PeopleSoft员工维度SDE_PSFT_EmployeeDimension_PhonesPeopleSoftSourceBCmaplet(seebelow)ExpressionTransformationTemporaryStagingTablePeopleSoftSourceTableSourceQualifierExpressionTransformationMapletoutputtoExtractMapping©2007OracleCorporation–ProprietaryandConfidential抽取PeopleSoft员工维度SDE_PSFT_EmployeeDimension_AddressesPeopleSoftSourceBCmaplet(seebelow)ExpressionTransformationTemporaryStagingTablePeopleSoftSourceTableSourceQualifierExpressionTransformationMapletoutputtoExtractMapping©2007OracleCorporation–ProprietaryandConfidential抽取PeopleSoft员工维度SDE_PSFT_EmployeeDimension_Biography1PeopleSoftSourceBCmaplet(seebelow)ExpressionTransformationTemporaryStagingTablePeopleSoftSourceTablesSourceQualifierExpressionTransformationMapletoutputtoExtractMappingLookupProcedures©2007OracleCorporation–ProprietaryandConfidential抽取PeopleSoft员工维度SDE_PSFT_EmployeeDimension_Biography2PeopleSoftSourceBCmaplet(seebelow)ExpressionTransformationTemporaryStagingTablePeopleSoftSourceTableSourceQualifierExpressionTransformationMapletoutputtoExtractMapping©2007OracleCorporation–ProprietaryandConfidential抽取PeopleSoft员工维度SDE_PSFT_EmployeeDimension_JobInformationPeopleSoftSourceBCmaplet(seebelow)ExpressionTransformationTemporaryStagingTablePeopleSoftSourceTableSourceQualifierExpressionTransformationMapletoutputtoExtractMappingLookupProcedures©2007OracleCorporation–ProprietaryandConfidential抽取PeopleSoft员工维度SDE_PSFT_EmployeeDimensionPeopleSoftSourceTableExpressionTransformationTemporaryStagingTableSourceQualifiermaplet©2007OracleCorporation–ProprietaryandConfidentialEmployeeDimensionpopulatedfromPeopleSoftSDE_PSFT_EmployeeDimensionExpressionTransformationInputtoMaplet(fromabove)ExpressionTransformationMapletoutputtoExtractMappingLookupProcedures©2007OracleCorporation–ProprietaryandConfidentialEmployeeDimensionpopulatedfromPeopleSoftSIL_EmployeeDimension©2007OracleCorporation–