owb基本概念之Workspaces、Repository和Control Center Service

最新推荐文章于 2026-05-08 11:35:34 发布

原创最新推荐文章于 2026-05-08 11:35:34 发布 · 1.7k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

数据仓库和数据挖掘专栏收录该内容

28 篇文章

订阅专栏

本文介绍Oracle Warehouse Builder中的工作区概念及其组织结构。工作区位于Oracle Database中的Oracle Warehouse Builder存储库内，用于组织用户及功能区域。每个工作区包含一个或多个项目，并可通过Design Center进行ETL流程的设计。

Workspaces

A workspace resides within Oracle Warehouse Builder repository on Oracle Database. Oracle Warehouse Builder repository can contain one or more workspaces, depending on how you want to organize your users and functional areas. The first step in building a new workspace is to assign it a name and to specify the path and directory where its source files are saved. Oracle Warehouse Builder organizes your workspace into projects and creates and organizes many of the configuration files required by the type of data system you are creating. For a description of projects, see "Projects".

The workspace is hosted on an Oracle database. As a general user, you do not have full access to all the workspaces. Instead, you can access those workspaces to which you have been granted access and privileges. You log in to a workspace by starting the Design Center, which is the primary graphical user interface. The Design Center is used to import source objects, design ETL processes such as mappings, and ultimately define the integration solution. For information about the Design Center, see "Design Center".

Figure 3-1 shows a representation of the Oracle Warehouse Builder repository in Oracle Database. Within the repository, at least one workspace containing one project exists. In the figure, numeral 1. points to a workspace and numeral 2. points to several projects within that workspace. Multiple workspaces can reside within Oracle Warehouse Builder repository.

Figure 3-1 Oracle Database with a Workspace Contained within the OWB Repository

Description of "Figure 3-1 Oracle Database with a Workspace Contained within the OWB Repository"
注释：
Oracle Warehouse Builder repository can contain one or more workspaces, Within the repository, at least one workspace containing one project exists. 上图中的TS1和SS1、SS2就是project。
参考：http://docs.oracle.com/cd/E11882_01/owb.112/e10581/uitour.htm#WBCON4439

The Oracle Warehouse Builder Repository

A major feature of the architecture in Oracle Warehouse Builder is the single, unified Oracle Warehouse Builder Repository for the database instance, which is pre-seeded with a schema and database objects. The run time environment and the design environment reside in this single repository. The repository schema, named Oracle Warehouse BuilderSYS（OWBSYS）, gets created when you install Oracle Database. After the database is installed, you must not perform additional actions, other than unlocking the Oracle Warehouse BuilderSYS and Oracle Warehouse BuilderSYS_AUDIT accounts.

Note:

Oracle Warehouse Builder Release 11g stores all repository objects in the Oracle Warehouse BuilderSYS schema, which is created as part of every Oracle release 11g database. Oracle Warehouse BuilderSYS database user is also registered as an Oracle Warehouse Builder user. Administrators and developers generally register other database users and assign them required privileges, rather than using Oracle Warehouse BuilderSYS account directly.
You can create multiple repositories if you prefer to separate the run time and design environments; however, this is not recommended.

Workspaces

To start using Oracle Warehouse Builder, you create at least one, new workspace. Users access their respective workspaces, instead of the repository as a whole. Thus, if you are Oracle Warehouse Builder administrator, instead of granting users access to a repository, you grant them access to one or more workspaces. Because all workspaces are stored in a single repository schema, creating workspaces is simplified.

In defining the repository, an administrator creates one or more workspaces, with each workspace corresponding to a set of users working on related projects. For example, a common practice is to create separate workspaces for Development, Testing, and Production. This practice provides team focus in addition to security. Users such as developers can have access to the Development and Testing workspaces, and can be restricted from the Production workspace. Later in the implementation cycle, you can use the Repository Assistant in Oracle Warehouse Builder to manage existing workspaces or to create new ones.

Control Center Service

Each workspace has a default Control Center that points to itself, and it is started and stopped with its corresponding Control Center Service. A Control Center stores detailed information about every deployment and execution, which you can access either by object or by job.

You can use the default Control Center to deploy to the local system, or you can create additional Control Centers for deploying to different（remote） systems as needed. Only one Control Center is active at any given time, and this is the Control Center associated with the current active configuration.