Oracle数据仓库解决方案.pptxVIP

Oracle Data Warehouse SolutionOracle ( China )Presales ConsultantXu Xin数据仓库几大功能Query/ReportDrill up/ Drill DownCompareExceptionForcast, WhatifData Mining数据仓库三大流程数据建模 Data Model Design数据抽取 Data Extract, Transform, Transport数据表现 Rolap, Molap Data Delivery, Drill up/Drill down, Data Rotation, Data MiningROLAP / MOLAP - 争论的焦点在哪里定义 :ROLAP = 基于关系的 OLAPMOLAP = 基于多维的 OLAPROLAP / MOLAP - 争论的焦点在哪里ROLAP 供应商说 : 你能用关系技术做所有的事情?MOLAP ROLAP 供应商说 : 你用多维数据库能做得更好ROLAP 供应商仅仅能做ROLAP MOLAP 供应商仅仅能做MOLAP ORACLE 能提供 ROLAP和MOLAPROLAP和MOLAP - Oracle的解决方案Oracle ROLAPData Mart Suite -- 建模，数据抽取的工具Discoverer -- 基于关系数据库的分析工具多维数据的视图, 挖掘和旋转Oracle MOLAPExpress 系列产品提供 MOLAP的方案多维数据的视图, 挖掘和旋转, 计算和存取、预测Oracle 能提供 ROLAP 和 MOLAPExpress 系列产品能做 MOLAP 和 ROLAPOperationsDecisionsDiscovererQuery, Reporting,AnalysisOLTPDataStorageExpressPower Analysis OLTPOFA, OSAApplicationsExternal DataComponents of a Data Warehouse / MartData Mart SuiteAdd Value To The Oracle WarehouseData Mart Suite 2.0 - ComponentsGreat8 - Oracle8, release 8.0.4Dashing - Data Mart Designer 2.1Better - Data Mart Builder 2.0Debonair - Discoverer 3.1Awesome - Web Application Server 3.0.1Ravishing - Reports Server 3.0Compelling - CookbookConstruction Methodology Drag drop visual metaphorData ModelingIdentify data sourcesIdentify source subsetModel Star SchemaProcess ModelingBuild PlansDimension tablesTime DimensionFact tablePopulate databaseBusiness ModelingDefine end-user layerAny DataAny SourceAny AccessMetadataDesign and ManagementOracle8i for Data Warehousing Continuous InnovationOracle 7.3Oracle 8.0Oracle8iHash JoinBitmap IndexesParallel-Aware OptimizerPartition ViewsInstance Affinity: Function ShippingParallel Union AllAsynchronous Read-AheadHistogramsAnti-JoinPartitioned Tables and IndexesPartition PruningParallel Index ScansParallel Insert, Update, DeleteParallel Bitmap Star QueryParallel ANALYZEParallel Constraint EnablingServer Managed Backup/RecoveryPoint-in-Time RecoverySummary ManagementNew Partitioning SchemesResource