Oracle Workspace Manager Now Available in Autonomous Database

Oracle Workspace Manager is a feature of Oracle Database that provides the infrastructure for developers to create workspaces to maintain multiple versions of a set of tables. Developers can work on a copy of the data within a workspace that is visible only to them and not visible to other users of the database accessing production data. Changes they make to the data are isolated to the workspace. When a developer has finished working on data in a workspace, they can merge it with production data.

Oracle Workspace Manager is now available on Oracle Autonomous Database Serverless.

With Oracle Workspace Manager, developers can

◉ Manage a collection of updates and inserts to tables as a unit before adding them to production data

◉ Support a collaborative development effort with multiple workspaces and workspace hierarchies to concurrently work on subprojects

◉ Explore “what-if” scenarios

◉ Keep a history of changes to the data

◉ Manage “long-transaction” scenarios that are complex -long-duration database transactions can take days to complete - while users are accessing the same database in a production application

The diagram to the right illustrates how a company can use workspaces to explore proposed changes in an example geospatial application. The LIVE workspace is maintained as the single source of truth. The Parcel A Subdivision workspace and the Parcel B Zoning workspace are used to contain the updates from those components of the application.   When those projects successful the company can merge the updates into the LIVE workspace. Similarly, within the Parcel A Subdivision workspace, we have two sub-workspaces – open space and conventional. If approved, those projects can be merged into the Subdivision workspace.

The benefits of utilizing Oracle Workspace Manager include retaining a history of changes indefinitely and saving time, money, and resources by eliminating the need to maintain multiple database versions. Oracle Workspace Manager allows for differencing and conflict detection/resolution, partial and complete merge/refresh of workspaces or tables, and garbage collection operations to optimize version storage.

Soiurce: oracle.com