數(shù)據(jù)倉(cāng)庫(kù)解決方案課件

OracleDataWarehouseSolutionOracle(China)PresalesConsultantXuXinOracleDataWarehouseSolution1數(shù)據(jù)倉(cāng)庫(kù)幾大功能Query/ReportDrillup/DrillDownCompareExceptionForcast,WhatifDataMining數(shù)據(jù)倉(cāng)庫(kù)幾大功能Query/Report2數(shù)據(jù)倉(cāng)庫(kù)三大流程數(shù)據(jù)建模DataModelDesign數(shù)據(jù)抽取

DataExtract,Transform,Transport數(shù)據(jù)表現(xiàn)Rolap,Molap

DataDelivery,Drillup/Drilldown,DataRotation,DataMining數(shù)據(jù)倉(cāng)庫(kù)三大流程數(shù)據(jù)建模3ROLAP/MOLAP-爭(zhēng)論的焦點(diǎn)在哪里定義:ROLAP=基于關(guān)系的OLAPMOLAP=基于多維的OLAPROLAP/MOLAP-爭(zhēng)論的焦點(diǎn)在哪里定義:4ROLAP供應(yīng)商說:你能用關(guān)系技術(shù)做所有的事情?MOLAPROLAP供應(yīng)商說:你用多維數(shù)據(jù)庫(kù)能做得更好ROLAP供應(yīng)商僅僅能做ROLAP....MOLAP供應(yīng)商僅僅能做MOLAP....ORACLE能提供ROLAP和MOLAPROLAP/MOLAP-爭(zhēng)論的焦點(diǎn)在哪里ROLAP供應(yīng)商說:ROLAP/MOLAP-爭(zhēng)5ROLAP和MOLAP-Oracle的解決方案OracleROLAPDataMartSuite--建模，數(shù)據(jù)抽取的工具Discoverer--基于關(guān)系數(shù)據(jù)庫(kù)的分析工具多維數(shù)據(jù)的視圖,挖掘和旋轉(zhuǎn)OracleMOLAPExpress系列產(chǎn)品提供MOLAP的方案多維數(shù)據(jù)的視圖,挖掘和旋轉(zhuǎn),計(jì)算和存取、預(yù)測(cè)Oracle能提供ROLAP和MOLAPExpress系列產(chǎn)品能做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決策支持系統(tǒng)的范圍IT人員為用戶開發(fā)業(yè)務(wù)用戶獨(dú)立分析專業(yè)分析人員標(biāo)準(zhǔn)報(bào)表即席查詢分析復(fù)雜分析決策支持系統(tǒng)的范圍IT人員業(yè)務(wù)用戶專業(yè)分析人員標(biāo)準(zhǔn)報(bào)表即席15Oracle決策支持工具集標(biāo)準(zhǔn)報(bào)表即席查詢分析復(fù)雜分析上季度各地區(qū)銷售情況如何？什么原因造成東南亞地區(qū)的業(yè)務(wù)下降?如果同樣的因素影響到其它地區(qū)，將會(huì)對(duì)全球的業(yè)務(wù)造成什么影響?OracleExpressOracleDiscovererOracleReportsOracle決策支持工具集標(biāo)準(zhǔn)報(bào)表即席查詢分析復(fù)雜分析上季16Oracle決策支持工具集標(biāo)準(zhǔn)報(bào)表-OracleReports集中式報(bào)表生成存儲(chǔ)輸出發(fā)布高質(zhì)量的報(bào)表即席查詢分析-Discoverer即席查詢,數(shù)據(jù)鉆入，旋轉(zhuǎn)業(yè)界領(lǐng)先的易用性和性能復(fù)雜分析-ExpressOn-lineAnalyticalProcessing(OLAP)高級(jí)計(jì)算財(cái)務(wù),時(shí)間序列,建模,預(yù)測(cè),回歸分析，假設(shè)分析Oracle決策支持工具集標(biāo)準(zhǔn)報(bào)表-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可擴(kuò)展的多維數(shù)據(jù)庫(kù)服務(wù)器,內(nèi)置強(qiáng)大的分析

