1、Oracle BIEE (OBIEE) Overview,Janbao Chang 2011-8-8,Web Server (IIS, Tomcat, Websphere, iPlanet),Oracle BI Server,Intelligent Request Generation,Externalized Authentication,Oracle BI EE Architecture,Data Source Adapters,Navigator,Logical Request Generation,Aggregate Navigator,Fragmentation Optimizati
2、on,Multi-Pass / Sub-Request Logic,Optimized Query Rewrites,Session Management,Metadata Interchange,Logical SQL ODBC/JDBC (Logical Business Model),Cache Services,LDAP,DB Authentication,Custom Authenticator,Oracle BI Administration,Analytical and Operational Data Sources,Metadata Documentation Service
3、s,Metadata Management Services,Multi-User Development Services,Server Management Services,ODBC over TCP/IP (SSL),System / Perf Monitoring,Oracle BI Cluster Controller,ODBC, CLI, OCI, XML, MDX,Oracle BI Web,SOAP Web Services, XML and URL Interface,Cache Services (Web) & Connection Mngmt,XML Framework
4、,Web Catalog Service,User Profiling, Security and Session Mngmt,Oracle Interactive Dashboards,Oracle Answers,Load Balancer,Security Services,Query Govern.,Oracle Delivers Server,Scheduling/Event Services,Agent Execution Logic,Device Adaptive Content,TCP/IP (SSL),Javascript for Usability & Interactiv
5、ity,Web Browser,XML, HTML, XLS, PDF, TXT over HTTP/HTTPS,External Applications and Portals,HTML, SOAP over HTTP/HTTPS,Execution Engine,SAW Bridge (J2EE/ISAPI),TCP/IP (SSL),商务智能基础架构,主要Server组件为： Oracle BI Server Oracle Presentation Server处理机制 Oracle Presentation Server 接受数据查询请求并将Oracle BI Server返回的数据
6、查询结果以仪表盘、报表等形式展现。 Oracle BI Server 处理Oracle Presentation Server转发过来的数据查询请求，并从数据仓库中获取数据。主要客户端组件为： 逻辑模型开发工具Administration 展现层管理工具 Catalog MangerBI应用主要组件包括： Data Warehouse Application Console (DAC) OEM Informatica Power Center BI应用预先构建包包括： 数据仓库模型； Inforatica 资料库(Repository) mappings, workflows DAC 资料库(
7、Repository) 任务(workflows)以及依赖关系，执行计划等。 逻辑模型资料库(Repository)物理数据源、逻辑模型和主题域 仪表盘和报表,Enterprise Business Model Administration 企业业务模型管理,Physical Layer “Intelligent Request Generation”物理层 Reads in system catalogMultiple sourcesOptimized SQL generationRegardless of SchemaFunction ship to appropriate data so
8、urces/Compensation,Business Model Layer “Calculation Engine” 业务模型层Physical complexity converted to logical subject areasDrill-PathsComplex/Derived Measures (Level-based, time series, dimension-specific, nested)Aggregate/Fragment Aware,Enterprise Business Model Administration 企业业务模型管理,Presentation La
9、yer表示层Role-based, in context, personalized presentation Oracle Answers,Enterprise Business Model Administration 企业业务模型管理,Siebel Analytics Architecture,Janbao Chang 2011-8-8,Siebel Analytics Architecture,Is made up of five main components Clients Siebel Analytics Web Server Siebel Analytics Server Si
10、ebel Analytics Scheduler Data Sources,Access analytics information via Web Browser Siebel Answers 问答 Siebel Dashboards仪表盘 Siebel Delivers 发布,提供-客户端消费的可视化信息-的过程 接收分析服务器的数据并提供给客户端.webcat（catalog文件） 用户通过管理界面定义的应用的 dashboard，通过BI Anwsers定义出来的各种报表，以及这些仪表盘，报表和用户或者组的权限对应关系,管理和执行请求数据分析的任务 调度在指定的时间里送给用户报告,提供
11、高效的处理-智能访问的物理数据源和结构化信息,Relational databases关系型数据库 OLAP databases OLAP数据库 Flat files 平面文件 Spreadsheets 电子数据表,Several important components are used by the Siebel Analytics Server (一些重要的组件) Repository file (.rpd) 包含代表分析模型的元数据， Cache 包含的查询结果 NQSConfig.ini 配置文件，说明控制过程的值 DBFeatures.ini 配置文件，说明控制SQL生成的值 Lo
12、g files 日志文件,Siebel Analytics Server Details,分成三个层次： Physical represents the data sources 表示数据源 Business models the data source into facts and dimensions 将数据源建模成事实维和维度 Presentation specifies the users view of the model指定的用户模型视图 ; rendered（呈现） in Siebel Answers,Sample Request Processing,User views a
13、dashboard or submits an Answers request 用户查看一仪表盘或提交一个问答请求 The Siebel Analytics Web Server makes a request to the Siebel Analytics Server to retrieve the requested data Siebel Analytics Web Server 生成一请求给 Siebel Analytics Server 检索所请求的数据 The Siebel Analytics Server using the .rpd file, optimizes funct
14、ions to request the data from the data sources Siebel Analytics Server 使用.RPD文件，优化功能，从数据源请求数据 The Siebel Analytics Server receives the data from the data sources and process as necessary Siebel Analytics Server 从数据源接收数据，必要的处理过程 The Siebel Analytics Server passes the data to the Siebel Analytics Web Server Siebel Analytics Server 传递数据给 Siebel Analytics Web Server The Siebel Analytics Web Server formats the data and sends it to the client Siebel Analytics Web Server 格式化数据并送给 Client,What does BIEE do?,Dashbords,Answers,Administrator Tools,
