biee mysql_【Oracle BIEE学习笔记一】Oracle BIEE简介 | 学步园

一、Oracle BIEE架构

两大任务:

1、解释逻辑SQL查询和对适当的数据源写入相应的物理查询；

2、对物理结果集进行变换和组合，并执行最终计算。

二、Oracle BI资料库中的三层结构

1、Physical layer

This layer defines the objects and relationships that the Oracle BI Server needs to write native queries against each physical data source. You create this layer by importing tables, cubes, and flat files from your data sources.

Separating the logical behavior of the application from the physical model provides the ability to federate multiple physical sources to the same logical object, enabling aggregate navigation and partitioning, as well as dimension conformance and isolation from changes in the physical sources. This separation also enables the creation of portable BI Applications.

这层定义了BI需要写入的针对每个物理数据源的原生查询的对象和关系，可以通过导入表、多维数据集和数据源中的平面文件来创建该层。

应用程序的逻辑行为从物理模型的分离，使多个物理数据源可以绑定到同一个逻辑模型。实现了聚合导航和分区，与物理模型的变换保持一致和隔离，这种分离也实现了便携式BI应用程序的创建。

2、Business Model and Mapping layer

This layer defines the business or logical model of the data and specifies the mapping between the business model and the physical schemas. This layer determines the analytic behavior seen by users, and defines the superset of objects and relationships available to users. It also hides the complexity of the source data models.

Each column in the business model maps to one or more columns in the Physical layer. At run time, the Oracle BI Server evaluates Logical SQL requests against the business model, and then uses the mappings to determine the best set of physical tables, files, and cubes for generating the necessary physical queries. The mappings often contain calculations and transformations, and might combine multiple physical tables.

这层定义了业务或逻辑模型，并指定了业务模式与物理架构之间的映射关系。这一层决定了用户可见的分析行为，以及对象和关系的超集，同时还实现了对复杂的源数据模型的隐藏。

业务逻辑层中的每一列对应到物理层中的一列或多列。在运行时，BI计算对业务模型的逻辑SQL查询，并使用映射关系来决定最合适屋里查询所需的物理表、文件或多位数据集。这些映射常常包含计算和转换，并且常常包含多个物理表。

3、Presentation layer

This layer provides a way to present customized, secure, role-based views of a business model to users. It adds a level of abstraction over the Business Model and Mapping layer and provides the view of the data seen by users building requests in Presentation Services and other clients.

这一层提供了前台定制展现、安全、基于角色的用户业务逻辑视图的方法。它在商业模式和映射层之上增加了一个抽象层，并提供了相应前台服务和其他请求的视图。

You can create multiple subject areas in the Presentation layer that map to a single business model, effectively breaking up the business model into manageable pieces.

你可以在展现层创建多个映射到一个业务模型的主题域，有效的将业务模型分解成已处理的部分。