功能和決策支持能力PersonalExpress,ExpressServer用于銷售分析,市場(chǎng)分析,財(cái)務(wù)分析的OLAP應(yīng)用產(chǎn)品SalesAnalyzer,FinancialAnalyzer面向?qū)ο蟮腛LAP應(yīng)用開發(fā)工具ExpressAnalyzer,ExpressObjectsExpressServerExpressApplicationsExpressToolsOracleOLAP-ExpressProducts可擴(kuò)展的多維數(shù)據(jù)庫(kù)服務(wù)器,內(nèi)置強(qiáng)大的分析功能和決策支持能44Express一個(gè)專門為查詢和分析商業(yè)情報(bào)數(shù)據(jù)而設(shè)計(jì)的服務(wù)器Express一個(gè)專門為查詢和分析商業(yè)情報(bào)數(shù)據(jù)而設(shè)計(jì)的服務(wù)45Express?對(duì)于一些分析查詢和計(jì)算,Express比關(guān)系型技術(shù)快10倍，100倍，甚至1000倍JerryHeldSeniorVP,ServerTechnologies,OracleCorporation查詢速度如此快，使Express具有很強(qiáng)的競(jìng)爭(zhēng)能力.Express?對(duì)于一些分析查詢和計(jì)算,Express比46多維數(shù)據(jù)模型轄區(qū)經(jīng)理/行長(zhǎng)財(cái)務(wù)經(jīng)理任意分析PRODTIME資金經(jīng)理為數(shù)據(jù)提供快速，靈活的訪問方法金融產(chǎn)品時(shí)間頭寸轄區(qū)多維數(shù)據(jù)模型轄區(qū)經(jīng)理/行長(zhǎng)財(cái)務(wù)經(jīng)理任意分析PRODTIME47對(duì)時(shí)間，日期的智能處理，系統(tǒng)相關(guān)數(shù)據(jù)自行匯總。根據(jù)數(shù)據(jù)建立層次關(guān)系數(shù)據(jù)自行匯總在維上建立層次關(guān)系對(duì)時(shí)間，日期的智能處理，在維上建立層次關(guān)系48KEYS相同的數(shù)學(xué)模型華東區(qū)域華中月份產(chǎn)品西南Jan膠卷鏡片攝像機(jī)銷售量DIMENSIONSFebMarKEYS相同的數(shù)學(xué)模型華東區(qū)域華中月份產(chǎn)品西南Jan膠卷鏡片49多維數(shù)據(jù)庫(kù)服務(wù)器的特性立方體，頁(yè)，片的數(shù)據(jù)維=主鍵只存放一次，重復(fù)使用強(qiáng)制性保證數(shù)據(jù)完整性節(jié)省磁盤空間極容易地結(jié)合數(shù)據(jù)和公式支持共享的商業(yè)邏輯保證數(shù)據(jù)的一致性每一個(gè)單元都被索引因此有很高的存取效率TimeproductGeography多維數(shù)據(jù)庫(kù)服務(wù)器的特性立方體，頁(yè)，片的數(shù)據(jù)TimepGeog50數(shù)據(jù)存放PhiladelphiaNewYorkBostonQ1Q2Q3Q4TentsCanoesRacquetsSportswearFootwearSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSales數(shù)據(jù)頁(yè)數(shù)據(jù)存放PhiladelphiaNewYorkBoston51數(shù)據(jù)存取SalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSalesSales關(guān)系數(shù)據(jù)庫(kù) 多維數(shù)據(jù)庫(kù)CostCostCostCostCostCostCostCostCostCostCostCostCostCostCostCostSalesCostUnitsDateMktProdSalesCostUnitsDateMktProdSalesCostUnitsDateMktProdSalesCostUnitsDateMktProdSalesCostUnitsDateMktProdSalesCostUnitsDateMktProdSalesCostUnitsDateMktProdSalesCostUnitsDateMktProd只要讀取一頁(yè)要讀取兩頁(yè)數(shù)據(jù)存取SalesSalesSalesSalesSalesS52數(shù)據(jù)存取方法DistrictQuarterProductNewYorkBostonPhiladelphiaQ1Q2Q3Q4TentsCanoesRacquetsSportswearFootwear偏移地址存取更強(qiáng)有力的分析能力更好的執(zhí)行效率數(shù)據(jù)存取方法DistrictQuarterProductNe53很多的已建好的函數(shù)FinancialFunctionsDepreciation折舊率GrowthRate增長(zhǎng)率NetPresentValue現(xiàn)值InternalRateofReturnNumeric/TimeSeriesFunctionsAverage平均值CumulativeSums累積和Lag/Lead落后/領(lǐng)先Variance變動(dòng)率MovingAverage/Total移動(dòng)平均值Smallest/Largest最大/最小StandardDeviation水平偏差Total總和OtherFunctionsForecastingRegression...你也能創(chuàng)建你自己的函數(shù)很多的已建好的函數(shù)FinancialFunctionsNu54ExpressLanguageApplicationProgrammingInterfacesBasicOperationsCharacterManipulationFunctionsCommunicationsCountingandTestingFunctionsComputerResourceManagementDataManipulationDictionaryOperationsDimensionInformationFinancialFunctionsForecastingandRegressionMiscellaneousInformationandOptionsModelsNumericFunctionsandCommandsNumericOptionsPagingOptionsProgramsSecurityandScopingSystemCommandsandInformationUsingExternalDataWorkingwithWindowsOracleConfidentialExpressLanguageApplicationPr55持續(xù)的查詢過程查詢示例：從費(fèi)城的最近一個(gè)季度的產(chǎn)品中選擇銷售額大于150K的產(chǎn)品，并且從蠖鈄?大的產(chǎn)品。費(fèi)城季度產(chǎn)品紐約波士頓Q1Q2Q3Q4運(yùn)動(dòng)鞋運(yùn)動(dòng)衣滑板手套球拍地區(qū)持續(xù)的查詢過程查詢示例：費(fèi)城季度產(chǎn)品紐約波士頓Q1Q2Q3Q56持續(xù)的查詢過程查詢示例：限制

