案例講稿文件jimmyzhang張wwisvoem_第1頁(yè)
案例講稿文件jimmyzhang張wwisvoem_第2頁(yè)
案例講稿文件jimmyzhang張wwisvoem_第3頁(yè)
案例講稿文件jimmyzhang張wwisvoem_第4頁(yè)
案例講稿文件jimmyzhang張wwisvoem_第5頁(yè)
已閱讀5頁(yè),還剩45頁(yè)未讀, 繼續(xù)免費(fèi)閱讀

下載本文檔

版權(quán)說(shuō)明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡(jiǎn)介

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

溫馨提示

  • 1. 本站所有資源如無(wú)特殊說(shuō)明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒(méi)有圖紙預(yù)覽就沒(méi)有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫(kù)網(wǎng)僅提供信息存儲(chǔ)空間,僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。

評(píng)論

0/150

提交評(píng)論