数据仓库解决方案课件

OracleDataWarehouseSolutionOracle(China)PresalesConsultantXuXinOracleDataWarehouseSolution1数据仓库几大功能Query/ReportDrillup/DrillDownCompareExceptionForcast,WhatifDataMining数据仓库几大功能Query/Report2数据仓库三大流程数据建模DataModelDesign数据抽取

DataExtract,Transform,Transport数据表现Rolap,Molap

DataDelivery,Drillup/Drilldown,DataRotation,DataMining数据仓库三大流程数据建模3ROLAP/MOLAP-争论的焦点在哪里定义:ROLAP=基于关系的OLAPMOLAP=基于多维的OLAPROLAP/MOLAP-争论的焦点在哪里定义:4ROLAP供应商说:你能用关系技术做所有的事情?MOLAPROLAP供应商说:你用多维数据库能做得更好ROLAP供应商仅仅能做ROLAP....MOLAP供应商仅仅能做MOLAP....ORACLE能提供ROLAP和MOLAPROLAP/MOLAP-争论的焦点在哪里ROLAP供应商说:ROLAP/MOLAP-争5ROLAP和MOLAP-Oracle的解决方案OracleROLAPDataMartSuite--建模，数据抽取的工具Discoverer--基于关系数据库的分析工具多维数据的视图,挖掘和旋转OracleMOLAPExpress系列产品提供MOLAP的方案多维数据的视图,挖掘和旋转,计算和存取、预测Oracle能提供ROLAP和MOLAPExpress系列产品能做MOLAP和ROLAPROLAP和MOLAP-Oracle的解决方案Oracl6OFA,OSAApplicationsExpressPowerAnalysisDiscovererQuery,Reporting,AnalysisDecisionsComponentsofaDataWarehouse/MartOLTPOLTPExternalDataOperationsData

StorageOFA,OSAExpressDiscovererDecis7DataMartSuiteAddValueToTheOracleWarehouseDataMartSuite8DataMartSuite2.0-ComponentsGreat8-Oracle8,release8.0.4Dashing-DataMartDesigner2.1Better-DataMartBuilder2.0Debonair-Discoverer3.1Awesome-WebApplicationServer3.0.1Ravishing-ReportsServer3.0Compelling-CookbookDataMartSuite2.0-Componen9DesignandManagementAnyDataAnyAccessAnySourceMetadata

ConstructionMethodology

Drag&dropvisualmetaphorData

ModelingIdentifydatasourcesIdentifysourcesubsetModelStarSchemaProcess

ModelingBuildPlansDimensiontablesTimeDimensionFacttablePopulatedatabaseBusinessModelingDefineend-userlayerDesignandManagementAnyDataA10Oracle8iforDataWarehousing

ContinuousInnovationOracle7.3HashJoinBitmapIndexesParallel-AwareOptimizerPartitionViewsInstanceAffinity:FunctionShippingParallelUnionAllAsynchronousRead-AheadHistogramsAnti-JoinPartitionedTablesandIndexesPartitionPruningParallelIndexScansParallelInsert,Update,DeleteParallelBitmapStarQueryParallelANALYZEParallelConstraintEnablingServerManagedBackup/RecoveryPoint-in-TimeRecoveryOracle8.0SummaryManagementNewPartitioningSchemesResourceManagerProgressMonitorAdaptiveParallelQueryServer-basedAnalyticFunctionsTransportableTablespacesDirectLoaderAPIFunctionalIndexesPartition-wiseJoinsSecurityEnhancements andmore...Oracle8iOracle8iforDataWarehousing11DataModeling

