Oracle数据仓库解决方案

OracleDataWarehouseSolutionOracle(China)PresalesConsultantXuXin数据仓库几大功能Query/ReportDrillup/DrillDownCompareExceptionForcast,WhatifDataMining数据仓库三大流程数据建模DataModelDesign数据抽取DataExtract,Transform,Transport数据表现–Rolap,Molap–DataDelivery,Drillup/Drilldown,DataRotation,DataMiningROLAP/MOLAP-争论的焦点在哪里定义:ROLAP=基于关系的OLAPMOLAP=基于多维的OLAPROLAP供应商说:你能用关系技术做所有的事情?MOLAPROLAP供应商说:你用多维数据库能做得更好ROLAP供应商仅仅能做ROLAP....MOLAP供应商仅仅能做MOLAP....ORACLE能提供ROLAP和MOLAPROLAP/MOLAP-争论的焦点在哪里ROLAP和MOLAP-Oracle的解决方案OracleROLAP–DataMartSuite--建模，数据抽取的工具–Discoverer--基于关系数据库的分析工具–多维数据的视图,挖掘和旋转OracleMOLAP–Express系列产品提供MOLAP的方案–多维数据的视图,挖掘和旋转,计算和存取、预测Oracle能提供ROLAP和MOLAP–Express系列产品能做MOLAP和ROLAPOFA,OSAApplicationsExpressPowerAnalysisDiscovererQuery,Reporting,AnalysisDecisionsComponentsofaDataWarehouse/MartOLTPOLTPExternalDataOperationsDataStorageDataMartSuiteAddValueToTheOracleWarehouseDataMartSuite2.0-ComponentslGreat8-Oracle8,release8.0.4lDashing-DataMartDesigner2.1lBetter-DataMartBuilder2.0lDebonair-Discoverer3.1lAwesome-WebApplicationServer3.0.1lRavishing-ReportsServer3.0lCompelling-CookbookDesignandManagementAnyDataAnyAccessAnySourceMetadataConstructionMethodologyDrag&dropvisualmetaphorDataModelingIdentifydatasourcesIdentifysourcesubsetModelStarSchemaProcessModelingBuildPlansDimensiontablesTimeDimensionFacttablePopulatedatabaseBusinessModelingDefineend-userlayerOracle8iforDataWarehousingContinuousInnovationOracle7.3HashJoinBitmapIndexesParallel-AwareOptimizerPartitionViewsInstanceAffinity:FunctionShippingParallelUnionAllAsynchronousRead-AheadHistogramsAnti-JoinPartitionedTablesandIndexesPartitionPruningParallelIndexScansParallelInsert,Update,DeleteParallelBitmapStarQueryParallelANALYZEParallelConstraintEnablingServerManagedBackup/RecoveryPoint-in-TimeRecoveryOracle8.0SummaryManagementNewPartitioningSchemesResourceManagerProgressMonitorAdaptiveParallelQueryServer-basedAnalyticFunctionsTransportableTablespacesDirectLoaderAPIFunctionalIndexesPartition-wiseJoinsSecurityEnhancementsandmore...Oracle8iDataModelingOracleDataMartDesignerTableorders(constraintc_o_datecheck(O_entry_dbetweento_date(?1-jan-1997?慸d-mon-yyyy?andto_date(?1-dec-1997?慸d-mon-yyyy?)disable,o_idnumber,o_d_idnumber,o_w_idnumber,o_c_idnumber,o_entry_ddate,o_carrier_idnumber,o_ol_cntnumber,o_all_localnumber)tablespaceordinitrans3pctfree5storage(initial20Knext110Mpctincrease0freelistgroups19freelists9);Source:OLTPProductdescriptionsizeflavorpackagePromotiondescriptiondealdiscountmediaMarketdescriptiondistrictregiondemographicsTimedescriptionweekdayholidayfiscalFactTableTarget:DataMartProcessModelingOracleDataMartBuilderOrders-ExtractSQLQueryProductProduct_LineProduct_GroupShipShipperContactCus_LocOrdersContact_LocProductLookupMarketLookupPromotionLookupTimeLookupDirectPathLoaderOracleDataMartBuilderMetadataIntegrationProductdescriptionsizeflavorpackagePromotiondescriptiondealdiscountmediaMarketdescriptiondistrictregiondemographicsTimedescriptionweekdayholidayfiscalFactTableOrders-ExtractSQLQueryProductLookupMarketLookupPromotionLookupTimeLookupDirectPathLoaderOracleDataMartBuilderOracleDiscovererOracleDataMartDesignerMetadata决策支持系统的范围IT人员为用户开发业务用户独立分析专业分析人员标准报表即席查询分析复杂分析Oracle决策支持工具集标准报表即席查询分析复杂分析上季度各地区销售情况如何？什么原因造成东南亚地区的业务下降?如果同样的因素影响到其它地区，将会对全球的业务造成什么影响?OracleExpressOracleDiscovererOracleReportsOracle决策支持工具集标准报表-OracleReports–集中式报表生成存储–输出发布高质量的报表即席查询分析-Discoverer–即席查询,数据钻入，旋转–业界领先的易用性和性能复杂分析-Express–On-lineAnalyticalProcessing(OLAP)–高级计算财务,时间序列,建模,预测,回归分析，假设分析OracleReportsWhatisit?–FormatsanddistributesdatabaseinformationKeyadvantages–Unlimiteddataformatting–DistributeshighfidelityreportsviatheWeb–ApplicationserverbasedreportingengineOracleExpressOracleDiscovererOracleReportsProductionReportingAdHocQuery,AnalysisAdvancedAnalysisOracleDiscoverAddValueToTheOracleWarehouseOracleDiscovererWhatisit:–AdhocqueryandanalysisofrelationaldataKeyadvantages:–Award-winningeaseofuse–Industry-leadingqueryperformanceOracleExpressOracleDiscovererOracleReportsProductionReportingAdHocQuery,AnalysisAdvancedAnalysisDiscovereris:10timesfasterthanCognos9timesfasterthanBusinessObjectsMarket-LeadingPerformanceTimetoquery100,000rows:CognosBusinessObjectsDiscovererOracleDiscoverer3.1UserEditionBusinessAbstractionLayerEndUserLayer(TM)DataWarehouse/DataMart(orOLTP)UserEditionAdministrationEditionOracleDiscoverer3.1UserEditionSuperiorEaseofUseEaseofUsePerformanceWarehouseExplorationExceptionalPerformanceNavigationalPowerNavigationalPowerOpennessOpennessMostTestedUIontheMarketResizeableWizardInterfaceIndustrySpecificQuickTourDramaticReductionoftheLearningCurveandmore...EaseofUseEndUserLayerEaseofUseHidestheComplexityoftheUnderlyingDatabaseDatabasecl_addr1||','||cl_addr2|','||cl_addr3||','||cl_twn||','||cl_zipcodesum(nvl(qty*unit_price,0))JonesSmithNameCustomerClientAddressRevenueEasternRegionUserBatchReportingOpennessToDo...SchedulelongrunningqueriesforlaterEaseofUse9:00Openworkbooks12:00Refreshworkbooks3:00ScheduleMonthlyreports5:00ScheduleQuarterlyrep