




版權(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ì)自己和他人造成任何形式的傷害或損失。
最新文檔
- 高中語(yǔ)文第四冊(cè)林黛玉進(jìn)賈府 同步練習(xí)3舊人教版基礎(chǔ)知識(shí)及其運(yùn)用
- 高中語(yǔ)文必修5六國(guó)論 同步練習(xí)加線詞與例句中加線詞用法相同
- 勞務(wù)合同工作合同范例
- 企業(yè)文員勞務(wù)合同范例
- 農(nóng)機(jī)維修合同范例
- 前期開(kāi)辦合同范例
- ps租房合同范例
- 公司賣水果訂購(gòu)合同范例
- 買賣珠寶文玩合同范例
- 住宿出租房屋合同范例
- CRRT治療原理、模式選擇
- 《安徽省幼兒園保育教育質(zhì)量自評(píng)指導(dǎo)手冊(cè)》(文本)
- 成都市2024屆高中畢業(yè)班第二次診斷性監(jiān)測(cè)-2024年全國(guó)各地高考語(yǔ)文模擬卷作文導(dǎo)寫講練
- 醫(yī)保統(tǒng)計(jì)信息管理制度
- 2024年保育員(初級(jí))證考試題庫(kù)及答案
- 40篇英語(yǔ)短文搞定3500個(gè)單詞 正文
- 如何闡述自己的觀點(diǎn) 高中語(yǔ)文統(tǒng)編版必修下冊(cè)第一單元寫作課課件
- 交通運(yùn)輸執(zhí)法知識(shí)培訓(xùn)課件
- 2023年臺(tái)州市中考科學(xué)(正卷)和答案
- 經(jīng)鼻高流量氧療小講課護(hù)理課件
- 2019年上海高考英語(yǔ)真題試卷(答案版含聽(tīng)力原文)
評(píng)論
0/150
提交評(píng)論