数据仓库解决方案.pptx
- 文档编号:15122968
- 上传时间:2023-07-01
- 格式:PPTX
- 页数:73
- 大小:965.93KB
数据仓库解决方案.pptx
《数据仓库解决方案.pptx》由会员分享,可在线阅读,更多相关《数据仓库解决方案.pptx(73页珍藏版)》请在冰点文库上搜索。
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,DataStorage,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&dropvisualmetaphor,DataModelingIdentifydatasourcesIdentifysourcesubsetModelStarSchemaProcessModelingBuildPlansDimensiontablesTimeDimensionFacttablePopulatedatabaseBusinessModelingDefineend-userlayer,Oracle8iforDataWarehousingContinuousInnovation,Oracle7.3,HashJoinBitmapIndexesParallel-AwareOptimizerPartitionViewsInstanceAffinity:
FunctionShippingParallelUnionAllAsynchronousRead-AheadHistogramsAnti-Join,PartitionedTablesandIndexesPartitionPruningParallelIndexScansParallelInsert,Update,DeleteParallelBitmapStarQueryParallelANALYZEParallelConstraintEnablingServerManagedBackup/RecoveryPoint-in-TimeRecovery,Oracle8.0,SummaryManagementNewPartitioningSchemesResourceManagerProgressMonitorAdaptiveParallelQueryServer-basedAnalyticFunctionsTransportableTablespacesDirectLoaderAPIFunctionalIndexesPartition-wiseJoinsSecurityEnhancementsandmore.,Oracle8i,DataModelingOracleDataMartDesigner,Tableorders(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:
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,NavigationalPower,Openness,Openness,MostTestedUIontheMarket,ResizeableWizardInterfaceIndustrySpecificQuickTourDramaticReductionoftheLearningCurveandmore.,EaseofUse,EndUserLayer,EaseofUse,HidestheComplexityoftheUnderlyingDatabase,User,BatchReporting,Openness,ToDo.,Schedulelongrunningqueriesforlater,EaseofUse,9:
00Openworkbooks12:
00Refreshworkbooks3:
00ScheduleMonthlyreports5:
00ScheduleQuarterlyreports5:
30Generatenewreportformanagementmeetingtomorrow,SolutiontoLongRunningQueries,Performance,PredictiveQueryGovernor,ManagingLargeDataVolumes,SelectLocation,Period,Product,sum(videos_lent)Fromvideo_detailsGroupbyLocation,Period,Product,DetailRows,Performance,SlowTableScansMachineIntensiveAggregations,SummaryRedirection,SelectLocation,Period,Product,sum(videos_lent)Fromvideo_detailsGroupbyLocation,Period,Product,DetailRows,SummaryTable,Performance,SelectLocation,Period,Product,SalesFromvideo_summary,Automatic!
SummaryRedirection,DetailRows,SummaryTable,Performance,Server,Client,Network,ResultsBase:
CubicClientCache,Performance,EfficientStorageAlgorithmMultidimensionalaccessRapidrotation,drill,Region,North,Paris,Product,Year,DetailRows,ExternalData,DrillEverywhere,DrillDownDrillAcrossDrilltoDetailDrillOut,NavigationalPower,WebPublishing,NavigationalPower,Integration,Reports,Express,Openness,MAPI,OracleDiscoverer3.1AdministrationEdition,SuperiorEaseofUse,EaseofUse,SummaryManagement,ServerBasedAdministration,AdvancedSummaryManagement,ServerBasedAbstractionLayer,ServerBased,Administration,EaseofUse,PRODUCTIONEUL(RDBMS),Sales.Marketing匜inance匛ducation匔onsultancyUsers,Administrator,Read/Write,ReadOnly,EasytoCreate,MaintainandSetupScaleableLeverageSecurity,Open-ODBC,Enhancements,Openness,BuildSummariesfromQueries,QueryperformancestatisticsSummarymanagementrecommendations,SummaryManagement,38,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,.你也能创建你自己的函数,ExpressLanguage,ApplicationProgrammingInterfacesBasicOperationsCharacterManipulationFunctionsCommunicationsCountingandTestingFunctionsComputerResourceManagementDataManipulationDictionaryOperationsDimensionInformationFinancialFunctions,ForecastingandRegressionMiscellaneousInformationandOptionsModelsNumericFunctionsandCommandsNumericOptionsPagingOptionsProgramsSecurityandScopingSystemCommandsandInformationUsingExternalDataWorkingwithWindows,OracleConfidential,持续的查询过程,查询示例:
从费城的最近一个季度的产品中选择销售额大于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,Tents,Canoes,Racquets,Sportswear,Footwear,地区,多维数据分析,在过去半年内,华北地区实际销售额与预算相比较如何。
公司产品在东北地区的销售情况与华北地区相比较如何一月份产品销售情况与去年同期相比较增长率为多少,进行比较分析,销售额,东北地区,华北地区,华南地区,产品一,产品二,产品三,一月,三月,二月,120,115,123,60,75,73,92,87,106,那些产品在过去半年内销售额发展趋势为负增长那些产品的销售比预算低5%以上,并占总销售额的10%以上产品销售总额过去两年的总体变化情况如何,异常分析报告,趋势分析,多维数据分析,Sales,东北地区,华北地区.,华南地区,产品一,产品二,产品三,一月,三月,二月,120,115,123,60,75,73,92,87,106,如果产品一价格下调5%,销售量增加3%,结果将如何?
如果在东北地区增加一个销售人员,销售额将会如何?
根据今年的销售情况,预测明年上半年销售发展。
应用模型,预测,多维数据分析,Sales,东北地区,华北地区.,华南地区,产品一,产品二,产品三,一月,三月,二月,120,115,123,60,75,73,92,87,106,ExpressObjects,为IS专业开发人员设计面向对象的,可视化的OLAP开发工具内置Data-Aware控件,ExpressAnalyzer,面向最终用户的报表和分析工具通过交互式的分析简报发布分析结果提供Drill,pivot和what-if分析能力运行ExpressObjects开发的应用,Persona
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 数据仓库 解决方案