季度

到

Q4季度產(chǎn)品紐約波士頓Q1Q2Q3Q4運(yùn)動(dòng)鞋運(yùn)動(dòng)衣滑板手套球拍地區(qū)費(fèi)城持續(xù)的查詢過程查詢示例：季度產(chǎn)品紐約波士頓Q1Q2Q3Q4運(yùn)57持續(xù)的查詢過程查詢示例：限制季度到Q4

限制

地區(qū)

到

費(fèi)城季度產(chǎn)品紐約波士頓Q1Q2Q3Q4運(yùn)動(dòng)鞋運(yùn)動(dòng)衣滑板手套球拍地區(qū)費(fèi)城持續(xù)的查詢過程查詢示例：季度產(chǎn)品紐約波士頓Q1Q2Q3Q4運(yùn)58持續(xù)的查詢過程查詢示例：限制季度到Q4

限制

地區(qū)到

費(fèi)城限制產(chǎn)品的銷售額大于

150,000季度產(chǎn)品紐約波士頓Q1Q2Q3Q4運(yùn)動(dòng)鞋運(yùn)動(dòng)衣滑板手套球拍地區(qū)費(fèi)城持續(xù)的查詢過程查詢示例：季度產(chǎn)品紐約波士頓Q1Q2Q3Q4運(yùn)59持續(xù)的查詢過程查詢示例：限制季度到Q4

限制

地區(qū)到

費(fèi)城限制產(chǎn)品的銷售額大于150,000限制

