Siebel BIEE Overview精髓ppt課件

1、Oracle BIEE (OBIEE) OverviewJanbao Chang2021-8-8Web Server (IIS, Tomcat, Websphere, iPlanet)Oracle BI ServerIntelligent Request GenerationExternalized AuthenticationOracle BI EE ArchitectureData Source AdaptersNavigatorLogical Request GenerationAggregate NavigatorFragmentation Optimization Multi-Pas

2、s /Sub-Request LogicOptimized Query RewritesSession ManagementMetadata InterchangeLogical SQL ODBC/JDBC (Logical Business Model)Cache ServicesLDAPDB AuthenticationCustom AuthenticatorOracle BI AdministrationAnalytical and Operational Data SourcesMetadata Documentation ServicesMetadata Management Ser

3、vicesMulti-User Development ServicesServer Management ServicesODBC over TCP/IP (SSL)System / Perf MonitoringOracle BI Cluster ControllerODBC, CLI, OCI, XML, MDXOracle BI WebSOAP Web Services, XML and URL InterfaceCache Services (Web) & Connection MngmtXML FrameworkWeb Catalog ServiceUser Profiling,

4、Security and Session MngmtOracle Interactive DashboardsOracle AnswersLoad BalancerSecurity ServicesQuery Govern.Oracle Delivers ServerScheduling/Event ServicesAgent Execution LogicDevice Adaptive ContentTCP/IP (SSL)Javascript for Usability & InteractivityWeb BrowserXML, HTML, XLS, PDF, TXT over /HTT

5、PSExternal Applications and PortalsHTML, SOAP over /HTTPSExecution EngineSAW Bridge (J2EE/ISAPI)TCP/IP (SSL)商務(wù)智能根底架構(gòu) 主要Server組件為：Oracle BI Server Oracle Presentation Server處置機(jī)制Oracle Presentation Server 接受數(shù)據(jù)查詢懇求并將Oracle BI Server前往的數(shù)據(jù)查詢結(jié)果以儀表盤、報(bào)表等方式展現(xiàn)。Oracle BI Server 處置Oracle Presentation Server轉(zhuǎn)發(fā)過來

6、的數(shù)據(jù)查詢懇求，并從數(shù)據(jù)倉庫中獲取數(shù)據(jù)。主要客戶端組件為：邏輯模型開發(fā)工具Administration展現(xiàn)層管理工具 Catalog MangerBI運(yùn)用主要組件包括：Data Warehouse Application Console (DAC) OEM Informatica Power Center BI運(yùn)用預(yù)先構(gòu)建包包括： 數(shù)據(jù)倉庫模型；Inforatica 資料庫(Repository) mappings, workflowsDAC 資料庫(Repository) 義務(wù)(workflows)以及依賴關(guān)系，執(zhí)行方案等。邏輯模型資料庫(Repository)物理數(shù)據(jù)源、邏輯模型和主題域儀

7、表盤和報(bào)表Enterprise Business Model Administration企業(yè)業(yè)務(wù)模型管理Physical Layer “Intelligent Request Generation物理層Reads in system catalogMultiple sourcesOptimized SQL generationRegardless of SchemaFunction ship to appropriate data sources/CompensationDB2Supply Chain DMTeradataOLAPOracleERP.XML DataSourceSQL Ser

8、verAcxiomSiebelOperationalBusiness Model Layer “Calculation Engine業(yè)務(wù)模型層Physical complexity converted to logical subject areasDrill-PathsComplex/Derived Measures (Level-based, time series, dimension-specific, nested)Aggregate/Fragment AwareEnterprise Business Model Administration企業(yè)業(yè)務(wù)模型管理Presentation

9、Layer表示層Role-based, in context, personalized presentation Oracle AnswersEnterprise Business Model Administration企業(yè)業(yè)務(wù)模型管理Siebel Analytics ArchitectureJanbao Chang2021-8-8Siebel Analytics ArchitectureIs made up of five main componentsClientsSiebel Analytics Web ServerSiebel Analytics ServerSiebel Anal

10、ytics SchedulerData SourcesClientsSiebelAnalytics Web ServerSiebelAnalyticsServerSiebelAnalyticsSchedulerDataSourcesAccess analytics information via Web BrowserSiebel Answers 問答Siebel Dashboards儀表盤 Siebel Delivers 發(fā)布提供-客戶端消費(fèi)的可視化信息-的過程接納分析效力器的數(shù)據(jù)并提供應(yīng)客戶端.webcatcatalog文件用戶經(jīng)過管理界面定義的運(yùn)用的 dashboard，經(jīng)過BI Anw

11、sers定義出來的各種報(bào)表，以及這些儀表盤，報(bào)表和用戶或者組的權(quán)限對(duì)應(yīng)關(guān)系管理和執(zhí)行懇求數(shù)據(jù)分析的義務(wù)調(diào)度在指定的時(shí)間里送給用戶報(bào)告提供高效的處置-智能訪問的物理數(shù)據(jù)源和構(gòu)造化信息Relational databases關(guān)系型數(shù)據(jù)庫OLAP databases OLAP數(shù)據(jù)庫Flat files 平面文件Spreadsheets 電子數(shù)據(jù)表Several important components are used by the Siebel Analytics Server (一些重要的組件)Repository file (.rpd)包含代表分析模型的元數(shù)據(jù)，Cache 包含的查詢結(jié)果NQS

12、Config.ini 配置文件，闡明控制過程的值DBFeatures.ini 配置文件，闡明控制SQL生成的值Log files 日志文件Siebel Analytics Server Details SiebelAnalyticsServerCacheNQSConfig.iniDBFeatures.iniNQServer.logNQQuery.log.rpdSiebel AnalyticsAdministration Tool分成三個(gè)層次：Physical represents the data sources 表示數(shù)據(jù)源Business models the data source int

13、o facts and dimensions 將數(shù)據(jù)源建模成現(xiàn)實(shí)維和維度Presentation specifies the users view of the model指定的用戶模型視圖 ; rendered呈現(xiàn) in Siebel AnswersSample Request ProcessingUser views a dashboard or submits an Answers request用戶查看一儀表盤或提交一個(gè)問答懇求The Siebel Analytics Web Server makes a request to the Siebel Analytics Server t

14、o retrieve the requested dataSiebel Analytics Web Server 生成一懇求給 Siebel Analytics Server 檢索所懇求的數(shù)據(jù)The Siebel Analytics Server using the .rpd file, optimizes functions to request the data from the data sourcesSiebel Analytics Server 運(yùn)用.RPD文件，優(yōu)化功能，從數(shù)據(jù)源懇求數(shù)據(jù)The Siebel Analytics Server receives the data from the data sources and process as necessarySiebel Analytics Server 從數(shù)據(jù)源接納數(shù)據(jù)，必要的處置過程The Siebel Analytics Server passes the data to the Siebel Analytics Web ServerSiebel Analytics Server 傳送數(shù)據(jù)給 Siebel Analytics Web ServerThe Siebe