




版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
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对时间,日期的智能处理,系统相关数据自行汇总。根据数据建立层次关系数据自行汇总在维上建立层次关系对时间,日期的智能处理,
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 云南省曲靖市2025届高三上学期第一次教学质量监测试题 物理 含解析
- XX学院附属中学班级量化管理考核实施方案
- 事业单位聘用合同续签书
- 停车场承包合同新
- 厂房电气安装安装合同
- 水上光伏预制管桩施工方案
- 韶关采光井造景施工方案
- 汽车零部件生产质量控制题库
- 2025年幼儿园综合课活动标准教案
- 四川桥梁栏杆定制施工方案
- 湘教版地理八年级下册 第五章 中国的地域差异 综合测试卷(含答案)
- 电线电缆质量缺陷修复规范(暂行)
- 小儿鼾症课件
- 药店门店店长述职报告
- 2024年电工(初级)操作证考试题库附答案
- 2024年湖南省公务员考试《行测》真题及答案解析
- 建筑构造-教材说课-李银星
- XX基于物联网技术的智慧养老院建设方案
- 2024年执业医师考试-临床执业助理医师考试近5年真题集锦(频考类试题)带答案
- 断绝父子关系协议书
- 金属材料课程设计作业
评论
0/150
提交评论