產(chǎn)品的利潤(rùn)額前兩位季度產(chǎn)品紐約波士頓Q1Q2Q3Q4運(yùn)動(dòng)鞋運(yùn)動(dòng)衣滑板手套球拍地區(qū)費(fèi)城持續(xù)的查詢過程查詢示例：季度產(chǎn)品紐約波士頓Q1Q2Q3Q4運(yùn)60許多實(shí)體/公用維BUDGETTimeMarketProductTimeFORECASTScenarioMarketPRICETimeProductTimeSALESMarketProductProduct許多實(shí)體/公用維BUDGETTimeMarketProd61派生的實(shí)體存放結(jié)果在變量中或者由一個(gè)計(jì)算公式來(lái)決定x=價(jià)格銷售數(shù)量銷售金額派生的實(shí)體存放結(jié)果在變量中x=價(jià)格銷售銷售62派生的實(shí)體存放結(jié)果在變量中或者由一個(gè)計(jì)算公式來(lái)決定這些計(jì)算公式可由其它公式得來(lái)....x=價(jià)格銷售數(shù)量銷售金額派生的實(shí)體存放結(jié)果在變量中x=價(jià)格銷售銷售63多個(gè)邏輯的最終用戶視圖產(chǎn)品經(jīng)理視圖地區(qū)經(jīng)理視圖財(cái)務(wù)經(jīng)理視圖總經(jīng)理視圖TimeQ1Q2Q3Q4ProductTentsCanoesRacquetsSportswearFootwearPhiladelphiaNewYorkBostonDistrict多個(gè)邏輯的最終用戶視圖產(chǎn)品經(jīng)理視圖地區(qū)經(jīng)理視圖財(cái)務(wù)經(jīng)理視圖64多維分析舉例查詢上季度在費(fèi)城地區(qū)，營(yíng)利最多的2種產(chǎn)品。這些產(chǎn)品的銷售額必須大于15萬(wàn)元。Philadelphia時(shí)間產(chǎn)品NewYorkBostonQ1Q2Q3Q4TentsCanoesRacquetsSportswearFootwear地區(qū)多維分析舉例查詢上季度在費(fèi)城地區(qū)，營(yíng)利最多的2種產(chǎn)品。這些65多維數(shù)據(jù)分析在過去半年內(nèi)，華北地區(qū)實(shí)際銷售額與預(yù)算相比較如何。公司產(chǎn)品在東北地區(qū)的銷售情況與華北地區(qū)相比較如何一月份產(chǎn)品銷售情況與去年同期相比較增長(zhǎng)率為多少進(jìn)行比較分析銷售額東北地區(qū)華北地區(qū)華南地區(qū)產(chǎn)品一產(chǎn)品二產(chǎn)品三一月三月二月1201151236075739287106多維數(shù)據(jù)分析在過去半年內(nèi)，華北地區(qū)實(shí)際銷售額與預(yù)算相比較如何66那些產(chǎn)品在過去半年內(nèi)銷售額發(fā)展趨勢(shì)為負(fù)增長(zhǎng)那些產(chǎn)品的銷售比預(yù)算低5%以上，并占總銷售額的10%以上產(chǎn)品銷售總額過去兩年的總體變化情況如何異常分析報(bào)告，趨勢(shì)分析多維數(shù)據(jù)分析Sales東北地區(qū)華北地區(qū).華南地區(qū)產(chǎn)品一產(chǎn)品二產(chǎn)品三一月三月二月1201151236075739287106那些產(chǎn)品在過去半年內(nèi)銷售額發(fā)展趨勢(shì)為負(fù)增長(zhǎng)異常分析報(bào)告，趨勢(shì)67如果產(chǎn)品一價(jià)格下調(diào)5%,銷售量增加3%，結(jié)果將如何？如果在東北地區(qū)增加一個(gè)銷售人員，銷售額將會(huì)如何？根據(jù)今年的銷售情況，預(yù)測(cè)明年上半年銷售發(fā)展。應(yīng)用模型，預(yù)測(cè)多維數(shù)據(jù)分析Sales東北地區(qū)華北地區(qū).華南地區(qū)產(chǎn)品一產(chǎn)品二產(chǎn)品三一月三月二月1201151236075739287106如果產(chǎn)品一價(jià)格下調(diào)5%,銷售量增加3%，結(jié)果將如何？應(yīng)用模型68ExpressObjects為IS專業(yè)開發(fā)人員設(shè)計(jì)面向?qū)ο蟮?可視化的OLAP開發(fā)工具內(nèi)置Data-Aware控件ExpressObjects為IS專業(yè)開發(fā)人員設(shè)計(jì)69ExpressAnalyzer面向最終用戶的報(bào)表和分析工具通過交互式的分析簡(jiǎn)報(bào)發(fā)布分析結(jié)果提供Drill,pivot和what-if分析能力運(yùn)行ExpressObjects開發(fā)的應(yīng)用ExpressAnalyzer面向最終用戶的報(bào)表和分析工具70PersonalExpressEnablesMobileOLAPExpressServerUnix/MainframePersonalExpressWindowsRDBMSOLAPClientPersonalExpressEnablesMobil71OracleDSSProductFamilyOracleExpressServerExpressAdministratorRelationalAccessManagerOtherLegacy&ExternalDataRelationalDatabaseManagementSystemsExpressWebAgentExpressObjectsExpressAnalyzerExpressWebPublisherSalesAnalyzerFinancialAnalyzer3rdPartyTools&AppsOracleReportsOracleDiscovererOracleDSSProductFamilyOracl72EnablingtheInformationAgeTMEnablingtheInformationAgeTM73OracleDataWarehouseSolutionOracle(China)PresalesConsultantXuXinOracleDataWarehouseSolution74數(shù)據(jù)倉(cāng)庫(kù)幾大功能Query/ReportDrillup/DrillDownCompareExceptionForcast,WhatifDataMining數(shù)據(jù)倉(cāng)庫(kù)幾大功能Query/Report75數(shù)據(jù)倉(cāng)庫(kù)三大流程數(shù)據(jù)建模DataModelDesign數(shù)據(jù)抽取