OracleDataMartDesignerTableorders(constraintc_o_datecheck(O_entry_dbetweento_date(?1-jan-1997?慸d-mon-yyyy?andto_date(?1-dec-1997?慸d-mon-yyyy?)disable,o_id number,o_d_id number,o_w_id number,o_c_id number,o_entry_d date,o_carrier_id number,o_ol_cnt number,o_all_local number)tablespaceordinitrans3pctfree5storage(initial20Knext110Mpctincrease0freelistgroups19freelists9);Source:OLTPProductdescriptionsizeflavorpackagePromotiondescriptiondealdiscountmediaMarketdescriptiondistrictregiondemographicsTimedescriptionweekdayholidayfiscalFactTableTarget:DataMartDataModeling

OracleDataMart12ProcessModeling

OracleDataMartBuilderOrders-ExtractSQLQueryProductProduct_LineProduct_GroupShipShipperContactCus_LocOrdersContact_LocProduct

LookupMarket

LookupPromotionLookupTime

LookupDirectPathLoader

Oracle

Data

Mart

BuilderProcessModeling

OracleData13MetadataIntegrationProductdescriptionsizeflavorpackagePromotiondescriptiondealdiscountmediaMarketdescriptiondistrictregiondemographicsTimedescriptionweekdayholidayfiscalFactTableOrders-ExtractSQLQueryProduct

LookupMarket

LookupPromotionLookupTime

LookupDirectPathLoader

Oracle

Data

Mart

BuilderOracleDiscovererOracle

Data

Mart

DesignerMetadataMetadataIntegrationProductPro14决策支持系统的范围IT人员为用户开发业务用户独立分析专业分析人员标准报表即席查询分析复杂分析决策支持系统的范围IT人员业务用户专业分析人员标准报表即席15Oracle决策支持工具集标准报表即席查询分析复杂分析上季度各地区销售情况如何？什么原因造成东南亚地区的业务下降?如果同样的因素影响到其它地区，将会对全球的业务造成什么影响?OracleExpressOracleDiscovererOracleReportsOracle决策支持工具集标准报表即席查询分析复杂分析上季16Oracle决策支持工具集标准报表-OracleReports集中式报表生成存储输出发布高质量的报表即席查询分析-Discoverer即席查询,数据钻入，旋转业界领先的易用性和性能复杂分析-ExpressOn-lineAnalyticalProcessing(OLAP)高级计算财务,时间序列,建模,预测,回归分析，假设分析Oracle决策支持工具集标准报表-OracleRe17OracleReportsWhatisit?FormatsanddistributesdatabaseinformationKeyadvantagesUnlimiteddataformattingDistributeshighfidelityreportsviatheWebApplicationserverbasedreportingengineOracleExpressOracleDiscovererOracleReportsProductionReportingAdHocQuery,AnalysisAdvancedAnalysisOracleReportsWhatisit?Orac18OracleDiscoverAddValueToTheOracleWarehouseOracleDiscover19OracleDiscovererWhatisit:AdhocqueryandanalysisofrelationaldataKeyadvantages:Award-winningeaseofuseIndustry-leadingqueryperformanceOracleExpressOracleDiscovererOracleReportsProductionReportingAdHocQuery,AnalysisAdvancedAnalysisOracleDiscovererWhatisit:20Discovereris:10timesfasterthan

Cognos

9timesfasterthan

BusinessObjectsMarket-LeadingPerformanceTimetoquery100,000rows:CognosBusinessObjectsDiscovererDiscovereris:Market-LeadingP21OracleDiscoverer3.1

UserEditionBusinessAbstractionLayerEndUserLayer(TM)DataWarehouse/DataMart(orOLTP)UserEditionAdministrationEditionOracleDiscoverer3.1

UserEdi22OracleDiscoverer3.1

UserEdition

SuperiorEaseofUseEaseofUsePerformance WarehouseExploration ExceptionalPerformance NavigationalPower NavigationalPower

OpennessOpennessOracleDiscoverer3.1

UserEdi23MostTestedUIontheMarket Resizeable

WizardInterface IndustrySpecificQuickTour DramaticReductionoftheLearningCurve

andmore...EaseofUseMostTestedUIontheMarket R24EndUserLayerEaseofUseHidestheComplexityoftheUnderlyingDatabaseDatabasecl_addr1||','||cl_addr2|','||cl_addr3||','||cl_twn||','||cl_zipcodesum(nvl(qty*unit_price,0))JonesSmithNameCustomerClientAddressRevenueEasternRegionUserEndUserLayerEaseofUseHides25BatchReportingOpennessToDo...SchedulelongrunningqueriesforlaterEaseofUse9:00Openworkbooks

12:00Refreshworkbooks

3:00ScheduleMonthlyreports

5:00ScheduleQuarterlyreports

5:30GeneratenewreportformanagementmeetingtomorrowBatchReportingOpennessToDo.26SolutiontoLongRunningQueriesReactiveQueryGovernorStopsqueriesafterapre-settime

Usestheresourceswithoutshowingresults!PerformancePredictiveQueryGovernorPredictsthetimeaquerytakesbeforeexecutionDoesnotwastevaluableresources!SolutiontoLongRunningQuer27ManagingLargeDataVolumesSelectLocation,Period,Product,sum(videos_lent)From

video_detailsGroupbyLocation,Period,ProductDetailRowsPerformanceSlowTableScansMachineIntensiveAggregationsManagingLargeDataVolumesSel28SummaryRedirectionSelectLocation,Period,Product,sum(videos_lent)From

video_detailsGroupbyLocation,Period,ProductDetailRowsSummaryTablePerformanceSummaryRedirectionSelectLoca29SelectLocation,Period,Product,SalesFrom

video_summary Automatic!!SummaryRedirectionDetailRowsSummaryTablePerformanceSelectLocation,Period,Produ30ServerClientNetworkResultsBase:CubicClientCachePerformanceEfficientStorageAlgorithmMultidimensionalaccessRapidrotation,drillServerClientNetworkResultsBase31RegionNorthParisProductYearDetailRowsExternalDataDrillEverywhereDrillDownDrillAcrossDrilltoDetailDrillOut NavigationalPowerRegionNorthParisProductYearDet32WebPublishing NavigationalPowerWebPublishing NavigationalPo33IntegrationReportsExpressOpennessMAPIIntegrationReportsExpressOpenn34

OracleDiscoverer3.1

AdministrationEditionSuperiorEaseofUseEaseofUse SummaryManagementServerBasedAdministrationServerBasedAdministrationAdvancedSummary

Management

OracleDiscoverer3.1

Adminis35ServerBasedAbstractionLayerServerBasedAdministrationEaseofUsePRODUCTIONEUL(RDBMS)Sales...Marketing匜inance匛ducation匔onsultancyUsersAdministratorRead/WriteReadOnlyEasytoCreate,MaintainandSetupScaleableLeverageSecurityServerBasedAbstractionLayer36Open-ODBCDB2SybaseInformixSQLServerOracle?.ODBCEnhancementsOpennessOracleEndUserLayerEULGatewayDes/2000ETTToolsApplicationsQueryToolsOpen-ODBC?.ODBCEnhancements37BuildSummariesfromQueriesQueryperformancestatisticsSummarymanagementrecommendationsSummaryManagement38BuildSummariesfromQueriesQuDefinitionsData

WarehouseAmulti-subjectinformationstoreDesignedspecificallyfordecisionsupportData

MartAsubjectorapplication-specificdatawarehouseTypes:Dependent,IndependentDefinitionsDataWarehouse39DWvs.DataMart Warehouse DataMartScope Corporate Line-of-BusinessSubjects multi-subject subject-specificDataSources many fewSize 100GB-1TB+ <100GBImplementation months-years monthsWarehouseDataMartDWvs.DataMart Warehouse Da40OracleExpressOracleWarehouseOracleExpress41OracleExpressWhatisit:AdvancedanalysisofmultidimensionalandrelationaldataKeyadvantages:BroadestrangeofanalyticalfunctionsScaleableperformanceIntegrateddevelopmentenvironmentOracleExpressOracleDiscovererOracleReportsProductionReportingAdHocQuery,AnalysisAdvancedAnalysisOracleExpressWhatisit:Orac42OracleExpressKeyDifferentiatorsAdvancedanalysisBuilt-inforecastingMulti-userwhat-ifAutomaticsimultaneousmodelsProgrammableserverScaleableperformanceAnalysisofexistingrelationaldatabasesMultiplecubes,hierarchiesperschemaIntegrateddevelopmentenvironmentBroadestrangeofcapabilitiesOracleExpressKeyDifferentia43可扩展的多维数据库服务器,内置强大的分析

功能和决策支持能力PersonalExpress,ExpressServer用于销售分析,市场分析,财务分析的OLAP应用产品SalesAnalyzer,FinancialAnalyzer面向对象的OLAP应用开发工具ExpressAnalyzer,ExpressObjectsExpressServerExpressApplicationsExpressToolsOracleOLAP-ExpressProducts可扩展的多维数据库服务器,内置强大的分析功能和决策支持能44Express一个专门为查询和分析商业情报数据而设计的服务器Express一个专门为查询和分析商业情报数据而设计的服务45Express?对于一些分析查询和计算,Express比关系型技术快10倍，100倍，甚至1000倍JerryHeldSeniorVP,ServerTechnologies,OracleCorporation查询速度如此快，使Express具有很强的竞争能力.Express?对于一些分析查询和计算,Express比46多维数据模型辖区经理/行长财务经理任意分析PRODTIME资金经理为数据提供快速，灵活的访问方法金融产品时间头寸辖区多维数据模型辖区经理/行长财务经理任意分析PRODTIME47对时间，日期的智能处理，系统相关数据自行汇总。根据数据建立层次关系数据自行汇总在维上建立层次关系对时间，日期的智能处理，在维上建立层次关系48KEYS相同的数学模型华东区域华中月份产品西南Jan胶卷镜片摄像机销售量DIMENSIONSFebMarKEYS相同的数学模型华东区域华中月份产品西南Jan胶卷镜片49多维数据库服务器的特性立方体，页，片的数据维=主键只存放一次，重复使用强制性保证数据完整性节省磁盘空间极容易地结合数据和公式支持共享的商业逻辑保证数据的一致性每一个单元都被索引因此有很高的存取效率TimeproductGeography多维数据库服务器的特性立方体，页，片的数据TimepGeog50数据存放PhiladelphiaNewYorkBostonQ1Q2Q3Q4TentsCanoesRacquetsSportswearFootwearSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSales数据页数据存放PhiladelphiaNewYorkBoston51数据存取SalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSales关系数据库 多维数据库CostCostCostCostCostCostCostCostCostCostCostCostCostCostCostCostSalesCostUnitsDateMktProdSalesCostUnitsDateMktProdSalesCostUnitsDateMktProdSalesCostUnitsDateMktProdSalesCostUnitsDateMktProdSalesCostUnitsDateMktProdSalesCostUnitsDateMktProdSalesCostUnitsDateMktProd只要读取一页要读取两页数据存取SalesSalesSalesSalesSalesS52数据存取方法DistrictQuarterProductNewYorkBostonPhiladelphiaQ1Q2Q3Q4TentsCanoesRacquetsSportswearFootwear偏移地址存取更强有力的分析能力更好的执行效率数据存取方法DistrictQuarterProductNe53很多的已建好的函数FinancialFunctionsDepreciation折旧率GrowthRate增长率NetPresentValue现值InternalRateofReturnNumeric/TimeSeriesFunctionsAverage平均值CumulativeSums累积和Lag/Lead落后/领先Variance变动率MovingAverage/Total移动平均值Smallest/Largest最大/最小StandardDeviation水平偏差Total总和OtherFunctionsForecastingRegression...你也能创建你自己的函数很多的已建好的函数FinancialFunctionsNu54ExpressLanguageApplicationProgrammingInterfacesBasicOperationsCharacterManipulationFunctionsCommunicationsCountingandTestingFunctionsComputerResourceManagementDataManipulationDictionaryOperationsDimensionInformationFinancialFunctionsForecastingandRegressionMiscellaneousInformationandOptionsModelsNumericFunctionsandCommandsNumericOptionsPagingOptionsProgramsSecurityandScopingSystemCommandsandInformationUsingExternalDataWorkingwithWindowsOracleConfidentialExpressLanguageApplicationPr55持续的查询过程查询示例：从费城的最近一个季度的产品中选择销售额大于150K的产品，并且从蠖钭?大的产品。费城季度产品纽约波士顿Q1Q2Q3Q4运动鞋运动衣滑板手套球拍地区持续的查询过程查询示例：费城季度产品纽约波士顿Q1Q2Q3Q56持续的查询过程查询示例：限制

季度

到

Q4季度产品纽约波士顿Q1Q2Q3Q4运动鞋运动衣滑板手套球拍地区费城持续的查询过程查询示例：季度产品纽约波士顿Q1Q2Q3Q4运57持续的查询过程查询示例：限制季度到Q4

限制

地区

到

费城季度产品纽约波士顿Q1Q2Q3Q4运动鞋运动衣滑板手套球拍地区费城持续的查询过程查询示例：季度产品纽约波士顿Q1Q2Q3Q4运58持续的查询过程查询示例：限制季度到Q4

限制

地区到

费城限制产品的销售额大于

150,000季度产品纽约波士顿Q1Q2Q3Q4运动鞋运动衣滑板手套球拍地区费城持续的查询过程查询示例：季度产品纽约波士顿Q1Q2Q3Q4运59持续的查询过程查询示例：限制季度到Q4

限制

地区到

费城限制产品的销售额大于150,000限制

产品的利润额前两位季度产品纽约波士顿Q1Q2Q3Q4运动鞋运动衣滑板手套球拍地区费城持续的查询过程查询示例：季度产品纽约波士顿Q1Q2Q3Q4运60许多实体/公用维BUDGETTimeMarketProductTimeFORECASTScenarioMarketPRICETimeProductTimeSALESMarketProductProduct许多实体/公用维BUDGETTimeMarketProd61派生的实体存放结果在变量中或者由一个计算公式来决定x=价格销售数量销售金额派生的实体存放结果在变量中x=价格销售销售62派生的实体存放结果在变量中或者由一个计算公式来决定这些计算公式可由其它公式得来....x=价格销售数量销售金额派生的实体存放结果在变量中x=价格销售销售63多个逻辑的最终用户视图产品经理视图地区经理视图财务经理视图总经理视图TimeQ1Q2Q3Q4ProductTentsCanoesRacquetsSportswearFootwearPhiladelphiaNewYorkBostonDistrict多个逻辑的最终用户视图产品经理视图地区经理视图财务经理视图64多维分析举例查询上季度在费城地区，营利最多的2种产品。这些产品的销售额必须大于15万元。Philadelphia时间产品NewYorkBostonQ1Q2Q3Q4TentsCanoesRacquetsSportswearFootwear地区多维分析举例查询上季度在费城地区，营利最多的2种产品。这些65多维数据分析在过去半年内，华北地区实际销售额与预算相比较如何。公司产品在东北地区的销售情况与华北地区相比较如何一月份产品销售情况与去年同期相比较增长率为多少进行比较分析销售额东北地区华北地区华南地区产品一产品二产品三一月三月二月1201151236075739287106多维数据分析在过去半年内，华北地区实际销售额与预算相比较如何66那些产品在过去半年内销售额发展趋势为负增长那些产品的销售比预算低5%以上，并占总销售额的10%以上产品销售总额过去两年的总体变化情况如何异常分析报告，趋势分析多维数据分析Sales东北地区华北地区.华南地区产品一产品二产品三一月三月二月1201151236075739287106那些产品在过去半年内销售额发展趋势为负增长异常分析报告，趋势67如果产品一价格下调5%,销售量增加3%，结果将如何？如果在东北地区增加一个销售人员，销售额将会如何？根据今年的销售情况，预测明年上半年销售发展。应用模型，预测多维数据分析Sales东北地区华北地区.华南地区产品一产品二产品三一月三月二月1201151236075739287106如果产品一价格下调5%,销售量增加3%，结果将如何？应用模型68ExpressObjects为IS专业开发人员设计面向对象的,可视化的OLAP开发工具内置Data-Aware控件ExpressObjects为IS专业开发人员设计69ExpressAnalyzer面向最终用户的报表和分析工具通过交互式的分析简报发布分析结果提供Drill,pivot和what-if分析能力运行ExpressObjects开发的应用ExpressAnalyzer面向最终用户的报表和分析工具70PersonalExpressEnablesMobileOLAPExpressServerUnix/MainframePersonalExpressWindowsRDBMSOLAPClientPersonalExpressEnablesMobil71OracleDSSProductFamilyOracleExpressServerExpressAdministratorRelationalAccessManagerOtherLegacy&ExternalDataRelationalDatabaseManagementSystemsExpressWebAgentExpressObjectsExpressAnalyzerExpressWebPublisherSalesAnalyzerFinancialAnalyzer3rdPartyTools&AppsOracleReportsOracleDiscovererOracleDSSProductFamilyOracl72EnablingtheInformationAgeTMEnablingtheInformationAgeTM73OracleDataWarehouseSolutionOracle(China)PresalesConsultantXuXinOracleDataWarehouseSolution74数据仓库几大功能Query/ReportDrillup/DrillDownCompareExceptionForcast,WhatifDataMining数据仓库几大功能Query/Report75数据仓库三大流程数据建模DataModelDesign数据抽取

DataExtract,Transform,Transport数据表现Rolap,Molap

DataDelivery,Drillup/Drilldown,DataRotation,DataMining数据仓库三大流程数据建模76ROLAP/MOLAP-争论的焦点在哪里定义:ROLAP=基于关系的OLAPMOLAP=基于多维的OLAPROLAP/MOLAP-争论的焦点在哪里定义:77ROLAP供应商说:你能用关系技术做所有的事情?MOLAPROLAP供应商说:你用多维数据库能做得更好ROLAP供应商仅仅能做ROLAP....MOLAP供应商仅仅能做MOLAP....ORACLE能提供ROLAP和MOLAPROLAP/MOLAP-争论的焦点在哪里ROLAP供应商说:ROLAP/MOLAP-争78ROLAP和MOLAP-Oracle的解决方案OracleROLAPDataMartSuite--建模，数据抽取的工具Discoverer--基于关系数据库的分析工具多维数据的视图,挖掘和旋转OracleMOLAPExpress系列产品提供MOLAP的方案多维数据的视图,挖掘和旋转,计算和存取、预测Oracle能提供ROLAP和MOLAPExpress系列产品能做MOLAP和ROLAPROLAP和MOLAP-Oracle的解决方案Oracl79OFA,OSAApplicationsExpressPowerAnalysisDiscovererQuery,Reporting,AnalysisDecisionsComponentsofaDataWarehouse/MartOLTPOLTPExternalDataOperationsData

StorageOFA,OSAExpressDiscovererDecis80DataMartSuiteAddValueToTheOracleWarehouseDataMartSuite81DataMartSuite2.0-ComponentsGreat8-Oracle8,release8.0.4Dashing-DataMartDesigner2.1Better-DataMartBuilder2.0Debonair-Discoverer3.1Awesome-WebApplicationServer3.0.1Ravishing-ReportsServer3.0Compelling-CookbookDataMartSuite2.0-Componen82DesignandManagementAnyDataAnyAccessAnySourceMetadata

ConstructionMethodology

Drag&dropvisualmetaphorData

ModelingIdentifydatasourcesIdentifysourcesubsetModelStarSchemaProcess

ModelingBuildPlansDimensiontablesTimeDimensionFacttablePopulatedatabaseBusinessModelingDefineend-userlayerDesignandManagementAnyDataA83Oracle8iforDataWarehousing

ContinuousInnovationOracle7.3HashJoinBitmapIndexesParallel-AwareOptimizerPartitionViewsInstanceAffinity:FunctionShippingParallelUnionAllAsynchronousRead-AheadHistogramsAnti-JoinPartitionedTablesandIndexesPartitionPruningParallelIndexScansParallelInsert,Update,DeleteParallelBitmapStarQueryParallelANALYZEParallelConstraintEnablingServerManagedBackup/RecoveryPoint-in-TimeRecoveryOracle8.0SummaryManagementNewPartitioningSchemesResourceManagerProgressMonitorAdaptiveParallelQueryServer-basedAnalyticFunctionsTransportableTablespacesDirectLoaderAPIFunctionalIndexesPartition-wiseJoinsSecurityEnhancements andmore...Oracle8iOracle8iforDataWarehousing84DataModeling

OracleDataMartDesignerTableorders(constraintc_o_datecheck(O_entry_dbetweento_date(?1-jan-1997?慸d-mon-yyyy?andto_date(?1-dec-1997?慸d-mon-yyyy?)disable,o_id number,o_d_id number,o_w_id number,o_c_id number,o_entry_d date,o_carrier_id number,o_ol_cnt number,o_all_local number)tablespaceordinitrans3pctfree5storage(initial20Knext110Mpctincrease0freelistgroups19freelists9);Source:OLTPProductdescriptionsizeflavorpackagePromotiondescriptiondealdiscountmediaMarketdescriptiondistrictregiondemographicsTimedescriptionweekdayholidayfiscalFactTableTarget:DataMartDataModeling

OracleDataMart85ProcessModeling

OracleDataMartBuilderOrders-ExtractSQLQueryProductProduct_LineProduct_GroupShipShipperContactCus_LocOrdersContact_LocProduct

LookupMarket

LookupPromotionLookupTime

LookupDirectPathLoader

Oracle

Data

Mart

BuilderProcessModeling

OracleData86MetadataIntegrationProductdescriptionsizeflavorpackagePromotiondescriptiondealdiscountmediaMarketdescriptiondistrictregiondemographicsTimedescriptionweekdayholidayfiscalFactTableOrders-ExtractSQLQueryProduct

LookupMarket

LookupPromotionLookupTime

LookupDirectPathLoader

Oracle

Data

Mart

BuilderOracleDiscovererOracle

Data

Mart

DesignerMetadataMetadataIntegrationProductPro87决策支持系统的范围IT人员为用户开发业务用户独立分析专业分析人员标准报表即席查询分析复杂分析决策支持系统的范围IT人员业务用户专业分析人员标准报表即席88Oracle决策支持工具集标准报表即席查询分析复杂分析上季度各地区销售情况如何？什么原因造成东南亚地区的业务下降?如果同样的因素影响到其它地区，将会对全球的业务造成什么影响?OracleExpressOracleDiscovererOracleReportsOracle决策支持工具集标准报表即席查询分析复杂分析上季89Oracle决策支持工具集标准报表-OracleReports集中式报表生成存储输出发布高质量的报表即席查询分析-Discoverer即席查询,数据钻入，旋转业界领先的易用性和性能复杂分析-ExpressOn-lineAnalyticalProcessing(OLAP)高级计算财务,时间序列,建模,预测,回归分析，假设分析Oracle决策支持工具集标准报表-OracleRe90OracleReportsWhatisit?FormatsanddistributesdatabaseinformationKeyadvantagesUnlimiteddataformattingDistributeshighfidelityreportsviatheWebApplicationserverbasedreportingengineOracleExpressOracleDiscovererOracleReportsProductionReportingAdHocQuery,AnalysisAdvancedAnalysisOracleReportsWhatisit?Orac91OracleDiscoverAddValueToTheOracleWarehouseOracleDiscover92OracleDiscovererWhatisit:AdhocqueryandanalysisofrelationaldataKeyadvantages:Award-winningeaseofuseIndustry-leadingqueryperformanceOracleExpressOracleDiscovererOracleReportsProductionReportingAdHocQuery,AnalysisAdvancedAnalysisOracleDiscovererWhatisit:93Discovereris:10timesfasterthan

Cognos

9timesfasterthan

BusinessObjectsMarket-LeadingPerformanceTimetoquery100,000rows:CognosBusinessObjectsDiscovererDiscovereris:Market-LeadingP94OracleDiscoverer3.1

UserEditionBusinessAbstractionLayerEndUserLayer(TM)DataWarehouse/DataMart(orOLTP)UserEditionAdministrationEditionOracleDiscoverer3.1

UserEdi95OracleDiscoverer3.1

UserEdition

SuperiorEaseofUseEaseofUsePerformance WarehouseExploration ExceptionalPerformance NavigationalPower NavigationalPower

OpennessOpennessOracleDiscoverer3.1

UserEdi96MostTestedUIontheMarket Resizeable

WizardInterface IndustrySpecificQuickTour DramaticReductionoftheLearningCurve

andmore...EaseofUseMostTestedUIontheMarket R97EndUserLayerEaseofUseHidestheComplexityoftheUnderlyingDatabaseDatabasecl_addr1||','||cl_addr2|','||cl_addr3||','||cl_twn||','||cl_zipcodesum(nvl(qty*unit_price,0))JonesSmithNameCustomerClientAddressRevenueEasternRegionUserEndUserLayerEaseofUseHides98BatchReportingOpennessToDo...SchedulelongrunningqueriesforlaterEaseofUse9:00Openworkbooks

12:00Refreshworkbooks

3:00ScheduleMonthlyreports

5:00ScheduleQuarterlyreports

5:30GeneratenewreportformanagementmeetingtomorrowBatchReportingOpennessToDo.99SolutiontoLongRunningQueriesReactiveQueryGovernorStopsqueriesafterapre-settime

Usestheresourceswithoutshowingresults!PerformancePredictiveQueryGovernorPredictsthetimeaquerytakesbeforeexecutionDoesnotwastevaluableresources!SolutiontoLongRunningQuer100ManagingLargeDataVolumesSelectLocation,Period,Product,sum(videos_lent)From

video_detailsGroupbyLocation,Period,ProductDetailRowsPerformanceSlowTableScansMachineIntensiveAggregationsManagingLargeDataVolumesSel101SummaryRedirectionSelectLocation,Period,Product,sum(videos_lent)From

video_detailsGroupbyLocation,Period,ProductDetailRowsSummaryTablePerformanceSummaryRedirectionSelectLoca102SelectLocation,Period,Product,SalesFrom

video_summary Automatic!!SummaryRedirectionDetailRowsSummaryTablePerformanceSelectLocation,Period,Produ103ServerClientNetworkResultsBase:CubicClientCachePerformanceEfficientStorageAlgorithmMultidimensionalaccessRapidrotation,drillServerClientNetworkResultsBase104RegionNorthParisProductYearDetailRowsExternalDataDrillEverywhereDrillDownDrillAcrossDrilltoDetailDrillOut NavigationalPowerRegionNorthParisProductYearDet105WebPublishing NavigationalPowerWebPublishing NavigationalPo106IntegrationReportsExpressOpennessMAPIIntegrationReportsExpressOpenn107

OracleDiscoverer3.1

AdministrationEditionSuperiorEaseofUseEaseofUse SummaryManagementServerBasedAdministrationServerBasedAdministrationAdvancedSummary

Management

OracleDiscoverer3.1

Adminis108ServerBasedAbstractionLayerServerBasedAdministrationEaseofUsePRODUCTIONEUL(RDBMS)Sales...Marketing匜inance匛ducation匔onsultancyUsersAdministratorRead/WriteReadOnlyEasytoCreate,MaintainandSetupScaleableLeverageSecurityServerBasedAbstractionLayer109Open-ODBCDB2SybaseInformixSQLServerOracle?.ODBCEnhancementsOpennessOracleEndUserLayerEULGatewayDes/2000ETTToolsApplicationsQueryToolsOpen-ODBC?.ODBCEnhancements110BuildSummariesfromQueriesQueryperformancestatisticsSummarymanagementrecommendationsSummaryManagement111BuildSummariesfromQueriesQuDefinitionsData

WarehouseAmulti-subjectinformationstoreDesignedspecificallyfordecisionsupportData

MartAsubjectorapplication-specificdatawarehouseTypes:Dependent,IndependentDefinitionsDataWarehouse112DWvs.DataMart Warehouse DataMartScope Corporate Line-of-BusinessSubjects multi-subject subject-specificDataSources many fewSize 100GB-1TB+ <100GBImplementation months-years monthsWarehouseDataMartDWvs.DataMart Warehouse Da113OracleExpressOracleWarehouseOracleExpress114OracleExpressWhatisit:AdvancedanalysisofmultidimensionalandrelationaldataKeyadvantages:BroadestrangeofanalyticalfunctionsScaleableperformanceIntegrateddevelopmentenvironmentOracleExpressOracleDiscovererOracleReportsProductionReportingAdHocQuery,AnalysisAdvancedAnalysisOracleExpressWhatisit:Orac115OracleExpressKeyDifferentiatorsAdvancedanalysisBuilt-inforecastingMulti-userwhat-ifAutomaticsimultaneousmodelsProgrammableserverScaleableperformanceAnalysisofexistingrelationaldatabasesMultiplecubes,hierarchiesperschemaIntegrateddevelopmentenvironmentBroadestrangeofcapabilitiesOracleExpressKeyDifferentia116可扩展的多维数据库服务器,内置强大的分析

功能和决策支持能力PersonalExpress,ExpressServer用于销售分析,市场分析,财务分析的OLAP应用产品SalesAnalyzer,FinancialAnalyzer面向对象的OLAP应用开发工具ExpressAnalyzer,ExpressObjectsExpressServerExpressApplicationsExpressToolsOracleOLAP-ExpressProducts可扩展的多维数据库服务器,内置强大的分析功能和决策支持能117Express一个专门为查询和分析商业情报数据而设计的服务器Express一个专门为查询和分析商业情报数据而设计的服务118Express?对于一些分析查询和计算,Express比关系型技术快10倍，100倍，甚至1000倍JerryHeldSeniorVP,ServerTechnologies,OracleCorporation查询速度如此快，使Express具有很强的竞争能力.Express?对于一些分析查询和计算,Express比119多维数据模型辖区经理/行长财务经理任意分析PRODTIME资金经理为数据提供快速，灵活的访问方法金融产品时间头寸辖区多维数据模型辖区经理/行长财务经理任意分析PRODTIME120对时间，日期的智能处理，系统相关数据自行汇总。根据数据建立层次关系数据自行汇总在维上建立层次关系对时间，日期的智能处理，