案例講稿文件jimmyzhang張wwisvoem

Oracle商務(wù)智能整體解決方案架構(gòu)

技術(shù)平臺(tái)上需要考慮的內(nèi)容

數(shù)據(jù)如何進(jìn)入數(shù)據(jù)倉(cāng)庫(kù)

數(shù)據(jù)如何存儲(chǔ),性能和空間

用戶如何使用數(shù)據(jù)提升管理思想

實(shí)時(shí)數(shù)據(jù)集成+

打包預(yù)置過(guò)程

軟硬件一體機(jī)+應(yīng)用模型

商務(wù)智能基礎(chǔ)平臺(tái)+分析應(yīng)用

源數(shù)據(jù)

管理分析主題

供應(yīng)鏈

訂單管理和執(zhí)行

銷售

財(cái)務(wù)

數(shù)據(jù)轉(zhuǎn)換

中央數(shù)據(jù)倉(cāng)庫(kù)

關(guān)系型

數(shù)據(jù)中心存儲(chǔ)

信息展現(xiàn)平臺(tái)

交互式信息板

EBS

PeopleSoftSiebel

JDEdward

+

OracleDatabase

Partitioning

OLAP

DataMining

轉(zhuǎn)換

報(bào)告并發(fā)布

預(yù)先

ReteckProfitLogic

轉(zhuǎn)換

市場(chǎng)營(yíng)銷

服務(wù)和聯(lián)系中心

人力資源

其A他gil系e統(tǒng)

G-Log

測(cè)

轉(zhuǎn)換

MSOffice

插件

ODI

+

數(shù)據(jù)加載過(guò)程+業(yè)界Go領(lǐng)ld先en的Gate

Essbase

OracleBIEE

OracleBIApps預(yù)置分析主題

不同部門和主題的分析內(nèi)容和管理

多維主題

數(shù)據(jù)倉(cāng)庫(kù)技術(shù)平臺(tái)+企業(yè)級(jí)數(shù)據(jù)倉(cāng)庫(kù)模型

思路+分析展現(xiàn)平臺(tái)

ETL工具

OracleBIEE+服務(wù)

統(tǒng)一企業(yè)信息模型

……

檢

警報(bào)

即席

分析

OracleBusinessIntelligence

ContinuedInvestmentandInnovation

EmbeddedBusinessIntelligence

OracleBusinessIntelligence

11g

OracleExadataEPMSystem

BIApplications

EnterpriseBIPlatform

DataMining

AdHocQueryDatabaseReporting

OLAP

BIReleases

1.2

1.6

2.0

8i

8.3

9i

2005

10g 10gR3

10gR5

11g

2000

2010

1995

3

ProductStrategy

Overview–OracleBusinessIntelligence11gR1

?

Deliversbest-of-breedproductsforQueryandAnalysis,OLAP,Reporting,DashboardsandScorecards

?

Onacomplete,open,andarchitecturallyunifiedBusinessIntelligenceFoundation

?

Coupledwithleadingpackagedbusinessintelligenceandenterpriseperformancemanagementapplications

?

Providingcustomerswithsuperioralignment,visibility,andfastesttimetovalue

4

Complete.

OracleBusinessIntelligence11g

Detect&Alert

DataIntegration

Scorecards

InteractiveDashboards

Reporting&Publishing

Ad-hocAnalysis

OfficeIntegration

Collaborate

Search

Mobile

Embedded

CommonBusinessIntelligenceFoundation

OLTP&ODS

Systems

DataWarehouseDataMart

Exadata

PackagedApplications

(Oracle,SAP,Others)

ExcelXML/Office

BusinessProcess

OLAP

Sources

Unstructured&Semi-Structured

5

Open.

OracleBusinessIntelligence11g

Detect&Alert

DataIntegration

Scorecards

InteractiveDashboards

Reporting&Publishing

Ad-hocAnalysis

OfficeIntegration

Collaborate

Search

Mobile

Embedded

CommonBusinessIntelligenceFoundation

OLTP&ODS

Systems

DataWarehouseDataMart

Exadata

PackagedApplications

(Oracle,SAP,Others)

ExcelXML/Office

BusinessProcess

OLAP

Sources

Unstructured&Semi-Structured

6

Integrated.

OracleBusinessIntelligence11g