DataExtract,Transform,Transport數(shù)據(jù)表現(xiàn)Rolap,Molap

DataDelivery,Drillup/Drilldown,DataRotation,DataMining數(shù)據(jù)倉(cāng)庫(kù)三大流程數(shù)據(jù)建模76ROLAP/MOLAP-爭(zhēng)論的焦點(diǎn)在哪里定義:ROLAP=基于關(guān)系的OLAPMOLAP=基于多維的OLAPROLAP/MOLAP-爭(zhēng)論的焦點(diǎn)在哪里定義:77ROLAP供應(yīng)商說:你能用關(guān)系技術(shù)做所有的事情?MOLAPROLAP供應(yīng)商說:你用多維數(shù)據(jù)庫(kù)能做得更好ROLAP供應(yīng)商僅僅能做ROLAP....MOLAP供應(yīng)商僅僅能做MOLAP....ORACLE能提供ROLAP和MOLAPROLAP/MOLAP-爭(zhēng)論的焦點(diǎn)在哪里ROLAP供應(yīng)商說:ROLAP/MOLAP-爭(zhēng)78ROLAP和MOLAP-Oracle的解決方案OracleROLAPDataMartSuite--建模，數(shù)據(jù)抽取的工具Discoverer--基于關(guān)系數(shù)據(jù)庫(kù)的分析工具多維數(shù)據(jù)的視圖,挖掘和旋轉(zhuǎn)OracleMOLAPExpress系列產(chǎn)品提供MOLAP的方案多維數(shù)據(jù)的視圖,挖掘和旋轉(zhuǎn),計(jì)算和存取、預(yù)測(cè)Oracle能提供ROLAP和MOLAPExpress系列產(chǎn)品能做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決策支持系統(tǒng)的范圍IT人員為用戶開發(fā)業(yè)務(wù)用戶獨(dú)立分析專業(yè)分析人員標(biāo)準(zhǔn)報(bào)表即席查詢分析復(fù)雜分析決策支持系統(tǒng)的范圍IT人員業(yè)務(wù)用戶專業(yè)分析人員標(biāo)準(zhǔn)報(bào)表即席88Oracle決策支持工具集標(biāo)準(zhǔn)報(bào)表即席查詢分析復(fù)雜分析上季度各地區(qū)銷售情況如何？什么原因造成東南亞地區(qū)的業(yè)務(wù)下降?如果同樣的因素影響到其它地區(qū)，將會(huì)對(duì)全球的業(yè)務(wù)造成什么影響?OracleExpressOracleDiscovererOracleReportsOracle決策支持工具集標(biāo)準(zhǔn)報(bào)表即席查詢分析復(fù)雜分析上季89Oracle決策支持工具集標(biāo)準(zhǔn)報(bào)表-OracleReports集中式報(bào)表生成存儲(chǔ)輸出發(fā)布高質(zhì)量的報(bào)表即席查詢分析-Discoverer即席查詢,數(shù)據(jù)鉆入，旋轉(zhuǎn)業(yè)界領(lǐng)先的易用性和性能復(fù)雜分析-ExpressOn-lineAnalyticalProcessing(OLAP)高級(jí)計(jì)算財(cái)務(wù),時(shí)間序列,建模,預(yù)測(cè),回歸分析，假設(shè)分析Oracle決策支持工具集標(biāo)準(zhǔn)報(bào)表-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可擴(kuò)展的多維數(shù)據(jù)庫(kù)服務(wù)器,內(nèi)置強(qiáng)大的分析

