Oracle的解决方案(ppt 73页).ppt

OracleDataWarehouseSolution,Oracle(China)PresalesConsultantXuXin,数据仓库几大功能,Query/ReportDrillup/DrillDownCompareExceptionForcast,WhatifDataMining,数据仓库三大流程,数据建模DataModelDesign数据抽取DataExtract,Transform,Transport数据表现Rolap,MolapDataDelivery,Drillup/Drilldown,DataRotation,DataMining,ROLAP/MOLAP-争论的焦点在哪里,定义:ROLAP=基于关系的OLAPMOLAP=基于多维的OLAP,ROLAP供应商说:你能用关系技术做所有的事情?MOLAPROLAP供应商说:你用多维数据库能做得更好ROLAP供应商仅仅能做ROLAP.MOLAP供应商仅仅能做MOLAP.ORACLE能提供ROLAP和MOLAP,ROLAP/MOLAP-争论的焦点在哪里,ROLAP和MOLAP-Oracle的解决方案,OracleROLAPDataMartSuite-建模，数据抽取的工具Discoverer-基于关系数据库的分析工具多维数据的视图,挖掘和旋转OracleMOLAPExpress系列产品提供MOLAP的方案多维数据的视图,挖掘和旋转,计算和存取、预测Oracle能提供ROLAP和MOLAPExpress系列产品能做MOLAP和ROLAP,ComponentsofaDataWarehouse/Mart,DataMartSuiteAddValueToTheOracleWarehouse,DataMartSuite2.0-Components,Great8-Oracle8,release8.0.4Dashing-DataMartDesigner2.1Better-DataMartBuilder2.0Debonair-Discoverer3.1Awesome-WebApplicationServer3.0.1Ravishing-ReportsServer3.0Compelling-Cookbook,DesignandManagement,AnyData,AnyAccess,AnySource,Metadata,ConstructionMethodologyDrag,Source:OLTP,Target:DataMart,ProcessModelingOracleDataMartBuilder,MetadataIntegration,OracleDataMartBuilder,OracleDiscoverer,OracleDataMartDesigner,Metadata,决策支持系统的范围,Oracle决策支持工具集,Oracle决策支持工具集,标准报表-OracleReports集中式报表生成存储输出发布高质量的报表即席查询分析-Discoverer即席查询,数据钻入，旋转业界领先的易用性和性能复杂分析-ExpressOn-lineAnalyticalProcessing(OLAP)高级计算财务,时间序列,建模,预测,回归分析，假设分析,OracleReports,Whatisit?FormatsanddistributesdatabaseinformationKeyadvantagesUnlimiteddataformattingDistributeshighfidelityreportsviatheWebApplicationserverbasedreportingengine,OracleExpress,OracleDiscoverer,OracleReports,ProductionReporting,AdHocQuery,Analysis,AdvancedAnalysis,OracleDiscoverAddValueToTheOracleWarehouse,OracleDiscoverer,Whatisit:AdhocqueryandanalysisofrelationaldataKeyadvantages:Award-winningeaseofuseIndustry-leadingqueryperformance,OracleExpress,OracleDiscoverer,OracleReports,ProductionReporting,AdHocQuery,Analysis,AdvancedAnalysis,Discovereris:10timesfasterthanCognos9timesfasterthanBusinessObjects,Market-LeadingPerformance,Timetoquery100,000rows:,Cognos,BusinessObjects,Discoverer,OracleDiscoverer3.1UserEdition,OracleDiscoverer3.1UserEdition,SuperiorEaseofUse,EaseofUse,Performance,WarehouseExploration,ExceptionalPerformance,NavigationalPower,Openness,Openness,MostTestedUIontheMarket,ResizeableWizardInterfaceIndustrySpecificQuickTourDramaticReductionoftheLearningCurveandmore.,EndUserLayer,HidestheComplexityoftheUnderlyingDatabase,User,BatchReporting,Openness,ToDo.,Schedulelongrunningqueriesforlater,9:00Openworkbooks12:00Refreshworkbooks3:00ScheduleMonthlyreports5:00ScheduleQuarterlyreports5:30Generatenewreportformanagementmeetingtomorrow,SolutiontoLongRunningQueries,PredictiveQueryGovernor,ManagingLargeDataVolumes,SelectLocation,Period,Product,sum(videos_lent)Fromvideo_detailsGroupbyLocation,Period,Product,DetailRows,SlowTableScansMachineIntensiveAggregations,SummaryRedirection,SelectLocation,Period,Product,sum(videos_lent)Fromvideo_detailsGroupbyLocation,Period,Product,DetailRows,SummaryTable,SelectLocation,Period,Product,SalesFromvideo_summary,SummaryRedirection,DetailRows,SummaryTable,Server,Client,Network,ResultsBase:CubicClientCache,EfficientStorageAlgorithmMultidimensionalaccessRapidrotation,drill,North,Paris,DetailRows,ExternalData,DrillEverywhere,DrillDownDrillAcrossDrilltoDetailDrillOut,WebPublishing,Integration,Openness,OracleDiscoverer3.1AdministrationEdition,SuperiorEaseofUse,EaseofUse,ServerBasedAdministration,AdvancedSummaryManagement,ServerBasedAbstractionLayer,ServerBased,Administration,Sales.Marketing匜inance匛ducation匔onsultancyUsers,Administrator,Read/Write,ReadOnly,EasytoCreate,MaintainandSetupScaleableLeverageSecurity,Open-ODBC,Enhancements,38,BuildSummariesfromQueries,QueryperformancestatisticsSummarymanagementrecommendations,Definitions,DataWarehouseAmulti-subjectinformationstoreDesignedspecificallyfordecisionsupportDataMartAsubjectorapplication-specificdatawarehouseTypes:Dependent,Independent,DWvs.DataMart,WarehouseDataMartScopeCorporateLine-of-BusinessSubjectsmulti-subjectsubject-specificDataSourcesmanyfewSize100GB-1TB+100GBImplementationmonths-yearsmonths,Warehouse,DataMart,OracleExpressOracleWarehouse,OracleExpress,Whatisit:AdvancedanalysisofmultidimensionalandrelationaldataKeyadvantages:BroadestrangeofanalyticalfunctionsScaleableperformanceIntegrateddevelopmentenvironment,OracleExpress,OracleDiscoverer,OracleReports,ProductionReporting,AdHocQuery,Analysis,AdvancedAnalysis,OracleExpressKeyDifferentiators,AdvancedanalysisBuilt-inforecastingMulti-userwhat-ifAutomaticsimultaneousmodelsProgrammableserverScaleableperformanceAnalysisofexistingrelationaldatabasesMultiplecubes,hierarchiesperschemaIntegrateddevelopmentenvironmentBroadestrangeofcapabilities,可扩展的多维数据库服务器,内置强大的分析功能和决策支持能力PersonalExpress,ExpressServer,用于销售分析,市场分析,财务分析的OLAP应用产品SalesAnalyzer,FinancialAnalyzer,面向对象的OLAP应用开发工具ExpressAnalyzer,ExpressObjects,ExpressServer,ExpressApplications,ExpressTools,OracleOLAP-ExpressProducts,Express,一个专门为查询和分析商业情报数据而设计的服务器,Express,?对于一些分析查询和计算,Express比关系型技术快10倍，100倍，甚至1000倍JerryHeldSeniorVP,ServerTechnologies,OracleCorporation查询速度如此快，使Express具有很强的竞争能力.,多维数据模型,辖区经理/行长,财务经理,任意分析,资金经理,为数据提供快速，灵活的访问方法,金融产品,时间,头寸,辖区,对时间，日期的智能处理，系统相关数据自行汇总。根据数据建立层次关系数据自行汇总,在维上建立层次关系,KEYS,相同的数学模型,多维数据库服务器的特性,立方体，页，片的数据维=主键只存放一次，重复使用强制性保证数据完整性节省磁盘空间极容易地结合数据和公式支持共享的商业逻辑保证数据的一致性每一个单元都被索引因此有很高的存取效率,Time,product,Geography,数据存放,Philadelphia,NewYork,Boston,Q1,Q2,Q3,Q4,Tents,Canoes,Racquets,Sportswear,Footwear,数据页,数据存取,关系数据库多维数据库,Sales,Cost,Units,Date,Mkt,Prod,Sales,Cost,Units,Date,Mkt,Prod,Sales,Cost,Units,Date,Mkt,Prod,Sales,Cost,Units,Date,Mkt,Prod,只要读取一页,要读取两页,数据存取方法,District,Quarter,Product,NewYork,Boston,Philadelphia,Q1,Q2,Q3,Q4,Tents,Canoes,Racquets,Sportswear,Footwear,偏移地址存取更强有力的分析能力更好的执行效率,很多的已建好的函数,FinancialFunctionsDepreciation折旧率GrowthRate增长率NetPresentValue现值InternalRateofReturn,Numeric/TimeSeriesFunctionsAverage平均值CumulativeSums累积和Lag/Lead落后/领先Variance变动率MovingAverage/Total移动平均值Smallest/Largest最大/最小StandardDeviation水平偏差Total总和,OtherFunctionsForecastingRegression,.你也能创建你自己的函数,OracleConfidential,ExpressLanguage,ApplicationProgrammingInterfacesBasicOperationsCharacterManipulationFunctionsCommunicationsCountingandTestingFunctionsComputerResourceManagementDataManipulationDictionaryOperationsDimensionInformationFinancialFunctions,ForecastingandRegressionMiscellaneousInformationandOptionsModelsNumericFunctionsandCommandsNumericOptionsPagingOptionsProgramsSecurityandScopingSystemCommandsandInformationUsingExternalDataWorkingwithWindows,持续的查询过程,查询示例：从费城的最近一个季度的产品中选择销售额大于150K的产品，并且从蠖钭?大的产品。,费城,季度,产品,纽约,波士顿,Q1,Q2,Q3,Q4,运动鞋,运动衣,滑板,手套,球拍,地区,持续的查询过程,查询示例：限制季度到Q4,季度,产品,纽约,波士顿,Q1,Q2,Q3,Q4,运动鞋,运动衣,滑板,手套,球拍,地区,费城,持续的查询过程,查询示例：限制季度到Q4限制地区到费城,季度,产品,纽约,波士顿,Q1,Q2,Q3,Q4,运动鞋,运动衣,滑板,手套,球拍,地区,费城,持续的查询过程,查询示例：限制季度到Q4限制地区到费城限制产品的销售额大于150,000,季度,产品,纽约,波士顿,Q1,Q2,Q3,Q4,运动鞋,运动衣,滑板,手套,球拍,地区,费城,持续的查询过程,查询示例：限制季度到Q4限制地区到费城限制产品的销售额大于150,000限制产品的利润额前两位,季度,产品,纽约,波士顿,Q1,Q2,Q3,Q4,运动鞋,运动衣,滑板,手套,球拍,地区,费城,许多实体/公用维,Product,派生的实体,存放结果在变量中或者由一个计算公式来决定,x,=,价格,销售金额,派生的实体,存放结果在变量中或者由一个计算公式来决定这些计算公式可由其它公式得来.,x,=,价格,销售金额,多个逻辑的最终用户视图,产品经理视图,地区经理视图,财务经理视图,总经理视图,多维分析举例,查询上季度在费城地区，营利最多的2种产品。这些产品的销售额必须大于15万元。,Philadelphia,时间,产品,NewYork,Boston,Q1,Q2,Q3,Q4,Tent