Detect&Alert

DataIntegration

Scorecards

InteractiveDashboards

Reporting&Publishing

Ad-hocAnalysis

OfficeIntegration

Collaborate

Search

Mobile

Embedded

OLTP&ODS

Systems

DataWarehouseDataMart

Exadata

PackagedApplications

(Oracle,SAP,Others)

ExcelXML/Office

BusinessProcess

OLAP

Sources

Unstructured&Semi-Structured

7

CommonEnterpriseInformationModel

CommonMetadataFoundationacrossallDataSources

CommonSecurity,AccessControl,Authorization,Auditing

CommonRequestGenerationandOptimizedDataAccessServices

CommonClustering,WorkloadManagement,&Deployment

CommonSystems&OperationalLifecycleManagement

UnifiedEndUserExperience

Complete.Consistent.Accurate.

Scorecards

Reports

Mobile

InteractiveDashboards

OfficeIntegration

GeospatialVisualization

Applications&Portals

Ad-hocQueries

Search

Collaboration

8

UnifiedBIMetadataforallBITools

TimetoValue,SimplifiedAdministration,LowerTCO

?

UnifiedCatalogforallBIObjects

EasytoDeployandMaintain

?

Centralizedpermissionsformetadataobjects.

Manageobjectsecurityinoneplace.

?

CentralizedAdministrationforallcomponentsincluding:

?

?

?

?

Security

SessionManagementBIPublisher

Mapping

9

ImprovedBIUserInterface

BasedonExtensiveUserExperienceTesting

NewBIHomePage

BLAF+compliancethroughout

Taskorientation,insteadofnavigationtoindividualproductcomponents

10

NewInteractiveVisualizations

GainInsightQuickerwithGreaterVisibility

?

RichInteractiveVisualizations

?

Animatedtransitions

?

RangeandPagingsliders

?

Legend-basedinteractions

?

Master-Detaillinking

?

Extensiveandextendedsetof

charttypes

?

Consistent,hi-fidelitycharting

acrossOracleproductline

11

OracleBIServerEE

LeadingROLAPServer

CompleteBIToolsSuite

?

–

ConsistentUI,metadata,calculations,dataaccess,security

?

BestROLAPPerformance

–

–

–

–

–

–

IntelligentRequestGenerationIntelligentFunctionShippingWithmulti-passcalculationsIntelligentAggregateNavigationIntelligentCaching

OptimizedDistributedDataAccess

?

Multi-userDevelopment

–

Enterpriseconsolidation&scale

?

HeterogeneousDataSources

–

Relational,OLAP,unstructured

12

ORACLEBISERVER

Complete.Open.Integrated.

CommonEnterpriseInformationModel

Best-in-ClassQuery&AnalysisUserInterface

?

Powerfuldashboards

–

–

–

VisuallyappealingIntuitive

100%thinclient

?

Acrossallstylesofanalysis

–

ROLAP,MOLAP,Scorecards,Reporting,Collaboration,Actions

?

Acrossalldatasources

–

–

–

SimplifiedmodelforusersFederateddataaccess

On-the-flycalculations,evenwithcomplexshareandtimeseries

Custommembers&groupsShare,collaborate,&publishConsistency&alignment

–

–

–

13

OracleEssbase

LeadingMOLAPServer

Self-ServiceandDepartmentalAnalysis

?

–

–

–

–

–

–

Forward-looking:Prediction&what-ifanalysisSimpletomodelcomplexbusinessscenariosSophisticated,cross-dimensionalcalculations

Procedural,financial,timeseries&customcalculationsCustomanalyticapplications

Multi-userwrite-back

BestMOLAPPerformance&Scalability

?

–

–

–

–

Flexiblestorage–Block,Aggregate&HybridOptimizedloadperformance,tricklefeedHigh-availabilityclustering

Benchmarkedsub-secondresponsetimewith20,000concurrentusers,15dimensions,1billionrecords

?

IntegratedwithOracleBIandOracleEPM

–

Sharedmetadata,calculations,dimensions,security

14

Best-in-ClassMOLAPUserInterface

?

First,seamlessROLAP&MOLAPBrowserInterface

OLAPQueryBuildingwithmemberselection

?

MemberselectionCalculatedmembersHierarchicalcalculations