功能和決策支持能力PersonalExpress,ExpressServer用于銷售分析,市場(chǎng)分析,財(cái)務(wù)分析的OLAP應(yīng)用產(chǎn)品SalesAnalyzer,FinancialAnalyzer面向?qū)ο蟮腛LAP應(yīng)用開發(fā)工具ExpressAnalyzer,ExpressObjectsExpressServerExpressApplicationsExpressToolsOracleOLAP-ExpressProducts可擴(kuò)展的多維數(shù)據(jù)庫(kù)服務(wù)器,內(nèi)置強(qiáng)大的分析功能和決策支持能117Express一個(gè)專門為查詢和分析商業(yè)情報(bào)數(shù)據(jù)而設(shè)計(jì)的服務(wù)器Express一個(gè)專門為查詢和分析商業(yè)情報(bào)數(shù)據(jù)而設(shè)計(jì)的服務(wù)118Express?對(duì)于一些分析查詢和計(jì)算,Express比關(guān)系型技術(shù)快10倍，100倍，甚至1000倍JerryHeldSeniorVP,ServerTechnologies,OracleCorporation查詢速度如此快，使Express具有很強(qiáng)的競(jìng)爭(zhēng)能力.Express?對(duì)于一些分析查詢和計(jì)算,Express比119多維數(shù)據(jù)模型轄區(qū)經(jīng)理/行長(zhǎng)財(cái)務(wù)經(jīng)理任意分析PRODTIME資金經(jīng)理為數(shù)據(jù)提供快速，靈活的訪問方法金融產(chǎn)品時(shí)間頭寸轄區(qū)多維數(shù)據(jù)模型轄區(qū)經(jīng)理/行長(zhǎng)財(cái)務(wù)經(jīng)理任意分析PRODTIME120對(duì)時(shí)間，日期的智能處理，系統(tǒng)相關(guān)數(shù)據(jù)自行匯總。根據(jù)數(shù)據(jù)建立層次關(guān)系數(shù)據(jù)自行匯總在維上建立層次關(guān)系對(duì)時(shí)間，日期的智能處理，