How are workspaces and baselines implemented in an encyclopedia database used by IBM Rational System Architect (SA)?
You want to know how SA implements workspaces and baselines on a database level for a Workspaces Encyclopedia compared to a Standard Encyclopedia.
In a Standard Schema (not workspace enabled) Encyclopedia
All entities (definitions, symbols, diagrams) are stored in simple flat tables in the database by SA. Any data shown in the SA client comes directly from those tables. Any modification you make (for example updating a diagram or definition) in the SA client for the encyclopedia, the modification will be directly reflected in those tables in the database.
In a Workspaces Schema (workspace enabled) Encyclopedia
SA uses database "views" rather than tables to determine what will be shown in the SA client.
Your modifications are still stored in the same database tables used for a Standard Schema Encyclopedia but with a workspace ID attached to each entity. This corresponds to the workspace or the baseline for workspaces you set as the baseline (read only workspace).
The data the SA client displays when using a workspace enabled encyclopedia no longer comes from a flat table. Instead, each "workspace" or "baseline" corresponds to a database "view".
For example, if you select a workspace "my workspace" in the SA client, any new definition you create will go into the "Entity" table in the encyclopedia database. Any information shown in the SA client will come from the "view" defined for "my workspace".