Customaggregates

–

–

–

–

?

Navigateacrossrelationalandmultidimensionalsources

–

Sharedmetadata,calculations,dimensions,security

Ragged&skip-levelhierarchiesPerformanceforeachsource

–

–

?

MicrosoftOfficeIntegration

15

BestinClassProductionReporting

OracleBIPublisher

?

?

?

100%thin-clientdesignenvironment

Pixel-perfectdocumentsLightweight,easytouse

Easytoembed:5MBDownload

Relational,OLAP,unstructuredsources

Multipleoutputformats:XML,HTML,Word,PPT,PDF,RTF,OpenOffice,…

–

–

–

Powerful&highlyscalableserver

?

–

–

1,000,000Reports/Houron2CPUs

Highlyscalable:Optimalresourceandprintqueuemanagement

Active-Activeclustering

–

?

Separatesdataextraction,formatting,deliverymodels

–

–

Dynamicfontsubstitution

Dynamiclanguagesubstitution

16

BestinClassReportBuilder

?

100%purethinclientinterface

–

Noplug-ins,nativeAJAX

?

100%lifecyclesupport

–

Accessdata,design,schedule,manageallinthinclient

?

Forinteractivereporting

–

Web-centricdesign

Forproductionreporting

?

–

Pixel-perfectdocuments

MicrosoftOfficeIntegration

Excel,PowerPoint,Word

MicrosoftOffice2003,2007&2010

?

17

OracleScorecard

andStrategyManagement

StrategyManagement&GoalSetting

IntegratedBIcomponent

?

?

?

?

?

KPIsascoremetadataThresholds,owners,history

Auto-generatedinteractiveanalyses

Linkedobjectives&initiatives

?

Automaticdetection

?

KPIalertstriggeredbythresholds

?

Strategyvisualization

?

?

?

?

StrategyMapsandTreesCauseandEffectsWatchlists

Annotations&override

?

Allmethodologies

?

Balancedscorecard,sixsigma,Baldrige

18

OracleBusinessIntelligenceMobile

BIContentConsumedonmobiledevice

?

NewProductinBIproductfamily

AvailablewithOBIEE+,BIFoundationSuite

AvailableontheAppleiOSplatform

AppleiPhone,iPad,iPodTouch

Clientappandserver(includedinPS)

?

?

?

SupportsAnswersAnalyses,Dashboards,BIPublisherReports,Actions,Scorecards,Alerts,Catalogsearch

PlatformRequirements

OracleBIEE11g.0

?

19

OracleBIOfficeAdd-in

IntegratedwithMicrosoftOffice

20

NewSpatialIntegration

UncoverPatternsHiddeninTables

Gainunderstandingofyourcustomers,markets,branches,storesandassets

Usegeographicinsightstoinnovatebusinessprocesses

Managelocation-basedassets,peopleandproperty

Optimizeserviceandsalesterritoriesforgreaterefficiencies

Mapresources,planlogisticsandprepareforemergencies

Manymappingvisualizations

Thematic,dot-density,bar,pie,orcolorshapeswithbinning,Multiplelayers,Interactivemapcontrols

GlobaldigitalmapdataprovidedbyNAVTEQ

GeographicdatastoredinOraclespatialdatabase

21

OracleBICollaboration

WebCenterWorkspaces&Collaboration

IntegratedwithWebCenter

?

?

?

?

?

Search,tagging,tagcloudsLinking&documentassociationDiscussionforums

Chat,presence,&real-timecollaboration

WorkspacesCommunitylists

?

?

?

BusinessIntelligenceinportals

?

Dashboards,dashboardpages,scorecards,reportsembeddable

Standards-basedportletintegrationContextpassing&run-timeeditingPersonalization&skinning

Oracle&otherportals

?

?

?

?

22

OracleBISearch

SecureEnterpriseSearch

?

AllBIobjectsaresearchable

?

Metadata,dimensions,prompts,hierarchies,reports,…

AlldatasourcesFulltextsearch

?

?

?

Fullsecurityenforced

?

Functional&datasecurity

?

Forusers

?

Easilylocatereports,analysisanddashboards

Executeselectedreportwithcorrectcontext

?

?

Foranalysts

?

Findallobjectsaffectedbybusinessmodelchanges

23

TheTroubleToday:OpenLoopProcesses

?

?

?

?

CostlytolinkinsightstoactionCompletelyseparatesystemsCollaborationismanual

Emailiscoretotheprocess

24

Disconnected.OpenEnded.

THEOLDWAY

IntegratingInsightswithBusinessProcesses

OracleBusinessIntelligence11g

25

Disconnected.OpenEnded.

THENEWWAY:ActionFramework

Integrated.ClosedLoop.

THEOLDWAY

Standards-basedActionFramework

OracleBusinessIntelligence11g

?

Initiate

–

–

–

–

Workflow/BusinessProcess(BPEL)

Message/PostEvent(ES)

WebService

DeliversiBot

?

Execute

JavaMethod

SiebelWorkflow

Navigate

?

–

–

–

BIContent

AnalyticApplicationWebContent

View

Deliver

BIContent

WebContent

?

26

HighPerformance,Scalability,Availability

EnterpriseManagerIntegration

?

?

FusionMiddlewareIntegration

OracleEnterpriseManager

–

Centralized,rolebasedadministration

Multi-appsupport

HotPluggable/Standardsbased

–

–

?

Easierdevelopment,test,deployment,patch,&upgrade

Centralizesperformancemonitoring

Acceleratesdiagnostics&troubleshooting

Automatessessionfailover

?

?

?

27

BestInClassEnterpriseManagement

TimetoValue,SimplifiedAdministration,LowerTCO

?

CentralizedConfiguration&ProcessControl

EasytoDeployandMaintain

?

CentralizedDiagnosticsandMonitoring

Easytotroubleshootandestablishrootcause

?

AvailabilityandClusterManagement

EasytoScaleoutand

Ensure24/7availability

KeydifferentiatorforenterpriseclassBI

28

SimplifiedandIntegratedLifecycle

TimetoValue,SimplifiedAdministration,LowerTCO

?

InstallandUpgrade

RapidInstallationandDeployment

QuicklyUpgradeall10gBIdeployments

StandardFMWInstallerandUpgradeTools

PatchandSupport

–QuicklyFindandapplypatches

?

?

Backup/Restore/TesttoProduction

–Standard,documentedandcertified

?

EnterpriseDeploymentArchitecture

–Standard,documentedandcertified

29

OBIEE11g

ArchitectureOverview

30

OracleBIArchitectureComponents

?

OracleBIarchitecturecomponentsinclude:

–

PresentationServices

End-UserTools:AnalysisEditor,DashboardsOracleBIPresentationServerandCatalogOracleBIServer

OracleBIrepository

Datasources

–

–

–

–

31

Datasources

OracleBIServer

OracleBIPresentation

Server

PresentatEionnSde-rvices

AnalyUsisseErditor

DTasohobolsards

Repository

PresentationCatalog

OracleBIEEArchitecture

WebServer

XML,HTML,XLS,PDF,TXT

overHTTP/HTTPS

OracleBIWeb

TCP/IP(SSL)

WebCatalogService

SOAPWebServices,XMLandURLInterface

OracleInteractiveDashboards

BI11gAnalysis

HTML,SOAP

overHTTP/HTTPS

OracleDeliversServer

UserProfiling,SecurityandSessionMngmt

Scheduling/EventServices

AgentExecutionLogic

CacheServices(Web)&ConnectionMngmt

TCP/IP(SSL)

DeviceAdaptiveContent

ODBCoverTCP/IP(SSL)

OracleBIServer

LogicalSQLODBC/JDBC(LogicalBusinessModel)

OracleBI

ClusterController

LoadBalancerSessionManagement

IntelligentRequestGeneration

ODBC,CLI,OCI,XML,MDX

32

QueryGovern.

SecurityServices

System/PerfMonitoringMetadataInterchange

DataSourceAdapters

AnalyticalandOperationalDataSources

OracleBIAdministration

MetadataManagementServices

Multi-UserDevelopmentServices

MetadataDocumentationServices

ServerManagementServices

ExternalApplicationsandPortals

WeblogicSecurityServices

DBAuthentication

CustomAuthenticator

LDAP

LogicalRequestGeneration

Navigator

OptimizedQueryRewritesExecutionEngine

Multi-Pass/Sub-RequestLogic

FragmentationOptimization

AggregateNavigator

CacheServices

XML

Framework

SAWBridge(J2EE/ISAPI)

WebBrowser

JavascriptforUsability&Interactivity

OracleBIEEArchitecture

WebServer

(IIS,Tomcat,Websphere,iPlanet)

XML,HTML,XLS,PDF,TXT

overHTTP/HTTPS

OracleBIWeb

TCP/IP(SSL)

WebCatalogService

SOAPWebServices,XMLandURLInterface

OracleInteractiveDashboards

OracleAnswers

HTML,SOAP

overHTTP/HTTPS

OracleDeliversServer

UserProfiling,SecurityandSessionMngmt

Scheduling/EventServices

AgentExecutionLogic

CacheServices(Web)&ConnectionMngmt

TCP/IP(SSL)

DeviceAdaptiveContent

ODBCoverTCP/IP(SSL)

OracleBIServer

LogicalSQLODBC/JDBC(LogicalBusinessModel)

OracleBI

ClusterController

LoadBalancerSessionManagement

IntelligentRequestGeneration

ODBC,CLI,OCI,XML,MDX

33

QueryGovern.

SecurityServices

System/PerfMonitoringMetadataInterchange

DataSourceAdapters

AnalyticalandOperationalDataSources

OracleBIAdministration

MetadataManagementServices

Multi-UserDevelopmentServices

MetadataDocumentationServices

ServerManagementServices

ExternalApplicationsandPortals

ExternalizedAuthentication

DBAuthentication

CustomAuthenticator

LDAP

LogicalRequestGeneration

Navigator

OptimizedQueryRewritesExecutionEngine

Multi-Pass/Sub-RequestLogic

FragmentationOptimization

AggregateNavigator

CacheServices

XML

Framework

SAWBridge(J2EE/ISAPI)

WebBrowser

JavascriptforUsability&Interactivity

OracleBIServer

CommonEnterpriseInformationModel

SimplifiedLogicalModel

TheOracleBIserverpresentsasalogicallymodeleddatabaseenablingtheCommonEnterpriseInformationModel.

Thisprovidespowerfulcalculation,computationandfederationcapabilitiesto

3rd

partytoolsaswellasourown.

34

ADayintheLifeofaQuery

35

ADayintheLifeofaQuery

Alogicalrequestcomesinaskingfor

Brand,

ClosedRevenue(GL)

ServiceRequests(CallCenter)ShareofRevenue(Derivation)

36

ADayintheLifeofaQuery

OracleBIServerCache

TheServerwillchecktoseeifthisrequestcanbefulfilledviaapriorrequestusingServerCache.

Thisisanon-demandintelligentshareableandsecurecachethatcansupport:Subsets,AggregationsandDerivations

37

ADayintheLifeofaQuery

Navigator

Ifitistherequestiscannotbefulfilledbycachethentheserverwillintelligentlyprocesstherequest

38

ADayintheLifeofaQuery

Multi-Pass/Sub-RequestLogic

DoesthisanalysisrequiresophisticatedanalysissuchasanOLAPcalculation?

[RevenueShare]

TheServerwilldeterminethebestpossiblewaytoprovidethiscalculation/computation

39

ADayintheLifeofaQuery

FragmentationOptimization

Doesthisrequestspanacrosspartitionsorsilosofdata?

[ClosedRevenueandServiceRequests]

Theserverwilldeterminebasedontherequestifitshouldnavigatetobothoronlyone.Itwillautomaticallyresolvefantraps.

40

ADayintheLifeofaQuery

AggregateNavigator

Isthereanaggregatethatcanbettersatisfythisrequestversushittingthedetail?

{BrandSummaryTable}

TheServerwillapplyappropratesummaryredirectiontoprovidethequickestresponse.

41

ADayintheLifeofaQuery

OptimizedQueryRewrites

Whatcanbefunction-shippeddowntothedatabaseversusperformed

/supplementedbythecomputationcapabilitiesoftheServer.

Theserverwillprovideaconsistentsetoffunctionalitytotheuserregardlessofunderlyingdatasource.

42

OracleBIServer

ExploitingNativeDatabaseFunctionality

43

OracleBIServer

OptimizedNativeSQLRewrites

44

selectD1.c2asc1,D1.c1asc4from

(selectsum